Great Deal! Get Instant \$10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

# 1. Return to the ‘cars.xlsx’ dataset that was used in the Unit 6 Homework. Recall that this dataset includes data on the 0-60 time (TIME), top speed (SPEED), curb weight (WEIGHT), and horsepower (HP)...

1. Return to the ‘cars.xlsx’ dataset that was used in the Unit 6 Homework. Recall that this dataset includes data on the 0-60 time (TIME), top speed (SPEED), curb weight (WEIGHT), and horsepower (HP) of 30 automobiles.

There are good reasons based in physics to believe that the relationship between horsepower and 0-60 time is non-linear. Look again at the scatter plot of HP (x-axis) and 0-60 time (y-axis) from the Unit 6 Homework. To test the goodness of fit of one possible non-linear relationship estimate the following quadratic regression: TIMEi = β0 + β1HPi + β2HPi2 + ε Please include your regression results with your answers (and submit the excel file to the D2L dropbox for the Unit 7 Homework).

Compare the results from this regression to those from the Unit 6 Homework. Which do you prefer and why?

Answered Same Day Oct 09, 2019

## Solution

David answered on Nov 30 2019
CARS7
OBS    MAKE    MODEL    TIME    SPEED    WEIGHT    HP    HP^2
1    Audi    TT Roadster    8.9    133    1335    150    22500
2    Mini     Cooper S    7.4    134    1240    168    28224
3    Volvo    C70 T5 Sport    7.4    150    1711    220    48400
4    Saab    Nine-Three    7.9    149    1680    247    61009
5    Mercedes-Benz    SL350    6.6    155    1825    268    71824
6    Jaguar    XK8    6.7    154    1703    290    84100
7    Bugatti    Veyron 16.4    2.4    253    1950    1000    1000000
8    Lotus    Exige    4.9    147    875    189    35721
9    BMW    M3 (E30)    6.7    144    1257    220    48400
10    BMW    330i Sport    5.9    155    1510    231    53361
11    Porsche    Cayman S    5.3    171    1350    291    84681
12    Nissan    Skyline GT-R (R34)    4.7    165    1560    276    76176
13    Porsche    911 RS    4.7    172    1270    300    90000
14    Ford    Shelby GT    5    150    1584    319    101761
15    Mitsubishi    Evo VII RS Sprint    4.4    150    1260    320    102400
16    Aston Martin    V8 Vantage    5.2    175    1630    380    144400
17    Mercedes-Benz    SLK55 AMG    4.8    155    1540    355    126025
18    Maserati    Quattroporte Sport GT    5.1    171    1930    394    155236
19    Spyker    C8    4.5    187    1275    400    160000
20    Fe
ari    288GTO    4.9    189    1161    400    160000
21    Mosler    MT900    3.9    190    1130    435    189225
22    Lamborghini    Countach QV    4.9    180    1447    455    207025
23    Chrysler    Viper GTS-R    4    190    1290    460    211600
24    Bentley    Arnage T    5.2    179    2585    500    250000
25    Fe
ari    430 Scuderia    3.5    198    1350    503    253009
26    Saleen    S7    3.3    240    1247    550    302500
27    Lamborghini    Murcielago    4    205    1650    570    324900
28    Pagani    Zonda F    3.6    214    1230    602    362404
29    McLaren    F1    3.2    240    1140    627    393129
30    Koenigsegg...
SOLUTION.PDF