Construct a scatter plot in Excel with FloorArea as the independent variable and AssessmentValue as the dependent variable. Insert the bivariate linear regression equation and r^2 in your graph. Do you observe a linear relationship between the 2 variables? FloorArea (Sq.Ft.) Offices Entrances Age AssessedValue ($'000) 4790 4 2 8 1796 4720 3 2 12 1544 5940 4 2 2 2094 5720 4 2 34 1968 3660 3 2 38 1567 5000 4 2 31 1878 2990 2 1 19 949 2610 2 1 48 910 5650 4 2 42 1774 3570 2 1 4 1187 2930 3 2 15 1113 1280 2 1 31 671 4880 3 2 42 1678 1620 1 2 35 710 1820 2 1 17 678 4530 2 2 5 1585 2570 2 1 13 842 4690 2 2 45 1539 1280 1 1 45 433 4100 3 1 27 1268 3530 2 2 41 1251 3660 2 2 33 1094 1110 1 2 50 638 2670 2 2 39 999 1100 1 1 20 653 5810 4 3 17 1914 2560 2 2 24 772 2340 3 1 5 890 3690 2 2 15 1282 3580 3 2 27 1264 3610 2 1 8 1162 3960 3 2 17 1447
Construct a scatter plot in Excel with FloorArea as the independent variable and AssessmentValue as the dependent variable. Insert the bivariate linear regression equation and r^2 in your graph. Do you observe a linear relationship between the 2 variables? FloorArea (Sq.Ft.) Offices Entrances Age AssessedValue ($'000) 4790 4 2 8 1796 4720 3 2 12 1544 5940 4 2 2 2094 5720 4 2 34 1968 3660 3 2 38 1567 5000 4 2 31 1878 2990 2 1 19 949 2610 2 1 48 910 5650 4 2 42 1774 3570 2 1 4 1187 2930 3 2 15 1113 1280 2 1 31 671 4880 3 2 42 1678 1620 1 2 35 710 1820 2 1 17 678 4530 2 2 5 1585 2570 2 1 13 842 4690 2 2 45 1539 1280 1 1 45 433 4100 3 1 27 1268 3530 2 2 41 1251 3660 2 2 33 1094 1110 1 2 50 638 2670 2 2 39 999 1100 1 1 20 653 5810 4 3 17 1914 2560 2 2 24 772 2340 3 1 5 890 3690 2 2 15 1282 3580 3 2 27 1264 3610 2 1 8 1162 3960 3 2 17 1447
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter4: Equations Of Linear Functions
Section4.6: Regression And Median-fit Lines
Problem 17HP
Related questions
Question
- Construct a
scatter plot in Excel with FloorArea as the independent variable and AssessmentValue as the dependent variable. Insert the bivariate linear regression equation and r^2 in your graph. Do you observe a linear relationship between the 2 variables?
FloorArea (Sq.Ft.) | Offices | Entrances | Age | AssessedValue ($'000) |
4790 | 4 | 2 | 8 | 1796 |
4720 | 3 | 2 | 12 | 1544 |
5940 | 4 | 2 | 2 | 2094 |
5720 | 4 | 2 | 34 | 1968 |
3660 | 3 | 2 | 38 | 1567 |
5000 | 4 | 2 | 31 | 1878 |
2990 | 2 | 1 | 19 | 949 |
2610 | 2 | 1 | 48 | 910 |
5650 | 4 | 2 | 42 | 1774 |
3570 | 2 | 1 | 4 | 1187 |
2930 | 3 | 2 | 15 | 1113 |
1280 | 2 | 1 | 31 | 671 |
4880 | 3 | 2 | 42 | 1678 |
1620 | 1 | 2 | 35 | 710 |
1820 | 2 | 1 | 17 | 678 |
4530 | 2 | 2 | 5 | 1585 |
2570 | 2 | 1 | 13 | 842 |
4690 | 2 | 2 | 45 | 1539 |
1280 | 1 | 1 | 45 | 433 |
4100 | 3 | 1 | 27 | 1268 |
3530 | 2 | 2 | 41 | 1251 |
3660 | 2 | 2 | 33 | 1094 |
1110 | 1 | 2 | 50 | 638 |
2670 | 2 | 2 | 39 | 999 |
1100 | 1 | 1 | 20 | 653 |
5810 | 4 | 3 | 17 | 1914 |
2560 | 2 | 2 | 24 | 772 |
2340 | 3 | 1 | 5 | 890 |
3690 | 2 | 2 | 15 | 1282 |
3580 | 3 | 2 | 27 | 1264 |
3610 | 2 | 1 | 8 | 1162 |
3960 | 3 | 2 | 17 | 1447 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt