statistics 1

Data Analytics 1

. ' . ' ' II R. ·--,· 1'-·E.stat~ ·data:·1~d•pre~;are,:a-(eportbn·the :s·.ares'pric~s:,:_:-·~ _'.1 r:nr-1·~ ·· i · · t •the North·Va ey ea · _ . . · .. · ,

86.: ~ e er or :· re,to answer-the-:following~qaestions.m -yo~r reppr~~·:·- . . . . ;. ·;1 of the homes. Be.su .. : . . __ d ·-the:data .tendr td.clustea-What..:l s: the mea n; sales;.;"'", , , ·. 1

A d ·- what values.-,of-.prlce. 0 · ·' · · · · · · t ti · f th "· ·, · ·! a.. roun - .. -

1 rice?· Is: one m.easure,· more:-represen a ve o _ e -•· ~""' ·.~

price?· Wha.t·rs the-medlant sa es-, p . . :. :· . -~ . - : ,.-_:- . . . .- - , -:; : . . ~ •

1 .

1 pdcesthanthe~othersl .1-r . .. ·. ·_ · .. -• --- • ---·. -_· .~ ·,

typ1ca sa es- 1 · , • - " "Whatts·.the>standate:tdeviatlonI~About.~95%:, o.fi t he:·; -~ Wh t-·1s the -range,.af. sa es-.pnces .. - · · • · · · · · · - fi · 1.- t t· t· · · ·.,

b. sal:sr.p~ic~~, are be.twe~n,~~att~oNal.~~sr_1:5'. t~'..stan~ard~_dev1~~10_~-_a· U~;,-,u :_s ~ -~s _ 1~ -~-' . : for' describing .\he '. dispers1on-:o.tsa_le5:,_p~1~e1.•r )\'. - .. -. : > ,- . r . . . •. l

c •. Repeat (a)"and,(bY.,using.lf,f~O 1

.score;:: _.._.. ;"· .-· / ·-· --~--- _ _ ... .. . ,;- --~\

. ' .. , ' .· 1

1

Data-Analytics 2.

s2:. 1i!DiRefer-to~,th¢~Basel:>aL~2..~'J1J;d:~tciu,tf;'l~~r-ep:or;:t;; i mforrn~ti<;ir;r.t(?~~ttte-,3Ql Major-: Leag_u~::.t ~--· ·-; 'i . . Baseb~l.b teams; t6r:tt.iei20i df:~-~~qdl t fe~te:!~t}r.~qliJ)~.f11€Yj :f istr:i.bi:JtiPl\i.If..qr.-.tbe"::Tfiam.iS.alari;=//:; :.:_i

v.ariab.lecar;ud;!ahswe1rthe/foilowinicr11estlori~A-J~;{rtF-i~r1~ti4.t jtllf~tr~":/ -~>;.~.-::· \ <;:~:·/ .i·: ·.-~: ~- ~:._: .. , a-!7 W-_h~f·j~ .the.fyP.l~a_,.1~a'.t~~f9~;~:-~~~~f ~_li_~t~f~?h~:r~p~i~'.i:i~th~~~-i~~i~s~\;" .? :.\ _-:. /~·'\\( .,~;.: I: b ;i .eomment0m:,.theshap_e/0f the:,dlstrlbutloo-:! 0oes1. ttapp,eaethat:an~ ot tfi;e-1teams-ha\le~ · · ·

• ~ l - I \ • , ••• ' : • • • ,-1, . , • • - .- ~' • ._• , ~ • ,. .. ,;: ._, :; r-_•,•• • ~-. ••; : . .,. ,.,_-. ,:-•• - ~•.. . • °\ . a-salarw~nat:Js--out.of:UMe:wtth}t~·e;·~tti~FS~~;t~1ff\~~r~<·"/:-,':\ ~-~ ~-~;.:::. ,·,c:V-.'~:ir;·;. ;- -~:: ... _, __ ;-_' -._ ~/ :::; ' :j

c;:: Draw~a-7<::umUl~ti\le,;~elatlyaff.eqtjen~.- disfrloutiontat.team ~ala r¥7.,,Uslng: thls.distribCJ::i-~:~ :, : ·--~

. < ,~iciri1 (arty, P:er.cer. J6~i1:1:e,~1.·e~~~:_f.-1 ~~~-1•_ai-~-~~~'W-9.:' l,e. :~i: th~~i~~t£,~~~-~-q1~.---f\~~_u ... t b_o~:-···t·'..' 7~~jJ ~ ~nY,,te~m~-ha't~ ~~tc;,t~l,tsaJ.e.~ ;:~i~~r~,!~~,,~t tf.3:fltP.Jllnq~]~ faJi·:J.k ·: _ :·· ·-~ .. E- . ' · .... · .. -:·, .--:. .:

. ~ . ~ .,.....:

1 I

! I

746

A.1 Data Set 1-North Valley Real Estate Data

Record Agent

1 Marty 2 Rose 3 Carter 4 Peter.;on 5 Carter 6 Peter.;on 7 Carter a Isaacs 9 Peterson

10 Isaacs 11 Rose 12 Peterson 13 Marty 14 Rose 15 Rose 16 Isaacs 17 Carter

Variables Record = Property identif1cat lon number Ag ent = Name of the real esta te agent assigned to the property Price = Market price in dollars Size = Livable squa re fee t of t he property Bedrooms = Number of bedrooms Baths = Number of bath rooms Pool = Does the home have a pool? ( 1 = yes, O = no) Garage = Does the home have· an attached ga ra ge (1 = yes, o = no) Days = Number of days of the property on the market Township = A rea where the property Is located Mortgage type = Fixed or adjustable. The fixed mortgage is a 3 0 year, fixed inte rest ra te loan. The adjustable rate loan begins-with an introductory interest rate of 3% for the first five years; then the· interest-rate is based on the current interest rates plus 1 % (i.e. the interest rate AND the payment is likely to change each yea r aft er the 5th year) Years = the number of years that the mortgage loan has been paid FICO = the credit score of the mortgage loan holder. The highest score is 8 50; an average score is 680, a low score is below 680. The score reflects a person's ability to pay their debts. Default= Is the mortgage loan in default? (1 = yes, 0 = no)

Pool Garage Mortgage Price Size Bedrooms Baths (Yes Is 1J • (Yes Is 1J Days Township type Years FICO

206424 1820 2 1.5 1 33 2 Fixed 2 824 346150 3010 · 3 2 0 0 36 4 Fixed 9 820 372360 3210 4 3 0 21 2 Fixed 18 819 3 10622 3330 3 2.5 1 0 26 3 Fixed 17 817 496100 4510 6 4.5 0 1 13 4 F_ixed 294086 3440 4 3 1 1 31 4 Fixed 228810 2630 4 2.5 0 39 4 Adj usta ble 384420 4470 5 3.5 0 1 26 2 Fixed 41 6 120 4040 5 3.5 0 1 26 4 Fixed 48 7494 4380 6 4 1 32 3 Fixed{ 448800 5280 6 4 0 35 4 Fixe'cf;. 388960 4420 4 3 0 1 50 2 Adjustable 335610 2970 3 2.5 0 1 25 3 Adjusta ble 276000 2300 2 1.5 0 0

346421 29 70 34 1 Fixed 4 3 1 1 453913 3660 17 3 Adj ustable 6 4 376146 3290

1 12 3 Fixed 5 3.5

17 816 19 81 3 10 8 13 6 8 12 3 810 6 808 8 806 9 805 9 80 1

20 798 10 795 18 792 1 1 28 18 Peterson 694430 5900 2 5 3.5 Adjustable 1 1 19 Rose 251269 2050 3 6 3 Adjustable 3 9 792

2 1 1 20 Rose 547596 4920 6 38 3 Fixed 21 Marty 214910 4.5 1 1 37 1950 2 1.5 1 5 Fixed 22 Rose 188799 1950 0 20 2 1.5 4 Fixed 23 Carter 459950 1 0 4680 4 52 1 24 Isaacs 264160 3 1 1 Fixed 2540 3 2.5 31 4 Fixed,: 25 Carter 393557 0 1 3 180 4 3 40 1 26 Isaacs 478675 466{) 1 54 Fixed 5 3.5 1 27 Carter 384020 4220 1 1 Fixed 28 Marty 5 J S 0 26 5 313 200 3600 4 1 23 Adjustable·· . 29 Isaacs 3 274482 2990 3 0 1 Adjustable -,· 30 Marty 167962 2 31 1920 2 1.5 0 37 Fixed

31 Fixed Fixed .

10 788 16 786 2 785 6 78 4

10 782 8 781 18 780 20 776 9 773 9 772

19 772 5 769 6 769

Default (Yes is 1)

0 0 0 0 0 0 0 0 0 0

1 1 ~- 0 "'"· 0

:,-

--!--1 0 ~ 1 " ;i 0 -'~ 0 _ .. .:.;

~

0 ft 0 ' .. , ~:- 0 1j

~-1 -~ o,,.s 0, Q ,., -~-

•" /ronl

. ;:~ . l ,c . ,,

,:: ~

~