Regression using excel Conduct a multiple regression analysis for the following data. Use Assessed Value as the dependent variable and all others as independent variables. Which of the following independent variables are satistically significant? Use p < 0.05 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 3960 3 2 17 1447 1280 1 1 45 433 5000 4 2 31 1878 1280 1 1 45 433 3660 3 2 38 1567 3960 3 2 17 1447 4880 3 2 42 1678 What is the R square? Interpret its meaning.
Regression using excel Conduct a multiple regression analysis for the following data. Use Assessed Value as the dependent variable and all others as independent variables. Which of the following independent variables are satistically significant? Use p < 0.05 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 3960 3 2 17 1447 1280 1 1 45 433 5000 4 2 31 1878 1280 1 1 45 433 3660 3 2 38 1567 3960 3 2 17 1447 4880 3 2 42 1678 What is the R square? Interpret its meaning.
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
Regression using excel
- Conduct a multiple
regression analysis for the following data. Use Assessed Value as the dependent variable and all others as independent variables. - Which of the following independent variables are satistically significant? Use p < 0.05
|
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 |
|
3960 |
3 |
2 |
17 |
1447 |
|
1280 |
1 |
1 |
45 |
433 |
|
5000 |
4 |
2 |
31 |
1878 |
|
1280 |
1 |
1 |
45 |
433 |
|
3660 |
3 |
2 |
38 |
1567 |
|
3960 |
3 |
2 |
17 |
1447 |
|
4880 |
3 |
2 |
42 |
1678 |
- What is the R square? Interpret its meaning.
- What is the standard error?
- What is the resulting model?
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 4 steps with 1 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman