The mean price for used cars is $10,681. A manager of a Kansas City used car dealership reviewed a sample of 50 recent used car sales at the dealership in an attempt to determine whether the population mean price for used cars at this particular dealership differed from the national mean. The prices for the sample of 50 cars are contained in the Excel Online file below. Construct a spreadsheet to answer the following questions.
Sale Price | ||||
11068 | Sample Size | 50 | ||
11735 | ||||
9145 | Sample Mean (to the whole number) | |||
6786 | ||||
11780 | Sample Standard Deviation (to the whole number) | |||
11389 | ||||
6471 | Hypothesized Mean | 10681 | ||
12100 | ||||
8176 | Test Statistic (3 decimals) | |||
11639 | ||||
8400 | Degrees of Freedom | |||
8086 | ||||
12654 | p-value (4 decimals) | |||
8875 | ||||
11482 | Level of Significance (Alpha) | 0.02 | ||
6568 | ||||
6390 | Reject Null Hypothesis? | |||
6561 | ||||
7642 | Can conclude the population mean price at this dealership differs from the national mean price? | |||
6841 | ||||
8066 | ||||
6605 | ||||
10486 | ||||
8843 | ||||
9653 | ||||
10360 | ||||
12705 | ||||
7856 | ||||
11700 | ||||
12101 | ||||
11650 | ||||
11304 | ||||
9725 | ||||
8607 | ||||
11387 | ||||
6475 | ||||
7229 | ||||
8945 | ||||
7525 | ||||
7109 | ||||
12363 | ||||
10625 | ||||
12326 | ||||
9690 | ||||
6776 | ||||
13198 | ||||
8468 | ||||
7862 | ||||
12212 | ||||
12723 |
What are the test statistic and the p-value? Do not round intermediate calculations.
test statistic | (to 3 decimals) |
p-value | (to 4 decimals) |
Get Answers For Free
Most questions answered within 1 hours.