Use Excel’s Data Analysis tool to conduct a multiple regression analysis with annual income and household size as independent variables. Choose confidence level at 95%. Using significance level α=0.05. Monthly Household Spending ($) Annual Household Income ($) Household Size 4,016 54,000 3 3,159 30,000 2 5,100 32,000 4 4,742 50,000 5 1,864 31,000 2 4,070 55,000 2 2,731 37,000 1 3,348 40,000 2 4,764 66,000 4 4,110 51,000 3 4,208 25,000 3 4,219 48,000 4 2,477 27,000 1 2,514 33,000 2 4,214 65,000 3 4,965 63,000 4 4,412 42,000 6 2,448 21,000 2 2,995 44,000 1 4,171 37,000 5 5,678 62,000 6 3,623 21,000 3 5,301 55,000 7 3,020 42,000 2 4,828 41,000 7 5,573 54,000 6 2,583 30,000 1 3,866 48,000 2 3,586 34,000 5 5,037 67,000 4 3,605 50,000 2 5,345 67,000 5 5,370 55,000 6 3,890 52,000 2 4,705 62,000 3 4,157 64,000 2 3,579 22,000 3 3,890 29,000 4 2,972 39,000 2 3,121 35,000 1 4,183 39,000 4 3,730 54,000 3 4,127 23,000 6 2,921 27,000 2 4,603 26,000 7 4,273 61,000 2 3,067 30,000 2 3,074 22,000 4 4,820 46,000 5 5,149 66,000 4
Use Excel’s Data Analysis tool to conduct a multiple regression analysis with annual income and household size as independent variables. Choose confidence level at 95%. Using significance level α=0.05. Monthly Household Spending ($) Annual Household Income ($) Household Size 4,016 54,000 3 3,159 30,000 2 5,100 32,000 4 4,742 50,000 5 1,864 31,000 2 4,070 55,000 2 2,731 37,000 1 3,348 40,000 2 4,764 66,000 4 4,110 51,000 3 4,208 25,000 3 4,219 48,000 4 2,477 27,000 1 2,514 33,000 2 4,214 65,000 3 4,965 63,000 4 4,412 42,000 6 2,448 21,000 2 2,995 44,000 1 4,171 37,000 5 5,678 62,000 6 3,623 21,000 3 5,301 55,000 7 3,020 42,000 2 4,828 41,000 7 5,573 54,000 6 2,583 30,000 1 3,866 48,000 2 3,586 34,000 5 5,037 67,000 4 3,605 50,000 2 5,345 67,000 5 5,370 55,000 6 3,890 52,000 2 4,705 62,000 3 4,157 64,000 2 3,579 22,000 3 3,890 29,000 4 2,972 39,000 2 3,121 35,000 1 4,183 39,000 4 3,730 54,000 3 4,127 23,000 6 2,921 27,000 2 4,603 26,000 7 4,273 61,000 2 3,067 30,000 2 3,074 22,000 4 4,820 46,000 5 5,149 66,000 4
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
Use Excel’s Data Analysis tool to conduct a multiple
| Monthly Household Spending ($) | Annual Household Income ($) | Household Size |
| 4,016 | 54,000 | 3 |
| 3,159 | 30,000 | 2 |
| 5,100 | 32,000 | 4 |
| 4,742 | 50,000 | 5 |
| 1,864 | 31,000 | 2 |
| 4,070 | 55,000 | 2 |
| 2,731 | 37,000 | 1 |
| 3,348 | 40,000 | 2 |
| 4,764 | 66,000 | 4 |
| 4,110 | 51,000 | 3 |
| 4,208 | 25,000 | 3 |
| 4,219 | 48,000 | 4 |
| 2,477 | 27,000 | 1 |
| 2,514 | 33,000 | 2 |
| 4,214 | 65,000 | 3 |
| 4,965 | 63,000 | 4 |
| 4,412 | 42,000 | 6 |
| 2,448 | 21,000 | 2 |
| 2,995 | 44,000 | 1 |
| 4,171 | 37,000 | 5 |
| 5,678 | 62,000 | 6 |
| 3,623 | 21,000 | 3 |
| 5,301 | 55,000 | 7 |
| 3,020 | 42,000 | 2 |
| 4,828 | 41,000 | 7 |
| 5,573 | 54,000 | 6 |
| 2,583 | 30,000 | 1 |
| 3,866 | 48,000 | 2 |
| 3,586 | 34,000 | 5 |
| 5,037 | 67,000 | 4 |
| 3,605 | 50,000 | 2 |
| 5,345 | 67,000 | 5 |
| 5,370 | 55,000 | 6 |
| 3,890 | 52,000 | 2 |
| 4,705 | 62,000 | 3 |
| 4,157 | 64,000 | 2 |
| 3,579 | 22,000 | 3 |
| 3,890 | 29,000 | 4 |
| 2,972 | 39,000 | 2 |
| 3,121 | 35,000 | 1 |
| 4,183 | 39,000 | 4 |
| 3,730 | 54,000 | 3 |
| 4,127 | 23,000 | 6 |
| 2,921 | 27,000 | 2 |
| 4,603 | 26,000 | 7 |
| 4,273 | 61,000 | 2 |
| 3,067 | 30,000 | 2 |
| 3,074 | 22,000 | 4 |
| 4,820 | 46,000 | 5 |
| 5,149 | 66,000 | 4 |
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 2 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