M102_M3_Milestone1
docx
keyboard_arrow_up
School
Schoolcraft College *
*We aren’t endorsed by this school
Course
123
Subject
Mathematics
Date
Feb 20, 2024
Type
docx
Pages
3
Uploaded by SargentHedgehogMaster637
::Math 102 ~ Milestone 1::
Population and Exploratory Data Analysis
1.
Determine a career that interests you.
a.
Identify the population you want to study (Chicago Police Officers, for example)
i.
Career Choice: Database Administrator b.
Answer the following questions, making predictions
for each of your answers
:
i.
What are the Minimum
and Maximum
salaries for your chosen career?
$20,000 and $180,000
ii.
What is the Mean
salary for your chosen career?
$85,000
iii.
What is the Median
salary for your chosen career in the USA? in Illinois?
In the USA my prediction is $75,000 and in Illinois my prediction is $80,000
iv.
What is the Median
salary for all careers in the USA? in Illinois?
$55,000 in the USA. $65,000 in Illinois.
***Using the Data Directions Word Doc, go to the Bureau of Labor Statistics and pull the appropriate salary data for the career you chose in Part a. The data will be downloaded as an Excel workbook. DO NOT CONTINUE
until you have pulled the data and reformatted it according to the directions.***
2.
From your salary data in Excel, use Pivot Tables to create a Frequency Chart,
use Grouping by 10,000 (you should get around 20 Bins), and create a Histogram for your salary data. Make sure to give your Histogram an appropriate title.
3.
Use Excel to Calculate the 5 Number Summary and create a Box Plot to represent this data
. ●
Minimum = $17,230
●
1
st
Quartile = $61,457.5
●
Median = $80,660
●
3
rd
Quartile = $120,067.5
●
Maximum = $166,450
Box Plot Generator: http://www.imathas.com/stattools/boxplot.html
*Copy/Paste Box Plot from generator to your Excel sheet somewhere near your calculations.
4.
From your Frequency Chart, create a Pie Chart for your salary data
. Make sure to give your Pie Chart an appropriate title.
5.
Use Excel to Calculate the Measures of Central Tendency
and for each one, write a short explanation
of what each one measures and what that means for your data specifically
. ●
Mean: The mean is also be known as the average and in my data specifically the mean is $88,910.42308 which is the average salary of a database administrator. ●
Median: Is the value separating the higher half and lower half. In my data the median is $80,660 so that is the value that separates the higher half and the lower half of data. ●
Mode: Is the most frequent number. In my data the mode is $100,690 and $126,780 which means these are the two most frequent numbers. 6.
Use Excel to Calculate the Measures of Spread
and for each one, write a short explanation
of what each one measures and what that means for your data specifically
.
●
Standard Deviation: Is a measure of how dispersed data is compared to the mean. In
my data the STD Deviation is $32,880.77704 which means its lower than the mean. ●
Range: Is the difference between highest and lowest value. For my data the range is $149,220 which is my highest value (166,450) subtracted by my lowest value (17,230).
●
IQR (Inner-Quartile Range): Is the difference between Q3 and Q1. In my data my IQR is $58,610 which is the range that isn’t affected by outliers. 7.
Submit both
parts of Milestone 1 (Word and
Excel) to the Milestone 1 DropBox on D2L
before
the due date.
8.
For Extra Credit: (+1 Incentive Point if
all 5 z-scores are correct)
Look back at your original data source sheet (OES Report):
List the salary values for Illinois
only:
For each of the Illinois salary values
,
calculate the Z-score:
Annual 10% =$48,370
10% =$
48,367.29598
Annual 25% =$62,020
25% =$
62,017.29598
Annual 50% =$83,480
50% =$
83,477.29598
Annual 75% =$125,550
75% =$
125,547.296
Annual 90% =$162,770
90% = $
162,767.296
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help