Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Recently Santa Fe, New Mexico, was named one of the safest places to live in the United States. Since then housing development projects have been

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Recently Santa Fe, New Mexico, was named one of the safest places to live in the United States. Since then housing development projects have been springing up all around Santa Fe. Six housing development projects are currently dominating the local marketPinon Pine, Rancho Hondo, Creek Side, Vista Del Monte, Forest View, and Santa Fe South. These six projects each started with 100 homes, have sold all of them, and are currently developing phase two.

As one of the three partners and real estate agents of Affordable Homes Real Estate, it is your responsibility to analyze the information concerning the past 600 home sales and choose which development project to focus on for selling homes in phase two. Because your real estate firm is so small, you and your partners have decided that the firm should focus on selling homes in only one of the development projects.

From the New Mexico Real Estate Association you have obtained a spreadsheet file hat contains information concerning each of the sales for the first 600 homes for information on how to use Excel.). It contains the following fields:

The following numbers have been assigned to each of the housing development projects:

It is your responsibility to analyze the sales list and prepare a report that details which housing development project your real estate firm should focus on. Your analysis should be from as many angles as possible.

1.

You do not know how many other real estate firms will also be competing for sales in each of the housing development projects.

2.

Phase two for each housing development project will develop homes similar in style, price, and square footage to their respective first phases.

3.

As you consider the information provided to you, think in terms of what information is important and what information is not important. Be prepared to justify how you went about your analysis.

4.

Upon completing your analysis, please provide concise, yet detailed and thorough, documentation (in narrative, numeric, and graphic forms) that justifies your decision.

AutoSave OFF GFF ADES AYK15_Data_Version 1 (1) Q Home Insert Draw Page Layout Formulas e Share Comments X LIA Arial 10 v AP Data Review View Tell me al General $ % ) Conditional Formatting V Format as Table v 1 Cell Styles Insert v & Delete A10 3 - Paste BI IV Sensitivity Format Sort & Filter Find & Select Analyze Data Yes No Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? A xv for A1 1 N T w Y Y AF AC AE PROJECT 23 60 23 21 6 47 97 20 21 2 23 23 21 64 97 23 22 A - 3 LOTE 84 5 72 6 119 7 11A 187 9 10 4 11 107 12 164 18178 14 0 1574 17 142 13 65 15 19 100 20 79 31 70 22 1 119 2 24 23 1010 3 10 39 27 111 25 20 11 169 13 101 108 34 33 ol 13 71 26 42 20 40 10CE 11 13 116 43 44 45 10 121 17 111 45 110 4. 7 29 51 52 1200 34 54 1 35 174 SE 10 53 167 56 112 30 105 es 100 61 21 6 F H A.SK PRICE SELL PRICE LIST DATE SALE DATE 80FL #BATH BDRMS $70,000 Sr0.000 U-11 1 1900 SB, CD SH 000 3 S. $43,500 25 20 11 5923 1 3 506 500 $74.00 0. 02 F11 . $25,000 UF11 14:11 900 1 4579 04-11 -1 1750 25 $32,900 9500 0-11 Wel 1700 3 $0,30 5615 1 AF-1 1900 1 2 $94.000 SA2000 OSFA1-14 1971-19 1200 3 30.000 $899 05 F. 112: 1750 4 2 $:1,200 $80.000 01-11 4 25+4-119950 2.25 $82,900 28 ON 4 or 230 SIS SA 1900 Se 900 SA 044 60 2 3.560 020241350 1 $70,000.00 U-11 US-W-11 25 $81,900 -11 850 4 $81.9 591 m nga 191700 2 $96.900 SA003 011 09 F-11 900 01.11 09.08.11 2 4 $70,000 $10.000 04.11 10WU1200 3 $17, swings 1790 25 4 SH 250 17-01 4135 $70.000 $713 191 2 10 235 Sa 05 F0.11 19 11 4 $12.200 $14.50 U11 1972-111490 2.25 3 Srana 1900 1 3 5491980 5101 21 1900 3.500 4 2.0 9.603 01.11 29 11 1900 2 4 $190,000 S2830 20-1950 $82,900 28.00 Ww1 1700 2.25 SUB, 19 INN 1900 1.78 5 SA 900 221 2 572,500 $90.000 04.11 01 096 U11 011330220 3 SE2 D2 09-11 pr1 1900 25 3 573,500 STI 2011 April 1935 3.35 $1,700 NA 1200 Star 09 DET AFS450 2.25 8 $84292 U11 Ura-1 9900 3 572,200 ST 1,100 DP-11-20 4 $14,500 01-11 OTA 1 1900 3 578.900373 ) 350 8 $21.550 0.00 0041 WA 1700 3 5104.000 U11 10.A-119900 25 $34,000 1775 3 10-11 2.23 $82,10 591 m. OW 10-AP1 3 a $17.400 10-11 4 981.560 2009 09.11 10 5750 $70,000 Sru. U-11 11-11 DU 1.75 $11,000 no: 0-1 11 April 1730 25 3 $14,500 STT AS 05-11 12-Apr-113490 $97.500 SA ASFA-11 12 Apr 20 SA.260 $67.693 01.11 18 1310 2.25 4 $ srrrna 11 4 1 142-111450 500,000 141310 3 4 SIDODO simu 15 Apr1 2.35 a Value of Information + 61 21 23 21 64 HE 23 6 23 21 - 1 97 47 27 21 AYK 15 El + 70% AutoSave OFF GFF ADES AYK15_Data_Version 1 (1) Q Home Insert Draw Page Layout Formulas e Share Comments X Arial 10 vi Data Review View Tell me al General : $ % ) Conditional Formatting V Format as Tablev Insert v & Delete - 3 Paste BI Uv A Sensitivity Cell Styles Format Sort & Filter Find & Select Analyze Data Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No A1 1 J N F R 3 T LA U x AR AD AE 11 1059 84 10! 115 4 4 4 . PT 4 4793 * 110 D 70 130 71 114 73 7 64 14 75 49 73 494 149 70 4 11 16 114 12 34 9 23 DY 31 11 28 51 DY 32 ET 61 B1 3 1 4 4 3 1 3 4 4 2 3 4 23 61 61 31 BI PT 11 61 B1 43 25 15 11 9 1 F F R $79993 57 00 61-yrtt 11. Art 1003 2 02 Mar 11 1511 1602 2 $8.900 39. 15-111 110 225 ST. SES, DOO DI-JN-It 17- AN! 1293 1 SAS 993 SR2 SM 17.AM 1790 $7409 SET 2011 Jan 11 12Art 1253 78 $74.00 SEO.OO 11 Jan 118 1275 225 SE, DI-1 15-63199 229 SEKI ! 10-11 the 1703 2 ST9 9135.10 1-Fnh-11 1999 $A7A0001 Feb 111 109 471,200 01 Jan 11 16112 S87.000 964, SUU 01--vb-1 10-4111 1230 2 2 579,00 W! 2 17: AINI 153 . 1 Sms SIA ETA 1975 2010.01.0112161 1788 $12.500 UEU 1-1 21.11 103 SOT E 05-11 21A 223 Sms SE2BB1-Jan-1 J.M1109 $79993 5260 01 Jan 11 23 A11 20 01 Feb 11 2011102 $2.999 SEU, BU 24-43M11790 2 SED, DI!! 24-AMI! 1790 shi na AN SIM 74-ASMA 1553 2 SASEADO 4 Jan 11 21 16932 14.00 SESEO 01F661125 1833 $32.900 968,250 D1---112M 123 2.a ST2 200 575,00 Iwb-1 2AM 1593 225 SATSER MMM-AM 1573 SA 52.00 37 17193 175 471,000 O Mart 2511100 11 $2.000 965, DUU 20-4111 1203 2 STA 3200 579,00 DI-J-11 1500 571 SEAT ! 2011! 19 0-11 1 1 sro $110.000 . 225 $87.00 856.00 06 fub 1102 11 102 $10.00 369.00 11-11 US-11 1900 Sexo: 5E4,900 1593 SB2.000 - A4 17:50 Sen 20 cm 1903 2 0.00 0.00 11104 1632 $9.00 904,350 10W-11 1799 ST 3203 574,5 250w1 1400 229 574.000 5700M 35-45M105W 1203 1 SA SEA 70 25 Art www11 1999 299 956,200 01 Mar 1105 11 109 225 -11 US- 09--11 1900 SED DOO 25.4 Sw 1500 1 5229 5H11 D1-11 AS- 1990 3. $7:03 59 1993 3 95.000 1.500 250W 11 1909 $99.500 904, DI-F-11011 1992 1 500 SE2, DO win 514.30 12-UAN 05-11 1573 $70.000 SEAS 11 OM 11 1225 225 $83.60 $51.500 01 Mart 07 Nov 11 1692 2.6 $ 90,00 DIF-11 UrW-11 170 3 S2 303 S SEE, DOO DI'mb-11 07- Ww;-11 . 229 Value of Information + 3 3 4 3 4 1 2 $ 4 4 3 11 H2 93 100 98 1007 24 10! 35 SE 190 93 -21 9 20 2000 10 C2 101 10 102 103 10338 104 233 103 10 100 101 107 1070 1001111 102 10624 11 103 4 4 3 23 12 23 4 4 1 41 T 17 GY 12 47 32 4 2 4 47 11228 113 1009 114 44 113 112 116 11 117 1001 11111 92 9 4 4 3 4 51 120 41 AYK 15 BP 70% AutoSave OFF GFF ADES AYK15_Data_Version 1 (1) Q Home Insert Draw Page Layout Formulas e Share Comments X Arial 10 vi Data Review View Tell me al General $ % ) Conditional Formatting V Format as Tablev Insert v & Delete #10 3 - Paste BI Uv Sensitivity Cell Styles Format Sort & Filter Find & Select Analyze Data Yes No Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? + x fx A1 ! 1 N R w Y 2 AB AC AD AE 3 23 21 97 A2 97 4 3 3 4 92 47 27 4 4 21 6 47 8 . 3 W 23 97 64 07 4 21 8 6 22 . 2 10147 147 12 39 14 17 121 122 124 183 180 1:20 151 127145 1211910 199 11 190 1001 159181 13211 123 404 404 185 16 1901 157 4: 13 121151 129 130 10018 141118 1 14212 14 1700 143 181 140 1094 ja 1931 14 1013 129 1047 10018 151 44 1922 151 16405 163 10 150 102 157 1611934 1991 11A 180 114 189 1021 12 197 1994 1012 185 160 120 1671 165 10 1991 173 al 163 11 1998 172 10.7 11911 170 186 175 167 1 100 ITT 170 11 47 92 93 47 97 E 346.900 0 F11 7100 2.25 $ $0.00 U11 1 - 1 550 1.75 $1,000 2 04. $82,790 ON 2 554,500 0 0 892.50 S9 59 de 260 1.25 $24.95 $89.90 UT-110-May-1950 $102,300 5109500 H- 100- V1 1900 25 SIB, 800 57001 OP-U11 1300 2 $93.500 SA 298 $4.003 26 A11 May 1950 $70,000 Usu..11 10-Wur111350 $94,000 ]] 11-11 2.23 $78,00 STAAN 12-11 1900 5-90 SAA 13 12-U11 420 26.960 $99.00 05 F1s We9900 $21,000 $8009 01.11 13-Wee19 2.25 $7,00 2,790 11 See 13-15 SUR780 1.250 05FA-11 14-11 1550 $18.900 999 999 0-11 110 3 05 F11 14 | 25 $14.89 U11 | 14-41 42U $84,900 swings 15-May-11 1700 2.23 $19,900 17: 15-16 SA 73 20 OSNr.1 15 v 11 125 $1.500 883252 05 F11 15 1 350 2.25 . $5,000 $842 15-ap100 $3,300 S12500 12 211 1E-11 1900 2 $14,900 501 10-11 1900 $94.500 100 26 1 Apr11 410 25 $ 0.00 $100.000 05 F 11 16 W 1950 397,200 $9.500 U-11 1990 547,00 17-11 1200 2 2.pl Siro ST7AN: 17.11 1900 2.35 STE 50 Stama 2017 10 25 011 09 15 W 1280 $95,50 $8.50 09-11 18-Map 11 1950 $54,900 STO Osa. 10-11 1990 1 $11,000 02-11-11156 571,500 $ ON 25 100 $5.500 84003 092195510 1 $20,000 S. www-11 20-May11 2250 $75,300 99,753 : 04-11 21-ver-11 275 25 $13,000 5101 21 31--11 1900 $78.900 Stam) 02.11 31-Wyp 1145003 $104.500 5104002 0 11 22 1902 U11 22-Way-11 1700 $7D STS DOS 1 $0.900 0922- WHEO ASFA-11 33-11 588960 SAR 0% 3102 $94.500 $82.603 099 215002.25 $71,700 $0.00 09-11 23-Map.11 1900 Sale $71,700 Stanos Apr 1124.p.11330 579,00 11 31-11100 578.900 $77 090-120 1 Spa 820 N24 ap. 1226 2.25 $290 09:11 24-May-11 1750 $25,00 S403 11 24-11 1920 573, 57 ST 011 25-11 1300 2.75 Value of Information + 4 4 2 97 47 27 8 97 97 A2 64 5 3 2 2 T x Y AR AE 36 361 1093 27 862 101 553 1023 354 115 97 120 97 3000 1001 86/1990 1972-1 4 4 3 4 T x Y AR AE 36 361 1093 27 862 101 553 1023 354 115 97 120 97 3000 1001 86/1990 1972-1 4 4 3 4 Sensitivity A 6 % * $ = Format Sort & Filter Find & Select Analyze Data A Yes No Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? xv fx A1 1 1 1 N T x Y Y NE AC AD AE A 4. 4 2 DOCHS BOULOS COU S . A w 4021014 410 1959 41010337 212 419 1920 414 415 412100 410 21 217 79 23 4131 * 4 419 2011 42 1913 93 92 292 1050 A2 4291014 47 424 40 425 4234.. 21 27 1024011 1047 A2 1045 3 4 a G 3 3 2 7 4 a & 26 430 102 23 92 2221 2 21 23 7 SU 21 21 23 23 4 435 114 24 427 126 480 34 1045 102D 4 1014 2.22 103 223 1015 E 11,90 $24.LU 20-May-11 : 1 29-Aug-11 1200 1 S25,000 900 $94,500 1700 225 $43.560 27.115500 $21,900 27-Aug-11 9950 $71,150 413 20-ep-11 27-Aug-11 1350 $1,50 Sasas . 27-421 25 571,200 STA 274 10 1 384.50 31999.11.30 $5,700 sara 02-54-11 CU 2.25 $72,290 Singga 02.11 1300 2.25 577. BOSTA 3D-WRp.11 01-5-11 4100 $76.000 $740 20 y 11:00 171 $57.603 25 A01100110 3. V 2010-11 03-540-11 1900 5:7,00 SH 300 Ol SIB 09-849-1900 300 3 $93.560 SA255 20 ANS 20 171 *S72 25 05 800.91 500 2.25 $75,000 $64.88 09-11 09-30-1400 ST7.00 20-105-50-1100 soban SA70108-11025 $10.00 S69499 OS-11 0111100 3 8:2000 $0.00 011 0711500 1.75 Sra. 09-11 07-Way-11 1900 SAD, 200 Se ay-va1 1300 574 572410 1250 2.23 $9.900 Quar 18.750 2009 01.11 09.08.1960 $70,000 fra 80 2A11 02-511 400 500,000 ros 03-04-11 230 1.73 $7,00 900 1 517 400 SAT679 op My11 900 21 $72.500 $70.000 26.1980.1900 3.250 S. US1.11 9.6.1900 1 $71,300 20-11 11.3.11 1300 574,500 JD-11 1300 577.900 2011 10 8440 29.12.1990 29.01 $191,000 $100.000 21-4-1 200 $25,500 AI 1700 2 . 900 www. $93.500 2.39 20 y 11 $27.900 2059 2009 200 2.25 $82.3 2I--1 19-04-11 1200 S80,000 56700 0.11 1940-11 1300 SIBE 0-1 25-GA-11 1950 $97.40 3 $9.0 S 29.4.11 21801010 25 tar.250 01-11 1300 25 $3,400 09.11 21-10-11 1900 21-10-11 1900 25 579,900 : 21-01 560 1 $43.560 SA 4 4 550 25 $26.900 583.78 150 2.25 $72,700 SN 092 A 20.1115019 $13,500 #2290 OWN. 2.29 $100 510-Oct11 1900 3-11 sean sam Value of Information + COCOS 27 23 4 6 2 92 73 DOUS COUPS 2 a 8 76 440 1070 1970 1000 w 244 443 1027 450 45 90 202 1001 4631071 454 1072 COOTERS 21 A2 2 2 7 7 S T - 21 23 DHE BUS PS 7 DOGAS DELIS 160116 267119 46 24 81 460 23 2. 46 10 202 117 437 28 107 484 1027 465 1085 21 5 ? FX. 3. 4 a 92 73 AYK 15 B 70% AutoSave OFF GFF ADES AYK15_Data_Version 1 (1) Q Home Insert Draw Page Layout Formulas e Share Comments X Arial OL ~ APA Data Review View Tell me al General $ % ) Conditional Formatting V Format as Tablev Insert v & Delete ' ANO - 3 At Paste BI Uv > Sensitivity = Cell Styles Format Sort & Filter Find & Select Analyze Data A Yes No Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? 1 x fx A1 A 1 1 1 w N 0 d U T Y 7 AR AC AE . 21 A2 hel 480 4 470 1024 D 29 UL EL 7 472 473 5 4 Ta 475 279 SC SP TA Ta 3 34 1032 1040 93 72 1011 100 2A 282 2 Ta 27 3 3 4 405 2A Ta 21 TA Ta ? 7 480 4 71 13 29 BOUW SOL EVS Ta 3 21 2012 403 4344 485 A C D E H $13,500 52 253 . Set $100 20v 2.22 1900 :0.900 29. J 01250 $70,000 sra. 2010-11 UGO1,11 500 2 $144,150 5101000 1100 3 $84,900 591 ms 1170 SHBO wa 100 2 2.0 20130001140 $82.800 2010-11 UGO191 1900 $72,900 . 1300 SILO ! 907 19 23 Searn 579.900 $749 SA 11 16.11 3500 40 398.000 88000209 6600156012 $89.000 25.11 USHR11 550 20 25 $27,00 692 58700910 AU G-1 577.00 $74 AS 30-10-11 11 426 175 5109002 2601 $70,000 Sr.80 B- 01-11 450 1.75 $70,000 STA 9.10.116-D-11 HD 2.23 $8140 5400 9-11 1700 578.900 $77.70 SAINT 11 10 1 *2850 $70.003 20 010 2 $10.000 01-11 11. ep.1984 5:5000 12300 1900 575,000 $18.900 14-11-10 175 $75.00 $74.63 16 000114480 $54.000 15-01-11 9220 5:2,300 Sad nga 25 $3,500 330 ng 1790 $17.00 SAS 1 170 17.11 $32.00 1900 12800 $50 20401-11 1350 $10,000 5100 DO 990 2.25 235 $78,00 STA 10 20-Oct111550 1 $10.900 PA 11 2010 371.40 $9.802 20 Map. 1 2100011 $89.00 25 2010-11 21-01-11 CU $85,000 200 20.11 21-Oct-11 1700 $7,00 SA 21-01-11 11025 $47.900 SAS 21-01-2002 902.603 21.09.1200 Srau 2010-11 21-03111450 SIDO 01.11 22-ver-11 2.25 577,900 STS: 4100 St.md $41.000 SA 34 2014 2015 $97.900 960209 2355576 1 $5,000 5102.900 2010-11 28-01-11 1 1200 2 SAD,000 367 20-11 24-Oct-11 1300 571,500 9.213 30-10-11-01-11 130 $26.400 SAAT SAIN-1 4370 371.560 $ 2.60 29.11 24 000 1 1920 25 $3,000 2003 2010.11 29402111 275 2.25 SNE, DO $ 12.30. 1. 2018 21.11 1.73 $1,400 1995 2. 572,400 mm 34 36 $48.000 $99.792 2704763 896 ... 2010-11 28-01-11 2.25 Value of Information + 2 6 Ta 91 34 ra 438 4979 301 . 3 71 122 23 10:1 21 Ta 7 B02 503 504 Ta 7 105 23 29 ra 209 PNG MOS DIS T C 7 & ra 612 513 514 Ta T 7 617 ba 518 20 62 94 20 73 ra ra 8 4 2 G Ta 7 7 529 22 4 AYK 15 El u 70% AutoSave OFF GFF ADES AYK15_Data_Version 1 (1) Q Home Insert Draw Page Layout Formulas e Share Comments X Arial 10 vi Data Review View Tell me al General $ % ) Conditional Formatting V Format as Tablev Insert v & Delete ' 3 #10 Paste BI Sensitivity Cell Styles Format Sort & Filter Find & Select Analyze Data Yes No Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? . ? 1 x fx A1 ! 1 N T w Y Y 7 AC AD AF Ta . 5022 as M 75 os BA 189 527 2 93 og 1051 99 4 4 5 42 ra Ta 92 Ta ra 532 4 3 3 22 31 Ta 97 TA Ta ra 537 . 4 29 70 G 118 Ta 2 4 3 Ta Ta 2 ra 4 4 a 129 om TA 47 5 D E @ H $89.730 21-01 875 $15,490 9119 H. 1700 aHl1 2.23 $82,500 591 m. 1 $45.000 SA303 304 4 4560 1 4000 $0.99 21.09 06 1 TABU Sr. 2010-11 POW910 2 S80,000 Synos 2011 2 $94,50 597 093 3-11-1117009.) 577 400 2011 2010 225 2011 OM 1200 26 2010-11 WU11 200 $23,00 Sen 29-10-11 WHO:11 $85 541.200 30-01-11 21. Aug 11 . 1735 1.75 $14,50 $74253 SA 11 30-11 10 1 ST 20.ju SOLO450 2.25 $75,OLU $14.000 04.11 31 40 2.25 1190 $13,50 5010: AJ-11 -1 1500 25 5700 9 ASS PAIN1 81 110 25 891.400 $90.003 01110111200 1 $800 2010-11 01-04-11 420 $70,000 STa 900 2011 01.11 1900 SH 5219 $ $94. SEO SAM 34 03 N4 1750 2.2 89,90 $9770 04.11 02 No.1 900 2.25 $75,000 $12.000 2010-11 02-11 1950 $12,000 sa nas 29-10-11 03-04-11 1700 $70 1.75 $97.500 21.02-1104-11 435025 $83.000 20.11 04 N1150 $8.000 2010-11 04-Na-11950 2.25 $75,000 ST439: 2.25 $11,50 04.1990 STAAN 1900 $? STAAN 4500 $ 20,000 20 JU11 0450 3:2,900 S02 2014.11 09-04-11 SCU 1.75 $72,000 07-11350 2 $161,900 AJ-11 07-07-11 1900 525.700 $740 128 29.11 09 1750 $8.50 2010-11 9.1.1990 $70,000 Srengs 2010-11 1924-11 1900 1 $4,900 11-11 000 $17.9 S250 200 450 $4.900 23-Aug-11 1944:11 15 $70,000 STTHO 13.11 Daru SID000 ST9 M. 570,400 $7703 2011 333 677.500 20... 9.990 $54 2010-11 1250 1 $35,950 $22.490 3--11524-11 1700 1 $83,500 5910 2010-11 20 $17.900 Sama 1 200 221 814,50 $70.000 29.10.11 23 N.1 $3,400 2014-11 29-12.11 1900 1 $92,300 21 $100,00 204 5101 1900 3 4586 $70,000 $77,790 4 3 Ta 21 2 2 3 3 41 91 43 81 17 11 4 140 ra Ta 51 02 Ta Ta ya 97 . 4 4 587 17 23 21 140 3. 12 1 7 21 c 3 | '* br2 ST3 ST4 ra ra Ta 13 Ta Ta ra brr sta 4 8 3 4 3 121 13 21 47 AYK 15 Value of Information + If 70% AutoSave OFF GFF ADES AYK15_Data_Version 1 (1) Q Home Insert Draw Page Layout Formulas e Share Comments X Data Review View Tell me al General Arial OL vi Conditional Formatting V Format as Tablev Insert v & Delete ' 3 #10 Paste BI > 6 % * $ Sensitivity Cell Styles Format Sort & Filter Find & Select Analyze Data A Yes No Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? . ? 1 x fx A1 = 1 1 1 M N 0 0 T w Y Y 7 AC UV AF Ta . 5022 as M 75 os BA 189 527 2 93 og 1051 99 4 4 5 42 ra Ta 92 Ta ra 532 4 3 3 22 096 ces 185 10 31 Ta 97 TA Ta ra ? 537 . 4 HS BL UR GAS DOULUS 70 G 118 Ta F. 2 4 3 Ta WS 973 FC 4 22 Ta 9 ra 7 a 129 om TA 47 5 7 D E @ H $89.730 21-01 875 $15,490 9119 H. 1700 aHl1 2.23 $82,500 591 m. 1 $45.000 SA303 304 4 4560 1 4000 $0.99 21.09 06 1 TABU Sr. 2010-11 POW910 2 S80,000 Synos 2011 2 $94,50 597 093 3-11-1117009.) 577 400 2011 2010 225 2011 OM 1200 26 2010-11 WU11 200 Sen 29-10-11 WHO:11 541.200 30-01-11 21. Aug 11 . 1735 1.75 $14,50 $74253 SA 11 30-11 10 1 ST 20.ju SOLO450 2.25 $75,OLU $14.000 04.11 31 40 2.25 1190 $13,50 AJ-11 -1 1500 25 5700 9 ASS PAIN1 81 110 25 891.400 $90.003 01110111200 1 $800 2010-11 01-04-11 420 $70,000 STa 900 2011 01.11 1900 5219 900 $94,510 SA? 2.2 1250 89,90 02.11 $9770 04.11 02 No.1 900 2.25 $75,000 $12.000 2010-11 02-11 1950 $12,000 sa nas 29-10-11 03-04-11 1700 $70 1.75 $97.500 21.02-1104-11 435025 $83.000 20.11 04 N1150 $8.000 2010-11 04-Na-11950 2.25 $75,000 ST439: 2.25 $11,50 04.1990 STAAN 1900 $? STAAN 4500 $ 20,000 20 JU11 0450 3:2,900 S02 2014.11 09-04-11 SCU 1.75 $72,000 07-11350 2 $161,900 AJ-11 07-07-11 1900 525.700 $740 128 29.11 09 1750 2010-11 550 $70,000 2010-11 1924-11 1900 1 $4,900 11-11 000 $17.9 S250 200 450 $4.900 23-Aug-11 1944:11 15 $70,000 2010-11 13.11 SID000 ST9 M. . 570,400 $7703 2011 - 677.500 20... Ne 90 $54 2010-11 1974-11 2250 1 $99,90 $22.490 20.11 24.11 1700 1 $82,500 5910 2010-11 $17.900 S5093 1 221 814,50 $70.00 29.11 29.01 1960 2.25 $3,250 2010-11 1 $92,300 21 20140320 23.11 1790 500,000 5101 572,400 $77,791 21.11 2.4.11 Value of Information + 3 3 41 91 Ta 21 2 93 2 3 Et LP 2. PC EP ra Ta 51 008 140 26 DOCESS DOUES Ta . 4 Ta ya 97 7 587 17 23 21 140 3. 12 1 7 T 21 7 & | 67 br2 ST3 ST4 Ta ra Ta SC 7 73 ra ra 43 DO PAG brr sta 3 4 LEGE 121 21 ANNE . tes AYK 15 El 70% AutoSave OFF GFF ADES AYK15_Data_Version 1 (1) Q Home Insert Draw Page Layout Formulas Data Review View Tell me e Share Comments X al Arial 10 vi General Conditional Formatting V Format as Table v Insert v & Delete "480 A10 3 Paste BI Uv $ % ) Sensitivity Cell Styles Format Sort & Filter Find & Select Analyze Data Yes No T v w Y Y 7 AC ME Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? . ? A1 A x fx A F H ! 1 w N N 21 Ta 578.900 $77193 AM 4711 515025 140 $96.750 $4.00 525 565939 ra $70,000 13-04-11 1980 1 4 512 590,000 12. Aug.1996 2.25 TO 11 71 5100 == T 523.500 $70993 BAJN51 520 3 2.4504989 2009 250 4 bra 31 ra $25,00 2010-11 9.11 200 1 3 574 13 $12,500 9449.1 075 STS 65 $17,099 70 33 Ta 574,500 $719 30-10-11 29-11 110 2 b749 YA 3460 20.ju 23 N900 1 bra $22,900 09 26.11 1790 579 121 21 $100,000 5100 Dag 24.11 1900 2.25 3 134 97 578,10 ST779 21. Aug 11 1935 2 147 47 $ SAYAN 29. 20 20 21:11 1 4 1892 348.00 S 20.02.11 $85.000 29.11.200 2.25 583 181 27 $14.89 29-Aug-11 994411480 . SH 141 97 $7,00 Song 23-Aug-11 39.40115 140 97 5* O 59203 23.11.11 1735 1i 47 $ $93.500 21.12.110700 2 25 3 07 $900,000 $97.63 23.09.102001950 2.25 580 181 21 $94.39 2- Aug-11 02-02-11 200 Ta $25,900 $2.500 4 2.29 21-11 00:11 1700 130 97 SI ST4 21.11.11 4135 1.75 21 TA Seo $16.900 2 510400 2900 4 1299 22 $768) 2009 2009 4/5 3 $5,000 $84.90 : UW09-11 11-11 1 CU 3 5814 IZT 97 5:1,200 ST9 23-49-11 13-04-1400 4 1 SAS 142 97 SI 29-11-08-11 190025 TAS 12 47 $93.500 SA2093 27.29-11-09-11750 1 128 7 $77.00 23 1 -450 2 2 3 500 21 $70,000 $3290 23 A11 21-04-11 1950 3 32 $40,000 2 2010-11 21-05-11 1300 4 2 143 97 san 591170 21.11.11 30 2 2 144 97 $8676 SAN 31.10.200 125 3 502 1055 47 S7 823 AM 14.010220 2 2 BUS 145 23-Aug-11 11-02 1200 4 51 BUS MO 612 813 614 615 60 617 619 Os 5002 5023 AYK 15 Value of Information + BP + 70% AutoSave OFF GFF ADES AYK15_Data_Version 1 (1) Q Home Insert Draw Page Layout Formulas e Share Comments X LIA Arial 10 v AP Data Review View Tell me al General $ % ) Conditional Formatting V Format as Table v 1 Cell Styles Insert v & Delete A10 3 - Paste BI IV Sensitivity Format Sort & Filter Find & Select Analyze Data Yes No Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? A xv for A1 1 N T w Y Y AF AC AE PROJECT 23 60 23 21 6 47 97 20 21 2 23 23 21 64 97 23 22 A - 3 LOTE 84 5 72 6 119 7 11A 187 9 10 4 11 107 12 164 18178 14 0 1574 17 142 13 65 15 19 100 20 79 31 70 22 1 119 2 24 23 1010 3 10 39 27 111 25 20 11 169 13 101 108 34 33 ol 13 71 26 42 20 40 10CE 11 13 116 43 44 45 10 121 17 111 45 110 4. 7 29 51 52 1200 34 54 1 35 174 SE 10 53 167 56 112 30 105 es 100 61 21 6 F H A.SK PRICE SELL PRICE LIST DATE SALE DATE 80FL #BATH BDRMS $70,000 Sr0.000 U-11 1 1900 SB, CD SH 000 3 S. $43,500 25 20 11 5923 1 3 506 500 $74.00 0. 02 F11 . $25,000 UF11 14:11 900 1 4579 04-11 -1 1750 25 $32,900 9500 0-11 Wel 1700 3 $0,30 5615 1 AF-1 1900 1 2 $94.000 SA2000 OSFA1-14 1971-19 1200 3 30.000 $899 05 F. 112: 1750 4 2 $:1,200 $80.000 01-11 4 25+4-119950 2.25 $82,900 28 ON 4 or 230 SIS SA 1900 Se 900 SA 044 60 2 3.560 020241350 1 $70,000.00 U-11 US-W-11 25 $81,900 -11 850 4 $81.9 591 m nga 191700 2 $96.900 SA003 011 09 F-11 900 01.11 09.08.11 2 4 $70,000 $10.000 04.11 10WU1200 3 $17, swings 1790 25 4 SH 250 17-01 4135 $70.000 $713 191 2 10 235 Sa 05 F0.11 19 11 4 $12.200 $14.50 U11 1972-111490 2.25 3 Srana 1900 1 3 5491980 5101 21 1900 3.500 4 2.0 9.603 01.11 29 11 1900 2 4 $190,000 S2830 20-1950 $82,900 28.00 Ww1 1700 2.25 SUB, 19 INN 1900 1.78 5 SA 900 221 2 572,500 $90.000 04.11 01 096 U11 011330220 3 SE2 D2 09-11 pr1 1900 25 3 573,500 STI 2011 April 1935 3.35 $1,700 NA 1200 Star 09 DET AFS450 2.25 8 $84292 U11 Ura-1 9900 3 572,200 ST 1,100 DP-11-20 4 $14,500 01-11 OTA 1 1900 3 578.900373 ) 350 8 $21.550 0.00 0041 WA 1700 3 5104.000 U11 10.A-119900 25 $34,000 1775 3 10-11 2.23 $82,10 591 m. OW 10-AP1 3 a $17.400 10-11 4 981.560 2009 09.11 10 5750 $70,000 Sru. U-11 11-11 DU 1.75 $11,000 no: 0-1 11 April 1730 25 3 $14,500 STT AS 05-11 12-Apr-113490 $97.500 SA ASFA-11 12 Apr 20 SA.260 $67.693 01.11 18 1310 2.25 4 $ srrrna 11 4 1 142-111450 500,000 141310 3 4 SIDODO simu 15 Apr1 2.35 a Value of Information + 61 21 23 21 64 HE 23 6 23 21 - 1 97 47 27 21 AYK 15 El + 70% AutoSave OFF GFF ADES AYK15_Data_Version 1 (1) Q Home Insert Draw Page Layout Formulas e Share Comments X Arial 10 vi Data Review View Tell me al General : $ % ) Conditional Formatting V Format as Tablev Insert v & Delete - 3 Paste BI Uv A Sensitivity Cell Styles Format Sort & Filter Find & Select Analyze Data Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No A1 1 J N F R 3 T LA U x AR AD AE 11 1059 84 10! 115 4 4 4 . PT 4 4793 * 110 D 70 130 71 114 73 7 64 14 75 49 73 494 149 70 4 11 16 114 12 34 9 23 DY 31 11 28 51 DY 32 ET 61 B1 3 1 4 4 3 1 3 4 4 2 3 4 23 61 61 31 BI PT 11 61 B1 43 25 15 11 9 1 F F R $79993 57 00 61-yrtt 11. Art 1003 2 02 Mar 11 1511 1602 2 $8.900 39. 15-111 110 225 ST. SES, DOO DI-JN-It 17- AN! 1293 1 SAS 993 SR2 SM 17.AM 1790 $7409 SET 2011 Jan 11 12Art 1253 78 $74.00 SEO.OO 11 Jan 118 1275 225 SE, DI-1 15-63199 229 SEKI ! 10-11 the 1703 2 ST9 9135.10 1-Fnh-11 1999 $A7A0001 Feb 111 109 471,200 01 Jan 11 16112 S87.000 964, SUU 01--vb-1 10-4111 1230 2 2 579,00 W! 2 17: AINI 153 . 1 Sms SIA ETA 1975 2010.01.0112161 1788 $12.500 UEU 1-1 21.11 103 SOT E 05-11 21A 223 Sms SE2BB1-Jan-1 J.M1109 $79993 5260 01 Jan 11 23 A11 20 01 Feb 11 2011102 $2.999 SEU, BU 24-43M11790 2 SED, DI!! 24-AMI! 1790 shi na AN SIM 74-ASMA 1553 2 SASEADO 4 Jan 11 21 16932 14.00 SESEO 01F661125 1833 $32.900 968,250 D1---112M 123 2.a ST2 200 575,00 Iwb-1 2AM 1593 225 SATSER MMM-AM 1573 SA 52.00 37 17193 175 471,000 O Mart 2511100 11 $2.000 965, DUU 20-4111 1203 2 STA 3200 579,00 DI-J-11 1500 571 SEAT ! 2011! 19 0-11 1 1 sro $110.000 . 225 $87.00 856.00 06 fub 1102 11 102 $10.00 369.00 11-11 US-11 1900 Sexo: 5E4,900 1593 SB2.000 - A4 17:50 Sen 20 cm 1903 2 0.00 0.00 11104 1632 $9.00 904,350 10W-11 1799 ST 3203 574,5 250w1 1400 229 574.000 5700M 35-45M105W 1203 1 SA SEA 70 25 Art www11 1999 299 956,200 01 Mar 1105 11 109 225 -11 US- 09--11 1900 SED DOO 25.4 Sw 1500 1 5229 5H11 D1-11 AS- 1990 3. $7:03 59 1993 3 95.000 1.500 250W 11 1909 $99.500 904, DI-F-11011 1992 1 500 SE2, DO win 514.30 12-UAN 05-11 1573 $70.000 SEAS 11 OM 11 1225 225 $83.60 $51.500 01 Mart 07 Nov 11 1692 2.6 $ 90,00 DIF-11 UrW-11 170 3 S2 303 S SEE, DOO DI'mb-11 07- Ww;-11 . 229 Value of Information + 3 3 4 3 4 1 2 $ 4 4 3 11 H2 93 100 98 1007 24 10! 35 SE 190 93 -21 9 20 2000 10 C2 101 10 102 103 10338 104 233 103 10 100 101 107 1070 1001111 102 10624 11 103 4 4 3 23 12 23 4 4 1 41 T 17 GY 12 47 32 4 2 4 47 11228 113 1009 114 44 113 112 116 11 117 1001 11111 92 9 4 4 3 4 51 120 41 AYK 15 BP 70% AutoSave OFF GFF ADES AYK15_Data_Version 1 (1) Q Home Insert Draw Page Layout Formulas e Share Comments X Arial 10 vi Data Review View Tell me al General $ % ) Conditional Formatting V Format as Tablev Insert v & Delete #10 3 - Paste BI Uv Sensitivity Cell Styles Format Sort & Filter Find & Select Analyze Data Yes No Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? + x fx A1 ! 1 N R w Y 2 AB AC AD AE 3 23 21 97 A2 97 4 3 3 4 92 47 27 4 4 21 6 47 8 . 3 W 23 97 64 07 4 21 8 6 22 . 2 10147 147 12 39 14 17 121 122 124 183 180 1:20 151 127145 1211910 199 11 190 1001 159181 13211 123 404 404 185 16 1901 157 4: 13 121151 129 130 10018 141118 1 14212 14 1700 143 181 140 1094 ja 1931 14 1013 129 1047 10018 151 44 1922 151 16405 163 10 150 102 157 1611934 1991 11A 180 114 189 1021 12 197 1994 1012 185 160 120 1671 165 10 1991 173 al 163 11 1998 172 10.7 11911 170 186 175 167 1 100 ITT 170 11 47 92 93 47 97 E 346.900 0 F11 7100 2.25 $ $0.00 U11 1 - 1 550 1.75 $1,000 2 04. $82,790 ON 2 554,500 0 0 892.50 S9 59 de 260 1.25 $24.95 $89.90 UT-110-May-1950 $102,300 5109500 H- 100- V1 1900 25 SIB, 800 57001 OP-U11 1300 2 $93.500 SA 298 $4.003 26 A11 May 1950 $70,000 Usu..11 10-Wur111350 $94,000 ]] 11-11 2.23 $78,00 STAAN 12-11 1900 5-90 SAA 13 12-U11 420 26.960 $99.00 05 F1s We9900 $21,000 $8009 01.11 13-Wee19 2.25 $7,00 2,790 11 See 13-15 SUR780 1.250 05FA-11 14-11 1550 $18.900 999 999 0-11 110 3 05 F11 14 | 25 $14.89 U11 | 14-41 42U $84,900 swings 15-May-11 1700 2.23 $19,900 17: 15-16 SA 73 20 OSNr.1 15 v 11 125 $1.500 883252 05 F11 15 1 350 2.25 . $5,000 $842 15-ap100 $3,300 S12500 12 211 1E-11 1900 2 $14,900 501 10-11 1900 $94.500 100 26 1 Apr11 410 25 $ 0.00 $100.000 05 F 11 16 W 1950 397,200 $9.500 U-11 1990 547,00 17-11 1200 2 2.pl Siro ST7AN: 17.11 1900 2.35 STE 50 Stama 2017 10 25 011 09 15 W 1280 $95,50 $8.50 09-11 18-Map 11 1950 $54,900 STO Osa. 10-11 1990 1 $11,000 02-11-11156 571,500 $ ON 25 100 $5.500 84003 092195510 1 $20,000 S. www-11 20-May11 2250 $75,300 99,753 : 04-11 21-ver-11 275 25 $13,000 5101 21 31--11 1900 $78.900 Stam) 02.11 31-Wyp 1145003 $104.500 5104002 0 11 22 1902 U11 22-Way-11 1700 $7D STS DOS 1 $0.900 0922- WHEO ASFA-11 33-11 588960 SAR 0% 3102 $94.500 $82.603 099 215002.25 $71,700 $0.00 09-11 23-Map.11 1900 Sale $71,700 Stanos Apr 1124.p.11330 579,00 11 31-11100 578.900 $77 090-120 1 Spa 820 N24 ap. 1226 2.25 $290 09:11 24-May-11 1750 $25,00 S403 11 24-11 1920 573, 57 ST 011 25-11 1300 2.75 Value of Information + 4 4 2 97 47 27 8 97 97 A2 64 5 3 2 2 T x Y AR AE 36 361 1093 27 862 101 553 1023 354 115 97 120 97 3000 1001 86/1990 1972-1 4 4 3 4 T x Y AR AE 36 361 1093 27 862 101 553 1023 354 115 97 120 97 3000 1001 86/1990 1972-1 4 4 3 4 Sensitivity A 6 % * $ = Format Sort & Filter Find & Select Analyze Data A Yes No Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? xv fx A1 1 1 1 N T x Y Y NE AC AD AE A 4. 4 2 DOCHS BOULOS COU S . A w 4021014 410 1959 41010337 212 419 1920 414 415 412100 410 21 217 79 23 4131 * 4 419 2011 42 1913 93 92 292 1050 A2 4291014 47 424 40 425 4234.. 21 27 1024011 1047 A2 1045 3 4 a G 3 3 2 7 4 a & 26 430 102 23 92 2221 2 21 23 7 SU 21 21 23 23 4 435 114 24 427 126 480 34 1045 102D 4 1014 2.22 103 223 1015 E 11,90 $24.LU 20-May-11 : 1 29-Aug-11 1200 1 S25,000 900 $94,500 1700 225 $43.560 27.115500 $21,900 27-Aug-11 9950 $71,150 413 20-ep-11 27-Aug-11 1350 $1,50 Sasas . 27-421 25 571,200 STA 274 10 1 384.50 31999.11.30 $5,700 sara 02-54-11 CU 2.25 $72,290 Singga 02.11 1300 2.25 577. BOSTA 3D-WRp.11 01-5-11 4100 $76.000 $740 20 y 11:00 171 $57.603 25 A01100110 3. V 2010-11 03-540-11 1900 5:7,00 SH 300 Ol SIB 09-849-1900 300 3 $93.560 SA255 20 ANS 20 171 *S72 25 05 800.91 500 2.25 $75,000 $64.88 09-11 09-30-1400 ST7.00 20-105-50-1100 soban SA70108-11025 $10.00 S69499 OS-11 0111100 3 8:2000 $0.00 011 0711500 1.75 Sra. 09-11 07-Way-11 1900 SAD, 200 Se ay-va1 1300 574 572410 1250 2.23 $9.900 Quar 18.750 2009 01.11 09.08.1960 $70,000 fra 80 2A11 02-511 400 500,000 ros 03-04-11 230 1.73 $7,00 900 1 517 400 SAT679 op My11 900 21 $72.500 $70.000 26.1980.1900 3.250 S. US1.11 9.6.1900 1 $71,300 20-11 11.3.11 1300 574,500 JD-11 1300 577.900 2011 10 8440 29.12.1990 29.01 $191,000 $100.000 21-4-1 200 $25,500 AI 1700 2 . 900 www. $93.500 2.39 20 y 11 $27.900 2059 2009 200 2.25 $82.3 2I--1 19-04-11 1200 S80,000 56700 0.11 1940-11 1300 SIBE 0-1 25-GA-11 1950 $97.40 3 $9.0 S 29.4.11 21801010 25 tar.250 01-11 1300 25 $3,400 09.11 21-10-11 1900 21-10-11 1900 25 579,900 : 21-01 560 1 $43.560 SA 4 4 550 25 $26.900 583.78 150 2.25 $72,700 SN 092 A 20.1115019 $13,500 #2290 OWN. 2.29 $100 510-Oct11 1900 3-11 sean sam Value of Information + COCOS 27 23 4 6 2 92 73 DOUS COUPS 2 a 8 76 440 1070 1970 1000 w 244 443 1027 450 45 90 202 1001 4631071 454 1072 COOTERS 21 A2 2 2 7 7 S T - 21 23 DHE BUS PS 7 DOGAS DELIS 160116 267119 46 24 81 460 23 2. 46 10 202 117 437 28 107 484 1027 465 1085 21 5 ? FX. 3. 4 a 92 73 AYK 15 B 70% AutoSave OFF GFF ADES AYK15_Data_Version 1 (1) Q Home Insert Draw Page Layout Formulas e Share Comments X Arial OL ~ APA Data Review View Tell me al General $ % ) Conditional Formatting V Format as Tablev Insert v & Delete ' ANO - 3 At Paste BI Uv > Sensitivity = Cell Styles Format Sort & Filter Find & Select Analyze Data A Yes No Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? 1 x fx A1 A 1 1 1 w N 0 d U T Y 7 AR AC AE . 21 A2 hel 480 4 470 1024 D 29 UL EL 7 472 473 5 4 Ta 475 279 SC SP TA Ta 3 34 1032 1040 93 72 1011 100 2A 282 2 Ta 27 3 3 4 405 2A Ta 21 TA Ta ? 7 480 4 71 13 29 BOUW SOL EVS Ta 3 21 2012 403 4344 485 A C D E H $13,500 52 253 . Set $100 20v 2.22 1900 :0.900 29. J 01250 $70,000 sra. 2010-11 UGO1,11 500 2 $144,150 5101000 1100 3 $84,900 591 ms 1170 SHBO wa 100 2 2.0 20130001140 $82.800 2010-11 UGO191 1900 $72,900 . 1300 SILO ! 907 19 23 Searn 579.900 $749 SA 11 16.11 3500 40 398.000 88000209 6600156012 $89.000 25.11 USHR11 550 20 25 $27,00 692 58700910 AU G-1 577.00 $74 AS 30-10-11 11 426 175 5109002 2601 $70,000 Sr.80 B- 01-11 450 1.75 $70,000 STA 9.10.116-D-11 HD 2.23 $8140 5400 9-11 1700 578.900 $77.70 SAINT 11 10 1 *2850 $70.003 20 010 2 $10.000 01-11 11. ep.1984 5:5000 12300 1900 575,000 $18.900 14-11-10 175 $75.00 $74.63 16 000114480 $54.000 15-01-11 9220 5:2,300 Sad nga 25 $3,500 330 ng 1790 $17.00 SAS 1 170 17.11 $32.00 1900 12800 $50 20401-11 1350 $10,000 5100 DO 990 2.25 235 $78,00 STA 10 20-Oct111550 1 $10.900 PA 11 2010 371.40 $9.802 20 Map. 1 2100011 $89.00 25 2010-11 21-01-11 CU $85,000 200 20.11 21-Oct-11 1700 $7,00 SA 21-01-11 11025 $47.900 SAS 21-01-2002 902.603 21.09.1200 Srau 2010-11 21-03111450 SIDO 01.11 22-ver-11 2.25 577,900 STS: 4100 St.md $41.000 SA 34 2014 2015 $97.900 960209 2355576 1 $5,000 5102.900 2010-11 28-01-11 1 1200 2 SAD,000 367 20-11 24-Oct-11 1300 571,500 9.213 30-10-11-01-11 130 $26.400 SAAT SAIN-1 4370 371.560 $ 2.60 29.11 24 000 1 1920 25 $3,000 2003 2010.11 29402111 275 2.25 SNE, DO $ 12.30. 1. 2018 21.11 1.73 $1,400 1995 2. 572,400 mm 34 36 $48.000 $99.792 2704763 896 ... 2010-11 28-01-11 2.25 Value of Information + 2 6 Ta 91 34 ra 438 4979 301 . 3 71 122 23 10:1 21 Ta 7 B02 503 504 Ta 7 105 23 29 ra 209 PNG MOS DIS T C 7 & ra 612 513 514 Ta T 7 617 ba 518 20 62 94 20 73 ra ra 8 4 2 G Ta 7 7 529 22 4 AYK 15 El u 70% AutoSave OFF GFF ADES AYK15_Data_Version 1 (1) Q Home Insert Draw Page Layout Formulas e Share Comments X Arial 10 vi Data Review View Tell me al General $ % ) Conditional Formatting V Format as Tablev Insert v & Delete ' 3 #10 Paste BI Sensitivity Cell Styles Format Sort & Filter Find & Select Analyze Data Yes No Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? . ? 1 x fx A1 ! 1 N T w Y Y 7 AC AD AF Ta . 5022 as M 75 os BA 189 527 2 93 og 1051 99 4 4 5 42 ra Ta 92 Ta ra 532 4 3 3 22 31 Ta 97 TA Ta ra 537 . 4 29 70 G 118 Ta 2 4 3 Ta Ta 2 ra 4 4 a 129 om TA 47 5 D E @ H $89.730 21-01 875 $15,490 9119 H. 1700 aHl1 2.23 $82,500 591 m. 1 $45.000 SA303 304 4 4560 1 4000 $0.99 21.09 06 1 TABU Sr. 2010-11 POW910 2 S80,000 Synos 2011 2 $94,50 597 093 3-11-1117009.) 577 400 2011 2010 225 2011 OM 1200 26 2010-11 WU11 200 $23,00 Sen 29-10-11 WHO:11 $85 541.200 30-01-11 21. Aug 11 . 1735 1.75 $14,50 $74253 SA 11 30-11 10 1 ST 20.ju SOLO450 2.25 $75,OLU $14.000 04.11 31 40 2.25 1190 $13,50 5010: AJ-11 -1 1500 25 5700 9 ASS PAIN1 81 110 25 891.400 $90.003 01110111200 1 $800 2010-11 01-04-11 420 $70,000 STa 900 2011 01.11 1900 SH 5219 $ $94. SEO SAM 34 03 N4 1750 2.2 89,90 $9770 04.11 02 No.1 900 2.25 $75,000 $12.000 2010-11 02-11 1950 $12,000 sa nas 29-10-11 03-04-11 1700 $70 1.75 $97.500 21.02-1104-11 435025 $83.000 20.11 04 N1150 $8.000 2010-11 04-Na-11950 2.25 $75,000 ST439: 2.25 $11,50 04.1990 STAAN 1900 $? STAAN 4500 $ 20,000 20 JU11 0450 3:2,900 S02 2014.11 09-04-11 SCU 1.75 $72,000 07-11350 2 $161,900 AJ-11 07-07-11 1900 525.700 $740 128 29.11 09 1750 $8.50 2010-11 9.1.1990 $70,000 Srengs 2010-11 1924-11 1900 1 $4,900 11-11 000 $17.9 S250 200 450 $4.900 23-Aug-11 1944:11 15 $70,000 STTHO 13.11 Daru SID000 ST9 M. 570,400 $7703 2011 333 677.500 20... 9.990 $54 2010-11 1250 1 $35,950 $22.490 3--11524-11 1700 1 $83,500 5910 2010-11 20 $17.900 Sama 1 200 221 814,50 $70.000 29.10.11 23 N.1 $3,400 2014-11 29-12.11 1900 1 $92,300 21 $100,00 204 5101 1900 3 4586 $70,000 $77,790 4 3 Ta 21 2 2 3 3 41 91 43 81 17 11 4 140 ra Ta 51 02 Ta Ta ya 97 . 4 4 587 17 23 21 140 3. 12 1 7 21 c 3 | '* br2 ST3 ST4 ra ra Ta 13 Ta Ta ra brr sta 4 8 3 4 3 121 13 21 47 AYK 15 Value of Information + If 70% AutoSave OFF GFF ADES AYK15_Data_Version 1 (1) Q Home Insert Draw Page Layout Formulas e Share Comments X Data Review View Tell me al General Arial OL vi Conditional Formatting V Format as Tablev Insert v & Delete ' 3 #10 Paste BI > 6 % * $ Sensitivity Cell Styles Format Sort & Filter Find & Select Analyze Data A Yes No Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? . ? 1 x fx A1 = 1 1 1 M N 0 0 T w Y Y 7 AC UV AF Ta . 5022 as M 75 os BA 189 527 2 93 og 1051 99 4 4 5 42 ra Ta 92 Ta ra 532 4 3 3 22 096 ces 185 10 31 Ta 97 TA Ta ra ? 537 . 4 HS BL UR GAS DOULUS 70 G 118 Ta F. 2 4 3 Ta WS 973 FC 4 22 Ta 9 ra 7 a 129 om TA 47 5 7 D E @ H $89.730 21-01 875 $15,490 9119 H. 1700 aHl1 2.23 $82,500 591 m. 1 $45.000 SA303 304 4 4560 1 4000 $0.99 21.09 06 1 TABU Sr. 2010-11 POW910 2 S80,000 Synos 2011 2 $94,50 597 093 3-11-1117009.) 577 400 2011 2010 225 2011 OM 1200 26 2010-11 WU11 200 Sen 29-10-11 WHO:11 541.200 30-01-11 21. Aug 11 . 1735 1.75 $14,50 $7

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Illustrating Finance Policy With Mathematica

Authors: Nicholas L. Georgakopoulos

1st Edition

3319953710, 978-3319953717

More Books

Students also viewed these Finance questions

Question

Explain the process of biochemistry

Answered: 1 week ago