Question
In: Statistics and Probability
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
orchestra answered 1 year agoRelated 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....
Question
2. The following tables provide some example data that
will be kept in the database. Write the INSERT commands necessary
to place the following data in the tables that were created in
Question 1. Alternatively provide the text files (copy and pasted
into your final report) and the open/insert from file
commands..
Table: actor
act_id | act_fname | act_lname | act_gender
101 | James | Stewart | M
102 | Deborah | Kerr | F
103 | Peter |...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- UNIX ONLY -- DIFFICULT LAB ASSIGNMENT This is an extremely difficult subject for me. Could you...
- Do you know why your credit card can be refused even though you are profitable?
- The Following Java expression: S/10 * 10 + 10 – S = C Show that this...
- Year Cash Flow 0 −$9,700 1 5,800 2 2,500 3 3,400 &nb
- In a two – story building, an exterior column is to be designed for a service...
- Explain the use of neural networking modeling in predictive analytics. Discuss a real-life example of where...
- Boarder line and antisocial disorder are perhaps the most research personality disorder.What are the most common...
ADVERTISEMENT