jam

1. Over time (OT), boss, gender (m/f), and pay rate are the factors believedto be behind the high quitting rates of the employees in Happy Mazen Logistics Company. The top management decided to study this issue and collected data for the 100 employees who left the company lately as in Exam II_TakeHome Excel file. The company has six bosses (1-6) and male = 1 in the Excel file.

i. Analyze the data using Excel .

ii. Analyze the data using Minitab .

a. Which factors seem predictive of how long an employee stays (hourly $, M/F, OT, boss)?

b. The COO thinks there is a difference among the bosses regarding employees quitting. Is she right?

c. Among pay rate and OT, which has the most impact on employee longevity?

d. We need a new employee to work 10 hours of OT. If we want them to likely stay 20 years, what should their hourly pay be (to nearest penny)?

e. What does the adjusted square number mean?

f. Comment on the results.

2. A company is considering installing new machines to assemble its products. The company is considering two types of machines, but will buy only one type. The company asked its eight assembly workers to use these two types of machines to assemble products. The following table provides the time taken (in minutes) to assemble one unit of the product on each type of machine for each of the eight workers. Assume equal variances.

Machine I	23	26	19	24	27	22	20	18
Machine II	21	24	23	25	24	28	24	23

i. Analyze the data using Excel .

ii. Analyze the data using Minitab .

a. State both the null and alternate hypothesis

b. Test whether the mean times taken to assemble a unit of the product are different for the two types of machines.

Note: Use the same Excel file for part (i) of problem 1 and problem 2 but different Worksheets. Use the same Minitab file for part (ii) of problem 1 and problem 2. Submit organized files.

1