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.

Tony's Luigi's Angelo's Kowiski's

20.0 22.1 22.3 23.9

24.0 27.0 26.0 24.1

18.3 20.2 24 25.8

22.0 32.0 30.1 29.0

20.8 26.0 28.0 25.0

19.0 24.8 25.8 24.2

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.