BUS 308 Week 1 Problem Set Week One;Problem Set Week One.;All statistical calculations will use the Employee Salary Data set (in Appendix section).;1. Using the Excel Analysis ToolPak or StatPlus:mac LE function descriptive statistics, generate and show the;descriptive statistics for each appropriate variable in the sample data set.;a. For which variables in the data set does this function not work correctly for? Why?;2. Sort the data by Gen or Gen 1 (into males and females) and find the mean and standard deviation for each gender for the following variables;a. sal, compa, age, sr and raise. Use either the descriptive stats function or the Fx functions (average and stdev).;3. What is the probability for a;a. Randomly selected person being a male in grade E?;b. Randomly selected male being in grade E?;c. Why are the results different?;4. Find;a. The z score for each male salary, based on only the male salaries.;b. The z score for each female salary, based on only the female salaries.;c. The z score for each female compa, based on only the female compa values;d. The z score for each male compa, based on only the male compa values.;e. What do the distributions and spread suggest about male and female salaries?;f. Why might we want to use compa to measure salaries between males and females?;5. Based on this sample, what conclusions can you make about the issue of male and female pay equality?;6. Are all of the results consistent with your conclusion? If not, why not?
Paper#81070 | Written in 18-Jul-2015Price : $27