Wk4.xlsx - Home Market Value House Age House Age Square...

This preview shows page 1 - 10 out of 24 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.83 321,836$101,900.00"=SUM(A4:A45)/42"332,028$108,500.00Variance321,732$87,600.005.76 331,850$96,000.00"=SUM(H4:H45)/42"321,791$89,200.00Std Dev331,666$88,400.002.40 321,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.83 331,666$87,500.00"=AVERAGE(A4:A45)"322,123$116,100.00Variance321,620$94,700.005.7579365079321,731$86,400.00"=VARP(A4:A45)"321,666$87,100.00Std Dev281,520$83,400.002.3995700673271,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 data Obs - Mean(Obs-Mean)^23.17 10.03 USING TEXT FORMULAS2.17 4.69 2.17 4.69 Mean3.17 10.03 1,695.26 2.17 4.69 3.17 10.03 Variance2.17 4.69 47,357.96 3.17 10.03 2.17 4.69 Std Dev3.17 10.03 217.62 2.17 4.69 2.17 4.69 USING EXCEL FORMULAS2.17 4.69 2.17 4.69 Mean2.17 4.69 1,695.26 3.17 10.03 2.17 4.69 Variance2.17 4.69 13,340.25 2.17 4.69 2.17 4.69 Std Dev(1.83) 3.36 115.50 (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 - Mean117 13,627.78 USING TEXT FORMULAS-$2,069219 47,846.35 $12,331147 21,532.07 Mean$1,231117 13,627.78 92,069.05 -$1,069141 19,807.21 $9,831333 110,714.64 Variance$16,43137 1,349.69 108,715,946.71 -$4,469155 23,943.88 $3,93196 9,165.78 Std Dev-$2,869(29) 856.26 10,426.69 -$3,669157 24,566.83 $8,731(75) 5,664.35 USING EXCEL FORMULAS$4,631(3) 10.64 -$4,569677 457,974.45 Mean$21,931677 457,974.45 $92,069.05$21,131(29) 856.26 -$4,569428 182,959.88 Variance$24,031(75) 5,664.35 108,715,946.71 $2,63136 1,277.21 -$5,669(29) 856.26 Std Dev-$4,969(175) 30,716.74 10,426.69 -$8,669(211) 44,631.59 -$12,269(107) 11,505.12 -$10,569(97) 9,459.88 -$4,969(211) 44,631.59 -$9,469(211) 44,631.59 -$13,269(175) 30,716.74 -$4,4696 32.93 $2,131(211) 44,631.59 -$10,069(227) 51,647.97 -$3,969(175) 30,716.74 -$3,969(175) 30,716.74 -$3,469(211) 44,631.59 -$15,469(175) 30,716.74 -$7,669(27) 743.21 -$1,169(107) 11,505.12 -$11,06989 7,874.45 -$769(211) 44,631.59 -$10,769(175) 30,716.74 $8,631(175) 30,716.74 -$4,869(11) 126.83 $4,631(114) 13,055.78 $28,631
(Obs-Mean)^24,280,958 152,052,387 1,515,244 1,142,863 96,647,625 269,976,196 19,972,387 15,452,387 8,231,434 13,461,910 76,229,529 21,445,720 20,876,196 480,966,672 446,517,149 20,876,196 577,486,672 6,921,910 32,138,101 24,691,434 75,152,387 150,529,529 111,704,768 24,691,434 89,662,863 176,067,625 19,972,387 4,540,958 101,385,720 15,753,339 15,753,339 12,034,291 239,291,434 58,814,291 1,366,672 122,523,815 591,434 115,972,387 74,493,339 23,707,625 21,445,720 819,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)" Formula calculation
AVERAGE NUMBER OF FRIENDS176.97 MEDIAN NUMBER OF FRIENDS120MODE FOR NUMBER OF FRIENDS90Formula calculation
Tablet Computer SalesWeekUnits SoldUnits Sold Sorted188912448836082456715707069168754618606094860103556114954124450136149146848158244167144175035First step is to sort data low to high
MEAN60.65 "=AVERAGE(data rangeSTDEV [S.D.]15.93 "=STDEV.S(data range)"Q149"=QUARTILE(data rangeQ370"=QUARTILE(data rangeIQ RANGE21"=G9-G7"CHEBYSHEV'S THEOREMFill cells using formulaskTheory(MEAN) - k * (S.D.)275.00%"=1-1/F16^2" 28.78 388.89%"=1-1/F17^2" 12.85 493.75%"=1-1/F18^2" (3.09)EMPIRICAL RULESStd Dev [ # ]TheoryMEAN - # S.D.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture