In this assignment, you will once again serve as an expert consultant for MPHR. Using their dataset, you will develop graphs, calculate descriptive statistics, and provide your assessment of the results.
mphr502-comic-01-03.jpg
MPHR is interested in examining the distributions for salary and its relationship with tenure. A sample has been drawn from the company with information on salary (in dollars) and tenure (in years).
Using Tab 2 of the MPHR Dataset download, Dave is interested in the following questions:
Complete Table 1, create and copy/paste (screengrab) the mean salary line graph into your assignment document, and describe the results for the line graph for salary by tenure in five-year intervals.
Complete Table 2, create and copy/paste (screengrab) the salary frequency distribution into your assignment document, and describe the results for the frequency distribution for salary.
Based on results from Tables 1 & 2, how does salary at MPHR compare to the normal distribution?
What is mean and median salary at MPHR? What features of the distribution might have an impact on any differences between these statistics.
Based on this dataset, Dave finds a positive correlation between tenure and salary. Describe what this statistic tells us about the relationship between tenure and salary.
Describe what a negative correlation between tenure and salary would mean.
