# We want to determine the factors that affect selling prices of Ford Mustangs (answer attached) - 14482

Solution Posted by

## SERVICE

Rating : (1)A+
Solution Detail
Price: \$14.00
• From: ,
• Posted on: Sun 21 Oct, 2012
• Request id: None
• Purchased: 0 time(s)
• Average Rating: No rating
Request Description

We want to determine the factors that affect selling prices of Ford Mustangs (answer attached)

Please shows all work in excel.

We want to determine the factors that affect selling prices of Ford Mustangs. The statistical analysis of the data involves hypothesis testing and multiple-regression analysis.
Analyses that you'll want to do are:

1. Test the hypothesis that mean price does not depend on whether the car is a convertible. (Interpret your answer in nontechnical terms for "Tom".) Then, perform the same hypothesis for transmission type, presence or absence of air conditioning, GT model or not, and private versus dealer ownership.

2. Perform a hypothesis test that mean selling price does not vary with color.

3. Find a reasonable multiple regression model of PRICE on the other variables available in the data set. (Which variables are significant, which are not? How do the significant variables affect the PRICE?)

Solution Description

Convertible

The null hypothesis tested is

H0: The mean price does not depend on whether the car is a convertible.

The alternative hypothesis is

H1: The mean price depends on whether the car is a convertible

Attachments