BUSN250 W4 HW Gloster.xlsx - Home Market Value House Age...

This preview shows page 1 - 12 out of 26 pages.

Home Market ValueHouse AgeHouse AgeSquare FeetMarket Value331,812$90,000.00USING TEXT FORMULAS321,914$104,400.00321,842$93,300.00Mean331,812$91,000.0029.83321,836$101,900.00"=SUM(A4:A45)/42"332,028$108,500.00Variance321,732$87,600.005.76331,850$96,000.00"=SUM(H4:H45)/42"321,791$89,200.00Std Dev331,666$88,400.002.40321,852$100,800.00"=SQRT(E10)"321,620$96,700.00USING EXCEL FORMULAS321,692$87,500.00322,372$114,000.00Mean322,372$113,200.0029.83331,666$87,500.00"=AVERAGE(A4:A45)"322,123$116,100.00Variance321,620$94,700.005.76321,731$86,400.00"=VARP(A4:A45)"321,666$87,100.00Std Dev281,520$83,400.002.40271,484$79,800.00"=STDEVP(A4:A45)"281,588$81,500.00281,598$87,100.00281,484$82,600.00281,484$78,800.00281,520$87,600.00271,701$94,200.00281,484$82,000.00281,468$88,100.00281,520$88,100.00271,520$88,600.00271,484$76,600.00281,520$84,400.00271,668$90,900.00281,588$81,000.00281,784$91,300.00271,484$81,300.00271,520$100,700.00281,520$87,200.00271,684$96,700.00271,581$120,700.00
Inser formula without ", thenSq FeetApply samedrag to end to creat dataObs - Mean(Obs-Mean)^23.1710.03USING TEXT FORMULAS2.174.692.174.69Mean3.1710.031,695.262.174.693.1710.03Variance2.174.6947,357.963.1710.032.174.69Std Dev3.1710.03217.622.174.692.174.69USING EXCEL FORMULAS2.174.692.174.69Mean2.174.691,6953.1710.032.174.69Variance2.174.6947357.95521541952.174.692.174.69Std Dev(1.83)3.36217.618830103049(2.83)8.03(1.83)3.36(1.83)3.36(1.83)3.36(1.83)3.36(1.83)3.36(2.83)8.03(1.83)3.36(1.83)3.36(1.83)3.36(2.83)8.03(2.83)8.03(1.83)3.36(2.83)8.03(1.83)3.36(1.83)3.36(2.83)8.03(2.83)8.03(1.83)3.36(2.83)8.03(2.83)8.03
e formula on sq feetMarket ValueObs - Mean(Obs-Mean)^2Obs - Mean11713,628USING TEXT FORMULAS-$2,06921947,846$12,33114721,532Mean$1,23111713,62892,069.05-$1,06914119,807$9,831333110,715Variance$16,431371,350108,715,946.71-$4,46915523,944$3,931969,166Std Dev-$2,869(29)85610,426.69-$3,66915724,567$8,731(75)5,664USING EXCEL FORMULAS$4,631(3)11-$4,569677457,974Mean$21,931677457,974$92,069.05$21,131(29)856-$4,569428182,960Variance$24,031(75)5,664108,715,946.71$2,631361,277-$5,669(29)856Std Dev-$4,969(175)30,71710,426.69-$8,669(211)44,632-$12,269(107)11,505-$10,569(97)9,460-$4,969(211)44,632-$9,469(211)44,632-$13,269(175)30,717-$4,469633$2,131(211)44,632-$10,069(227)51,648-$3,969(175)30,717-$3,969(175)30,717-$3,469(211)44,632-$15,469(175)30,717-$7,669(27)743-$1,169(107)11,505-$11,069897,874-$769(211)44,632-$10,769(175)30,717$8,631(175)30,717-$4,869(11)127$4,631(114)13,056$28,631
(Obs-Mean)^24,280,958152,052,3871,515,2441,142,86396,647,625269,976,19619,972,38715,452,3878,231,43413,461,91076,229,52921,445,72020,876,196480,966,672446,517,14920,876,196577,486,6726,921,91032,138,10124,691,43475,152,387150,529,529111,704,76824,691,43489,662,863176,067,62519,972,3874,540,958101,385,72015,753,33915,753,33912,034,291239,291,43458,814,2911,366,672122,523,815591,434115,972,38774,493,33923,707,62521,445,720819,731,434
Facebook SurveyStudentGenderHours online/weekFriends1female41502female104003male71204male155005female92606female5707female7908male52509female1211010female23011female68012female23013male320014female624015male615016male49017female834018male1045019female45020male412021male618022female428023female56024female910025female1238026male843027female28028female717029male69030male45031female25032male57033female7170
AVERAGE HOURS ONLINE6.24 "=AVERAGE(Hours data range)"MEDIAN HOURS ONLINE6 "=MEDIAN(Hours data range)"MODE FOR HOURS ONLINE4 "=MODE(Hours data range)"Formulacalculation
AVERAGE NUMBER OF FRIENDS176.97MEDIAN NUMBER OF FRIENDS120.00MODE FOR NUMBER OF FRIENDS90.00Formulacalculation
Tablet Computer SalesWeekUnits SoldUnits Sold Sorted188352444436044456485704969150754548605694860103560114961124468136170146871158282167188175091
MEAN(60.65)"=AVERAGE(data range)"STDEV [S.D.]15.93"=STDEV.S(data range)"Q148.5"=QUARTILE(data range,1)"Q370.5"=QUARTILE(data range,3)"IQ RANGE22"=G9-G7"CHEBYSHEV'S THEOREMkTheory(MEAN) - k * (S.D.)MEAN + k * S.D.275.00%(92.51)(28.78)388.89%(108.45)(12.85)493.75%(124.38)3.09EMPIRICAL RULESStd Dev [ # ]TheoryMEAN - # S.D.MEAN + # S.D.168.00%(76.58)(44.71)295.00%(92.51)(28.78)399.70%(108.45)(12.85)Formulacalculation
Actual %100%100%100%Actual %65%100%100%
Atlanta Airline DataMEAN4.9211.60STDEV54.905.50Flight NumberOrigin Airport8IAH19:0419:19151416LAX15:1015:04-6622MSY16:3316:24-91124LAS14:3314:27-6928MCO14:1014:1551338MCO16:1015:48-22657JFK19:4119:54131261LAX19:0219:22201164LAS18:0017:58-21066DFW15:1815:14-4968SFO14:4414:35-9774MIA15:4115:39-218101LAX17:4117:561513105DTW17:35

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 26 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
N/A
Tags
MCO, Threesome, Obs Mean, Time Difference Taxi

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture