Question: Answer the problems 1-6 and explain use excel Excel Assignment 3 - 6 Problems - 100 Points asked to do a review of employee salaries
Answer the problems 1-6 and explain use excel

Excel Assignment 3 - 6 Problems - 100 Points asked to do a review of employee salaries at your startup. You compiled the salary of all of your employees at your company below. Years of 59,000 Question 1 30 points Calculate the Z-score for each data point Years of Employee Salary Emglaymeat Z-score Question 2 10 points Based on the z-scores, what could you say about the salaries of the employees at your company? Question 3 10 points Based on the z-scores and the overall salary information, are there other criteria you would want to ask about the employees? Why would it be important to know? Question 4 10 points Say you find out that Jim is the office assistant, while the other employees are all engineers. How 'would this change the way you look at the data? Question 5 10 points Would you want to calculate the z-scores differently? Why? Question 6 30 points Say you want to compare only the engineer's salaries. Calculate the z-scores below. What do you notice about the new z-scores? Observation
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
