Q30. Refer to the tab titled “Yarn Purchased” for data required to solve this problem. This data rep

Q30. Refer to the tab titled “Yarn Purchased” for data required to solve this problem. This data represents the number of skeins bought with 4 different colors of the same yarn per customer. Answer questions 1 through 2 below. 1. What is an appropriate null hypothesis (H0) for this data analysis?A. There is a significant difference in customer color preferences for the yarn.B. There is no difference in color preference for the 4 different colors of yarn. Perform a one-way ANOVA to test for significant difference in color preference between the 4 colors. Use the data analysis tool to perform the test. You will need to rearange the data to be able to run the test appropriately. You can create a new tab with the data ordered in the way that is required to run this test.)Based on the p-value from your ANOVA test, would youaccept or reject your null hypothesis ? Explainwhy?CustomerColor of yarnNumber of Skeins purchased1Blue22Blue43Blue114Blue45Blue66Blue67Blue48Blue39Blue1510Blue211Blue412Blue413Blue814Blue1315Blue116Blue217Blue918Blue1019Green620Green721Green622Green1223Green1424Green625Green726Green827Green1928Green729Green730Green131Green732Green2133Green534Green335Green2536Green537Green438Green1339Green240Green1441Green2042Green343Green644Green345Green746Green647Green448Green449Green1350Green751Green652Green1253Green354Green655Green456Green1557Green458Green459Green660Green561Green1062Green1063Green1864Green1765Green566Green767Green368Green169Green770Green771Green572Green773Yellow1174Yellow1075Yellow276Yellow677Yellow2578Yellow179Yellow780Yellow181Yellow1582Yellow1383Yellow484Yellow1185Yellow186Yellow287Yellow288Yellow689Yellow190Yellow791Yellow592Yellow493Yellow1694Yellow1995Yellow996Yellow697Yellow498Yellow399Yellow8100Yellow7101Yellow18102Yellow1103Yellow3104Yellow4105Yellow1106Yellow4107Yellow2108Yellow10109Orange5110Orange15111Orange19112Orange9113Orange2114Orange1115Orange18116Orange11117Orange6118Orange1119Orange6120Orange7121Orange4122Orange2123Orange1124Orange12