. In the Excel file Restaurant Sales, determine if the variance of weekday sales
ID: 3132966 • Letter: #
Question
. In the Excel file Restaurant Sales, determine if the variance of weekday sales is different than that of weekend sales with significance level of 5% for the variable lunch sales. solve using excel
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.00Explanation / Answer
Standard deviation for weekdays = 685.569, N=16
Standard deviation for weekends = 292.8775, N=10
F-Test =
variance of 1st set/ variance of secoond one
F= 685.5/293 = 2.33
df1= 15, df2= 9
from f table, critical F= 3.01 > actual F
Null Hypothesis
Claim is satisfied
Sum of All Sales Column Labels Row Labels Tuesday Wednesday Thursday Friday Saturday Sunday Grand Total 01-Apr 2894 2894 02-Apr 2707 2707 04-Apr 1256 1256 05-Apr 1425 1425 06-Apr 1484 1484 07-Apr 2973 2973 08-Apr 2883 2883 09-Apr 2247 2247 11-Apr 1214 1214 12-Apr 1352 1352 13-Apr 1546 1546 14-Apr 2754 2754 15-Apr 2798 2798 16-Apr 2204 2204 18-Apr 1235 1235 19-Apr 1318 1318 20-Apr 1552 1552 21-Apr 3053 3053 22-Apr 2990 2990 23-Apr 2489 2489 25-Apr 1167 1167 26-Apr 1315 1315 27-Apr 1716 1716 28-Apr 2931 2931 29-Apr 3049 3049 30-Apr 2406 2406 Grand Total 4872 5410 6298 11711 14614 12053 54958Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.