The Excel file Returaunt Sales provides sample information on lunch, dinner, and

Question

The Excel file Returaunt Sales provides sample information on lunch, dinner, and delivery sales for a local italian restaurant. Develop a 95% confidence intervals for the mean of each of these variables. as well as total sales for weekdays and weekends. What conclusions can you reach? Solve using excel

Restaurant 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

Explanation / Answer

the lowest average sales is 603.841 and highest is 790.980. 95% of the time, the average will fall between these values.

697.410 mean Data 421.633 std. dev. 47.741 std. error 78 n

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.