N 3 Laurie Fitsin owns a small sandwich shop called Laurie's Lunch Box. She has developed a 4 sales history for the first week of March using total sales and guests served. Help Laurie calculate her average sales per guest for each day of the week and calculate her totals. TIP: 5 Remember to calculate total sales and total guests served on line 16 BEFORE you try 6 to calculate average sales per guest in cell E16. 7 Guests Average Sales 8 Sales Period Date Sales Served Per Guest 9 Monday 3/1 $1,248.44 200 10 Tuesday 3/2 1,686.25 360 11 Wednesday 3/3 1,700.00 350 12 Thursday 3/4 1,555.65 300 13 Friday 3/5 1,966.31 380 14 Saturday 3/6 2,134.65 400 3/7 15 Sunday 2,215.77 420 16 Total $12,507.07 17 18 Laurie's "shortcut": Average Sales Per Guest (sum divided by 7): A B D E Laurie has decided that she could take a shortcut and calculate the average sales per guest for the week by adding Monday through Sunday's average sales per guest and dividing by e seven (put this figure in cell E18). In the space below, explain the difference between this 3 figure and the one you calculated in cell E16, and why this "shortcut" would not be an accurate reflection of average sales per guest. 4 5 6 7 8 9 50 31 82 33 34