Kia Motor Corporation developed the Soul car model to appeal to young consumers. Kia claims the average age of a Soul driver is 24.5 years old. Suppose a random sample of 18 Soul drivers was drawn,...

Asap, in excel formulas


Extracted text: Kia Motor Corporation developed the Soul car model to appeal to young consumers. Kia claims the average age of a Soul driver is 24.5 years old. Suppose a random sample of 18 Soul drivers was drawn, and the average age of the drivers was found to be 26.5 years with a standard deviation for the age of soul drivers is 2.3 years. Construct a 95% confidence interval to estimate the average age of a Soul driver. Is Kia claim correct? in excel formulas