1 answer

From the data in the table below, estimate two regression models using a calculator or MS...

Question:

From the data in the table below, estimate two regression models using a calculator or MS Excel (calculations only) to solve this. At a very minimum, please attempt one using a calculator. Show your work in a table Model 1: Weekly Disposable IncomeAge+ Model 2: Weekly Per Capita Consumption Age+ Age (years) Income (S Weekly Disposable Weekly Consumption per capita (S 30 35 40 45 50 500 550 600 500 900 1000 1000 1200 1500 50 60 60 50 70 75 80 90 60 65 70 For each model a) Find the slope, intercept and model equation. b) Interpret the estimated regression line c) Find and interpret R2 d) Find the predicted value of the dependent variable when Age is 58.

From the data in the table below, estimate two regression models using a calculator or MS Excel (calculations only) to solve this. At a very minimum, please attempt one using a calculator. Show your work in a table Model 1: Weekly Disposable IncomeAge+ Model 2: Weekly Per Capita Consumption Age+ Age (years) Income (S Weekly Disposable Weekly Consumption per capita (S 30 35 40 45 50 500 550 600 500 900 1000 1000 1200 1500 50 60 60 50 70 75 80 90 60 65 70 For each model a) Find the slope, intercept and model equation. b) Interpret the estimated regression line c) Find and interpret R2 d) Find the predicted value of the dependent variable when Age is 58.

Answers

for weekly disposable income-

X(age) Y(weekly disposable income) (x-x̅)² (y-ȳ)² (x-x̅)(y-ȳ)
30 500 400 130401.2 7222.222
35 550 225 96790.12 4666.667
40 600 100 68179.01 2611.111
45 500 25 130401.2 1805.556
50 900 0 1512.346 0
55 1000 25 19290.12 694.4444
60 1000 100 19290.12 1388.889
65 1200 225 114845.7 5083.333
70 1500 400 408179 12777.78
ΣX ΣY Σ(x-x̅)² Σ(y-ȳ)² Σ(x-x̅)(y-ȳ)
total sum 450 7750 1500 988888.9 36250
mean 50 861.111111 SSxx SSyy SSxy

sample size ,   n =   9          
here, x̅ =   50       ȳ =   861.1111111  
                  
SSxx =    Σ(x-x̅)² =    1500          
SSxy=   Σ(x-x̅)(y-ȳ) =   36250          
                  
slope ,    ß1 = SSxy/SSxx =   24.16666667          
                  
intercept,   ß0 = y̅-ß1* x̄ =   -347.2222222          
                  
so, regression line is   Ŷ =   -347.2222   +   24.1667   *x
                  

correlation coefficient ,    r = Sxy/√(Sx.Sy) =   0.9412          
                  
R² =    (Sxy)²/(Sx.Sy) =    0.8859  

-----------------------------

a)

slope = 24.167

intercept= -347.2222

eqn is

Ŷ =   -347.2222   +   24.1667   *x


b) for every unit increase in age, weekly disposable income will get increase by 24.1667

c) R² = 0.8859

88.59% variations in observations of variable Y(weekly disposable income) is explained by variable X(age)

d)

age,X=58

Ŷ =   -347.2222   +   24.1667   *58=1054.444

-----------------------------------------------------------------------------------------------------------------------------------------------------------------

for weekly consumption per capita-

X Y (x-x̅)² (y-ȳ)² (x-x̅)(y-ȳ)
30 50 400 241.9753 311.1111
35 55 225 111.4198 158.3333
40 60 100 30.8642 55.55556
45 60 25 30.8642 27.77778
50 50 0 241.9753 0
55 70 25 19.75309 22.22222
60 75 100 89.19753 94.44444
65 80 225 208.642 216.6667
70 90 400 597.5309 488.8889
ΣX ΣY Σ(x-x̅)² Σ(y-ȳ)² Σ(x-x̅)(y-ȳ)
total sum 450 590 1500 1572.222 1375
mean 50 65.5555556 SSxx SSyy SSxy

sample size ,   n =   9          
here, x̅ =   50       ȳ =   65.55555556  
                  
SSxx =    Σ(x-x̅)² =    1500          
SSxy=   Σ(x-x̅)(y-ȳ) =   1375          
                  
slope ,    ß1 = SSxy/SSxx =   0.916666667          
                  
intercept,   ß0 = y̅-ß1* x̄ =   19.72222222          
                  
so, regression line is   Ŷ =   19.7222   +   0.9167   *x
                     
                  
correlation coefficient ,    r = Sxy/√(Sx.Sy) =   0.8954          
                  
R² =    (Sxy)²/(Sx.Sy) =    0.8017  

------------------------------

a)

slope = 0.9167

intercept= 19.7222

eqn is

Ŷ =   19.7222   +   0.9167   *x

b) for every unit increase in age, weekly per capita consumption will get increase by 0.9167

c) R² = 0.8017

80.17% variations in observations of variable Y is explained by variable X(age)

d)

age,X=58

Ŷ =   19.7222   +   0.9167   *58 = 72.889

.

Similar Solved Questions

1 answer
A resistor rated at 570 kn is connected across two cell batteries (each 1.50 V) in...
A resistor rated at 570 kn is connected across two cell batteries (each 1.50 V) in series, with a total voltage of 3.00 V. The manufacturer advertises that their resistors are within 4% of the rated value. What are the possible minimum current and maximum current through the resistor (in A)? minimum...
1 answer
Compute the integral of the vector field F(x, y, z) = (2x, 29, 42) over (1)...
Compute the integral of the vector field F(x, y, z) = (2x, 29, 42) over (1) = (cos(i), sin(i),1) for OSISK (Use symbolic notation and fractions where needed.) F. dr =...
1 answer
1. In a one-period model, the share price starts at S and in one month’s time...
1. In a one-period model, the share price starts at S and in one month’s time is either SU or S/U where U > 1. Assuming rates are zero, show that the risk-neutral probability p of the upmove is given by p = 1/(U + 1). Hence, or otherwise, deduce that the probability of the share price incre...
1 answer
8. TV channel 3 (VHF) broadcasts at a frequency of 63.0 MHz, channel 23 is a...
8. TV channel 3 (VHF) broadcasts at a frequency of 63.0 MHz, channel 23 is a (UHF) frequency of 527 MHz, and shortwave radio bands reserved for amateur "hams" is 1.8 MHz. Find the wavelength for each frequency. Additional Problems (PHY 212 only) 9. A 1500 watt sound source is emitting a stea...
1 answer
A harvard english professor attempts to estimate the number of novels that the students read during...
A harvard english professor attempts to estimate the number of novels that the students read during their time in college. professor expects to have margin error of five books at 80% confidence & expects to have a deviation of 15 books to read. how many students should he survey?...
1 answer
Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and...
Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and Maintenance). During July, the following costs and service department usage ratios were recorded: Supplying Department Using Department Engineering Adminis...
1 answer
When creating the financial statement, which should be created THIRD? (Answer IS NOT "B" or "C")...
When creating the financial statement, which should be created THIRD? (Answer IS NOT "B" or "C") Statement of Retained Earnings Income Statement Statement of Cash Flows Balance sheet...
1 answer
Please complete all parts to the problem including the graph section. added extra photos of the...
please complete all parts to the problem including the graph section. added extra photos of the answer choices to choose from so its easier. 4. Expected dividends as a basis for stock values The following graph shows the value of a stock's dividends over time. The stock's current ...
1 answer
A simple instrument consists of two metal strings stretched parallel to one another and attached at...
A simple instrument consists of two metal strings stretched parallel to one another and attached at both ends to boards perpendicular to the strings. The tension is the same in both strings, and the length of the strings is ` = 35.0 cm. The first string has a mass m = 8.00 g and generates middle C (...
1 answer
Assume that the most efficient production technology available for making vitamin pills has the cost structure...
Assume that the most efficient production technology available for making vitamin pills has the cost structure given in the following table. Note that output is measured as the number of bottles of vitamins produced per day and that costs include a normal profit. a. What is ATC per unit for each lev...
1 answer
Erie Company manufactures a mobile fitness device called the Jogging Mate. The company uses standards to...
Erie Company manufactures a mobile fitness device called the Jogging Mate. The company uses standards to control its costs. The labor standards that have been set for one Jogging Mate are as follows: Standard Hours 27 minutes Standard Rate per Hour $5.80 Standard Cost $2.61 During August, 9,415 hour...
1 answer
Name: Date: Writing Skills Assessment Task 1 On the 1" of every month, Division Office employees...
Name: Date: Writing Skills Assessment Task 1 On the 1" of every month, Division Office employees will stay late to assist in the Accounting department's month-end closing procedures, Dinner will be ordered for the Division Office employees. The Administrative Assistant will choose a restaura...
1 answer
The heights of fully grown trees of a specific species are normally distributed, with a mean...
The heights of fully grown trees of a specific species are normally distributed, with a mean of 72 5 feet and a standard imit theorem to find the mean and standand error of the sampling distribution. Than sketch a graph of the sampling distribution rhestardad error of Po sampingdantuon isoiD (Round ...
1 answer
Microeconomics: 1. There are two kinds of goods, food F and shelter S, which are only...
Microeconomics: 1. There are two kinds of goods, food F and shelter S, which are only available in non-negative quantities. Ann's utility from consuming bundle (F, S) is given by the function U(F, S) = F0.690.2. Bob's utility from consuming bundle (F, S) is given by the function V(F, S) = F0...