Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I used regression on Excel and made a graph and table using some data. But I am not sure how to analyze these things. I
I used regression on Excel and made a graph and table using some data.
But I am not sure how to analyze these things.
I need to interpret the graph and R square, coefficient, P-value, and significance F on the table.
As long as you can interpret other things as well, I will appreciate it.
A23 X V fx A B C D E F G H I 1 SUMMARY OUTPUT N W Regression Statistics 4 Multiple R 0.976378196 5 R Square 0.953314381 6 Adjusted R Square 0.951262266 Standard Error 192.4544265 8 Observations 96 LO ANOVA 11 df SS MS F Significance F 12 Regression 4 68825635.06 17206408.77 464.5521 1.24445E-59 13 Residual 91 3370522.27 37038.70626 14 Total 95 72196157.33 15 16 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 17 Intercept 113.4700248 70.83958708 1.601788343 0.11266825 -27.24411262 254.184162 -27.244113 254.184162 18 A -22.461232 17.85221318 -1.258176327 0.21154671 -57.92246043 12.9999964 -57.92246 12.9999964 19 B 0.011518628 0.01533551 0.751108259 0.45452552 -0.018943478 0.04198073 -0.0189435 0.04198073 20 C -2.55996E-05 7.6908E-05 -0.332859293 0.74000612 -0.000178368 0.00012717 -0.0001784 0.00012717 21 D 1.041359607 0.025467195 40.89023508 2.3134E-60 0.990772152 1.09194706 0.99077215 1.09194706 22 23Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started