Gradebook Question 11 - Wk 2 - Practice: Wk 2 X G finding the mean in excel - Goc X https://ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fvle.phoenix.edu%252Fultra%252Fcourses%252F_288506_1%252 8 90% ) ... E Wk 2 - Practice: Wk 2 Exercises [due Day 5] @ Saved Help Save & Exit Submit Check my work 11 Noodles and Company tested consumer reaction to two spaghetti sauces. Each of 70 raters assessed both sauces on a scale of 1 (worst) to 10 (best) using several taste criteria. To correct for possible bias in tasting order, half the raters tasted Sauce A first, while the other half tasted Sauce B first. Actual results are shown below for "overall liking." 2 points Sauce A: 5, 8, 5, 3, 8, 6, 6, 2, 7, 5, 4, 6, 6, 6, 5, 1, , 8, 8, 1, 8, 5, 2, 7, 6, 8, 1, 6, 8, 8, 6, 9, 5, 4, 8, 8, 6, 8, 2, 8, 6, 7, 6, 6, 3, 8, 7, 8, 6, 7, 8, 8, 2, 5, 8, 5, 9, 7, 7, 8, 1, 7, 5, 5, 7, 8, 8, 8, 5, 3 Book Sauce B: 5 , 5 , 8 , 3, 9, 6, 5, 8, 5, 6, 5, 5, 7, 8, 9, 8, 5, 5, 8, 6, 7, 2, 5 , 6, 6, References 6, 7, 5, 6, 8, 7, 5, 8, 2, 5, 7, 7, 8, 6, 4, 7, 7, 8, 8, 5 Click here for the Excel Data File (a) Calculate the mean and standard deviation for each sample. (Round your answers to 3 decimal places.) x-bar Sauce A Sauce B (b) Calculate the coefficient of variation for each sample. (Enter your answer as a percentage rounded to 1 decimal place.) CVA CVB (c) What is your conclusion about consumer preferences for the two sauces? O On average, consumers seem to prefer sauce B over sauce A. O On average, consumers seem to prefer sauce A over sauce B.