microsoft excel - 1340

Request Posted by
kevin2412

kevin2412

Rating : No Rating
Earned: $0
Request Detail
Price: $20
  • From: Mathematics,
  • Due on: Mon 12 Mar, 2012 (07:24am)
  • Asked on: Mon 12 Mar, 2012
  • Due date has passed, but you can still Post Solution.
Description

Chapter 3 Lab – Occupational Employment and Wage Estimates Report

 

Visit the: The Bureau of Labor Statistics Website –http://stats.bls.gov/home.htm



  • Download the National May 2010 Occupational Employment and Wage Estimates 

    • National 
      Cross-Industry estimates (94 KB)

 

  • Download the National May 2009 Occupational Employment and Wage Estimates 

    • National 
      Cross-Industry estimates (117 KB)

 

  • Download the National May 2008 Occupational Employment and Wage Estimates 

    • National 
      Cross-Industry estimates (111 KB)

 

  • Download the National May 2007 Occupational Employment and Wage Estimates 

    • National 
      Cross-Industry estimates (111 KB)

 

  • Download the National May 2006 Occupational Employment and Wage Estimates 

    • National 
      Cross-Industry estimates (111 KB)

 

Choose 3 Occupations to analyze

 

Filter data by: selected occupations

 

Copy/Group each of those results to a separate worksheet

 

Analyze and answer the following for each selected occupation:



  1. Determine if the following variables are quantitative or qualitative data:Total Employment, Annual Salary & Hourly Salary

 

  1. Determine the level of measurement for each variable: Total 
    Employment, Annual Salary & Hourly Salary

 

  1. Organize/Create a Frequency Table for the Total Employment data for all 3 
    occupations for the last 5 years.

 

  1. Using the Frequency Table create either a Bar Chart o Pie Chart showing the 
    Total Employment data for all 3 occupations for the last 5 years.

 

  1. Find the Mean, Median and Standard Deviation of the Total Employment for the 
    last 5 years.

 

  1. Find the Mean, Median and Standard Deviation of the Annual Salary for the 
    last 5 years.

 

  1. Find the Mean, Median and Standard Deviation of the Hourly Salary.

 

Please submit 1 final Excel file that has 7 separate worksheets with the 
correct data analysis

HAVE MANY OTHER ASSIGNEMNTS, THEREFORE, IF DONE WELL MORE BUSINESS FOR YOU

Please Login or Register to Submit the Solution for the Request