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.
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...
Give a brief introduction to Project Proposal with examples. Can you describe the best Project Proposal one should pick?Jul 27 2020
â€‹DO all parts of this question, this is ch 9: reporting and interpreting liabilitiesYou have decided to buy a used car. The dealer has offered you two options: a. Pay $...Aug 11 2020
Figure P1–9 shows a plot of the net positive charge flowing in a wire versus time. Sketch the corresponding current during the same period of time.Jun 15 2020
If the Phillips curve equation is represented by equation: , with the change in the inflation rate equal to m plus z minus the product of alpha and u, which of the follo...Apr 16 2021
Assume a $40,000 investment and the following cash flows for two alternatives. a. Calculate the payback for investment X and Y. (Do not round intermediate answers to 2 de...Apr 15 2020
You are bullish on Telecom stock. The current market price is $50 per share, and you have $5,000 of your own to invest. You borrow an additional $5,000 from your broker a...Jun 16 2020
what are the differences between the following components of taxable income o Deductions for AGI and deductions from AGI o Gross i...Sep 09 2020
Business analytics minicase studyThe company is an energy retailer of gas and electricity across AUS & NZ with 1million customers.They have employed 160 people across 8 d...Apr 20 2021
How important are communications skills to IS personnel? Consider this statement: “IS personnel need a combination of skills—one-third technical skills, one-third busines...Jul 15 2020
Differentiate between 20th-century totalitarianism, dictatorship, and 18th-century absolutismWhat were the main reasons for World War II? Why did these factors lead to a ...Apr 15 2020