Saeko has a yarn shop and wants to test her theory on what types of colors she is selling. She believes that Black, White, the Primary Colors, and Tertiary colors sell in equal amounts. The primary colors are blue, red, and yellow; while the tertiary colors are Brown, Green, and Purple. Test Saeko's theory using the 5 step hypothesis testing analysis and Chi Square at the .10 level of significance. (Optional) Use the "Pivot Table Data" tab to create a pivot table that shows Saeko the number of yards that were sold in the various yarn types during the busiest weekend of her shop last year. Here is the pivot table that you should have created. It is optional so that you can practice your pivot table skills. Row Labels Black Blue Brown Green Purple Red White Yellow (blank) Grand Total 1) Count of Color Type Sum of Yards 23 35856 16 17053 13 13426 12 12509 12 12131 8 8393 26 37666 12 12874 122 149908 Using the pivot table that you just created, fill in the blanks in the following table: Primary Colors consists of the sum of Blue, Red, and Yellow yarn sold Tertiary Colors consists of the sum of Brown, Green, and Purple Colors Sold. The Total in this chart must equal the Grand Total, Cell D19 in the above table. Black 35,856 White 37,666 Primary Colors 38,320 Tertiary Colors 38,066 Total 149,908.00 This table represents the observed data in the Chi Square analysis. Find the Expected values for each of the colors. Saeko expects that the colors sell in equal amounts. Color Type Sum of Yards Black 37,477 White 37,477 Primary Colors 37,477 Tertiary Colors 37,477 Total 149,908.00 Subtract the Expected values from the observed values Color Type Sum of Yards Black (1,621.00) White 189.00 Primary Colors 843.00 Tertiary Colors 589.00 Square the values just found Color Type Sum of Yards Black 2,627,641.00 White 35,721.00 Primary Colors 710,649.00 Tertiary Colors 346,921.00 2) Divide each square by the expected value and add together Color Type Sum of Yards Black 70.11 White 0.95 Primary Colors 18.96 Tertiary Colors 9.26 Total 99.29 This total is your Chi Square test statistic Use the 5 step hypothesis testing procedure to determine if Saeko's hypothesis that the colors sell in equal amounts is true. What is the null hypothesis? What is the alternative hypothesis? What is the level of significance? 3) What is the Chi Square test statistic? 4) What is the Chi Square critical ValueUse =CHISQ.INV() What is your answer to Saeko