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
HR Organizational Chart
View
SWOT PRO
View
Branching diagram
View
Fishbone Diagram
View
Puzzle Diagram
View
Gear Diagram
View
Square Timeline Diagram
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