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

Question

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: TIME_i = β₀ + β₁HP_i + β₂HP_i² + ε 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?

tae_636431600522397177_113245_1.xlsx tae_636431600522397177_113245_2.xlsx

David · Accepted Answer

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.

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)...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment