**BUS 308 WEEK 1 A+ rated**

$ 20.00

Problem 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?

**Category:**Accounting, General Accounting

**Aplus**

- Ratings 8
- Grade:
**A+** - Questions 0
- Solutions 675
- Blog 0
- Earned: $2326.85