In: Statistics and Probability
In the Excel file Restaurant Sales, determine if the variance of weekday (M/T/W/T/F) sales is different from that of weekend (S/S) sales with significance level of 5% for the variable delivery sales.
Date | Day | Lunch Sales $ | Dinner Sales $ | Delivery Sales $ |
1-Apr | Saturday | $542.00 | $1,468.00 | $884.00 |
2-Apr | Sunday | $873.00 | $1,345.00 | $489.00 |
4-Apr | Tuesday | $289.00 | $646.00 | $321.00 |
5-Apr | Wednesday | $354.00 | $782.00 | $289.00 |
6-Apr | Thursday | $403.00 | $805.00 | $276.00 |
7-Apr | Friday | $442.00 | $1,289.00 | $1,242.00 |
8-Apr | Saturday | $449.00 | $1,652.00 | $782.00 |
9-Apr | Sunday | $697.00 | $1,209.00 | $341.00 |
11-Apr | Tuesday | $307.00 | $579.00 | $328.00 |
12-Apr | Wednesday | $387.00 | $664.00 | $301.00 |
13-Apr | Thursday | $412.00 | $891.00 | $243.00 |
14-Apr | Friday | $508.00 | $1,178.00 | $1,068.00 |
15-Apr | Saturday | $503.00 | $1,581.00 | $714.00 |
16-Apr | Sunday | $741.00 | $1,137.00 | $326.00 |
18-Apr | Tuesday | $298.00 | $572.00 | $365.00 |
19-Apr | Wednesday | $419.00 | $621.00 | $278.00 |
20-Apr | Thursday | $345.00 | $913.00 | $294.00 |
21-Apr | Friday | $467.00 | $1,332.00 | $1,254.00 |
22-Apr | Saturday | $622.00 | $1,732.00 | $636.00 |
23-Apr | Sunday | $846.00 | $1,324.00 | $319.00 |
25-Apr | Tuesday | $233.00 | $523.00 | $411.00 |
26-Apr | Wednesday | $341.00 | $731.00 | $243.00 |
27-Apr | Thursday | $426.00 | $940.00 | $350.00 |
28-Apr | Friday | $379.00 | $1,409.00 | $1,143.00 |
29-Apr | Saturday | $592.00 | $1,856.00 | $601.00 |
30-Apr | Sunday | $779.00 | $1,229.00 | $398.00 |