Statistic Calculation Problem
Question and instructions in PDF file and Excel sheet provided for work.
You may discuss this lab with your classmates, but your writeup should be done by yourself. Your name
MUST be typed into the Excel spreadsheet (not handwritten on a printout).
The example shown below does not use the actual data set. The real assignment is at the end.
In this example, an item has been purchased from 10 different retail shops. We wish to test the hypothesis
that the population mean price is greater than 3 dollars. The screen capture shown below shows the formu-
las that were entered into column E to generate the numbers that you see there.
The first three entries just calculate n, x , and s. The next entry is the standard error, which is the name of
the quantity
s
n
that is used in the denominator of the test statistic.
The entry next to “mu zero” should be the value that would appear in the null hypothesis. Since we are test-
ing to see if the population mean is greater than 3, our null hypothesis would have been H0: 3 , so the
number “3” appears there. Next to the word “tails”, you would enter “1” for either the upper or lower 1-
sided test, or “2” for a 2-sided test.
The p-value is found using the Excel function called TDIST. This function requires 3 pieces of information.
The first item is the absolute value of the test statistic. The second item is the number of degrees of free-
dom, and the final item tells the function whether or not to double the area under the curve. The TDIST
function then finds the area under the curve, to the right of the absolute value of the test statistic, and dou-
bles that area for 2-sided tests.
Lab 1: Hypothesis Tests
Stat 244 Spring 2021 Due April 21
Lab 1 (Due April 21)
Using the method described above, and the data set called “gas2015.xlsx”, test to see if there is evidence
that the population mean price for a gallon of gas differs from $2.50. Use 0.05. Include this file with
your test results in your assignment submission.
Include a full 5 Step writeup. While Excel will be used to perform calculations for Step 3 (you can just de-
clare your p-value and compare it to your alpha), you must still write Steps 1, 2, 4, and 5. I encourage you
to hand-write these steps and scan the file as a pdf.
Include both the .xlsx file (with your test results) and your 5 Step writeup in your D2L submission. Your
submission will thus be made up of two different files – do not merge these together into a single file.
>Sheet 6
8
2.7781
Gas Station
Price
1
2.
4
11
2
2.
40
6
3
2.3
7
4
2.
37
5
5
2.372
6
2.3
8
7
2.457
8
2.5
20
9
2.553
10
2.584
11
2.6
19
12
2.6
22
13
2.651
14
2.670
15
2.7
25
16
2.758
17
2.788
18
2.761
19
2.746
20
2.743
21
2.750
22
2.765
23
2.749
24
2.760
25
2.778
26
27
2.753
28
2.712
29
2.671
30
2.617
31
2.595
32
2.582
33
2.549
34
2.532
35
2.5
36
36
2.534
37
2.485
38
2.432
39
2.434
40
2.382