How many outliers would be considered in this data? Something is wrong with my lower and upper formulas City Median Household Income Morgantown, WV $ 38,060 Fayetteville, AR $ 40,835 Wooster, OH $ 43,054 max $ 138,192.00 =MAX(B:B) Council Bluffs, IA $ 46,844 min $ 38,060.00 =MIN(B:B) Bossier City, LA $ 47,051 mean $ 72,342.94 =AVERAGE(B:B) St. Augustine, FL $ 47,748 median $ 66,743.00 =MEDIAN(B:B) Rapid City, SD $ 47,788 range $ 100,132.00 =E4-E5 Bozeman, MT $ 49,303 std deviation $ 23,711.80 =STDEV.S(B:B) Sparks, NV $ 54,230 first quartile $ 56,562.75 =QUARTILE.EXC(B:B,1) Orem, UT $ 54,515 third quartile $ 82,775.75 =QUARTILE.EXC(B:B,3) Concord, NC $ 54,579 inner quartile $ 26,213.00 =E11-E10 South Portland, ME $ 56,472 lower $ 17,243.25 =E10-1.5*E12 Cheyenne, WY $ 56,593 upper $ 122,095.25 =E11+1.5*E12 Monterey Park, CA $ 57,419 Mauldin, SC $ 57,480 St. Peters, MO $ 57,728 Georgetown, KY $ 58,709 Beaverton, OR $ 58,785 Rio Rancho, NM $ 58,982 Kapaa, HI $ 62,546 Meridian, ID $ 62,899 Olive Branch, MS $ 62,958 Warwick, RI $ 63,414 Manchester, CT $ 64,828 Mustang, OK $ 66,714 Pelham, AL $ 66,772 Nashua, NH $ 66,872 Colchester, VT $ 69,181 Farmington Hills, MI $ 71,154 Dickinson, ND $ 71,866 Vinings, GA $ 73,103 Schaumburg, IL $ 73,824 North Arlington, NJ $ 73,885 New Berlin, WI $ 74,983 Waltham, MA $ 75,106 Lenexa, KS $ 76,505 Papillion, NE $ 79,131 Franklin, TN $ 82,334 Juneau, AK $ 84,101 Fishers, IN $ 87,043 Valley Stream, NY $ 88,693 Woodbury, MN $ 99,657 Rockville, MD $ 100,158 Allen, TX $ 104,524 Reston, VA $ 112,722 Hockessin, DE $ 115,124 Lone Tree, CO $ 116,761 Lower Merion, PA $ 117,438 Mercer Island, WA $ 128,484 Paradise Valley, AZ $ 138,192

Question

How many outliers would be considered in this data? Something is wrong with my lower and upper formulas City  Median Household Income      Morgantown, WV  $                                    38,060     Fayetteville, AR  $                                    40,835     Wooster, OH  $                                    43,054  max  $ 138,192.00 =MAX(B:B)  Council Bluffs, IA  $                                    46,844  min  $   38,060.00 =MIN(B:B)  Bossier City, LA  $                                    47,051  mean   $   72,342.94 =AVERAGE(B:B)  St. Augustine, FL  $                                    47,748  median   $   66,743.00 =MEDIAN(B:B)  Rapid City, SD  $                                    47,788  range  $ 100,132.00 =E4-E5  Bozeman, MT  $                                    49,303  std deviation   $   23,711.80 =STDEV.S(B:B)  Sparks, NV  $                                    54,230  first quartile   $   56,562.75 =QUARTILE.EXC(B:B,1)  Orem, UT  $                                    54,515  third quartile   $   82,775.75 =QUARTILE.EXC(B:B,3)  Concord, NC  $                                    54,579  inner quartile  $   26,213.00 =E11-E10  South Portland, ME  $                                    56,472  lower   $   17,243.25 =E10-1.5*E12  Cheyenne, WY  $                                    56,593  upper  $ 122,095.25 =E11+1.5*E12  Monterey Park, CA  $                                    57,419     Mauldin, SC  $                                    57,480     St. Peters, MO  $                                    57,728     Georgetown, KY  $                                    58,709     Beaverton, OR  $                                    58,785     Rio Rancho, NM  $                                    58,982     Kapaa, HI  $                                    62,546     Meridian, ID  $                                    62,899     Olive Branch, MS  $                                    62,958     Warwick, RI  $                                    63,414     Manchester, CT  $                                    64,828     Mustang, OK  $                                    66,714     Pelham, AL  $                                    66,772     Nashua, NH  $                                    66,872     Colchester, VT  $                                    69,181     Farmington Hills, MI  $                                    71,154     Dickinson, ND  $                                    71,866     Vinings, GA  $                                    73,103     Schaumburg, IL  $                                    73,824     North Arlington, NJ  $                                    73,885     New Berlin, WI  $                                    74,983     Waltham, MA  $                                    75,106     Lenexa, KS  $                                    76,505     Papillion, NE  $                                    79,131     Franklin, TN  $                                    82,334     Juneau, AK  $                                    84,101     Fishers, IN  $                                    87,043     Valley Stream, NY  $                                    88,693     Woodbury, MN  $                                    99,657     Rockville, MD  $                                  100,158     Allen, TX  $                                  104,524     Reston, VA  $                                  112,722     Hockessin, DE  $                                  115,124     Lone Tree, CO  $                                  116,761     Lower Merion, PA  $                                  117,438     Mercer Island, WA  $                                  128,484     Paradise Valley, AZ  $                                  138,192

Accepted Answer

Outliers are values or observations which are more deviated away from other variables or…

City	Median Household Income
Morgantown, WV	$ 38,060
Fayetteville, AR	$ 40,835
Wooster, OH	$ 43,054	max	$ 138,192.00	=MAX(B:B)
Council Bluffs, IA	$ 46,844	min	$ 38,060.00	=MIN(B:B)
Bossier City, LA	$ 47,051	mean	$ 72,342.94	=AVERAGE(B:B)
St. Augustine, FL	$ 47,748	median	$ 66,743.00	=MEDIAN(B:B)
Rapid City, SD	$ 47,788	range	$ 100,132.00	=E4-E5
Bozeman, MT	$ 49,303	std deviation	$ 23,711.80	=STDEV.S(B:B)
Sparks, NV	$ 54,230	first quartile	$ 56,562.75	=QUARTILE.EXC(B:B,1)
Orem, UT	$ 54,515	third quartile	$ 82,775.75	=QUARTILE.EXC(B:B,3)
Concord, NC	$ 54,579	inner quartile	$ 26,213.00	=E11-E10
South Portland, ME	$ 56,472	lower	$ 17,243.25	=E10-1.5*E12
Cheyenne, WY	$ 56,593	upper	$ 122,095.25	=E11+1.5*E12
Monterey Park, CA	$ 57,419
Mauldin, SC	$ 57,480
St. Peters, MO	$ 57,728
Georgetown, KY	$ 58,709
Beaverton, OR	$ 58,785
Rio Rancho, NM	$ 58,982
Kapaa, HI	$ 62,546
Meridian, ID	$ 62,899
Olive Branch, MS	$ 62,958
Warwick, RI	$ 63,414
Manchester, CT	$ 64,828
Mustang, OK	$ 66,714
Pelham, AL	$ 66,772
Nashua, NH	$ 66,872
Colchester, VT	$ 69,181
Farmington Hills, MI	$ 71,154
Dickinson, ND	$ 71,866
Vinings, GA	$ 73,103
Schaumburg, IL	$ 73,824
North Arlington, NJ	$ 73,885
New Berlin, WI	$ 74,983
Waltham, MA	$ 75,106
Lenexa, KS	$ 76,505
Papillion, NE	$ 79,131
Franklin, TN	$ 82,334
Juneau, AK	$ 84,101
Fishers, IN	$ 87,043
Valley Stream, NY	$ 88,693
Woodbury, MN	$ 99,657
Rockville, MD	$ 100,158
Allen, TX	$ 104,524
Reston, VA	$ 112,722
Hockessin, DE	$ 115,124
Lone Tree, CO	$ 116,761
Lower Merion, PA	$ 117,438
Mercer Island, WA	$ 128,484
Paradise Valley, AZ	$ 138,192