Please provide a step by step guide and all formulas needed, thank you.

Instructions:

1.- On the Site X and Site Y worksheets, use the RANK.EQ function to rank each respondent by the number of desserts they eat out per month and the number of meals they eat out per month respectively (ranking from most desserts and meals out to the least).

2.- Freeze the top row on the Site X and Site Y worksheets to make the category headings visible at all times.

3.- In the Comparison worksheet, calculate the difference and percent difference of the mean and standard deviation for the data sets (Site X and Site Y) for the number of desserts and meals. Use the STDEV.S function for the standard deviation. The difference should be calculated as Site Y - Site X. The percent difference should be calculated as (Site Y - Site X) / Site X. Next, complete the table so that it lists the four highest number of desserts per month from each data set (Site X and Site Y) and the ten lowest number of meals eaten out by respondents for each of the data sets (Site X and Site Y).

4.- After looking at the data in the Comparison worksheet, you have decided that Site Y is the more attractive location for your new restaurant. On the Summary worksheet, use various formulas and functions to complete cells B1:B7 using only the data for Site Y.

The total number of respondents. \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline 4 & A & B & C & D & E & F & G \\ \hline 1 & Respondent \# & Age Category & Income & #DessertsOutperMonth & #MealsOutperMonth & Rankby#Desserts & Rankby#Meals \\ \hline 2 & 2000 & 3135 & $75,000 & 0 & 13 & & \\ \hline 3 & 2001 & 3135 & $30,000 & 10 & 7 & & \\ \hline 4 & 2002 & 2630 & 5,000 & 4 & 24 & & \\ \hline 5 & 2003 & 1821 & $20,000 & 0 & 5 & & \\ \hline 6 & 2004 & 3135 & $100,000 & 5 & 16 & & \\ \hline 7 & 2005 & 2630 & $20,000 & 10 & 19 & & \\ \hline 8 & 2006 & 3135 & $75,000 & 8 & 9 & & \\ \hline 9 & 2007 & 3135 & $100,000 & 10 & 5 & & \\ \hline 10 & 2008 & 3135 & $30,000 & 5 & 9 & & \\ \hline 11 & 2009 & 3135 & $75,000 & 4 & 13 & & \\ \hline 12 & 2010 & 3135 & $100,000 & 4 & 4 & & \\ \hline 13 & 2011 & 1821 & $30,000 & 7 & 5 & & \\ \hline 14 & 2012 & 2225 & 5,000 & 9 & 14 & & \\ \hline 15 & 2013 & 1821 & $30,000 & 0 & 3 & & \\ \hline 16 & 2014 & 1821 & $30,000 & 0 & 13 & & \\ \hline 17 & 2015 & over 35 & $100,000 & 0 & 17 & & \\ \hline 18 & 2016 & 3135 & $100,000 & 7 & 3 & & \\ \hline 19 & 2017 & 2630 & $50,000 & 4 & 5 & & \\ \hline 20 & 2018 & 3135 & $100,000 & 17 & 14 & & \\ \hline 21 & 2019 & 1821 & $20,000 & 10 & 8 & & \\ \hline 22 & 2020 & 3135 & $75,000 & 13 & 9 & & \\ \hline 3 & 1 & ic on & c 1nnn & 1 & 3 & & \\ \hline