Question
BUS 173- MID SEMESTER ASSIGNMENT ANSWER THE FOLLOWING QUESTION. USE EXCEL FOR CALCULATION. COPY THE ANOVA TABLE FROM EXCEL AND WRITE THE REST OF THE
BUS 173- MID SEMESTER ASSIGNMENT
ANSWER THE FOLLOWING QUESTION. USE EXCEL FOR CALCULATION. COPY THE ANOVA TABLE FROM EXCEL AND WRITE THE REST OF THE ANSWERS IN A WORD DOCUMENT. UPLOAD BOTH WORD AND EXCEL CALCULATION DURING SUBMISISON. CONDUCT YOUR OWN EXCEL CALCULATIONS- IT IS VERY EASY FOR ME TO CHECK THE AUTHOR OF EACH EXCEL WORKBOOK. IF YOU ARE COPYING FROM YOUR CLASSMATE- I WILL BE ABLE TO FIND OUT AND PENALIZE ACCORDINGLY. YOU HAVE 24 HOURS FOR SUBMISSION. I WILL NOT BE DEDUCTING MARKS FOR LATE SUBMISISON (EVEN IF THAT IS BY A MINUTE).
1. A small college town has four pizza parlors that make deliveries. A student wants to compare how promptly the four pizza parlors deliver pizza. On six randomly chosen nights, the student orders a large pepperoni pizza from each establishment, then records the elapsed time until the pizza is delivered to her apartment. Assume that her apartment is approximately the same distance from the four pizza parlors. The following table shows the times (in minutes) for these deliveries. Assume that all the assumptions required to apply the one-way ANOVA procedure hold true.
a) Using the 2.5% significance level, test the null hypothesis that the mean delivery time is the same for each of the four pizza parlors. Use excel to conduct the calculation and then copy pasta the ANOVA table into the word document for the rest of the hypotheses testing.
b) Now apply the same technique but use a 10% significance level and test the null hypothesis that the mean delivery time is the same for each of the four pizza parlors. Use excel to conduct the calculation and then copy pasta the ANOVA table into the word document for the rest of the hypotheses testing.
c) Does your conclusion differ from the results obtained in part a) and part b). If the answer is 'yes' - explain why. If the answer is 'no'- also explain why.
d) Show the calculation manually on how to obtain SST. Explain what is SST- using the concept discussed in class.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started