[next] [prev] [prev-tail] [tail] [up]

Mechanics and Techniques Problems

3.1. Download the data file C03 Salaries.xls [.rda]. This data represents salaries for employees at a small company.

  1. Add in two new columns of computed data: The first column should contain the salaries of each employee after a flat $1000 raise. The second column should contain the salaries after a 5% raise.
  2. What are the mean, median, and standard deviation of these three different salaries? (Be sure to copy and paste these statistics from your software).
  3. What happened to the mean after the $1000 increase? Why?
  4. What happened to the mean after the 5% increase? Why?
  5. What happened to the Standard Deviation after the $1000 increase? Why?
  6. What happened to the Standard Deviation after the 5% increase? Why?

3.2. Data file C03 Incomes.xls [.rda] contains a list of 1000 family incomes from each of four fictitious countries. All of the families are the same size (two parents and one child) and the families form a representative sample of such families in their country.

  1. Place the four countries in order of increasing average income. Explain what this ordering tells you about these countries. Describe each country as either ”Poor”, ”Average”, or ”Wealthy”.
  2. Place the four countries in order of increasing standard deviation. Explain what this ordering tells you about these countries. Describe each country as either ”Shared Wealth” or ”Disparate”. Make sure you consider not just the standard deviation alone, but also how it compares with the mean income of the country.
  3. Which country would you want to live in? Explain your reasoning.

3.3. These problems will involve the data set C03 AllTron.xls [.rda]. The data shows information on the employees at AllTron, an electronics design company. Use pivot tables to answer the following questions.

  1. How many of the employees in this sample are men (gender=0 for male, 1 for female)?
  2. What percentage of the employees is female?
  3. What is the average salary of the male employees?
  4. What is the average salary of the male employees who have exactly four years of post-secondary education?
  5. What is the total number of years of experience at AllTron for the male employees? For the female employees?

3.4. Using data file C02 Homes.xls [.rda], answer each question below by preparing a pivot table. Put your answers into a Word document and be sure to include your answer in full sentences as well as the pivot table or other computations that support your answer.

  1. How many of each STYLE of home do we have?
  2. How many of each STYLE of home, broken down by the number of bedrooms?
  3. What is the average VALUE of each STYLE of home, broken down by BED?
  4. What is the Standard Deviation of VALUE, broken down by STYLE (row) and BED (column)?
  5. What is the average SIZE of the houses, broken down by LOCATION (row), and BED (column)?

3.5. Using data file C03 BeefNBuns.xls [.rda], answer each question below by preparing a pivot table. Be sure to include your answer in full sentences as well as the pivot table or other computations that support your answer.

  1. Calculate the mean and standard deviation for the variable WaitTime.
  2. Now create a pivot table and calculate the AVERAGE of WaitTime.
  3. Now break that statistic down with Venue for the Row Variable (C for Counter; D for Drive-thru.)
  4. Can you break that down by Complexity (as the Column Variable)?
  5. How about Venue (as the Row) and Size (as the Column Variable)?
  6. How about Time (Time of Day) by Size?

[next] [prev] [prev-tail] [front] [up]