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