The data set contains a random sample of 120 sugar sodas, and a random sample of 120 diet sodas. The populations of interest would be the population of all sugar sodas and all diet sodas, respectively. The variable that was measured on each sampled soda was the caffeine content, measured in mg/12 oz drink

1 Think about whether or not there appears to be a difference in the mean caffeine content between the two groups of sodas. Be sure to explain your reasoning.

2 State the null and alternative hypotheses under investigation, using proper mathematical notation.

3 Use the Data Analysis ToolPak in Excel to carry out the Welch Approximate t Procedure. Include the output from Excel as a figure in your report.

4 Identify the value of the test statistic from the Excel output.

Sample Details:

Sugar

47.32 43.78 48.12 43.25 46.42 45.16 45.17 42.48 47.7 36.62 39.06 34.59 45.96 41.19 35.81 32.56 40.06 42.09 39.3 40.37 41.92 40.9 38.43 34.09 38.81 40 38.9 40.38 32.98 35.59 44 34.85 33.41 30.56 37.94 29.38 37.03 34 35.4 33.44 33.04 33.55 35.91 36.81 32.04 32.3 29.93 28.43 35.34 30.64 37.49 38.75 40.45 41.05 40.04 36.63 39.8 41.24 38.72 38.82 34.3 43.52 41.4 36.32 39.5 36.19 39.13 42.18 34.61 43.86 37.21 35.08 40.47 34.01 36.32 41.36 37.44 39.93 42.86 36.31 42.28 33.24 39.01 42.16 39.66 36.54 37.82 38.6 34.27 36.43 37.85 36.79 38.88 35.66 37.97 34.88 36.8 36.22 38.47 33.46 36.14 34.26 35.01 33.23 39.32 40.35 32.61 37.1 32.73 34.26 33.79 35.68 34.15 33.57 35.74 34.46 39.01 34.36 35.88 34.38

Diet

44.6 45.66 46.37 48.11 48.47 45.91 47.91 48.25 47.26 47.47 41.07 42.55 41.27 47.52 46 46.99 49.12 41.27 43.8 44.39 39.71 44.35 46.73 45.18 47.79 43.93 47.77 39.34 49.65 46.55 44.76 48.7 47.95 51.2 46.21 42.05 48.06 47.26 48.97 46.85 48.35 49.71 49.64 46.65 49.31 47.49 49.37 46.85 45.77 47.87 32.79 35.03 32.83 31.78 35.54 33.69 36.92 33.57 30.83 34.02 50.74 39.39 44.21 50.82 37.49 48.98 39.87 36.51 48.27 44.71 45.19 35.54 41.5 52.54 36.1 39.59 44.5 34.54 31.18 29.32 35.69 32.97 36.1 33.44 32.08 34.83 37.6 32.12 35.39 31.78 40.25 40.07 40.1 38.27 40.11 38.32 39.07 41.06 38.56 37.19 35.53 33.85 32.98 29.24 31.87 31.86 32.24 33.11 32.05 34.27 39.82 38.06 39.13 33.11 36.85 35.64 39.09 39.85 34.87 38.57