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

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.5E12 Cheyenne, WY $ 56,593 upper $ 122,095.25 =E11+1.5E12 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

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

100%

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

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here