Question: Open the workbook namedLaRosa.xlsxlocated in the Chapter 2 folder, and thensave it asLa Rosa Demographic Analysis.xlsx. On the SiteX and SiteY worksheets, rank each respondent

Open the workbook namedLaRosa.xlsxlocated in the Chapter 2 folder, and thensave it asLa Rosa Demographic Analysis.xlsx. On the SiteX and SiteY worksheets, rank each respondent by the number ofmeals they eat out per month and the number of desserts they eat out per month,respectivelyranking from most meals and desserts out to the least. Freeze the panesof the window on each worksheet to make the category headings at the top visible atall times. On a separate worksheet namedCompare, calculate the difference and percentdifference of the mean and standard deviation for the data sets (X and Y) for thenumber of meals and number of desserts per month obtained. On the sameworksheet,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 ofthe data sets (X and Y). Below the data, discuss how these values differ between thedata sets, and recommend either X or Y for further analysis, highlighted in pink. On a separate worksheet namedSummary, determine the following for the locationyou think should be selected: The total number of respondents The total number of respondents with incomes at or above $80,000 The total number of respondents who eat fewer than three desserts out each month The total number of meals eaten out per month reported by respondents who earnat least $60,000 The total number of desserts per month reported by respondents who are in the 31 to 35 or over 35 age categories Include appropriate titles, labels, and formatting so that the worksheets are easyto read. Save and close the La Rosa Demographic Analysis.xlsx workbook

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!