The Excel file Salary reports the monthly salaries for93 randomly and independently selected employees of a bank; thereare 32 salaries of male employees and 61 salaries of femaleemployees. Â
Let um = the mean monthly salary for all male bank employees,and uf = the mean monthly salary for all female bank employees.Your objective is to find some evidence of um > uf, that is, thefemale employees are discriminated against.
Provide descriptive statistical summaries of the data sets formale and female employees. What are your primary observationsconcerning the two data sets? Calculate the 99% confidenceintervals for um and uf, and interpret them. Do these intervalsoverlap?
Formulate a hypothesis test for supporting um > uf. What isthe distribution of the test statistic? What is the value of thetest statistics? What is the p-value of the test? What isyour conclusion and its interpretation when the test is conductedunder the 0.01 significance level?
Do your findings support a discrimination suit against theemployer?
Instructions
For Task 1, apply “Descriptive Statistics†in Data Analysis ofExcel (see instructions on pages 354-356). Summarize the obtainedrelevant statistics. Recall that in the row “Confidence Level(99.0%)†of the Descriptive Statistics output you actually see themargin of error of the confidence interval for the correspondingpopulation mean.
To complete Task 2, formulate the null and alternativehypotheses, and apply “t-Test; Two-sample Assuming UnequalVariances†in Data Analysis of Excel with α = 0.01 (seeinstructions on pages 446-447). Note. In Excel, e.g., 2.71E-06 is2.71(10^-6), which is practically zero.
Feel free to express your opinion.
Use Microsoft Word to write a managerial report with your nameshown on the first page. The report should include all your Exceloutputs (copy and paste them), so do not attach any separate Excelfiles. Hint. You may assume that you are an internworking for a branch of the bank and your boss, who has a verylimited knowledge about business statistics, asked you to conduct astatistical analysis concerning the comparison of the salaries ofmale and female employees. You report may look like a letterwritten to your boss in which you present your findings.  Â
| Male Salary | Female Salary |
| 4620 | 3900 |
| 5040 | 4020 |
| 5100 | 4290 |
| 5100 | 4380 |
| 5220 | 4380 |
| 5400 | 4380 |
| 5400 | 4380 |
| 5400 | 4380 |
| 5400 | 4440 |
| 5400 | 4500 |
| 5700 | 4500 |
| 6000 | 4620 |
| 6000 | 4800 |
| 6000 | 4800 |
| 6000 | 4800 |
| 6000 | 4800 |
| 6000 | 4800 |
| 6000 | 4800 |
| 6000 | 4800 |
| 6000 | 4800 |
| 6000 | 4800 |
| 6000 | 4800 |
| 6000 | 4980 |
| 6000 | 5100 |
| 6300 | 5100 |
| 6600 | 5100 |
| 6600 | 5100 |
| 6600 | 5100 |
| 6840 | 5100 |
| 6900 | 5160 |
| 6900 | 5220 |
| 8100 | 5220 |
| 5280 |
| 5280 |
| 5280 |
| 5400 |
| 5400 |
| 5400 |
| 5400 |
| 5400 |
| 5400 |
| 5400 |
| 5400 |
| 5400 |
| 5400 |
| 5400 |
| 5400 |
| 5520 |
| 5520 |
| 5580 |
| 5640 |
| 5700 |
| 5700 |
| 5700 |
| 5700 |
| 5700 |
| 6000 |
| 6000 |
| 6120 |
| 6300 |
| 6300 |
