Question #2 - Review 'Cars Database'. From this data set develop the following: a. One bivariate...

Question #2 - Review 'Cars Database'. From this data set develop the following: a. One bivariate regression b. One multiple regression c. Provide an effective chart displaying each of the two regressions. Charts should be presentation ready with effective title and labels. d. Provide a brief description of each of the two regressions (please use a text box in your Excel spreadsheet for your descriptions). Also, be sure to correctly identify and describe your independent and dependent variables, linear equation (answer), R, R square, F statistics, t statistic, other.

ENGINE	HORSE	WEIGHT	ACCEL	YEAR	CYLINDER	MPG
307	130	3504	12	70	8	18
350	165	3693	12	70	8	15
318	150	3436	11	70	8	18
304	150	3433	12	70	8	16
302	140	3449	11	70	8	17
429	198	4341	10	70	8	15
454	220	4354	9	70	8	14
440	215	4312	9	70	8	14
455	225	4425	10	70	8	14
390	190	3850	9	70	8	15
383	170	3563	10	70	8	15
340	160	3609	8	70	8	14
400	150	3761	10	70	8	15
455	225	3086	10	70	8	14
113	95	2372	15	70	4	24
198	95	2833	16	70	6	22
199	97	2774	16	70	6	18
200	85	2587	16	70	6	21
97	88	2130	15	70	4	27
97	46	1835	21	70	4	26
110	87	2672	18	70	4	25
107	90	2430	15	70	4	24
104	95	2375	18	70	4	25
121	113	2234	13	70	4	26
199	90	2648	15	70	6	21
360	215	4615	14	70	8	10
307	200	4376	15	70	8	10
318	210	4382	14	70	8	11
97	88	2130	15	71	4	27
140	90	2264	16	71	4	28
113	95	2228	14	71	4	25
232	100	2634	13	71	6	19
225	105	3439	16	71	6	16
250	100	3329	16	71	6	17
250	88	3302	16	71	6	19
232	100	3288	16	71	6	18
350	165	4209	12	71	8	14
400	175	4464	12	71	8	14
351	153	4154	14	71	8	14
318	150	4096	13	71	8	14
383	180	4955	12	71	8	12
400	170	4746	12	71	8	13

Solutions

Expert Solution

orchestra answered 1 year ago

Next > < Previous

Related Solutions

a) Run a regression analysis on the following bivariate set of data with y as the...

a) Run a regression analysis on the following bivariate set of data with y as the response variable. x y 10.7 81.6 13.7 81.5 36.7 56.5 4 72.1 50.7 23.2 47.6 -4.8 37.3 31.9 24.3 75.2 21.5 59.3 17.2 54.6 23.6 75.5 22.2 60.8 29.3 51 14 63.4 0.2 102.7 30.7 48.2 10.3 74.8 26.5 48.2 23.1 87 Verify that the correlation is significant at an ?=0.05?=0.05. If the correlation is indeed significant, predict what value (on average) for the...

8. Run a regression analysis on the following bivariate set of data with y as the...

8. Run a regression analysis on the following bivariate set of data with y as the response variable. x y 27.2 68.2 28.1 66.7 28.7 64.6 30.2 66.4 33.7 69.5 31.8 68.3 30.4 67.8 28.6 65.5 32.5 69.4 34.8 67.9 33.3 67.1 28 66.1 - Find the correlation coefficient and report it accurate to three decimal places. r = - What proportion of the variation in y can be explained by the variation in the values of x? Report answer...

Run a regression analysis on the following bivariate set of data with y as the response...

Run a regression analysis on the following bivariate set of data with y as the response variable. x y 15.5 58.8 25.4 62.9 53.7 68.8 46.5 78.6 28.5 57.5 5.7 68.1 -0.4 67.8 43.8 87.7 23.1 64.9 31.3 81.3 48.2 80.1 15.9 71.1 1) Find the correlation coefficient and report it accurate to three decimal places. r = 2) What proportion of the variation in y can be explained by the variation in the values of x? Report answer as...

Run a regression analysis on the following bivariate set of data with y as the response...

Run a regression analysis on the following bivariate set of data with y as the response variable. x y 81 81.3 92.6 90.8 80.1 94.9 77.8 53.4 89.4 102.9 70.3 38.2 90.2 98 81.4 94.6 94.9 122.4 77.2 42.1 70.6 47.8 71 50.6 Find the correlation coefficient and report it accurate to three decimal places. r = What proportion of the variation in y can be explained by the variation in the values of x? Report answer as a percentage...

Run a regression analysis on the following bivariate set of data with y as the response...

Run a regression analysis on the following bivariate set of data with y as the response variable. x y 73 16.1 80 14.9 72.5 8.5 55.8 33.6 54.6 23.4 76.6 26.2 74.6 19.1 40.2 40.6 58.7 25.8 Find the correlation coefficient and report it accurate to three decimal places. What proportion of the variation in y can be explained by the variation in the values of x? Report answer as a percentage accurate to one decimal place. (If the answer...

Run a regression analysis on the following bivariate set of data with y as the response...

Run a regression analysis on the following bivariate set of data with y as the response variable. x y 26.1 54.3 28.4 42.5 33.8 50.2 63.4 63.3 64.3 79.4 72.5 76.1 46.2 57.4 70.2 82.1 50.5 64.3 55.4 58.8 40.7 48.5 69.4 57.5 40.4 47.8 45.1 60 64 72.5 50.6 56.9 44.2 65.6 Verify that the correlation is significant at an α = 0.05 . If the correlation is indeed significant, predict what value (on average) for the explanatory variable...

Run a regression analysis on the following bivariate set of data with y as the response...

Run a regression analysis on the following bivariate set of data with y as the response variable. x y 58.6 56.3 66.3 72.1 54.8 119.2 57.4 83.2 62.8 74.3 77.6 72.2 71.8 62.2 46.4 77.2 77.4 86.6 60.5 78.4 66.4 131.3 76.4 113.5 68.5 84.2 81.5 102 77.5 136.3 49 12.2 Verify that the correlation is significant at an α=0.05. If the correlation is indeed significant, predict what value (on average) for the explanatory variable will give you a value...

Run a regression analysis on the following bivariate set of data with y as the response...

Run a regression analysis on the following bivariate set of data with y as the response variable. x y 37.2 26.9 66.2 41.4 80.9 37.6 83.7 45 55 31.2 46.3 29.1 82 44.1 71.6 36.1 54.7 29.3 56.4 33.8 Predict what value (on average) for the response variable will be obtained from a value of 45.1 as the explanatory variable. Use a significance level of α = 0.05 to assess the strength of the linear correlation. What is the predicted...

Run a regression analysis on the following bivariate set of data with y as the response...

Run a regression analysis on the following bivariate set of data with y as the response variable. x y 62.4 39.2 62.2 40.4 47.7 68.9 120.5 -36.5 49 37.9 69.1 -9.4 53.2 71.8 66 13.8 87 8.4 92.3 -1.6 70.3 17.8 Verify that the correlation is significant at an α=0.05α=0.05. If the correlation is indeed significant, predict what value (on average) for the explanatory variable will give you a value of 67.7 on the response variable. What is the predicted...

Question 2. The following tables provide some example data that will be kept in the database....

Subjects