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...
Which of the following might lead to an increase in the equilibrium price of jelly and a decrease in the equilibrium quantity of jelly sold?a. An increase in the price of...May 08 2021
Ineed to do a retirement future savings.Please help me to answer the questions5,6,7,(Show all work here.) on 79,11,12,13, *******answer the blanks I need to put this on e...Aug 13 2020
In a recent survey, 1358 Arizona State University students were asked about their plans after graduation. The following results were obtained: 1194 plan to get a new job,...Apr 18 2020
Need to figure out the cost of debt / the yield, using the following data:Annual coupon - 11% and pays interest on a semiannual basisNumber of years to maturity - 18curre...Jul 01 2021
The corporate officers are responsible fora.appointing the board of directors.b.carrying out corporate policy.c.determining corporate policy.d.arranging for major loans w...Dec 10 2019
What ouput mix should a profit maximizing firm produce when its profit function is:pi = 80x - 2x^2 -xy - 3y^2 + 100y and maximum output capacity is x+y=12?Aug 17 2021
The management of Gill Corporation is trying to decide whether to continue manufacturing a part or to buy it from an outside supplier. The part, called FIZBE, is a compon...Aug 01 2021
In this chapter you learned that the United States uses date and time formats that are different from those used in much of the rest of the world. Choose a country and re...Jul 20 2021
Determine whether the following compounds are soluble or insoluble in water.a. NaBrb. Ba(OH)2c. calcium carbonateJul 06 2021
What is disintermediation?7) How is e-commerce related to price elasticity?8) What kind of marketing is used for Web 2.0 applications?9) What are mashups? Explain with th...Dec 07 2019