Reference no: EM13579719
Q1. Dun & Bradstreet reports, among other things, information about new business incorporations and number of business failures over several years. Shown here are data on business failures and current liabilities of the failing companies over several years. Use these data and the following model to predict current liabilities of the failing companies by the number of business failures. Discuss the strength of the model.
y = βo β1x ε
Now develop a different regression model by recoding x. Use Tukey's four-quadrant approach as a resource.
|
Rate of Business Failures (10,000)
|
Current Liabilities of Failing Companies ($ millions)
|
|
44
|
1,888
|
|
43
|
4,380
|
|
42
|
4,635
|
|
61
|
6,955
|
|
88
|
15,611
|
|
110
|
16,073
|
|
107
|
29,269
|
|
115
|
36,937
|
|
120
|
44,724
|
|
102
|
34,724
|
|
98
|
39,126
|
|
65
|
44,261
|
Q2. Given here are the data from a dependent variable and two independent variables. The second independent variable is an indicator variable with several categories. Hence, this variable is represented by x2, x3, and x4. How many categories are needed in total for this independent variable? Use a computer to perform a multiple regression analysis on this data to predict y from x values.
|
y
|
x1
|
x2
|
x3
|
x4
|
|
11
|
1.9
|
1
|
0
|
0
|
|
3
|
1.6
|
0
|
1
|
0
|
|
2
|
2.3
|
0
|
1
|
0
|
|
5
|
2
|
0
|
0
|
1
|
|
9
|
1.8
|
0
|
0
|
0
|
|
14
|
1.9
|
1
|
0
|
0
|
|
10
|
2.4
|
1
|
0
|
0
|
|
8
|
2.6
|
0
|
0
|
0
|
|
4
|
2
|
0
|
1
|
0
|
|
9
|
1.4
|
0
|
0
|
0
|
|
11
|
1.7
|
1
|
0
|
0
|
|
4
|
2.5
|
0
|
0
|
1
|
|
6
|
1
|
1
|
0
|
0
|
|
10
|
1.4
|
0
|
0
|
0
|
|
3
|
1.9
|
0
|
1
|
0
|
|
4
|
2.3
|
0
|
1
|
0
|
|
9
|
2.2
|
0
|
0
|
0
|
|
6
|
1.7
|
0
|
0
|
1
|
Q3. The U.S. Energy Information Administration releases figures in their publication, Monthly Energy Review, about the cost of various fuels and electricity. Shown here are the figures for four different items over a 12-year period. Use the data and stepwise regression to predict the cost of residential electricity from the cost of residential natural gas, residential fuel oil, and leaded regular gasoline.
|
Electricity
|
Natural Gas
|
Fuel Oil
|
Gasoline
|
|
234
|
129
|
021
|
0.39
|
|
331
|
1.71
|
031
|
0.57
|
|
4.64
|
298
|
0.44
|
0.86
|
|
536
|
3.68
|
0.61
|
1.19
|
|
62
|
429
|
0.76
|
1.31
|
|
6.86
|
5.17
|
0.68
|
1.22
|
|
7.18
|
6.06
|
0.65
|
1.16
|
|
7.54
|
6.12
|
0.69
|
1.13
|
|
7.79
|
6.12
|
0.61
|
1.12
|
|
7.41
|
5.83
|
034
|
0.86
|
|
7.41
|
534
|
0.42
|
0.9
|
|
7.49
|
4.49
|
033
|
0.9
|
Q4. Study the three predictor variables in problem 3 and attempt to determine whether substantial multicollinearity is present between the predictor variables. If there is a problem with multicollinearity, how might it affect the outcome of the multiple regression analysis?
Q5. Figures for acres of tomatoes harvested in the U.S. from an 11-year period follow. The data are published by the U.S. Department of Agriculture. Compute MAD and MSE on these forecasts. Comment on the errors.
|
Year
1
|
Number of Acres
140000
|
Forecast
|
|
2
|
141730
|
140000
|
|
3
|
134590
|
141038
|
|
4
|
131710
|
137169
|
|
5
|
131910
|
133894
|
|
6
|
134250
|
132704
|
|
7
|
135220
|
133632
|
|
8
|
131020
|
134585
|
|
9
|
120640
|
132446
|
|
10
|
115190
|
125362
|
|
11
|
114510
|
119259
|
Q6. The U.S. Census Bureau publishes data on factory orders for all manufacturing, durable goods, and nondurable goods industries. Shown here are factory orders in the U.S. over a 13-year period ($ billion).
a. Use these data to develop forecasts for the years 6 through 13 using a 5-year moving average.
b. Use these data to develop forecasts for the years 6 through 13 using a 5-year weighted moving average. Weight the most recent year by 6, the previous year by 4, the year before that by 2, and the other years by 1.
c. Compute the errors of the forecasts in parts (a) and (b)
|
Year
|
Factory Orders ($ billion)
|
|
1
|
2,512.7
|
|
2
|
2,7392
|
|
3
|
2,874.9
|
|
4
|
2,934.1
|
|
5
|
Z8653
|
|
6
|
2,978.5
|
|
7
|
3,0924
|
|
S
|
3,3562
|
|
9
|
3,607.6
|
|
10
|
3,7493
|
|
11
|
3,952.0
|
|
12
|
3,949.0
|
|
13
|
4,137.0
|
Q7. Shown below are dollar figures for commercial and industrial loans at all commercial banks in the U.S. as recorded for the month of April during a recent 9-year period and published by the Federal Reserve Bank of St. Louis. Plot the data, fit a trend line, and discuss the strength of the regression model. In addition, explore a quadratic trend and compare the results of the two models.
|
Year
|
Loans ($ billions)
|
|
1
|
741.0
|
|
2
|
807.4
|
|
3
|
871.3
|
|
4
|
951.6
|
|
5
|
1033.6
|
|
6
|
1089.8
|
|
7
|
1002.6
|
|
8
|
940.8
|
|
9
|
888.5
|