Question: The Sales worksheet DATA file provides sample information on lunch, dinner, and delivery sales for a local Italian restaurant. As the restaurant's in-house business analyst,
The Sales worksheet DATA file provides sample information on lunch, dinner, and delivery sales for a local Italian restaurant. As the restaurant's in-house business analyst, you've been tasked with determining which of these three meal types generates the highest average sales. Additionally, your manager has asked you if average total sales on weekends (i.e., Saturday and Sunday) are higher than during the week. Develop one or more tables that display the appropriate calculations/statistics needed using a 99% confidence level, and use statistical methods to draw your conclusions. Provide an explanation of your methodology and results. (Remember, this isn't as simple as averaging and comparing the sample data!)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help