You will analyze data that shows some details of a sample of 804 CARS.

Reports will be graded based upon the ability to present clear and correct results that demonstrate that they have learned the techniques that they have been taught in the course.

The CAR data consists of 12 variables:

X1 = Mileage

X2 = Price

X3 = Make

X4 = Model

X5 = Trim

X6 = Type

X7 = Cylinder

X8 = Liter

X9 = Doors

X10 = Cruise

X11 = Sound

X12 = Leather

Requirement:

1. Input the data for variables into an SPSS data sheet.
2. Using independent two-samples t test to test if there is a significant difference in the mean value of
3. prices for different makes of vehicles. Make sure that you summarize the details of statistical test in a table by listing out their test statistics, p-value, confidence interval of the mean value, etc. The results cannot be edited further in Word.
4. How many pairs of comparison that you have conducted in Question 2. List out all possible combinations.
5. Focusing on the one selected Make (It is free of your choice, for example, you can pick Buick), using an appropriate statistical test to decide if there is a significant difference in the mean value of prices for different models. Report the details of the statistical test.

H Name Type Width Decimals Label Values Missing Columns Align Measure Role H Mileage Numeric 5 0 None None 8 Right Scale Input N Price Numeric 12 6 None None 14 Right Scale Input W Make String 9 0 None None 9 Left Nominal Input A Model String 11 0 None None 11 Left Nominal Input UT Trim String 19 0 None None 19 Left Nominal Input 6 Type String 11 0 None None 11 Left Nominal Input 7 Cyl Numeric H 0 None None 8 Right Nominal Input 8 Liter Numeric 3 H None None 8 Right Scale Input 9 Doors Numeric 0 None None 8 Right Nominal Input 10 Cruise Numeric H 0 None None 8 Right Nominal Input 11 Sound Numeric O None None 8 Right Nominal Input 12 Leather Numeric H 0 None None 8 Right Nominal Input