Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Bridging Algebra, Geometry, And Topology

Authors: Denis Ibadula, Willem Veys

1st Edition

3319091867, 9783319091860

More Books

Students also viewed these Mathematics questions

Question

What is a goal? (p. 86)

Answered: 1 week ago

Question

Is your management system defined?

Answered: 1 week ago

Question

Do you have a comprehensive communication plan for your strategy?

Answered: 1 week ago

Question

Do you have sufficiently ambitious milestones?

Answered: 1 week ago