He needs a report of the following information,
- Code: Select all
Mean: {Mean (Avg) Wages} Median: {Median Wages} Mode: {Mode Wage}
Deviation: {Mean (Avg) Wage Deviation}
Std. Deviation: {Std. (Avg) Wage Deviation}
{List names and ages of top 30 people with wages within 1 std. deviation of the avg. wage, and at least 2 years of experience*}
*Since your company is an HR Firm, you should also clear out the people who have not been truthful on their resumes. All incompatible entries should be excluded.
I recommend that you use a file up around 2000 entries to make sure that the random numbers being generated will have some variation that wont make the report above difficult to create.