10:44 2 0 till 53% Module 4 The worksheet "Module 4" contains a subset of data from Module 4 focusing on counties in the state of Illinois. Follow the directions below to analyze the data, recording your answers in the corresponding answer blank in Column I (the yellow cells). Module 4.1 Use the SKEW.P formula (like VAR.P and STDEV.P above, we would normally use a different variation of the formula if we didn't have the entire census data) to compute the skewness coefficient for the data. Module 4.2 Interpret the Skewness Coefficient calculated in the previous problem; which type of skewness is present? Module 4.3 Compute the Z-Score associated with the Adjusted Gross Income for Adams County. Use the provided blanks in 14 and 15 to calculate the mean and standard deviation that you'll need for the z- score formula. Also, don't forget to put parentheses in the numerator - if you do, your answer will be in the millions! Module 4.4 Interpret the Z-Score computed in the previous question. Is Adams County an outlier? Total Number of Adjusted Gross Income Wages and Salaries County Name Tax Returns (In Thousands) Income (In Thousands) Problem Statistic Jams County Result 31429 $1476145 $1004704 4.1 Skewness Coefficient exander County 3729 $101842 $72913 Skew Type nd County 7289 $314527 $221820 43 one County Average for IL Counties 23261 $1364532 $1040444 St Dev for IL Counties own County 2313 $98200 $68280 Z-Score for Adams County reau County 16724 $759270 $526524 4.4 Adams County an Outlier? Thoun County 2355 $100192 $70456 roll County 7763 $340172 $209630 ss County 6282 $247024 $177213 ampaign County 78431 $4164455 $2895697 ristian County 16337 $715635 $482223 mark County 7833 $325829 $222727 ry County 6835 $242584 $16809 Al X Jx State Abbreviation D E s inton County 16748 $828547 $608236 6 les County 21405 $922583 $622660 ok County 2350974 $135079847 $99573469 sawford County 8980 $401622 $273246 9 mberland County 5017 $200533 $141818 to Kalb County 41384 $2251225 $1679303 21 Witt County 7741 $367299 $259514 22 uglas County 9570 $430309 $285314 23 Page County 407169 $34369049 $25032430 24 gar County 8826 $350577 $242809 25 wards County 3152 $123226 $85927 26 ingham County 16018 $805520 $525323 27 vette County 9679 $371843 $249235 28 rd County 6604 $294722 $193146 29 inklin County 18937 $684223 $450874 State Abbreviation Iton County 17034 $667181 $479362 latin County 2779 $104599 $69526 pene County 6133 $224797 $160105 undy County 22449 $1368494 $1036231 milton County 3850 $138335 $93842 incock County 9148 $371375 $251178 6 xdin County 2032 $65019 $46613 nderson County 3583 $140007 $95796 amy County 23670 $1 150000 $802851 quois County 14353 $616235 $407296 kson County 23643 $936130 $631863 per County 4585 $192160 $127246 e Person County 17536 $723717 $504533 u sey County 10554 $483634 $345541 u Daviess County 10787 $532416 $319924 5071 $104200 $136300 O10:44 e 2 0 it all 52% Six fx State Abbreviation nc County 202507 $13915903 $10774510 nkakec County 50146 $2303246 $1715317 andall County 45662 $3123490 $2551257 sox County 24521 $967638 $653051 ke County 283038 $27756003 $19446130 Salle County 54058 $2565105 $1854262 wrence County 6951 $270461 $186860 County 16465 $758685 $536111 ringston County 1733 $845085 $560283 gan County 12963 $568819 $390384 Donough County 12490 $523954 $340092 7Henry County 130772 $9633316 $7419071 Lean County 69049 $4261954 $3193832 vicon County $2319 $2624029 $1827489 aicoupin County 22578 $971265 $683369 1 X y fx State Abbreviation idison County 125064 $6353504 $4646987 irion County 18822 $701790 $495685 airshall County 6171 $283010 $193727 ison County 7183 $290510 $197939 s issac County 7355 $270724 $195540 emard County 5904 $312414 $217396 7 freer County 8014 $365354 $262644 Monroe County 14663 $983861 $734541 montgomery County 13549 $573092 $387858 o organ County 16413 $723887 $478392 moultrie County 6701 $316463 $207816 zz le County 24688 $1251909 $920281 noria County 87275 $5005693 $3617466 74ay County 9402 $356975 $251495 sitt County 7474 $421324 $293186 re County 7343 $271091 $187753 pe County 1862 $63611 $42923 laski County 2997 $87054 $64366 Inam County 2848 $153070 $100462 ondolph County 14224 $600046 $423981 shland County 7651 $312750 $204387 ck Island County 71275 $3369575 $2443298 Clair County 121900 $5881936 $4330056 line County 11850 $418036 $288965 agamon County 94497 $5103885 $3478165 buyler County 3354 $133523 $93598 ott County 2338 $99452 $69918 alby County 10127 $422413 $289636 o irk County 2841 $126520 $76989 arphenson County 2249 $1008913 $687639 rewell County 62493 $3416392 $2442165 ion County 8354 $314230 $218979 ammilion County 37591 $1436528 $1010439 ibash County 5683 $249431 $172521 siren County 7808 $318287 $210081 ishington County 6993 $355416 $236623 7 tyne County 7736 $291212 $194336 white County 7164 $291324 $190429 whiteside County 28594 $1249047 $868572 Do ll County 274298 $19251428 $15191116 lliamson County 30118 $1234869 $862912 ennebago County (37011 $6700803 $4936721 ma>odford County 16193 $1097744 $750442 Show transcribed data Expert Answer O