On a separate worksheet named Compare, calculate the difference and percent difference of the mean and standard deviation for the…
On a separate worksheet named Compare, calculate the difference and percent difference of the mean and standard deviation for the data sets (X and Y) for the number of meals and number of desserts per month obtained. On the same worksheet, set up a table to list the four highest number of desserts per month from each data set (X and Y) and the ten lowest number of meals eaten out by respondents for each of the data sets (X and Y). Below the data, discuss how these values differ between the data sets, and recommend either X or Y for further analysis, highlighted in pink.