Data from which I used excel to do the following three regressions The question is as follows Is the effect of edu on earnings different for men than for women? Specify and estimate a regression that you can use to answer this question. I think the effe

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
icon
Concept explainers
Question

Given: Data from which I used excel to do the following three regressions

The question is as follows

Is the effect of edu on earnings different for men than for women? Specify and estimate a regression that you can use to answer this question.

I think the effect of educations of more signifcant for men than women but I'm not sure how i would show this is a regression.

SUMMARY OUTPUT
Regression Statistics
Multiple R
R Square
Adjusted R S 0.31182246
Standard Erre 3.06365368
0.56424865
0.31837653
Observations
526
ANOVA
df
MS
Significance F
F
Regression
5
2279.7079 455.941579 48.5769069 3.0428E-41
Residual
520 4880.70641 9.38597387
Total
525 7160.41431
Coefficients Standard Erro.
t Stat
P-value
Lower 95%
Upper 95% Lower 95.0% Upper 95.0%
Intercept
educ
-2.2090053 0.80765943 -2.7350703 0.00644963 -3.7956817 -0.6223289 -3.7956817 -0.6223289
0.60465381 0.05380413 11.2380552 2.2078E-26 0.49895362 0.71035399 0.49895362 0.71035399
0.05894878
0.0112905 5.22109466 2.5761E-07 0.03676818 0.08112939 0.03676818 0.08112939
өxper
female
-2.0832992
0.2722011
-7.6535297 9.5722E-14 -2.6180482 -1.5485502 -2.6180482 -1.5485502
married
0.55718746 0.30554998 1.82355585 0.06879314 -0.0430766 1.15745155
-0.0430766 1.15745155
numdep
0.15806061 0.11274027 1.40198891 0.16151519 -0.0634218 0.37954298
-0.0634218 0.37954298
Transcribed Image Text:SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R S 0.31182246 Standard Erre 3.06365368 0.56424865 0.31837653 Observations 526 ANOVA df MS Significance F F Regression 5 2279.7079 455.941579 48.5769069 3.0428E-41 Residual 520 4880.70641 9.38597387 Total 525 7160.41431 Coefficients Standard Erro. t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept educ -2.2090053 0.80765943 -2.7350703 0.00644963 -3.7956817 -0.6223289 -3.7956817 -0.6223289 0.60465381 0.05380413 11.2380552 2.2078E-26 0.49895362 0.71035399 0.49895362 0.71035399 0.05894878 0.0112905 5.22109466 2.5761E-07 0.03676818 0.08112939 0.03676818 0.08112939 өxper female -2.0832992 0.2722011 -7.6535297 9.5722E-14 -2.6180482 -1.5485502 -2.6180482 -1.5485502 married 0.55718746 0.30554998 1.82355585 0.06879314 -0.0430766 1.15745155 -0.0430766 1.15745155 numdep 0.15806061 0.11274027 1.40198891 0.16151519 -0.0634218 0.37954298 -0.0634218 0.37954298
SUMMARY OUTPUT
Regression Statistics
Multiple R
R Square
0.65682965
0.43142519
Adjusted R S 0.42262712
Standard Err 0.17540702
Observations
526
ANOVA
df
MS
F
Significance F
Regression
8 12.0698639 1.50873299 49.0363833
9.845E-59
Residual
517 15.9068614 0.03076762
Total
525 27.9767253
Coefficients Standard Ero
t Stat
P-value
Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept
0.16187881 0.05486447 2.95052153 0.00331624 0.05409409 0.26966353 0.05409409 0.26966353
educ
0.03301773 0.00387496 8.52079887 1.7436E-16 0.02540513 0.04063033 0.02540513 0.04063033
0.01616746 0.00227787 7.09762926 4.2092E-12 0.01169245 0.02064248 0.01169245 0.02064248
еxper
female
-0.0624946 0.07474726 -0.8360787
0.4034969 -0.2093403 0.08435112 -0.2093403 0.08435112
maried
0.11743652 0.02504955 4.68816907 3.5312E-06
0.0682251 0.16664794
0.0682251 0.16664794
numdep
exper^2
female * edu 0.00134151 0.00572372 0.23437727 0.81478489
female * mar -0.1579155
-0.0144342 0.00677563
-2.1303145 0.03361711
-0.0277454 -0.0011231
-0.0277454 -0.0011231
-0.000299 4.9975E-05
-5.9824669 4.1073E-09
-0.0003972
-0.0002008
-0.0003972 -0.0002008
-0.0099031 0.01258612 -0.0099031 0.01258612
0.0321403
4.9133179 1.2037E-06
-0.2210572 -0.0947739
-0.2210572
-0.0947739
SUMMARY OUTPUT
Regression Statistics
Multiple R
R Square
Adjusted R S 0.3979933
Standard Erre 0.17910984
Observations
0.63629661
0.40487338
526
ANOVA
df
MS
F
Significance F
Regression
6 11.3270312 1.88783854 58.8472192
1.832E-55
Residual
519 16.6496941 0.03208034
Total
525 27.9767253
Coefficients Standard Ero.
t Stat
P-value
Lower 95%
Upper 95% Lower 95.0% Upper 95.0%
Intercept
0.19491815 0.04723164 4.12685549 4.2837E-05 0.10212945 0.28770685 0.10212945 0.28770685
educ
0.03442776 0.00320564
10.739746 1.9661E-24 0.02813013 0.04072539 0.02813013 0.04072539
exper
0.01626282 0.00232517 6.99423735 8.2538E-12 0.01169491 0.02083073 0.01169491 0.02083073
female
-0.1419812
0.0159141 -8.9217245 7.8791E-18 -0.1732452 -0.1107173 -0.1732452
-0.1107173
married
0.03226401 0.01846498 1.74730847 0.08117529 -0.0040113
0.0685393 -0.0040113
0.0685393
numdep
exper^2
-0.0102891 0.00686473 -1.4988368 0.13452396 -0.0237752 0.00319697
-0.0237752 0.00319697
-0.0002958 5.0991E-05 -5.8018953 1.1414E-08
-0.000396 -0.0001957
-0.000396
-0.0001957
Transcribed Image Text:SUMMARY OUTPUT Regression Statistics Multiple R R Square 0.65682965 0.43142519 Adjusted R S 0.42262712 Standard Err 0.17540702 Observations 526 ANOVA df MS F Significance F Regression 8 12.0698639 1.50873299 49.0363833 9.845E-59 Residual 517 15.9068614 0.03076762 Total 525 27.9767253 Coefficients Standard Ero t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 0.16187881 0.05486447 2.95052153 0.00331624 0.05409409 0.26966353 0.05409409 0.26966353 educ 0.03301773 0.00387496 8.52079887 1.7436E-16 0.02540513 0.04063033 0.02540513 0.04063033 0.01616746 0.00227787 7.09762926 4.2092E-12 0.01169245 0.02064248 0.01169245 0.02064248 еxper female -0.0624946 0.07474726 -0.8360787 0.4034969 -0.2093403 0.08435112 -0.2093403 0.08435112 maried 0.11743652 0.02504955 4.68816907 3.5312E-06 0.0682251 0.16664794 0.0682251 0.16664794 numdep exper^2 female * edu 0.00134151 0.00572372 0.23437727 0.81478489 female * mar -0.1579155 -0.0144342 0.00677563 -2.1303145 0.03361711 -0.0277454 -0.0011231 -0.0277454 -0.0011231 -0.000299 4.9975E-05 -5.9824669 4.1073E-09 -0.0003972 -0.0002008 -0.0003972 -0.0002008 -0.0099031 0.01258612 -0.0099031 0.01258612 0.0321403 4.9133179 1.2037E-06 -0.2210572 -0.0947739 -0.2210572 -0.0947739 SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R S 0.3979933 Standard Erre 0.17910984 Observations 0.63629661 0.40487338 526 ANOVA df MS F Significance F Regression 6 11.3270312 1.88783854 58.8472192 1.832E-55 Residual 519 16.6496941 0.03208034 Total 525 27.9767253 Coefficients Standard Ero. t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 0.19491815 0.04723164 4.12685549 4.2837E-05 0.10212945 0.28770685 0.10212945 0.28770685 educ 0.03442776 0.00320564 10.739746 1.9661E-24 0.02813013 0.04072539 0.02813013 0.04072539 exper 0.01626282 0.00232517 6.99423735 8.2538E-12 0.01169491 0.02083073 0.01169491 0.02083073 female -0.1419812 0.0159141 -8.9217245 7.8791E-18 -0.1732452 -0.1107173 -0.1732452 -0.1107173 married 0.03226401 0.01846498 1.74730847 0.08117529 -0.0040113 0.0685393 -0.0040113 0.0685393 numdep exper^2 -0.0102891 0.00686473 -1.4988368 0.13452396 -0.0237752 0.00319697 -0.0237752 0.00319697 -0.0002958 5.0991E-05 -5.8018953 1.1414E-08 -0.000396 -0.0001957 -0.000396 -0.0001957
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Correlation, Regression, and Association
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar 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