STATISTICS
recitation11

# The file gaso linexls contains regular gasoline

• Notes
• 2

This preview shows pages 1–2. Sign up to view the full content.

Lower Atlantic states are lower than the national average. The file Gaso- line.xls contains regular gasoline prices for a sample of 50 service stations from Lower Atlantic states. Use α = 0 . 01 as your level of significance. (In this problem we do not know σ ). 1. Set up your hypotheses. 2. Use Excel to compute the sample mean (¯ x ). Use =AVERAGE(A2:A51) 1

This preview has intentionally blurred sections. Sign up to view the full version.

3. Use Excel to compute the standard deviation ( s ). Use =STDEV(A2:A51) 4. Compute your test statistic using parts 2 and 3. 5. Compute the degrees of freedom ( n - 1). 6. To get the p -value for a lower tail test, type =TDIST( (-1)*your test statistic, degrees of freedom, 1) in an empty cell. Here, (-1)*your test statistic is the number you com- puted in part 4 multiplied by (-1). The degrees of freedom is the number you computed in part 5. The 1 indicates this is a one tailed test. Note: we can also get p -values for upper tailed tests and two-tailed tests: To get the p -value for an upper tail test, type =TDIST(your test statistic, degrees of freedom, 1) in an empty cell. To get the p -value for a two-tailed test: If your test statistic is negative, type =TDIST( (-1)*your test statistic, degrees of freedom, 2) If your test statistic is positive, type =TDIST( your test statistic, degrees of freedom, 2) 7. If your p -value is less than α = 0 . 01 reject H 0 . If your p -value is greater than α = 0 . 01 do not reject H 0 . 2
This is the end of the preview. Sign up to access the rest of the document.
• Fall '10
• Jager,AbigailL
• Statistics, Lower Atlantic, *your test statistic

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern