In order to predict the sales price of a sports car, several factors are being investigated. These factors include the speed at ¼ mile (mph), horsepower, and curb weight (in lbs). The data is provided below. You should be able to copy and paste this into an Excel file.:
Dependent Variable:
- The price of the vehicle (Example: A value of 25.035 represents $25,035).
Independent Variables:
- The quarter mile speed
- The horsepower
- The curb weight.
Price ($1000s)
|
Speed at 1/4 mile (mph)
|
Horsepower
|
Curb Weight (lb.)
|
54.365
|
105
|
355
|
3265
|
74.759
|
120.3
|
459
|
3332
|
27.985
|
95.2
|
236
|
3243
|
33.444
|
93.5
|
209
|
3061
|
51.433
|
96.8
|
230
|
3256
|
47.072
|
94.8
|
197
|
3039
|
52.875
|
103.2
|
332
|
3752
|
31.065
|
89.2
|
166
|
2876
|
33.294
|
106.4
|
317
|
3475
|
51.350
|
96.7
|
215
|
2839
|
45.456
|
108.1
|
332
|
3519
|
46.413
|
101
|
250
|
3301
|