Homework Help is Here – Start Your Trial Now!
Math
Statistics
Develop an estimated regression equation with annual income and household size as the independent variables.  Can you explain what to put into excel to generate regression, using the data analysis tool   Below is the data Income ($1000s) Household Size Amount Charged ($) 54 3 4,016 30 2 3,159 32 4 5,100 50 5 4,742 31 2 1,864 55 2 4,070 37 1 2,731 40 2 3,348 66 4 4,764 51 3 4,110 25 3 4,208 48 4 4,219 27 1 2,477 33 2 2,514 65 3 4,214 63 4 4,965 42 6 4,412 21 2 2,448 44 1 2,995 37 5 4,171 62 6 5,678 21 3 3,623 55 7 5,301 42 2 3,020 41 7 4,828 54 6 5,573 30 1 2,583 48 2 3,866 34 5 3,586 67 4 5,037 50 2 3,605 67 5 5,345 55 6 5,370 52 2 3,890 62 3 4,705 64 2 4,157 22 3 3,579 29 4 3,890 39 2 2,972 35 1 3,121 39 4 4,183 54 3 3,730 23 6 4,127 27 2 2,921 26 7 4,603 61 2 4,273 30 2 3,067 22 4 3,074 46 5 4,820 66 4 5,149

Develop an estimated regression equation with annual income and household size as the independent variables.  Can you explain what to put into excel to generate regression, using the data analysis tool   Below is the data Income ($1000s) Household Size Amount Charged ($) 54 3 4,016 30 2 3,159 32 4 5,100 50 5 4,742 31 2 1,864 55 2 4,070 37 1 2,731 40 2 3,348 66 4 4,764 51 3 4,110 25 3 4,208 48 4 4,219 27 1 2,477 33 2 2,514 65 3 4,214 63 4 4,965 42 6 4,412 21 2 2,448 44 1 2,995 37 5 4,171 62 6 5,678 21 3 3,623 55 7 5,301 42 2 3,020 41 7 4,828 54 6 5,573 30 1 2,583 48 2 3,866 34 5 3,586 67 4 5,037 50 2 3,605 67 5 5,345 55 6 5,370 52 2 3,890 62 3 4,705 64 2 4,157 22 3 3,579 29 4 3,890 39 2 2,972 35 1 3,121 39 4 4,183 54 3 3,730 23 6 4,127 27 2 2,921 26 7 4,603 61 2 4,273 30 2 3,067 22 4 3,074 46 5 4,820 66 4 5,149

MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
See similar textbooks
icon
Related questions
Question
  1. Develop an estimated regression equation with annual income and household size as the independent variables. 

Can you explain what to put into excel to generate regression, using the data analysis tool

 

Below is the data

  1. Income
    ($1000s)    		 Household
    Size    		 Amount
    Charged ($)
    54 3 4,016
    30 2 3,159
    32 4 5,100
    50 5 4,742
    31 2 1,864
    55 2 4,070
    37 1 2,731
    40 2 3,348
    66 4 4,764
    51 3 4,110
    25 3 4,208
    48 4 4,219
    27 1 2,477
    33 2 2,514
    65 3 4,214
    63 4 4,965
    42 6 4,412
    21 2 2,448
    44 1 2,995
    37 5 4,171
    62 6 5,678
    21 3 3,623
    55 7 5,301
    42 2 3,020
    41 7 4,828
    54 6 5,573
    30 1 2,583
    48 2 3,866
    34 5 3,586
    67 4 5,037
    50 2 3,605
    67 5 5,345
    55 6 5,370
    52 2 3,890
    62 3 4,705
    64 2 4,157
    22 3 3,579
    29 4 3,890
    39 2 2,972
    35 1 3,121
    39 4 4,183
    54 3 3,730
    23 6 4,127
    27 2 2,921
    26 7 4,603
    61 2 4,273
    30 2 3,067
    22 4 3,074
    46 5 4,820
    66 4 5,149
Expert Solution
steps

Step by step

Solved in 2 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
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 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…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
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
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman
SEE MORE TEXTBOOKS