Question
This part is asking to type or choose the answers from your regression excel file. The data is from CanadianJournal of Economics, August 1992.So it
This part is asking to type or choose the answers from your regression excel file.
The data is from "CanadianJournal of Economics", August 1992.So it is real data.I will send you the individual excel file.
In a very brief introduction:
Absenteeism is a serious employment problem in most countries. Two economists launched a research project to learn more about the problem.
They randomly selected 100 organizations to participate in a 1-year study. For each organization, they recorded:
Column 1: "Average number of days absent per employee (Dependent variable)";
And several variables thought to affect absenteeism (You can also think one or several other variables that "could", you don't really know whether that will impact the absenteeism).
The variables used in this study are:
Column 2: Average employee wage
Column 3: Percentage of part-time employees
Column4: Percentage of unionized employees
Column 5: Availability of Shiftwork(1 = yes; 0 = no)
Column 6: Union-management relationship (1 = good; 0 = not good);
Answer the questions inside the assignments.
Absent | Wage | Pct PT | Pct U | Av Shift | UM Rel |
5.4 | 22477 | 8.5 | 57.1 | 1 | 1 |
4.1 | 29939 | 1.9 | 41.5 | 0 | 1 |
11.5 | 22957 | 12.2 | 52.6 | 1 | 0 |
2.1 | 18888 | 30.8 | 65.1 | 0 | 1 |
5.9 | 15078 | 6.8 | 68.8 | 0 | 1 |
12.9 | 15481 | 5.1 | 46.4 | 0 | 0 |
3.5 | 21481 | 25.3 | 38.9 | 0 | 1 |
2.6 | 29687 | 9.2 | 17.2 | 0 | 0 |
8.6 | 13603 | 8.4 | 12.9 | 0 | 0 |
2.7 | 18303 | 4.9 | 18.1 | 0 | 1 |
6.6 | 20832 | 23.8 | 64.4 | 1 | 1 |
2.1 | 22325 | 24.1 | 63.7 | 1 | 1 |
3.8 | 19964 | 8.6 | 12.2 | 0 | 1 |
4.3 | 32496 | 5.9 | 11.8 | 1 | 0 |
4.3 | 15795 | 2.9 | 25.8 | 0 | 1 |
2.2 | 21138 | 24.3 | 53.2 | 0 | 0 |
8.6 | 18859 | 20.6 | 22.8 | 1 | 1 |
10.8 | 12023 | 9 | 49.8 | 1 | 1 |
2.9 | 33272 | 24 | 39.1 | 1 | 0 |
5.3 | 22325 | 11.9 | 32.6 | 1 | 0 |
8.2 | 26147 | 0 | 67.7 | 1 | 0 |
2.8 | 33229 | 11.7 | 10.8 | 0 | 0 |
2.4 | 37970 | 14.6 | 25.5 | 1 | 1 |
2.8 | 15281 | 27.2 | 31.8 | 0 | 0 |
5 | 19423 | 17.2 | 35 | 1 | 1 |
9.5 | 26587 | 13.9 | 41.9 | 1 | 1 |
4.3 | 22963 | 2.6 | 52.9 | 0 | 1 |
8.9 | 26404 | 6.4 | 64.4 | 0 | 1 |
7.2 | 16315 | 4.9 | 69.7 | 0 | 1 |
5.6 | 26759 | 23.2 | 61.8 | 1 | 1 |
2.4 | 30824 | 13.2 | 52.1 | 0 | 1 |
2.7 | 31979 | 27.7 | 57.4 | 1 | 1 |
13.4 | 23135 | 7 | 15.2 | 0 | 0 |
14.8 | 18014 | 0 | 38.7 | 1 | 0 |
10.7 | 18541 | 13.8 | 69.4 | 1 | 1 |
10.3 | 16747 | 9.9 | 67.2 | 1 | 0 |
4.6 | 13473 | 6.3 | 47.8 | 0 | 1 |
3.9 | 42986 | 13.4 | 24.5 | 1 | 0 |
13.3 | 23964 | 8.8 | 79.4 | 1 | 0 |
2.2 | 30794 | 0.4 | 12.1 | 1 | 0 |
5.7 | 21104 | 14.7 | 71 | 0 | 1 |
11.8 | 19137 | 7.7 | 28 | 1 | 0 |
2.5 | 26058 | 7.3 | 45.6 | 0 | 1 |
2.1 | 22085 | 6.8 | 25.4 | 0 | 1 |
4.1 | 29044 | 8.6 | 40.6 | 0 | 0 |
4.9 | 24205 | 19.6 | 25.1 | 1 | 1 |
7.7 | 17698 | 10.8 | 42.3 | 1 | 1 |
6.3 | 26399 | 4.5 | 63.3 | 1 | 1 |
2.9 | 40590 | 15.9 | 69.4 | 1 | 1 |
2.6 | 24805 | 5.7 | 17.7 | 1 | 1 |
6.1 | 18899 | 13.1 | 54.8 | 1 | 1 |
6 | 26802 | 15.5 | 46.5 | 0 | 1 |
6.7 | 30034 | 11.8 | 53.2 | 1 | 0 |
11.9 | 15713 | 16.6 | 41.2 | 1 | 0 |
9.3 | 18280 | 6.4 | 65 | 1 | 1 |
3.6 | 41009 | 6.7 | 54.9 | 0 | 1 |
2.6 | 24021 | 14 | 20.6 | 1 | 1 |
2.1 | 21836 | 27.6 | 29 | 0 | 1 |
9 | 21157 | 5.5 | 50.2 | 1 | 1 |
11 | 19529 | 14.5 | 56.6 | 1 | 0 |
2.9 | 31240 | 26.3 | 36.4 | 1 | 1 |
2.2 | 20963 | 0 | 0 | 1 | 1 |
3.3 | 33826 | 8.2 | 87.9 | 0 | 1 |
5.9 | 23349 | 0 | 38.5 | 1 | 1 |
4 | 22695 | 25.4 | 47 | 1 | 1 |
10.8 | 30475 | 0 | 69.3 | 1 | 0 |
7.1 | 16631 | 5.9 | 48.2 | 1 | 1 |
2.9 | 28996 | 18.6 | 29.3 | 1 | 1 |
6.2 | 15807 | 16.9 | 42.9 | 1 | 1 |
10.3 | 15585 | 0 | 59.4 | 1 | 0 |
13.5 | 18466 | 9 | 69.4 | 1 | 0 |
6.7 | 35140 | 21.1 | 37.1 | 1 | 1 |
2.6 | 33459 | 14.1 | 19.5 | 1 | 1 |
5.2 | 24357 | 0 | 21.5 | 1 | 1 |
7.2 | 19370 | 3.7 | 35 | 1 | 1 |
3.5 | 21820 | 6.3 | 0 | 1 | 1 |
5.4 | 23351 | 12.3 | 27.1 | 1 | 1 |
5.8 | 22938 | 6.8 | 68.5 | 1 | 1 |
11.7 | 16477 | 10 | 61.5 | 1 | 1 |
5.6 | 20790 | 28.5 | 59.9 | 1 | 0 |
4.6 | 20352 | 19.4 | 34.6 | 1 | 0 |
8.6 | 19743 | 14.3 | 39.7 | 1 | 0 |
2.1 | 22775 | 10.3 | 35.7 | 1 | 1 |
9.6 | 24229 | 0.9 | 26.7 | 1 | 0 |
4 | 41195 | 8.6 | 66.7 | 1 | 0 |
10.6 | 23143 | 4.2 | 63.1 | 0 | 1 |
5.8 | 13400 | 28.1 | 46.7 | 0 | 0 |
7.4 | 21371 | 14.9 | 78.9 | 1 | 0 |
10.3 | 28675 | 7.7 | 63.4 | 0 | 0 |
6.3 | 18171 | 6.9 | 47.9 | 0 | 1 |
6.7 | 23670 | 20.5 | 46.3 | 1 | 1 |
6.7 | 29745 | 6.1 | 53.9 | 1 | 0 |
13.3 | 14672 | 13.9 | 46 | 1 | 0 |
4.1 | 20382 | 0 | 38.6 | 1 | 1 |
4.6 | 24952 | 14.6 | 53.8 | 0 | 1 |
2.7 | 28878 | 7.4 | 12.2 | 1 | 1 |
8 | 24558 | 24.5 | 37 | 1 | 1 |
4.2 | 20447 | 0.9 | 27.4 | 1 | 1 |
9 | 27714 | 8.7 | 58.1 | 0 | 0 |
7.7 | 18116 | 3.5 | 47.5 | 1 | 1 |
Question 1
In the next several questions,the answers should be directly from the Regression analysis.
The first one is:What is the Adjusted R Square? 4decimals (without %sign:ex.)
Question 2
What is the p-value of the ANOVA table?
4 decimals.
Question 3
There are 5independent variables suchasWage,PctPT,PctU,AvgShiftand UM Rel.
Which one is the mostsignificant impact (independent variable):Choose only ONE from the list
A. Wage (Average employee wage)
B. Av Shift (Availability of shiftwork1 = yes and 0 = no)
C. Pct PT (percentage of part-time employees)
D. Pct U (Percentage of unionized employees)
E. UM rel (Union-Management relationship)
Question 4
Copy of
There are 5independent variables suchasWage,PctPT,PctU,AvgShiftand UM Rel.
Which one is theleastsignificant impact (independent variable):Choose only ONE from the list
A. Av Shift (Availability of shiftwork1 = yes and 0 = no)
B. UM rel (Union-Management relationship)
C. Pct U (Percentage of unionized employees)
D. Pct PT (percentage of part-time employees)
E. Wage (Average employee wage)
Question 5
What is the slope of the coefficient of the Av Shift?(4decimals)
Question 6
What is the slope or UM Rel?4decimals
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started