MTH/216 Phoenix

CopyofMTH216r3_Data_for_topic.xlsx

Topic 1 - Health & Nursing

Health Services and Nursing Scenario
Topic 1	Predicting Expected Medicare Payers
Scenario 1	Review data of the expected payers that used Medicare 2003 to 2014. Predict the percentage of expected payers that will use Medicare in 2018.
Year	County	Zip Code	Medicare payers
2003	Humbolt	90001	35612
2004	Humbolt	90001	37412
2005	Humbolt	90001	39841
2006	Humbolt	90001	40123
2007	Humbolt	90001	43122
2008	Humbolt	90001	44125
2009	Humbolt	90001	51229
2010	Humbolt	90001	59748
2011	Humbolt	90001	57008
2012	Humbolt	90001	56727
2013	Humbolt	90001	57985
2014	Humbolt	90001	63123

Security and Criminal Justice Scenario
Topic 2	Predicting Total US correctional population
Scenario 2	Review the data on persons supervised by U.S. adult correctional systems by correctional status. Predict the number of the United States population that will be supervised by U.S. adult correctional system in 2018.
Year	Total US correctional population	Probation	Parole
2000	6,467,800	3,839,400	725,500
2001	6,584,900	3,934,500	731,100
2002	6,730,900	3,995,000	753,100
2003	6,886,800	4,073,800	773,500
2004	6,997,000	4,140,400	775,900
2005	7,055,600	4,162,300	784,400
2006	7,199,700	4,236,800	798,200
2007	3,046,700	4,293,000	826,100
2008	7,313,600	4,270,100	828,200
2009	7,235,200	4,196,200	824,100
2010	7,086,500	4,053,600	840,700
2011	6,989,200	3,969,400	854,600
2012	6,945,100	3,940,800	857,800
2013	6,903,200	3,910,600	855,200
2014	6,851,000	3,864,100	856,900

Humanities and Sciences Scenario
Topic 3		Predicted College Tuition and Fees
Scenario 3		Review college data of the yearly tuition & fees. Predict the cost of yearly tuition and fees in 2018.
Year	Yearly Tuition	Books & Supplies	Living Costs	Yearly Tuition & Fees
2015	$29,450	$1,250	$12,400	$44,190
2014	$24,444	$1,038	$10,292	$36,679
2013	$20,288	$861	$8,542	$30,442
2012	$17,245	$732	$7,261	$25,876
2011	$16,412	$625	$6,532	$24,112
2010	$15,984	$600	$5,899	$22,984
2009	$8,618	$1,200	$15,682	$25,770
2008	$7,153	$996	$13,016	$21,389
2007	$5,937	$827	$10,803	$17,753
2006	$14,658	$703	$9,183	$24,702
2005	$13,549	$699	$5,771	$20,142
2004	$12,435	$612	$5,256	$18,415

Social Sciences Scenario
Topic 4	Predicting Teen Communication Preferences
Scenario 4	Review the data on communication preferences with teens. Predict how many high-school teens will prefer to use face-to-face communication in 2018.
Year	Communication Preference	Age	School Level	Number of Teens
2000	Face to Face	Teen	HS	87
2001	Face to Face	Teen	HS	98
2002	Face to Face	Teen	HS	86
2003	Face to Face	Teen	HS	76
2004	Face to Face	Teen	HS	55
2005	Face to Face	Teen	HS	49
2006	Face to Face	Teen	HS	50
2007	Face to Face	Teen	HS	43
2008	Face to Face	Teen	HS	42
2009	Face to Face	Teen	HS	36
2010	Face to Face	Teen	HS	23
2011	Face to Face	Teen	HS	30
2012	Face to Face	Teen	HS	15
2013	Face to Face	Teen	HS	13
2014	Face to Face	Teen	HS	8
2015	Face to Face	Teen	HS	5

Logarithmic Regression

Number of Teens

2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 87 98 86 76 55 49 50 43 42 36 23 30 15 13 8 5

Year

Number of Teens

Business Scenario
Topic 5	Predicting Tires Purchased
Scenario 5	Review the yearly data involving tires purchased at a tire shop with declining business. Predict how many tires will need to be in stock to have available for the customers in 2018.
Year	Tires Purchased	Wheels Purchased	Lugnuts Purchased
1996	20,478	20,018	28,592
1997	15,478	18,274	9,967
1998	11,148	13,086	11,148
1999	17,916	14,659	14,659
2000	13,390	9,697	8,080
2001	16,146	25,698	18,425
2002	18,456	32,237	15,132
2003	12,570	21,404	9,173
2004	16,243	14,993	7,184
2005	15,628	18,346	9,852
2006	18,063	14,193	6,999
2007	7,122	3,052	3,713
2008	6,649	3,740	3,586
2009	9,217	4,748	3,994
2010	6,235	3,662	2,733
2011	16,542	12,426	8,145
2012	12,459	8,743	11,405
2013	9,322	5,243	6,033
2014	8,704	4,687	4,491
2015	9,904	4,661	5,028

Education Scenario
Topic 6	Predicting SAT Test Scores
Scenario 6	Review the data on the average SAT scores of college-bound seniors from 2002-2015. Predict the average SAT scores of college-bound seniors in 2018.
Average SAT-Mathematics of college-bound seniors
Year	2002	2003	2004	2005	2006	2007	2008	2009	2010	2011	2012	2013	2014	2015
All students Average	540	529	530	522	531	523	525	530	525	520	519	516	518	514
White	530	531	533	534	531	536	536	534	537	536	536	535	536	534
Black	426	426	427	426	427	431	429	429	426	426	428	427	428	429
Mexican American	460	458	457	457	458	463	465	466	463	463	467	466	465	464
Puerto Rican	566	451	451	453	452	457	456	454	453	450	452	452	452	453
Other Hispanic	467	465	464	464	465	469	463	463	461	461	462	462	461	461
Asian/Pacific Islander	565	566	569	575	577	580	578	578	581	587	591	595	595	597
American Indian/Alaska Native	481	479	483	482	488	493	494	494	491	493	492	488	489	486