Scribd
Upload
9 views41 pages

Econ Assignment 2

The document presents regression analysis results for three different datasets, detailing statistics such as R Square, coefficients, and ANOVA results. It includes t-tests for comparing means based on height, with significant p-values indicating strong relationships. Additionally, it provides confidence intervals and margin of error calculations for the differences in means.

Uploaded by

Spandan Roy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
9 views41 pages

Econ Assignment 2

The document presents regression analysis results for three different datasets, detailing statistics such as R Square, coefficients, and ANOVA results. It includes t-tests for comparing means based on height, with significant p-values indicating strong relationships. Additionally, it provides confidence intervals and margin of error calculations for the differences in means.

Uploaded by

Spandan Roy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

d.

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.1042847
R Square 0.0108753
Adjusted R Square
0.01081994
Standard Error 26777.2396
Observations 17870

ANOVA
df SS MS F Significance F
Regression 1 1.40863E+11 1.4086E+11 196.4563546 2.12987E-44
Residual 17868 1.28117E+13 717020563
Total 17869 1.29526E+13

Coefficients Standard Error t Stat P-value Lower 95% Upper 95%


Intercept -512.73359 3386.856151 -0.1513892 0.879670383 -7151.29936 6125.832175
X Variable 1 707.671558 50.4892246 14.0162889 2.12987E-44 608.7077929 806.635324

f. SUMMARY OUTPUT

Regression Statistics
Multiple R 0.05169605
R Square 0.00267248
Adjusted R Square
0.00257247
Standard Error 26800.8958
Observations 9974

ANOVA
df SS MS F Significance F
Regression 1 19193661173 1.9194E+10 26.7213998 2.39557E-07
Residual 9972 7.16277E+12 718288013
Total 9973 7.18196E+12

Coefficients Standard Error t Stat P-value Lower 95% Upper 95%


Intercept 12650.8577 6383.741007 1.98173104 0.047536765 137.4364385 25164.27902
X Variable 1 511.22217 98.89630759 5.16927459 2.39557E-07 317.3654394 705.0789007
3a
Median value of height 67

b
i. Using averageif 44488.4359
ii. Using average If 49987.8758
iii. The difference in amounts 5499.4399
To check the confidence interval we set up the null hypothesis and alternate hyopthesis as
Ho: difference is zero
H1: difference is not zero
That is we conduct a 2 sample difference of means t-test

Group 1 Height <=67 n1 10114


Group 2 Height > 67 n2 7756
Var (Group 1) 712910664.5
Var (Group 2) 723424799.5

S.E.(Statistic) 404.6732422
t-stat 13.58982836 p-value 7.42971E-42
t-critical 1.96009676

Therefore, Margin of Error: 793.1987109


Therefore Confidence Interal are: 4706.241191 6292.638613

c.
Scatter Plot
90000

80000

70000

60000

50000

40000

30000

20000

10000

0
0 10 20 30 40 50 60 70 80 90

Series1
g. SUMMARY OUTPUT

Regression Statistics
Multiple R 0.14444001
R Square 0.02086292
Adjusted R Square
0.02073888
Standard Error 26671.2934
Observations 7896

ANOVA
df SS MS F Significance F
Regression 1 1.19651E+11 1.1965E+11 168.2010307 4.4703E-38
Residual 7894 5.61546E+12 711357894
Total 7895 5.73511E+12

Coefficients Standard Error t Stat P-value Lower 95% Upper 95%


Intercept -43130.342 7068.48053 -6.1017841 1.09839E-09 -56986.4341 -29274.2506
X Variable 1 1306.85991 100.7661598 12.969234 4.4703E-38 1109.331575 1504.388236

You might also like