EXCEL PROBLEM SET 2

Z-SCORES

Using the Week 2 Z Scores Excel data file and Appendix A of the book, report your results on the following prompts below.

Statewide	Average Median Home Price in 2021	Average Monthly Payment in 2021
Average	$182,158	$691
Std Dev	$68,646	$260

1. What percentage of cases falls between +.25 SD and -.25 SD in the population?

1. Using the Excel data file, what percentage of the 82 sampled counties would we expect to have a median home price of $150,000 or greater in 2021?

1. Calculate the Z scores for the average median home price in 2021 for all 82 sampled counties. Which county has the largest Z score?

1. Calculate the Z scores for the average median home price in 2021 for all 82 sampled counties. Which county has the smallest Z score?

PROBLEM SET 2

County	Median Home Price 2021	Monthly home payment 2021	Monthly home payment 2020
Alamance	190587	723	665
Alexander	155520	590	553
Anson	106949	406	372
Ashe	174029	660	620
Avery	163579	621	583
Beaufort	150856	572	537
Brunswick	279779	1062	976
Buncombe	315927	1199	1111
Burke	161559	613	574
Cabarrus	295283	1120	1028
Caldwell	149368	567	531
Camden	237189	900	845
Caswell	128137	486	456
Catawba	175003	664	622
Cherokee	180732	686	644
Chowan	148925	565	530
Cleveland	152787	580	544
Columbus	100987	383	360
Craven	173575	659	618
Cumberland	156003	592	566
Currituck	290720	1103	1047
Dare	328293	1246	1169
Davidson	175733	667	626
Davie	197770	750	702
Duplin	102464	389	365
Durham	283105	1074	1011
Edgecombe	97722	371	340
Forsyth	195020	740	692
Franklin	198264	752	700
Gaston	194901	740	679
Gates	167782	637	598
Graham	138928	527	495
Granville	177210	672	631
Greene	100511	381	357
Guilford	209953	797	744
Halifax	98034	372	349
Harnett	186752	709	665
Haywood	206144	782	725
Henderson	289427	1098	1018
Hertford	100646	382	358
Iredell	244271	927	851
Jackson	222762	845	793
Johnston	231901	880	818
Lee	163806	622	583
Lenoir	108484	412	386
Lincoln	237117	900	826
Macon	188115	714	670
Madison	223122	847	785
Martin	105077	399	374
Mcdowell	135407	514	482
Mecklenburg	318384	1208	1109
Mitchell	178800	678	637
Montgomery	133703	507	476
Moore	264111	1002	941
Nash	148122	562	516
New Hanover	313097	1188	1092
Onslow	187799	713	645
Orange	389113	1476	1390
Pamlico	177210	672	631
Pender	230673	875	804
Perquimans	195726	743	697
Pitt	176632	670	628
Randolph	149458	567	530
Robeson	83607	317	298
Rockingham	130403	495	462
Rowan	186105	706	648
Rutherford	145062	550	517
Sampson	101441	385	361
Scotland	97125	369	346
Stanly	157785	599	562
Surry	153469	582	547
Swain	158012	600	563
Transylvania	252070	956	898
Tyrrell	130408	495	464
Union	320847	1217	1117
Vance	115187	437	410
Wake	363694	1380	1283
Washington	97011	368	346
Watauga	270359	1026	963
Wilkes	156876	595	559
Wilson	156990	596	559
Yadkin	152510	579	541