Plot the standardized residuals against predicted income, from regression in part (a). Check for outliers and explain whether the residual plot supports the assumptions about Ɛ. What is your conclusion? Submit the graph to earn full points.
EDUCATION | AGE | GENDER | INCOME (in $1000) |
12 | 60 | female | 6.5 |
16 | 39 | male | 120 |
16 | 33 | female | 21.75 |
12 | 51 | male | 82.5 |
16 | 42 | female | 55 |
14 | 20 | male | 7.5 |
14 | 57 | male | 37.5 |
13 | 61 | female | 5.5 |
16 | 31 | male | 9 |
12 | 30 | male | 37.5 |
14 | 68 | female | 13.75 |
16 | 50 | male | 32.5 |
12 | 27 | male | 0.5 |
16 | 30 | male | 55 |
18 | 65 | female | 55 |
19 | 36 | male | 67.5 |
12 | 22 | male | 21.75 |
6 | 35 | male | 21.75 |
12 | 67 | female | 9 |
12 | 48 | male | 23.75 |
12 | 48 | female | 45 |
15 | 42 | male | 120 |
14 | 61 | female | 37.5 |
13 | 34 | male | 82.5 |
17 | 53 | male | 82.5 |
12 | 39 | male | 67.5 |
16 | 61 | male | 175 |
18 | 34 | male | 100 |
12 | 39 | female | 45 |
14 | 32 | male | 37.5 |
16 | 54 | female | 45 |
14 | 55 | female | 13.75 |
14 | 62 | male | 32.5 |
6 | 39 | male | 16.25 |
12 | 30 | female | 32.5 |
12 | 35 | female | 16.25 |
16 | 55 | male | 175 |
17 | 43 | male | 175 |
16 | 71 | male | 100 |
16 | 55 | male | 100 |
14 | 68 | female | 45 |
11 | 47 | male | 82.5 |
16 | 30 | male | 55 |
16 | 38 | female | 100 |
16 | 41 | female | 45 |
20 | 62 | female | 120 |
20 | 49 | male | 67.5 |
16 | 52 | female | 100 |
16 | 52 | male | 82.5 |
14 | 33 | male | 82.5 |
Answer:
MINITAB used.
The variable gender is coded as female = 1 and male =0.
Regression Equation
INCOME (in $1000) |
= |
-61.9 + 0.691 AGE - 34.2 Gender + 7.13 EDUCATION |
When age =0, female and 10 years education,
predicted income (in 1000) = -61.9+0.691*45-34.2*1+7.13*10 =6.295
or $6295
When age =0, male and 10 years education,
predicted income (in 1000) = -61.9+0.691*45-34.2*0+7.13*10 =40.495
or $40495.
For male predicted value increases by $34200.
Regression Analysis: INCOME (in $1000) versus AGE, ... r, EDUCATION
Analysis of Variance
Source |
DF |
Adj SS |
Adj MS |
F-Value |
P-Value |
Regression |
3 |
35265 |
11755 |
8.58 |
0.000 |
AGE |
1 |
3544 |
3544 |
2.59 |
0.115 |
Gender |
1 |
12136 |
12136 |
8.85 |
0.005 |
EDUCATION |
1 |
19171 |
19171 |
13.99 |
0.001 |
Error |
46 |
63046 |
1371 |
||
Lack-of-Fit |
43 |
59746 |
1389 |
1.26 |
0.495 |
Pure Error |
3 |
3301 |
1100 |
||
Total |
49 |
98312 |
Model Summary
S |
R-sq |
R-sq(adj) |
R-sq(pred) |
37.0213 |
35.87% |
31.69% |
25.70% |
Coefficients
Term |
Coef |
SE Coef |
T-Value |
P-Value |
VIF |
Constant |
-61.9 |
30.5 |
-2.03 |
0.048 |
|
AGE |
0.691 |
0.430 |
1.61 |
0.115 |
1.18 |
Gender |
-34.2 |
11.5 |
-2.98 |
0.005 |
1.14 |
EDUCATION |
7.13 |
1.91 |
3.74 |
0.001 |
1.04 |
Regression Equation
INCOME (in $1000) |
= |
-61.9 + 0.691 AGE - 34.2 Gender + 7.13 EDUCATION |
Fits and Diagnostics for Unusual Observations
Obs |
INCOME |
Fit |
Resid |
Std |
|
27 |
175.0 |
94.4 |
80.6 |
2.27 |
R |
37 |
175.0 |
90.2 |
84.8 |
2.36 |
R |
38 |
175.0 |
89.0 |
86.0 |
2.38 |
R |
R Large residual
Plot the standardized residuals against predicted income, from regression in part (a). Check for outliers and explain whether the residual plot supports the assumptions about Ɛ. What is your conclusion? Submit the graph to earn full points.
The residuals fan out from left to right rather than exhibiting a consistent spread around the residual = 0 line. The standardized residual vs. fits plot suggests that the error variances are not equal.
Predict the annual income for a female aged 45 with 10 years of education. How much would the predicted income have cha...
a. Using the Excel’s Regression Tool, develop the estimated regression equation to show how income (y annual income in $1000s) is related to the independent variables education(level of education attained in number of years), age ( Develop the dummy variable for the gender variable first. [ 6 points] Use the t test to test whether each of the coefficients obtained in part (a) are significant at .05 level of significance. What are your conclusions? [3 points] Use the F test...
a. Use t and F to test for a significant relationship between HRS1 and age. Use α = 0.05 and make sure you know what hypotheses you are using to conduct the significance tests.[3.5 points] b. Calculate and interpret the coefficient of determination R2. Based on this R2, did the estimated regression equation provide a good fit? Briefly justify your answer. Hint: If you used Excel Regression Tool to answer part c, R2was reported with your output. [2.5 points] Use the...
a Using the Excel’s Regression Tool, develop the estimated regression equation to show how income (y annual income in $1000s) is related to the independent variables education (level of education attained in number of years), age (Develop the dummy variable for the gender variable first. b. Use the t test to test whether each of the coefficients obtained in part (a) are significant at .05 level of significance. What are your conclusions? c. Use the F test to test...
1. Fully interpret the meaning of the coefficient on gender, x3 2. Predict the annual income for a female aged 45 with 10 years of education. How much would the predicted income have changed for a male. 3. Plot the standardized residuals against predicted income, from regression in part (a). Check for outliers and explain whether the residual plot supports the assumptions about Ɛ. What is your conclusion? Submit the graph to earn full point EDUCATION AGE...
Given data: Weight of female nurses in a hospital in lbs. 110 98 119 105 99 100 100 110 Compute the ff. using ungrouped data Mean Median Mode Variance Standard deviation V. The following data represent the respective heights (in inches) of 30 students enrolled in a physical education class. Construct a frequency distribution with eight class intervals. 60.0 59.7 70.1 58.2 62.1 60.1 62.3 62.4 68.3 63.3 67.3 62.7 ...
Subject 5 (10%) Is there a difference between the means of the total of rooms per hotel in Crete and Southern Aegean Islands? Answer your question by calculating an appropriate, symmetric, 95% confidence interval using a Z statistic and equal standard deviations in the two populations. Explain your findings. Region ID : 1= Crete 2=Southern Aegean Islands 3=Ionian Islands STARS Total_Rooms Region_ID ARR_MAY ARR_AUG L_COST 5 412 1 95 160 2.165.000 5 313 1 94 173 2.214.985 5 265 1...
Show all of your work in each question. In parts (d), (e), and (g) make sure to set up your null and alternative hypotheses and write your conclusions. Also, please round your numbers to 2 decimal points. Write legibly and neatly. You can use p-value approach or critical-value approach in writing the conclusions of your hypotheses. A large firm employing tens of thousands of workers has been accused of discriminating against its female managers. The accusation is based on a...
1. Forecast demand for Year 4. a. Explain what technique you utilized to forecast your demand. b. Explain why you chose this technique over others. Year 3 Year 1 Year 2 Actual Actual Actual Forecast Forecast Forecast Demand Demand Demand Week 1 52 57 63 55 66 77 Week 2 49 58 68 69 75 65 Week 3 47 50 58 65 80 74 Week 4 60 53 58 55 78 67 57 Week 5 49 57 64 76 77...
the way this is worded confuses me. Will there be one problem where male weight is x and female bmi is y. or is it two problems where x&y is male weight and bmi for the 1st problem, and x&y is female weight and bmi for problem 2? 2. Using the data set of the Health Exam Results, conduct the following of weight (WT) and Index (BMI). Number the data set from 1 to 40, and select the following individuals:...
7. (a) (15 pts.) With Figure 1 below showing shifts A and B, fill in the blank Table 1 showing the computation of the fraction of Bin Hours in each shift for the different time groups. VI V IV Group 1 A 9-12 13-16 17-20 21-24 Sunday Monday Tuesday Wednesday B B Thursday Friday Saturday Figure 1 Table 1 Computation of Fraction of Bin Hours in Each Shift Days Total in Shift A Fraction in Each Shift B Fraction in...