Problem Set Week One
loka9502Problem Set Week One
All statistical calculations will use Employee Salary Data Set
- Using the Excel Analysis ToolPak or the StatPlus:mac LE software function descriptive statistics, generate and show the descriptive
statistics for each appropriate variable in the sample data set.- For which variables in the data set does this function not work correctly for? Why?
- 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:- sal, compa, age, sr and raise. Use either the descriptive stats function or the Fx functions (average and stdev).
- What is the probability for a:
- Randomly selected person being a male in grade E?
- Randomly selected male being in grade E?
- Why are the results different?
- Find:
- The z score for each male salary, based on only the male salaries.
- The z score for each female salary, based on only the female salaries.
- The z score for each female compa, based on only the female compa values.
- The z score for each male compa, based on only the male compa values.
- What do the distributions and spread suggest about male and female salaries?
- Why might we want to use compa to measure salaries between males and females?
- Based on this sample, what conclusions can you make about the issue of male and female pay equality?
- Are all of the results consistent with your conclusion? If not, why not?
For additional assistance with these calculations reference the Recommended Resources for Week One
- 10 years ago
- 12
Answer(2)
Purchase the answer to view it
NOT RATED
- week_1assignment_graded.xls
Purchase the answer to view it
NOT RATED
- 10_bus_308_statistics_for_managers_week_5__regression_salary.xlsx
Bids(0)
other Questions(10)
- Can anyone help me with my golbe studies home work?
- Five pages paper.
- *Aristotle* Writing your own argument
- Accounting homework
- This is for leadership and ethics
- Finance Problems!! HELP!!
- De donde es ta tia Juisa
- History 3 paragraphs discussions
- Economics. How priceline.com revolutionized the travel industry
- hello