70.2K

Verified Solution

Link Copied!

Fred G. Hire is the manager of human resources at Crescent Custom Steel Products. As part of his yearly report to the CEO, he is required to present an analysis of the salaried employees. For each of the 30 salaried employees, he records monthly salary; service at Crescent, in months; age; gender (1 = male, 0 = female); and whether the employee has a management or engineering position. Those employed in management are coded 0, and those in engineering are coded 1.

Sampled Employee		Monthly Salary			Length of Service		Age	Gender	Job
1		$	1,769		93		42	1	0
2			1,740		104		33	1	0
3			1,941		104		42	1	1
4			2,367		126		57	1	1
5			2,467		98		30	1	1
6			1,640		99		49	1	1
7			1,756		94		35	1	0
8			1,706		96		46	0	1
9			1,767		124		56	0	0
10			1,200		73		23	0	1
11			1,706		110		67	0	1
12			1,985		90		36	0	1
13			1,555		104		53	0	0
14			1,749		81		29	0	0
15			2,056		106		45	1	0
16			1,729		113		55	0	1
17			2,186		129		46	1	1
18			1,858		97		39	0	1
19			1,819		101		43	1	1
20			1,350		91		35	1	1
21			2,030		100		40	1	0
22			2,550		123		59	1	0
23			1,544		88		30	0	0
24			1,766		117		60	1	1
25			1,937		107		45	1	1
26			1,691		105		32	0	1
27			1,623		86		33	0	0
28			1,791		131		56	0	1
29			2,001		95		30	1	1
30			1,874		98		47	1	0

Click here for the Excel Data File Complete the following table. (Negative amounts should be indicated by a minus sign. Round your answers 3 decimal places.)

Complete the Analysis of Variance table. (Round SS, MS to nearest whole number and F and p-value to 3 decimal places.)

a. Determine the regression equation, using salary as the dependent variable and the other four variables as independent variables. (Negative amounts should be indicated by a minus sign. Round your answers to 1 decimal place.)

b. What is the value of R²? (Round your answer to 3 decimal places.)

c-1. State the decision rule H₀: ₁ = ₂ = ₃ = ₄ = 0 versus H_i: Not all _i's = 0 at 0.05 significance level. (Round your answer to 2 decimal places.)

c-2. Compute the value of F. (Round your answer to 2 decimal places.)

c-3. Determine whether any of the independent variables are different from 0.

d-1. Conduct an individual test and state the decision rule at 0.05 significance level. (Negative amounts should be indicated by a minus sign. Round your answers 2 decimal places.)

d-2. Determine whether any of the independent variables can be dropped.

Compute the regression analysis using the independent variables service and gender. e-1. Complete the following table. (Round "t" to 2 decimal places, "p-value" to 3 decimal places and "Coefficient", "Standard deviation" to 1 decimal place.)

e-2. Complete an ANOVA table. (Round SS, MS to nearest whole number and F and p-value to 3 decimal places.)

e-3. How much more does a man earn per month than a woman? (Round your answer to the nearest dollar amount.)

Answer & Explanation Solved by verified expert

See Answer