Using level of significance of .05 test the claim that the colors are equally liked. ColorsObserved FreqRed24Blue28Green26Orange25Purpl e22a. Create a new column and place the expected frequency for a uniform distributionb. Create a new column that contains the difference of observed values and expected values (using Excel equation)c. Create a new column that contains the square of the difference in part b (Using Excel equation)d. Create a new column that contains the quotient of the answer in part c and the expected value in part a. e.Sum up the quotients. (This is your test value)f. Find the p-value of the test value using