Want to create interactive content? It’s easy in Genially!
Get started free
10.3 using excel to calculate simple linear regression
BCD Learning Design
Created on November 20, 2020
Start designing with a free template
Discover more than 1500 professional designs like these:
Transcript
Using excel to calculate simple linear regression
Example: Is there a relationship between house prices and square feet
Coefficient of determination (r2)
18934.9348
SSR
r2 =
= 0.58082
SST
32600.5000
Standard error of regression estimate (SER)
SYX = 41.33032