Question

Answer the following questions about 2. what test needs to be used explain why by making a null hypothesis. 5. Create a regression equation with the data giving underneath the problem.

A manger is interested in employee turnover. They examine data from 40 of its employees. The following variables were collected: - Employee Type: Employees are either current or former. - Department: Employees either work in sales or in the warehouse. - Rating: The employee's most recent performance rating out of 5. - Months: The number of months at the company. 1. Download your dataset into a new Excel Workbook. Save the document as "Case 3_First Name" (1 point). 2. What test is appropriate to test whether the 30 employees are equally representative across the departments? (1 point). Explain why (1.5 point). [answer here] Then create the appropriate null hypothesis statement (2 points) and formula (1.5 points) for this scenario. [answer here] 3. Use excel to calculate a chi-square test that looks at the relationship between employee type and department (3 points). Paste a screen shot of your excel work below. answer here] Then interpret the outcome and create an APA style sentence reporting the outcome (3 points). [answer here] 4. Use Excel to complete a correlation between performance rating and the months worked. Paste a screen shot of your excel work below (2 points). answer here Employee Type Current EmployeeSales Former Employee Former Employee Former Employee Former Employee Sales Current Employee Sales Former Employee Former EmployeeService Current Employee Sales Current EmploveeSales RatingMonths Department 35 23 27 12 29 32 12 24 27 27 20 Sales Sales Warehouse 4 Sales mer Employee Sales For Current EmployeeSales Current EmployeeService Current Employee Sales Former Employee Former Employee Former EmployeeSales Former Employee Current Employee Sales Former Emplovee Former Emplovee For 30 27 Service Warehouse 34 Sales 28 26 23 24 23 25 40 20 28 36 28 23 Warehouse Warehouse Sales 4 mer Employee Former Employee Current EmployeeSales Former Employee Former Employee Warehouse Former Employee Current Employee Warehouse Current Employee Warehouse Former 4 4 4 Sales Sales Warehouse Employee Sales 5. Using the values below, create a regression equation to predict the performance rating from months worked. Paste a photo of your work below (3 points). Sum X (inventory) 1476 Sum X2 Sum Y(sold) 745 Sum Y2 Sum XY 75090 19735 37669 30 answer here] Then, predict the performance rating of an employee who has worked at the company for 54 months. Paste a photo of your calculation below. [answer here]

Answer 1

Here F- Former Employee and C- Current Employee

S- Sales and W - Warehouse .

Employee Type Dept Rating Months 35 27 Sales Warehouse Total Current Employee Former Employee Total 10 27 27 Expected 12 13 Sales Warehouse Total 2.93333333 11 5.06666667 19 Current Employee Former Employee 13.93333333 15 16 17 18 19 27 Total 0.423925091 Correaltion 0.460708197 23 29 Sheet1 Ready

Hoi There is no association betwee enmplayee H1: There is association between these two As yod can type ond cdepaxt men t. excel sheet above p-value 04239 and oc- 590 oc Here tlence e accept Ho ,and conctudle tacik therc s no ass ccia tion bet ween employee t 4.The correats on letween performan e rati an the months employee uoxkecl is regression equation isgiven loy -745x7 Sogo 1476 x 3766g 드 4.622] 30X75090一 (1476)

2. 30 x 37669-ー1476x795 0-4108 4.6 22) t-o. 4108 χ