The mean price for used cars is $10,550. 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.
a. Formulate the hypotheses that can be used to determine whether a difference exists in the mean price for used cars at the dealership.
b. What is the p-value?
c. At αα= .05, what is your conclusion?