Question
In: Statistics and Probability
Using the GDP Data do the following: Generate the best fit model (regression) Generate the specific...
Using the GDP Data do the following:
- Generate the best fit model (regression)
- Generate the specific regression form
- Explain any dummy variables created
- Explain any time variables created
- Discuss the significance of all variables
- Generate and discuss the residual plot
-
GDP C I G 822.2 625.7 93.6 110.1 751.5 592.3 62.5 121.3 703.6 574.3 39.2 126.6 611.8 523.0 11.8 122.4 603.3 511.0 17.5 118.0 668.3 546.9 31.6 133.0 728.3 580.6 58.4 137.0 822.5 639.6 74.9 158.9 865.8 663.5 93.6 153.2 835.6 652.6 61.9 164.6 903.5 689.0 79.6 179.7 980.7 724.9 110.9 182.4 1148.8 776.7 135.4 303.0 1360.0 758.3 71.6 711.1 1583.7 779.1 42.3 1059.9 1714.1 801.7 52.2 1195.6 1693.3 851.8 69.0 1041.0 1505.5 956.9 175.0 359.7 1495.1 976.4 168.6 307.1 1560.0 998.1 215.3 328.9 1550.9 1025.3 164.3 367.3 1686.6 1090.9 232.5 367.4 1815.1 1107.1 233.2 500.0 1887.3 1142.4 211.1 605.1 1973.9 1197.2 221.0 647.5 1960.5 1221.9 210.8 602.9 2099.5 1310.4 262.1 580.4 2141.1 1348.8 258.6 580.8 2183.9 1381.8 247.4 606.7 2162.8 1393.0 226.5 626.2 2319.0 1470.7 272.9 661.4 2376.7 1510.8 272.8 661.3 2432.0 1541.2 271.0 693.2 2578.9 1617.3 305.3 735.0 2690.4 1684.0 325.7 752.4 2846.5 1784.8 352.6 767.1 3028.5 1897.6 402.0 791.1 3227.5 2006.1 437.3 862.1 3308.3 2066.2 417.2 927.1
Solutions
Expert Solution
Generate the best fit model (regression)
| SUMMARY OUTPUT | ||||||
| Regression Statistics | ||||||
| Multiple R | 0.99967511 | |||||
| R Square | 0.999350325 | |||||
| Adjusted R Square | 0.999294639 | |||||
| Standard Error | 20.70268274 | |||||
| Observations | 39 | |||||
| ANOVA | ||||||
| df | SS | MS | F | Significance F | ||
| Regression | 3 | 23075070.98 | 7691690.326 | 17946.0361 | 8.0381E-56 | |
| Residual | 35 | 15001.03755 | 428.6010728 | |||
| Total | 38 | 23090072.02 | ||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
| Intercept | -4.107255539 | 18.0377833 | -0.227702899 | 0.821202195 | -40.72590242 | 32.51139134 |
| C | 0.961003511 | 0.048690324 | 19.73705311 | 1.50263E-20 | 0.862156898 | 1.059850124 |
| I | 1.613966923 | 0.164158805 | 9.831741416 | 1.31922E-11 | 1.280706832 | 1.947227015 |
| G | 0.730060414 | 0.018998844 | 38.42656941 | 3.25576E-30 | 0.691490709 | 0.768630119 |
Generate the specific regression form
Y=-4.107255539 + 0.961003511(C) +1.613966923(I) +0.730060414(G)
Explain any dummy variables created
No dummy variables were created
Explain any time variables created
No time variables were created
Discuss the significance of all variables
p-values of all the variables C, I and G are lower than 0.05. This means all the variables are significant.
orchestra answered 1 year agoRelated Solutions
Fit your best model to the following data. I would recommend studying the data and then...
Fit your best model to the following data. I would recommend
studying the data and then trying to fit it.
Y X1 X2 X3 X4 X5
12229.31 101.51 77.44 7.32 122.08 51.45
19218.63 109.89 99.24 7.83 119.57 54.4
2579.63 95.75 103.61 4.68 125.69 53.35
7780.87 112.54 128.57 6.78 118.16 56.02
2135.14 108 116.21 4.18 120.68 48.99
1719.99 114.41 112.48 3.09 123.92 58.45
4538.07 123.96 98.62 6.1 122.83 57.47
3243.55 96.29 96.24 5.33 121.36 43.93
6983.13 90.04 121.44 6.57 121.96 47.19...
a. Using the following R codes to fit the linear regression model for VitC on HeadWt,...
a. Using the following R codes to fit the linear regression
model for VitC on HeadWt, and obtain its summary. Paste the R
output in your homework. cabbages_data <-
read.csv("http://users.stat.umn.edu/~wuxxx725/data/cabbages_data.csv")
cabbages_reg <- lm(VitC ~ HeadWt, data = cabbages_data)
summary(cabbages_reg)
b. State and interpret the value of r 2 from the model summary
output in part a).
c. Calculate the correlation r between HeadWt and VitC, and
state the strength and the direction of the correlation.
d. State the estimated regression...
Using the following R codes to fit the linear regression model for VitC on HeadWt, and...
Using the following R codes to fit the linear regression model
for VitC on HeadWt, and obtain its summary. Paste the R output in
your homework. cabbages_data <-
read.csv("http://users.stat.umn.edu/~wuxxx725/data/cabbages_data.csv")
cabbages_reg <- lm(VitC ~ HeadWt, data = cabbages_data)
summary(cabbages_reg)
a. Using the following R codes to fit the linear regression model for VitC on HeadWt,...
a. Using the following R codes to fit the linear regression
model for VitC on HeadWt, and obtain its summary. Paste the R
output in your homework. cabbages_data <-
read.csv("http://users.stat.umn.edu/~wuxxx725/data/cabbages_data.csv")
cabbages_reg <- lm(VitC ~ HeadWt, data = cabbages_data)
summary(cabbages_reg) b. State and interpret the value of r 2 from
the model summary output in part a). c. Calculate the correlation r
between HeadWt and VitC, and state the strength and the direction
of the correlation. d. State the estimated regression...
Using the data, fit an appropriate regression model to determine whether time spent studying (hours) is...
Using the data, fit an appropriate regression model to determine
whether
time spent studying (hours) is a useful predictor of the chance of
passing the exam (result, 0=fail 1=pass). Formally assess
the overall fit of the model.
DATA three;
INPUT result hours;
/* result=0 is fail; result=1 is pass */
cards;
0 0.8
0 1.6
0 1.4
1 2.3
1 1.4
1 3.2
0 0.3
1 1.7
0 1.8
1 2.7
0 0.6
0 1.1
1 2.1
1 2.8
1...
Multiple Regression: Must find a model that best fits the data: USING R 1. Test to...
Multiple Regression: Must find a model that
best fits the data: USING R
1. Test to see if x1 and x2 are highly correlated using
variance inflation factor technique. What can we
conclude? Is Multicollinearity present?
2. Construct scatter plot in R to visualize relationship between
y and each x.
Dataset:
Y= Time
X1= School
X2=District
"School" "District" "Time"
1,3,4
2,6,7
18,9,24
4,10,114
9, 2, 16
Using Excel generate a simple regression model with Y as the dependent variable and X1 and...
Using Excel generate a simple regression model with Y
as the dependent variable and X1 and X2 as the independent
variables in the attached spreadsheet.
Write the following from the output:
Intercept:
Coefficients of Independent variable:
R-square:
Significance F:
Based on the model generated, forecast profits for a firm with
X1= Based on the model generated, forecast profits for a firm with
x1=250 and X2=100.
Evaluate the predictability of the model using explanatory
language that someone who does not have...
Determine the Best Fit Linear Regression Equation Using Technology - Excel Question The table shows the...
Determine the Best Fit Linear Regression Equation Using
Technology - Excel
Question
The table shows the age in years and the number of hours slept
per day by 24 infants who were less than 1 year old. Use Excel to
find the best fit linear regression equation, where age is the
explanatory variable. Round the slope and intercept to one decimal
place.
Age
Hours
0.03
16.5
0.05
15.2
0.06
16.2
0.08
15.0
0.11
16.0
0.19
16.0
0.21
15.0
0.26
14.5...
Fit a multiple regression model using MPG as the dependent variable and DISP, HP, and WT...
Fit a multiple regression model using MPG as the dependent
variable and DISP, HP, and WT as the independent variables.
Is the overall regression model significant? Test at the α =
0.05 level of significance. State the null hypothesis, the
alternative hypothesis =, the test statistic calculated and
critical values and your test conclusion.
mpg
disp
hp
wt
21
160
110
2.62
21
160
110
2.875
22.8
108
93
2.32
21.4
258
110
3.215
18.7
360
175
3.44
18.1
225...
Develop the best logistic regression model that can predict the wage by using the combination of...
Develop the best logistic regression model that can predict the
wage by using the
combination of any following variables: total unit (X2),
constructed unit (X3), equipment
used (X4), city location (X5) and total cost of a project (X6).
Make sure that you partition
your data with 60% training test, 40% validation test, and default
seed of 12345 before
running the logistic regression (15 points)
Wage - X1
Total Unit - X2
Contracted Units - X3
Equipment Used - X4
City...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- 1) Alternative compiled code sequence using instructions in classes A, B, C. What is the average...
- An asset is purchased on January 1 for $48,700. It is expected to have a useful...
- Do we have any online or offline tool to convert c and cpp programs into MIPS...
- -what is the pH of HCl 0,1M and NaCl 0,1M mixed together solution? -What is the...
- function X=extractDWT(x_train,startS,endS,wStep,wRange) % x_train = input signal % startS = from second % endS = end...
- Do you agree that Social Loafing is similar to Theory X. Give an example to support...
- Computing Cost of Goods Sold and Ending Inventory. Bartov Corporation reports the following beginning inventory and...
ADVERTISEMENT