# microsoft excel - 1340

Request Posted by

## 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

• National
Cross-Industry estimates (94 KB)

• National
Cross-Industry estimates (117 KB)

• National
Cross-Industry estimates (111 KB)

• National
Cross-Industry estimates (111 KB)

• 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