Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Am I on the right track??? A person wants to know whether the average gas price in County A is cheaper than that in County

image text in transcribedimage text in transcribed

Am I on the right track???

A person wants to know whether the average gas price in County A is cheaper than that in County B. He collects a sample of gas stations from each county and the data is in the Excel file "Gas prices".

Use Excel to do the following:

  1. For each sample, find (i) sample mean, (ii) sample variance.

County A: sample mean = 2.12, sample variance = 0.008

County B: sample mean = 2.16, sample variance = 0.006

  1. At the = 0.01 level of significance, use the p-value approach todetermine whether there is evidence that the population mean price of County A is less than that of County B.

This is a two-tailed test. P-value (two-tail) = 0.05>a(0.01), so there is no evidence the mean average gas price for County A is different from County B.

  1. At the = 0.01 level of significance, use the critical value approach todetermine whether there is evidence that the population mean price of County A is less than that of County B.

From the output, we have:

tStat -2.02358

image text in transcribedimage text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Logic And Structure

Authors: Dirk Van Dalen

5th Edition

1447145585, 9781447145585

More Books

Students also viewed these Mathematics questions

Question

An improvement in the exchange of information in negotiations.

Answered: 1 week ago

Question

1. Effort is important.

Answered: 1 week ago