BUS 308 Problem Set Week Two - Employee Salary Data Set

Question # 00020036 Posted By: expert-mustang Updated on: 07/16/2014 06:13 AM Due on: 07/16/2014
Subject Business Topic General Business Tutorials:
Question
Dot Image
Problem Set Week Two

Complete the problems below and submit your work in an Excel document. Be sure to show all of your work and clearly label all calculations. All statistical calculations will use the Employee Salary Data Set.

Included in the Week Two tab of the Employee Salary Data Set are 2 one-sample t-tests comparing male and female average salaries to the overall sample mean.
Below are 2 one-sample t-test comparing male and female average salaries to the overall sample mean. Based on our sample, how do you interpret the results and what do these results suggest about the population means for male and female salaries?
Based on our sample data set, perform a 2-sample t-test to see if the population male and female average salaries could be equal to each other. (Since we have not yet covered testing for variance equality, assume the data sets have statistically equal variances.)
Based on our sample data set, can the male and female compas in the population be equal to each other? (Another 2-sample t-test.)
Since performance is often a factor in pay levels, is the average Performance Rating the same for both genders?
If the salary and compa mean tests in questions 2 and 3 provide different results about male and female salary equality, which would be more appropriate to use in answering the question about salary equity? Why? What are your conclusions about equal pay at this point??
Dot Image
Tutorials for this Question
  1. Tutorial # 00019440 Posted By: expert-mustang Posted on: 07/16/2014 06:15 AM
    Puchased By: 7
    Tutorial Preview
    The solution of BUS 308 Problem Set Week Two - Employee Salary Data Set Solution...
    Attachments
    BUS_308_Problem_Set_Week_Two_-_Employee_Salary_Data_Set_Solution.xlsx (103.12 KB)
    Recent Feedback
    Rated By Feedback Comments Rated On
    MH...d88 Rating Quite presentable tutorials 03/22/2016
    cp...ek Rating Provide assignments on time 07/01/2015
    3541...g Rd Rating Tutorials helped score A+ grades 02/18/2015
    sa...rby Rating Tutorials prepared by experts 01/21/2015
    b...08 Rating Well-structured work 10/29/2014

Great! We have found the solution of this question!

Whatsapp Lisa