Transcript
The following table shows the number of Teens aged 16-19 not attending school and not working for selected states in 2016. Source: http://datacenter.kidscount.org/data/tables/
Location
Number
Percent
Florida
71,000
7%
Illinois
45,000
7%
Indiana
24,000
7%
Iowa
8,000
4%
Kansas
10,000
6%
Kentucky
20,000
8%
Louisiana
29,000
11%
Michigan
38,000
7%
Missouri
18,000
5%
Ohio
35,000
6%
Use Excel to find the descriptive statistics listed below for the number of 16-19 year olds not attending/working. Clearly label these values in Excel.
Use Excel to find the descriptive statistics listed below for the percent of 16-19 year olds not attending/working.
Mean
Median
Mode
Maximum
Minimum
Range
Write a paragraph about your findings regarding teens not attending school and not working. Make sure to answer the following in your paragraph: How does the state of Indiana compare to the surrounding states? Which state has the best or worst data (explain your reasoning)? Which value gives a better comparison, the number or the percentage (explain your reasoning)?
Follow the examples from the class activity (Section 6: Descriptive Statistics) and be sure to include labels for the values you are computing and use the appropriate Excel functions for the calculations.
**You will need to submit your spreadsheet via Ivy Learn for grading.