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

Answer the problems 1-6 and explain use excel Excel Assignment 3 -

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!