Please kindly help me solve this math problem.

MGMT 650 Spring 2020 Week 11 Homework Questions (Last updated 11/24/2019) 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 th Here is the pivot table that you should have created. It is optional so that you can practice your pivot table skills Data Count - Color Type Sum - Yards 23 35856 16 17053 13 13426 12 12509 12 12131 8 8393 26 37666 12 12874 1) Color Type Black Blue Brown Green Purple Red White Yellow (empty) Total Result 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.00 White 37,666.00 Primary Colors 38,320.00 Tertiary Colors 38,066.00 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 White Primary Colors Tertiary Colors Total Subtract the Expected values from the observed values Color Type Sum of Yards Black White Primary Colors Tertiary Colors Square the values just found Color Type Sum of Yards Black White Primary Colors Tertiary Colors 2) Divide each square by the expected value and add together Color Type Sum of Yards Black White Primary Colors Tertiary Colors Total 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 amou 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 Value?Use =CHISQ.INV() What is your answer to Saeko? colors she is selling. sell in equal amounts. are Brown, Green, and Purple. hi Square at the .10 level of significance. ko the number of yards that were sold in the various yarn types during the busiest weekend of her shop last year. that you can practice your pivot table skills. owing table: he colors sell in equal amounts. ypothesis that the colors sell in equal amounts is true. Customer 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 Color Name Coriander Black Daffodil Black Opal Toffee Ruby Ash Black Ash Black Whirlpool Verde Regal Lynx Yellow Rose Chocolate Mist Whirlpool Alfalfa Ruby Verde Sky Black Whirlpool Black Mist Alfalfa Jade Yellow Rose Cream Black Ruby Mist Yellow Rose Black Sky Periwinkle Coriander Black Yellow Rose Black Periwinkle Black Color Type White Black Yellow Black Blue Brown Red Blue Black Blue Black Blue Green Purple Brown Yellow Brown White Blue Green Red Green White Black Blue Black White Green Green Yellow White Black Red White Yellow Black White Purple White Black Yellow Black Purple Black Yards Meters 1,155.00 1,056.13 1,504.00 1,375.26 904.00 826.62 1,850.00 1,691.64 1,497.00 1,368.86 929.00 849.48 918.00 839.42 584.00 534.01 2,363.00 2,160.73 816.00 746.15 1,685.00 1,540.76 1,402.00 1,281.99 972.00 888.80 590.00 539.50 1,263.00 1,154.89 791.00 723.29 1,331.00 1,217.07 2,425.00 2,217.42 848.00 775.41 990.00 905.26 1,269.00 1,160.37 1,441.00 1,317.65 2,269.00 2,074.77 1,496.00 1,367.94 815.00 745.24 1,570.00 1,435.61 1,999.00 1,827.89 1,217.00 1,112.82 737.00 673.91 1,063.00 972.01 1,799.00 1,645.01 2,721.00 2,488.08 575.00 525.78 2,305.00 2,107.69 828.00 757.12 2,037.00 1,862.63 2,157.00 1,972.36 1,363.00 1,246.33 2,179.00 1,992.48 1,846.00 1,687.98 1,290.00 1,179.58 1,894.00 1,731.87 973.00 889.71 2,393.00 2,188.16 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 Black Mist Coriander Cream Verde Black Daffodil Chocolate Regal Daffodil Coriander Black Black Lynx Periwinkle Daffodil Coriander Verde Lynx Alfalfa Cream Daffodil Periwinkle Cream Black Cream Cream Coriander Mist Verde Black Blush Opal Daffodil Mist Alfalfa Jade Verde Cream Black Chocolate Regal Sky Regal Yellow Rose Black White White White Green Black Yellow Brown Purple Yellow White Black Black Brown Purple Yellow White Green Brown Green White Yellow Purple White Black White White White White Green Black Red Blue Yellow White Green Green Green White Black Brown Purple White Purple Yellow 2,476.00 2,428.00 2,488.00 2,379.00 600.00 1,720.00 1,160.00 1,264.00 1,441.00 915.00 839.00 1,468.00 831.00 936.00 854.00 1,250.00 1,352.00 1,163.00 1,329.00 1,176.00 703.00 836.00 1,468.00 742.00 1,305.00 1,254.00 703.00 774.00 701.00 589.00 697.00 1,113.00 732.00 1,393.00 1,496.00 1,440.00 987.00 1,197.00 585.00 1,488.00 914.00 852.00 922.00 1,339.00 1,311.00 2,264.05 2,220.16 2,275.03 2,175.36 548.64 1,572.77 1,060.70 1,155.80 1,317.65 836.68 767.18 1,342.34 759.87 855.88 780.90 1,143.00 1,236.27 1,063.45 1,215.24 1,075.33 642.82 764.44 1,342.34 678.48 1,193.29 1,146.66 642.82 707.75 640.99 538.58 637.34 1,017.73 669.34 1,273.76 1,367.94 1,316.74 902.51 1,094.54 534.92 1,360.63 835.76 779.07 843.08 1,224.38 1,198.78 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 Lynx Regal Ash Periwinkle Black Black Blush Regal Whirlpool Yellow Rose Sapphire Chocolate Toffee Sapphire Whirlpool Black Regal Opal Blush Coriander Whirlpool Ash Blush Black Ruby Mist Chocolate Opal Toffee Sky White Black Chocolate Brown Purple Blue Purple Black Black Red Purple Blue Yellow Blue Brown Brown Blue Blue Black Purple Blue Red White Blue Blue Red Black Red White Brown Blue Brown White White Black Brown 739.00 731.00 1,485.00 827.00 992.00 581.00 708.00 1,152.00 1,434.00 1,133.00 734.00 1,221.00 906.00 1,423.00 1,287.00 1,277.00 541.00 501.00 1,104.00 1,187.00 1,408.00 820.00 1,427.00 517.00 1,279.00 788.00 508.00 1,267.00 832.00 981.00 1,056.00 1,145.00 1,254.00 675.74 668.43 1,357.88 756.21 907.08 531.27 647.40 1,053.39 1,311.25 1,036.02 671.17 1,116.48 828.45 1,301.19 1,176.83 1,167.69 494.69 458.11 1,009.50 1,085.39 1,287.48 749.81 1,304.85 472.74 1,169.52 720.55 464.52 1,158.54 760.78 897.03 965.61 1,046.99 1,146.66 Saeko owns a yarn 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 yarn. 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 799 784 807 675 795 875 Total 5) 4,735.00 Buffalo Yarns 776 640 822 856 616 893 4,603.00 What is the null hypothesis? What is the alternative hypothesis? What is the level of significance? 6) Use Tools - Data Analysis - ANOVA:Single Factor to find the F statistic: 7) From the ANOVA ooutput: What is the F value? 8) What is the F critical value? 9) What is your decision? 799 931 794 920 731 837 5,012.00 etween the brands? Studies have shown that the frequency with which shoppers browse Internet retailers is related to the frequency with following data show respondents age and answer to the question \"How many minutes do you browse online retailer Age (X) 34 17 42 35 19 43 51 50 22 58 48 35 39 39 59 40 60 22 33 36 28 22 28 44 54 30 28 16 52 22 28 35 50 Time (Y) 123,556.00 92,425.00 250,908.00 204,540.00 77,897.00 197,012.00 195,126.00 177,100.00 83,230.00 140,012.00 265,296.00 189,420.00 235,872.00 230,724.00 238,655.00 138,560.00 259,680.00 93,208.00 91,212.00 153,216.00 77,308.00 56,496.00 106,652.00 242,748.00 195,858.00 178,560.00 190,876.00 98,528.00 169,572.00 79,420.00 167,928.00 215,705.00 146,350.00 10) Use Data > Data Analysis > Correlation to compute the correlation checking the Labels checkbox. 11) Use the Excel function =CORREL to compute the correlation. If answers for #1 and 2 do not agree, there is an error 12) 13) The strength of the correlation motivates further examination. a) Insert Scatter (X, Y) plot linked to the data on this sheet with Age on the horizontal (X) axis. b) Add to your chart: the chart name, vertical axis label, and horizontal axis label. c) Complete the chart by adding Trendline and checking boxes Read directly from the chart: a) Intercept = b) Slope = c) R2 = Perform Data > Data Analysis > Regression. 14) Highlight the Y-intercept with yellow. Highlight the X variable in blue. Highlight the R Square in orange 15) Use Excel to predict the number of minutes spent by a 22-year old shopper. Enter = followed by the regression form Enter the intercept and slope into the formula by clicking on the cells in the regression output with the results. 16) Is it appropriate to use this data to predict the amount of time that a 9-year-old will be on the Internet? If yes, what is the amount of time, if no, why? ated to the frequency with which they actually purchase products and/or services online. The ou browse online retailers per year?\" ot agree, there is an error. ed by the regression formula. ut with the results. 17) On this worksheet, make an XY scatter plot linked to the following data: X Y 1.01 1.48 1.8 1.81 1.07 1.53 1.46 1.38 1.77 1.88 1.32 1.75 1.94 1.19 1.31 1.56 1.16 1.22 1.72 1.45 1.43 1.19 2 1.6 1.58 2.8482 4.2772 4.788 5.3757 2.5252 3.0906 4.3362 3.2016 4.3542 4.8692 3.8676 3.9375 5.7424 2.4752 26.2 4.5708 2.842 2.44 5.1256 4.3355 4.2471 3.5343 5.46 3.84 3.8552 18) Add trendline, regression equation and r squared to the plot. Add this title. ("Scatterplot of X and Y Data") 19) The scatterplot reveals a point outside the point pattern. Copy the data to a new location in the worksheet. You now Data that are more tha 1.5 IQR below Q1 or more than 1.5 IQR above Q3 are considered outliers and must be inves It was determined that the outlying point resulted from data entry error. Remove the outlier in the copy of the data. Make a new scatterplot linked to the cleaned data without the outlier, and add title ("Scatterplot without Outlier,") tren X Y 1.01 1.48 1.8 1.81 1.07 1.53 1.46 1.38 1.77 1.88 1.32 2.8482 4.2772 4.788 5.3757 2.5252 3.0906 4.3362 3.2016 4.3542 4.8692 3.8676 1.75 1.94 1.19 3.9375 5.7424 2.4752 1.56 1.16 1.22 1.72 1.45 1.43 1.19 2 1.6 1.58 4.5708 2.842 2.44 5.1256 4.3355 4.2471 3.5343 5.46 3.84 3.8552 Compare the regression equations of the two plots. How did removal of the outlier affect the slope and R 2? 20) ation in the worksheet. You now have 2 sets of data. dered outliers and must be investigated. outlier in the copy of the data. Scatterplot without Outlier,") trendline, and regression equation label. ffect the slope and R 2