Demographics of the workforce for a small manufacturing

In our last activity we analyzed the demographics of the workforce for a small manufacturing company. This week we will continue to analyze the salaries of the employees of this company.
Calculate the descriptive statistics for the male salaries following the same steps, but this time highlight all the male salaries for the input range. Edit the table in the same way as before. Copy and paste the table here:

Use the tables to answer the following questions:

  1. What is the typical salary for an employee of this company? Remember the measures of center (mean or median) give the typical value of a data variable.
  2. What is the relationship between the mean and the median of the salaries of all employees? (Circle answer)
    MEAN > MEDIAN MEAN = MEDIAN MEAN < MEDIAN
    What does this tell us about the shape of the histogram for the salaries of all employees? (You made this histogram in lab activity 1.)
  3. Now compare the mean and median of the female employees to the mean and median of the male employees. Who earns more money at this company – males or females? Justify your choice using the statistics you compared.
  4. Now compare the standard deviation of the female employees to the standard deviation of the male employees. Whose salaries are more consistent – males or females? Justify your choice using the statistics you compared.
    Boxplot
    Type ‘Female Salaries’ in cell G1. Highlight the female salaries. Select Copy from the ribbon menu at the top of the screen. Paste the female salaries in column G starting at cell 2.
    Type ‘Male Salaries’ in cell H1. Highlight the male salaries. Select Copy from the ribbon menu at the top of the screen. Paste the male salaries in column H starting at cell 2.
    Now highlight the female salaries and male salaries in columns G and H including the names of the columns. Click Insert on the menu at the top of the screen. Click on the All Charts tab and select Box and Whisker. Click on OK. Give the graph an appropriate title.
    Copy and paste the graph below.
    Use the graph to answer the following questions.
  5. How do the boxplots show the relationship between the medians you compared in question 3?
  6. How do the boxplots show the relationship between the standard deviations you compared in question 4?
  7. What else do the boxplots reveal that the descriptive statistics did not reveal?

Sample Solution

find the cost of your paper

This question has been answered.

Get Answer