To complete this scenario, use the Sammy's Subs Sales Data Excel file linked in the Resources.
Sammy, the owner of a fast food chain called Sammy's Subs, wants to know whether the levels of daily sales are different between his shop in Edina and the one in Richfield. He records sales in each shop for a month, in the Sammy's Subs Sales Data Excel file. Use the data in this file to determine whether sales levels are different between the two stores at the .05 level of significance. State the null hypothesis, and explain how you determined whether to reject it.
To complete this scenario, use the Mall Time Interview Results Excel file linked in the Resources.
Management at the Mall of Elbonia wanted to determine how much time customers spend at the mall. Four surveys were administered on four different days by randomly selecting individuals as they were returning from the mall to the parking lot, and asking them to participate. One of the questions asked was how much time the customer had spent in the mall on that day.
The results of the survey are provided in the Mall Time Interview Results Excel file. Columns A through D show the time spent by the customers interviewed, according to the weekday and time of day when the interviews occurred. Is there any statistically significant difference (at alpha = .05) in the average amount of time people spend in the mall, based on the weekday and time? Explain how you determined the answer to that question.
To complete this scenario, use the Seafood Prices Sample Excel file linked in the Resources.
You manage a grocery chain advertising account, and need to gather some data to support a campaign you are planning with your client, Rainbow Foods. The campaign will focus on seafood, and you need data to support your supposition that your client has the lowest prices, as compared to Cub Foods, Byerly's, and Kowalski's. The client points out that you need to include a control for the type of seafood. You agree on five categories:
6. 30-count wild shrimp, in shells.
7. Fillets of farmed tilapia.
8. Alaskan king crab legs.
9. Steaks of wild caught salmon.
10. Cod fillets.
Your tutorial is in Excel, attached. Each problem is a different tab.