| Week 1. | Describing the data. |
| | <Use right click on the row numbers at the left to insert rows below each question for your results and comments.> |
| 1 | Using the Excel Analysis ToolPak 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: |
| | 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? |
| | 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? |
| | Are all of the results consistent with your conclusion? If not, why not? |
blakta1
bus_308_week_1_assignment.xlsx
