Statistics homework
Format MLA
Academic Level: –
Volume of 2 pages (550 words)
Discipline Mathematics
Assignment type : Math Assignment
Description
March 12 – March 18
Calculating Mean, Median and Standard Deviation Assignment
1. Topics
Using EXCEL for calculating mean, median and standard deviation
2. Readings
EXCEL on line basic manual
Statistical Reasoning; Chapter 4
3. Assignments:
1. Using EXCEL and the data provided by New York State calculate:
– the average New York State unemployment rate (the mean of the rate) for September 2016 and September 2017
– the median of the NYS unemployment rate for September 2016 and September 2017
– the standard deviation of the NYS unemployment rate for September 2016 and September 2017
Data available on: www.labor.ny.gov (click on: 1. Government and Research 2. Monthly Local Unemployment Rates Press Release (pdf))
2. Using EXCEL and the data provided by New York State calculate:
– the average mortality rate caused by cardio-vascular diseases in New York State from 1980 to 1998, and from 1999
– the median median of the mortality rate caused by cardio-vascular diseases in New York State from 1980 to 1998, and from 1999
– the standard deviation of the mortality rate caused by cardio-vascular diseases in New York State from 1980 to 1998, and from 1999
Data available on: www.health.ny.gov/statistics/diseases/cardiovascular
Mean or median? Forum
You are in 2028. As a result of your degree from MCNY you had a very successful career and you want to buy a vacation home in Palm Beach, Florida. Taking into consideration that Mar-a-Lago, the very expensive mansion of the former US President Donald Trump is in Palm Beach, will you use the mean or the median when you will compare the average prices of different types of houses and apartments in Palm Beach?
Please, express your point of view.
