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 answer below »

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 DayOct 09, 2019

Answer To : 1. Return to the ‘cars.xlsx’ dataset that was used in the Unit 6 Homework. Recall that this dataset...

David answered on Nov 30 2019
63 Votes
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    V
olvo    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

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here