AutoSave . OFF MGMT650 HW11 Summer21_Questions ~ Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) A A General Conditional Formatting Insert v v 2 Format as Table v Ex Delete v I v Paste B A % 9 Sort & Find & Analyze Sensitivity Cell Styles v Format v Filter Select Data G30 X V fx B C D E F G H M N P Q R Saeko owns a yam shop and want to expands her color selection. 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 yam. As an experiment, she randomly selected 21 different days and recorded the sales of each brand. At the .10 significance level, can she conclude that there is a difference in preference between the brands? Misa's Bison Yak-et-ty-Yaks Buffalo Yams 799 776 799 784 640 931 807 822 794 675 856 920 795 616 731 875 893 837 Total 4,735.00 4,603.00 5,012.00 6 What is the null hypothesis? What is the alternative hypothesis? What is the level of significance? 7) Use Tools - Data Analysis - ANOVA: Single Factor to find the F statistic: Chi Square ANOVA Regression Cleaning Data with Outlier + Ready + 100%