Excel File Edit View Insert Format Tools Data Window Help C43. Sat 9:27 PM Q OE O . AutoSave OFF ABOU 3HW11 MGMT650_Spring2019_Questions-2-1 Q ~ Search Sheet Home Insert Draw Page Layout Formulas Data Review View Share Comments 7 Arial 10 V AA = = 28 Wrap Text General AutoSum v LGv Fill search Paste B IU v Lv Av E E Merge & Center Conditional Format Cell Insert Delete Format a Pierre 86 82 6 % ~ $ Formatting as Table styles X Clear v Sort & Filter xf J46 X V B D G H M O Q Saeko owns a yam shop and want to expands her color selection. sau Before she expands her colors, she wants to find out if her customers prefer one brand over another brand. Specifically, she is interested in three different types of bison yarn. As an experiment, she randomly selected 15 different days and recorded the sales of each brand. HNminorca At the .05 significance level, can she conclude that there is a difference in preference between the brands? lisa's Bison Yak-el-ly-Yaks Buffalo Yams 98 79 65 85 86 83 Shot 11 78 5.28 PM 87 98 82 66 193 14 15 1) What is the null hypothesis? 16 2) What is the alternative hypothesis? 18 3) What is the level of significance? Shot Use Tools - Data Analysis - ANOVA:Single Factor Anova: Single Factor 5.41 PM to find the F statistic: Shot? 5.57 PM Shot 7.34 PM 39 4) From the ANOVA ooutput: What is the F value? 40 41 5) What is the F critical value? 42 Shot 43 5) What is your decision? 7.46 PM HW11 ANOVA Pivot Table Pivot Table Data Regression Cleaning Data with Outlier + Select destination and press ENTER or choose Paste + 100% 13 XWOP DEEP