Please help me solve the problem using Excel. Please include excel formulas with answer.

Goal-To use Excel to perform a test of hypotheses concerning the means of two populations. Excel functions

• 2-sample Z-test (Independent samples,2and2known)-From the menu select:DataData, Analysisz-Test: Two Sample for Means
• Pooled T-test (Independent samples,2and2unknown but equal)-From the menu select: DataData Analysist-Test: Two-Sample Assuming Equal Variances
• Paired T-test (Dependent samples)-From the menu select:DataData Analysist-Test: Paired Two Sample for Means

Problem 2 - Low-carbohydrate foods are very popular as many Americans try to avoid this sugar and starch combination that many believe causes weight gain. An advertisement for a low-carb ice cream claims that the product has 16 fewer grams of carbohydrates per serving than the leading store brand. To check this claim, independent random samples of each type of ice cream were obtained, and the amount of carbohydrates in each serving was measured. The data is in the file Excel Homework 6 - Problem 2. The variance in carbohydrates per serving for the (1) store brand is known to be 8.5 and for the (2) low-carb brand it's known to be 0.253. Is there any evidence to suggest that the difference in population means of carbohydrates per serving is not 16 grams? Use = 0.05.

Questions - write your answers to the following directly on your output. Be neat and label your answers.

(a) Give the null and alternative hypotheses. [1 point]

(b) Find and circle the test statistic and the p-value for this test. [1 point]

(c) Give the decision for the test. Write a conclusion that relates your decision to the context of the

problem. [2 points]

Data Set:

Store brand (g)	Low-carb brand (g)
15.4	3.7
25.4	4.1
17.8	4.1
21.8	3.2
20.4	3.9
25.1	3.1
18.6	4.7
17.1	3.4
21.0	4.5
20.3	4.3
14.9	3.7
21.5	4.2
24.3	4.3
24.1	3.4
24.6	4.2
19.6	3.0
23.3	3.2
16.6	3.4
19.1	3.1
22.9	3.9
18.7	3.6
22.6	3.5
17.9	4.4
22.2	3.7
19.8	4.4
22.1	4.2
18.7	3.6
21.5	4.9
22.5	3.4
19.4	3.7
20.1	3.7
18.3	4.8
18.9	4.0
16.6	3.8
26.3	3.6
22.8
24.4
18.4