Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedimage text in transcribed
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 23

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Algebra (Subscription)

Authors: Elayn Martin Gay

7th Edition

0134305116, 9780134305110

More Books

Students also viewed these Mathematics questions

Question

How do I feel just after I give in to my bad habit?

Answered: 1 week ago

Question

1. Maintain my own perspective and my opinions

Answered: 1 week ago