Create an Account

Already have account?

Forgot Your Password ?

Home / Questions / BUS 308 week 3 assignment (see attachments)

BUS 308 week 3 assignment (see attachments)

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.

  1. Based on the sample data, can the average(mean) salary in the population be the same for each of the grade levels? (Assume equal variance, and use the analysis toolpak function ANOVA.) Set up the input table/range to use as follows: Put all of the salary values for each grade under the appropriate grade label.Be sure to include the null and alternate hypothesis along with the statistical test and result.
  2. The table and analysis below demonstrate a 2-way ANOVA with replication. Please interpret the results.
  3. Using our sample results, can we say that the compa values in the population are equal by grade and/or gender, and are independent of each factor?
  4. Pick any other variable you are interested in and do a simple 2-way ANOVA without replication. Why did you pick this variable and what do the results show?
  5. Using the results for this week, What are your conclusions about gender equal pay for equal work at this point
Document Preview:

Week 5 Week 4 Week 3 Week 2 Week 1 Data ID Sal Compa Mid Age EES SR G Raise Deg Gen1 Gr M E B F D C A Sal – Salary in thousands Age – Age in years EES – Appraisal rating (Employee evaluation score) SER – Years of service Mid – salary grade midpoint Raise – percent of last raise Grade – job/pay grade Deg (0= BS\BA 1 = MS) Gen1 (Male or Female) The column labels in the table mean: sal, compa, age, sr and raise. Week 1. Week 2 Week 4 Week 3 Week 5 Correlation and Regression G – Gender (0 = male, 1 = female) ID – Employee sample number Describing the data. The ongoing question that the weekly assignments will focus on is: Are males and females paid the same for equal work (under the Equal Pay Act)? Note: to simplfy the analysis, we will assume that jobs within each grade comprise equal work. Grade Gender Q1 Q2 which would be more appropriate to use in answering the question about salary equity? Why? expressing an employee’s salary, we do not want to have both used in the same regression.) Set up the input table/range to use as follows: Put all of the salary values for each grade under the appropriate grade label. a. For which variables in the data set does this function not work correctly for? Why? c. Why are the results different? Use either the descriptive stats function or the Fx functions (average and stdev). For full credit, you need to also show the statistical outcomes - either the Excel test result or the calculations you performed. Testing multiple means with ANOVA Testing means with the t-test For each question involving a statistical test below, list the null and alternate hypothesis statements. Use .05 for your significance level in making your decisions. Hint: use mean values in the boxes. Are all of the results consistent with your conclusion? If not, why not? Ho: Mean salary = 45 Ha: Mean salary =/= 45 Perform analysis: t-Test: Two-Sample Assuming Unequal...

Apr 25 2020 View more View Less

Answer (Solved)

question Subscribe To Get Solution

Related Questions