Want to create interactive content? It’s easy in Genially!
BCD Learning Design
Created on November 20, 2020
Discover more than 1500 professional designs like these:
Explore all templates
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
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:
View
Timeline Diagram
View
Timeline Diagram 3
View
Timeline Diagram 4
View
Timeline Diagram 2
View
Triangle Diagram 3
View
Color Shapes SWOT
View
Lean Business Canvas
Explore all templates
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