Question: Myy SIC Part 2: Data Analysis Open a new tab in your Excel document (the plus sign at the bottom near Sheet 1). You will

 Myy SIC Part 2: Data Analysis Open a new tab in

Myy SIC Part 2: Data Analysis Open a new tab in your Excel document (the plus sign at the bottom near Sheet 1"). You will use this tab to do a data analysis. Your data set is on the next page (you should be able to copy and paste it into your own Excel sheet. The data is hourly pay rates for new employees at a local company. Create all the same rows and columns as you did in the video tutorial. Use the Excel formulas to calculate the mean and standard deviation for the pay rates. Part 3: Interpret the Results Use the 68-95-99.7 rule to answer the following questions 1,68% of new employees will make between $ per hour 195% of new employees will make between and per hour 99.7% of new employees will make between $_ and per hour The top 2.5% of new employees will make more than per hour What hourly pay do you think you would get if you worked for this company? (You can answer these questions in the Excel document to that you only have to upload one document, Or, you can answer them here and turn in the Word Doc AND the Excel doc) Data sel The HR Department at a local company surveyed new hires with AAS degrees to see what their pay rate was. These were the results of the survey Copy this data into Excel (you can copy paste) and use the formulas described in the video to calculate the mean and standard deviation. You will use that information to answer the questions in part 3. You must use the Excel formulas to cam credit

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 Finance Questions!