Italian 12 13 15 17 18 20 17 24 Seafood Steakhouse 16 24 18 19 17 23 26 25 23 21 15 22 19 27 18 31 Excel Project 6 This Excel Project contains 7 questions. Work out the answers to the questions and then click on "Excel Project 6" to submit your answers. Directions for performing analysis of variance in Excel are in the Excel Demo for this week. Suppose a reporter wanted to study the average meal price for restaurants located in Myrtle Beach, South Carolina. The reporter selected a sample of 8 seafood restaurants, 8 Italian restaurants, and 8 steakhouses. This dataset shows the prices obtained for the 24 restaurants sampled. Use = 0.05 to test whether there is a significant difference among the mean meal price for the three types of restaurant. *Give your answers to two decimal places.* 1. 2. 3. 4. 5. 6. 7. What is the null hypothesis ? What is MSTR? What is MSE? *Give your answer to two decimal places.* What is the value of the test statistic? *Give your answer to two decimal places.* What is the p-value? *Give your answer to four decimal places.* What is your conclusion using = 0.05? State your conclusion in words a non-statistician could understand. Lawyer Physical Therapist Cabinetmaker Systems Analyst 44 55 54 44 42 78 65 73 74 80 79 71 42 86 69 60 53 60 79 64 50 59 64 66 45 62 59 41 48 52 78 55 64 55 84 76 38 50 60 62 This page is for helping you solve the first tab, there are no questions here Job satisfaction was measured for a sample of 10 individuals from each of the following professions: Lawyer, Physical Therapist, Cabinetmaker, and Systems Analyst. Higher scores mean higher job satisfaction. We would like to test whether the average job satisfaction is the same (or different) for the three different occupations. The hypotheses: H0: 1 = 2 = 3 = 4 (since we have four groups) Ha: Not all of the population means are equal. We can use Excel to obtain the ANOVA table for this data set: 1. Click "Data'' -> "Data Analysis''. In Excel 2003, click "Tools" -> "Data Analysis". 2. Select "Anova: Single Factor''. You may have to scroll up to see this option. 3. Click in the Input Range box and then highlight your data (include the variable names). Make sure the bubble next to "Columns" is selected, but NOT the bubble next to "Rows". 4. Check the box next to "Labels in First Row" (you can also change the value of alpha here if you want). 5. Click the bubble next to Output Range, and click in the box to the right of Output Range. On your spreadsheet click a blank space where you want your ANOVA table to appear. 6. Click "OK''. Click on the tab "Excel Output" below to see the Excel results. 7. What is the p-value? p-value = 0.0061 8. What is our conclusion? Use = 0.05 Reject H0, the four occupations have different average levels of job satisfaction. Anova: Single Factor SUMMARY Groups Lawyer Physical Therapist Cabinetmaker Systems Analyst ANOVA Source of Variation Between Groups Within Groups Total Count 10 10 10 10 SS 1939.4 4782.6 6722 Sum Average 500 50 637 63.7 691 69.1 612 61.2 df MS 3 646.4667 36 132.85 Variance 124.2222 164.6778 105.8778 136.6222 F P-value F crit 4.86614 0.006081 2.866266 39 4.86614 is the value of the test statistic. 0.006081 is the p-value. 2.866266 is the critical value (what we would look up in the table if doing the problem by hand. This page is for helping you solve the first tab, there a questions here <-Treatments row <-Error row e are no