11. (Total 5 points) We are interested in comparing the Our sample was taken by randomly selecting up pack of each brand of colesteach substmarket. The data are a comparing the average supermarket prices of two leading colas Sclecting eight supermarkets and recording the price of a six- market. The data are shown in the following table: Price Supermarket Brand 2.25 2.47 Brand 2 2.30 2.45 2.44 235 2.29 2.25 2.25 2.25 2.36 2.42 2.4 Mean Standard deviation 2.31 0.100676 2.35 0.085857 ( points) Write the null and alternative hypotheses to test the mean difference in price of two coal brands. : - 0 2) (3 points) Using the one of the EXCEL outputs, test the hypothesis using a p-value approach and give the appropriate conclusion in the words of the problem. Assume that all the assumptions are satisfied (Use a = 0.01). We al to jest becaust pinbat Alphia t-Test: Two-Sample Assuming Equal Variances t-Test:Paired Two Sample for Means Brand 2 Brand 1 2.3125 01 Brand 2 2.35 0.0024 Brand 1 2.3125 0.0101 Mean Variance Observations Pooled Variance Hypothesized Mean Difference Mean Variance Observations Pearson Correlation Hypothesized Mean Difference 0.0088 0923 t Stat P/Tot) one-tail Critical one-tall P(Tottwo-tail Critical two tail -0.8016 0.2151 1.7613 0.4362 t Stat PITct one-tail Critical one-tail PITottwo-tail Critical two-tail 0.0135 11946 00971 2146 11. (Total 5 points) We are interested in comparing the Our sample was taken by randomly selecting up pack of each brand of colesteach substmarket. The data are a comparing the average supermarket prices of two leading colas Sclecting eight supermarkets and recording the price of a six- market. The data are shown in the following table: Price Supermarket Brand 2.25 2.47 Brand 2 2.30 2.45 2.44 235 2.29 2.25 2.25 2.25 2.36 2.42 2.4 Mean Standard deviation 2.31 0.100676 2.35 0.085857 ( points) Write the null and alternative hypotheses to test the mean difference in price of two coal brands. : - 0 2) (3 points) Using the one of the EXCEL outputs, test the hypothesis using a p-value approach and give the appropriate conclusion in the words of the problem. Assume that all the assumptions are satisfied (Use a = 0.01). We al to jest becaust pinbat Alphia t-Test: Two-Sample Assuming Equal Variances t-Test:Paired Two Sample for Means Brand 2 Brand 1 2.3125 01 Brand 2 2.35 0.0024 Brand 1 2.3125 0.0101 Mean Variance Observations Pooled Variance Hypothesized Mean Difference Mean Variance Observations Pearson Correlation Hypothesized Mean Difference 0.0088 0923 t Stat P/Tot) one-tail Critical one-tall P(Tottwo-tail Critical two tail -0.8016 0.2151 1.7613 0.4362 t Stat PITct one-tail Critical one-tail PITottwo-tail Critical two-tail 0.0135 11946 00971 2146