Question: 1. Explain whether is would be better to use the relationship derived from the whole sample for prediction or if it would be better to



Home Insert Draw Page Layout X albe (Body) 11 EB- 1.3 f 1FH3>79%, "1", "0") Stock price this year 32 04296498 19.95291460 189307161 16.99249236 23.30015217 20.30451204 15.76543776 35.78701046 16324019 18.29518047 15 94449982 21.51803435 17,18217284 19.47563010 34.30065996 43-38783175 183713046 22 ASSIGNE 12.31979 33 13274782 28.395.75504 254229114 75.49210334 1442813907 Comman 2648141625 AISIN 2781526917 www 2131214004 14.9012054 www. 35.34445473 www 2334335259 wwwwwwww 27.34261463 3800232827 www 24.34952211 PACHETE 15040 38.13000653 14.78545039 1551864074 45.09070592 Shoot! 10 A rm10 nut Stock price 1 2 31 A 1 61 31 14 11 14 17 IN 41. AV 3. LE 16 27 12 ut SE D M 37 4 1 3 10 11 11 11 14 35 16 17 14 19 of 31 31 21 34 W M 21 40 26 37 283 10 29 300 31 32 34 35 36 37 Ready ZE Formulas Data AA www 1-1- D Stock price this year 3304296498 20.95291446 19.9307161 17.99249236 24.30015217 21.10455204 16.76563778 36.73701046 17:22491988 19.29518047 36.94449982 22.51803435 18,18717744 2047583038 19300659940 46.16783375 153733048 2345552418 MAR PACHEESE 33.13274782 DIAMAIN 25.5957504 assboogl 16 49239334 WEEZAYOF 15.47813907 27.48141631 27.48141679 2881526917 12.31214098 32.3331498 1296112054 12:00112014 14 34685873 16346487 2484335255 24431 74 34701461 RUCIAL 1.00222827 LISTETON SE 2514952211 25349211 1004084764 30.11800852 17.78545039 40 5186407 4609070592 High permanent earning ratio www.ww Review *** Stock price this year Stock price this year 3504286698 3404286658 21.59293466 20 9307161 18.99249236 25.30015217 22.30455204 17.76563778 37.73701046 18.22481988 20.39518047 17.34449912 21.51803435 19 18217284 11.47583038 40.30861996 47.18783175 733048 5552618 19791 www 1274782 MAM 3659575504 Add 27.49239334 be 1642813907 364 2848141625 C 2981526917 253150N 23-31214098 213100 18.50312054 17.24685873 w 2584335259 ASKERESZ 29.34261463 BA 40.00232827 26.34952211 2104086768 4013800852 18.78545039 41.51844076 47.00070592 VE BE View Tell me wwwwwwwww Wrap Text 3 Merge & Center 35332743 MAMINIM 11.59375504 28.49239334 www 17.42813907 # 2948141625 w 30.81526917 Sepwww 24.31214090 14.9012054 38-24685873 26.84335259 www 30.34241463 41.00252627 THE 27.34952211 CHAN 22.04006768 4113000052 15.78545039 42.51464076 48.09070592 Low permanent earning ratio 9990626622 21.9307161 1999249236 2630015217 25.10455204 18.76543778 38.73701046 15.22481988 21.29518047 1894449982 24.51803435 20.18217294 2247583038 41.30845996 4818783175 11 INNAN wwww.. SEPORTS SE PRECIENTLE 2347583038 413000594 49.14783175 22.37530448 24645552418 www www 36.33274783 Women 32.59575504 com Stack price this year 3604256698 23.99293664 22.3107161 20.99241234 27.30015217 24.10455204 19.76543779 39.73703046 20.23481984 22.29518047 19.94449982 PEEGEZEPT MEENA 18.43013007 pepened 48141635 po www 31214000 190312054 SOMORN 19.24685873 www 2784335259 3136261463 Moned 42.00232827 powod 28.34952211 23.0466768 42-13000012 20.78545039 41.53864074 4500070592 + CHEMESTE wwwwww General T 6% - $ D H Mock price the year 3704296498 24.99291664 23.9307161 21.99249236 28 30015217 25.10455204 20.76563778 40.73701046 21 2241988 33.29518047 20.94449982 EMONTEER SEPORTS DE 7218217284 2447563038 43.30845996 50.18783175 25.97330468 wwwwwww 17.13274782 www.w 35.59375504 000000 30,49239334 19.43813907 www 31.48141635 3281526917 26.31214094 21.90112054 20.24685873 povoleted 28.84335259 TOMMAX 3214261463 ****** 43.00232827 9 29.34952211 24.040678 43.13800053 21.78545039 44.51854016 10.09070583 ALANLAR 214 pourvoed 38.04286695 25.99293666 $ 24.9307361 $ 22.992492365 29.300152175 2610455204 21.765437765 41.73701046 5 22.2248185 24.295180475 23.9440935 27.518034355 23.382172843 25.47583038 5 44.3084599 $1.16781755 24.97550468 S 2845552418 S 38.132747825 34.595755045 31.492393345 www 30428139075 12.481416255 31813269175 www 27-31214008 22.00132014 3 www 21.34685873 poten 29.843352595 www 33.34261463 5 MODER 44.00252827 5 30.34952211 5 25.04006708 22 44,138008535 22 78565039 1 45.31864076 $ 5100592 5 MASCHE A MASHOEY Conditional Format Formatting as Table T Prejected Return M Call Styles 0.16 Projected FO 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 1.00 0.35 0.26 0.29 021 0.25 0.32 bon 0.34 0.31 Dew 5.00 8.27 5.00 $ 0.31 Pop 5.00 $ 1.001 5.00 $ S 1.00 1 1.001 5.00 $ 1.00 $ 1.00 13 5.00 1 100 1 1.00 1 PAPE 5.00 $ $.00 $ 1.000 Pemass 3.00 3 100 1 5.00 $ 3.00 $ 1.00 $ 5.00 $ 5.00 5.00 1.001 S 1.00 1.00 1 5.00 $ 1.00 1 1.00 H F 770 ren 6.21 0.25 0.26 DON 0.13 SOM WB tro - Delete- Format Price to farming sigh/Low 0914110544 0.8695251 0843205561 08443677 1 053229 0870155457 0.840183331 0.022554684 d 0.343951724 www 0.859123054 1 wwwwwwww 0841642652 Open 077410 PRESETSED NAMPINAS 08535 wwwwwwww 6377376001 www 0337743619 8147066 3847147938 a 0.11 0.24 BU www 0:11 MOSSEL 0.16 3.914609583 6.17 panossa ARUAN 08470674 AM 6:20 AM 0.35 8.827064562 0.0834001 15 ww 0:39 ww 6.34 ww 1 0876482 9.21 ww 0.34527 6.30 33 A11 0.33 ASSAL S 0888240487 0.21 0.14 O SOLLESISE 0.11 0926013423 0.21 0.26 0.13 0.30 013 031 veciente d SOOS TOPCON ASLED POCKED 09270/4739 27-C Sert & Fine Filter CHONCERING 0029442712 09767894 2 33 32 T T 1 L Edin View Insert Format Tools Data Window Help ww Page Layout Formulas Data Review View Tell me 11 EX Wrap Text- Cabr (Body) BIL -A A A- 4 Marge & Centr 02 :x & F2*82/2 C D F 4 H 0.46179 2.31999) 31.59 BON track price Pamant Trasteryal Tapered Total inspected rock Permanent Projected t 199294 LS8204 18.39072 14753 0324834 18 416993491401072 0.363023 17640 1.40 2.50581379 39523066431 1504209285 82% S 79% 5 20.48 18.34 38.77 17.34 28.36 1864 21.36 151 5 1.35 S 3.00 $ 139 1 4.538611792 5 1633040935 23349679755 1894454034 S WIN S 87% 5 BIN S N INS 1.75 S LAS S T 143 f 1.34 S 4.21 3 4109 45.40 2035 34.75 31:11 SINS AINS INS 3575701 3550037 0433571 41 11 11.5445 1313074 8150819 1.501933 122151801303442 443 2.346624 1937:38217 147758 6269124 1.346704 14184754 1753956 0.354551 23034 15 38.30000 1431041 0484247 4317288 2445 34783 41185740298462 4433036 37143713 1.454545 0338522233348 3032.13775 3247004 0.76765401555 21 2859576 2.466462 0.335.79 2801251 23 14.428141096275 0.191468124774 25 2741527 2.364399 02814873454096 27 14.90312 1,108007 0174519 1374529 21 2184335 101185 0.200201 3212001 302734161 1472526 0394756 2347241 32 2434 1 348 2798873 118.000 144ses 6312054179643 331678545 L445432 $28182 LT33432) 174509071 4.322304 0.487 4X100 39 15.66434 1.36097 03492117 403217542105243 054974 342201 1.583 2001 252 1 122 1 15.45 30.29 RINS S 347 S INS 147 1 16.30 26.01 2.37 S 29.70 2.34 S 2015 1.57 41 314) B 0 111 42060859 1732904 0454147 216887 4512397080863885 0223299 14714 4262441 2315000 0.500731 2.830753 53 2536508 2.343588 2541876 2.783863 55: 54.63833 188 178713425 SLTS 636561314518 330.10933.791143 06749 S 11.7762 2063047110451452 42100117334 0220371 19471 373551595 8521217 082879 4350012 68378244 1433845 0.25007 1681753 71 2548525 2.312852 043378 3.34167 Ar Shoat! High permanentang Excel Home insert LOO Fatt N 1 . # at 11 41 3.4 14 AS SE 31 18 19 20 n LE 12 * 24 21 SE AR 24 A H TE 31 ( M 35 WE AF H D WEL -DGA5U ps P 5 COMMERCE 4400920115 48280934255 2.20253100 43410115 KOT S 1.353370674 $ASSESPOR LAS 24132779 3334453809 3.030382704 S 19450973285 1 SWISSENT IMELLISES 18462829235 35283075255 1.2299166835 2:33102135 1471512547 S 101205 300135 S 753645 23204497 S 470213922 S HERUNGE FOT 5 SE 3337940354 S ww 20.61 18:19 49.11 16.91 RCH 14.35 22.24 13.34 28.40 3741 15 30 18:10 323 7931 3180 18:39 19:34 1410 $ Low permanentang ratio 28 SNI MONS INS KINS RIN 3 BONS BONS BUNS BANS 71% S 79% 5 KIN BINS BTH S TON BINS 8. S INS AINS IN AINS acet3110 project 2 Accounting Project SOFT 4.04 $ 125 1 2.31 5 1.33 5 1455 0.00 2.80 204 $ 127 1 1305 240 3 SHE 6%-5 1855 2.89 1 152 1 2.42 $ ISCRE Pro 0.08 KINY 0.0104914 6054324 0.00542151 1 0.09 10.411 1 600 147 0.00 0.08 9231481 0.003041 0.09 02419 200330576 4.00 400201 4.09 10 20454 0.001154319 4 0.09 10.46436 1 0.00 11.19342 0.09 10.776 DOP $33621 1 0.0 00012180 1 1 2006 1 DR SHI 20 KATHIS 1 000 $300 1 * # 11401s 1 030 008111406 0010 B0941042 com BARZ 600 3700 0.001124191 DO 16464 0.001260004 4 0.00 33001 1 4 HE WAS 28 MacBook Pro T T P 1 E 1 1 1 E 1 t t Condal Format Cel Formatting an Table Styles M D M 45 4 A FRA 11 " 36 A RA D insert D H- o High Permanent Earnings Firm LOS Fi f WAME .O. Find DAPE Thu Apr 28 10:10 PM Comments S W 11 Any Da A 100% Home 1- Paste 022 . 1 393 32 M 13 38 et DE 19 24 23 24 25 24 T IN 31 HE 16 31 11 M 18. 34 45 24 AP X B 18 Bet IN Draw fx D ( 10 me Mock prem Earnings Transitory (Total Ear 112008 2330035217 3.196531792 0901337 4098069 2014141412 1.790314144 0 1.21945 1396175227 10 201005530 T15NSERTM 16.224810 18.29518047 22 22.45552418 32 86389793 25.49239334 26 26.48141425 18 19 ** 24 24 25 25.31214098 28 15.34685879 35 38.00232827 34 38.13800832 36 355586407 38 17.08724144 44 1753541115 452840308254 47 22.30378224 413.52171254 145414750 30 15.4847538 5 25.90952645 53 1953 2665154 2541665 $22.22 0.778744 2549082 249766951954- BAR343 170228 1490091 $ 15.45 175777 0.543075 191975 1799633 5 11.08 1890487685 8.742019 2.433507 2.3141725 1741 1374841629 0417504 2.597346 25725975 23:29 3.313537549 1.222579 4516117 420476330.48 2564011226 0.770617 3334629 3.4628295 26.47 2391121286 0837328 342845 342845 5 26.48 1808340154 0.50645 2.3152 2.2067 5 20.31 3.281706756 0534587 1.796294 1821928 $15.00 3276876877 1046046 4922923 496109238.30 4.098213119 1204087 5382296 5218367 $36.98 41047607161206863 5.311724 5024391 5 37.38 1.5643897920440695 2046885190592951591 1.57753794 0643657 2221195 2.18964437.33 2639951696 0.726209 3.365159 1417938 $28.85 1366478140518927 2505406 24070825 2181 1202966941 0.510246 1.713213 1614976 5 12.7 1048177906 437684 1425014 1.3411463 $13.49 1442278861 0.592008 2.034287 204873 $15.59 2044207976 0670069 2-714277 3571383 1981 185120496 0820175 2.671419 2.59737 $14.99 34 3236434383 1064329635 0633599 1.698129 1629812 5 12.30 541542346744 3.75509731 632504 2548203 240292552949 58189032509 1343829236 DAFLE99 2.015728 1876784 17.40 312887033 0,932118 4060988 4.354855 $ 30.96 1321913076 0509454 2031405 1.940095 $16.76 1.239471444 0.438653 1478134 1614351 5 13.61 4.646666685 1.266321 5314994 5.729047 5.44.09 2.006425518 0645038 2.731864 2.793873 $ 22.65 3.438162954 0719323 3357686 3.255221 5 26.38 2.203126661 0637532 283645 24185445 20.30 1.339377752 0383848 1705625 1.756417 $ 16.42 169572016 0546037 3.343758 2.309587 5 18.61 2516422657 1141087 3457509 1431031 5.2314 40 302615260 17.5471301 4114 12677599 64 45.52014125 22 1462932 6254450 702255082245 74 16.1246526 1918.06595096 NO 3464842991 ************ Sheett High permanentang 19 (Apog) 2 n MEY Page Layout Formulas Data Review 11 -AA MM PAN wap x FDMerge & Center F 4 78% @ 0.051 9.261484 30.471 4364542 0 a 6 0 0 0 B 0 D L * 0 Projected 1 Projected 1 Permanent Projected Projected to a High/Low 42579533.29 1.25 $ 0.04 7810016 77% 51.00 500.05) 8743517 70% (0.541500001 7.82557 72% 3 0.13 $ 72% 5 01.17) 5 ON sas 0.05) 7.521123 76% $10.17) 5 001) 8.647242 73% 5 12.401 $ 10.07) 7.24535 77% $0.98 $ 0.04 7.644747 76% $ 7.724021 78% $(100) $10.05) 9.2012 71N022 1 0.014952 79% 5 0.30 5001 7.719464 76% (141 07.085826 77% 0.14 $0.05) 7.43 77% $0.11078347922 PINS 1025) 5 001 7912590 78% 0.45 $ 0.03 8.44038 0 78% 0.061918 D 70% 1076) $30017892004 D 74% 10041020443 D HINS 0115 0017611863 D 75% 5 11 10 5 10.051 7703533 6% 10.34) 1001 7.312175 63% 1034 po4 7.575852 69% 0.265 60 7563058 77% 5 (13050507) 30 77% $0.30 $0.02 7.451764 75% 10.7915 000 1437934 74% (0.52) 79% 5 (1431 S 76% 50.50 $ 77% $ 0.79 5 78% 51.755 78% 76% 9 0 0 000408418195 BOK 7495721 0 0.028100449 GOKOMOT 7544 0 0.50 $ 0.00 $476027 055 500 $1.5) D 05883 0 13.066744653 Takov & A OVO H View Tell me $ *** Low permanent earning ratio 28 $ werhe + acet3110 project 2 General 6%-$ 0 M M 0 D 0 0 0 D 0 0 a M M A in 25 Sk M 100 1 10 " E 2. MacBook Pro N tv NMA Conditional Format CAR Formatting as Table Styles P R Low Permanent Earnings Firms E 0 4244 LIFE: . the De Format +++ Lig MESSA T T 13- 28-0. Sert & Find & Select GEE ty nu Share 101 LOO Aym E Home Insert Draw Page Layout X albe (Body) 11 EB- 1.3 f 1FH3>79%, "1", "0") Stock price this year 32 04296498 19.95291460 189307161 16.99249236 23.30015217 20.30451204 15.76543776 35.78701046 16324019 18.29518047 15 94449982 21.51803435 17,18217284 19.47563010 34.30065996 43-38783175 183713046 22 ASSIGNE 12.31979 33 13274782 28.395.75504 254229114 75.49210334 1442813907 Comman 2648141625 AISIN 2781526917 www 2131214004 14.9012054 www. 35.34445473 www 2334335259 wwwwwwww 27.34261463 3800232827 www 24.34952211 PACHETE 15040 38.13000653 14.78545039 1551864074 45.09070592 Shoot! 10 A rm10 nut Stock price 1 2 31 A 1 61 31 14 11 14 17 IN 41. AV 3. LE 16 27 12 ut SE D M 37 4 1 3 10 11 11 11 14 35 16 17 14 19 of 31 31 21 34 W M 21 40 26 37 283 10 29 300 31 32 34 35 36 37 Ready ZE Formulas Data AA www 1-1- D Stock price this year 3304296498 20.95291446 19.9307161 17.99249236 24.30015217 21.10455204 16.76563778 36.73701046 17:22491988 19.29518047 36.94449982 22.51803435 18,18717744 2047583038 19300659940 46.16783375 153733048 2345552418 MAR PACHEESE 33.13274782 DIAMAIN 25.5957504 assboogl 16 49239334 WEEZAYOF 15.47813907 27.48141631 27.48141679 2881526917 12.31214098 32.3331498 1296112054 12:00112014 14 34685873 16346487 2484335255 24431 74 34701461 RUCIAL 1.00222827 LISTETON SE 2514952211 25349211 1004084764 30.11800852 17.78545039 40 5186407 4609070592 High permanent earning ratio www.ww Review *** Stock price this year Stock price this year 3504286698 3404286658 21.59293466 20 9307161 18.99249236 25.30015217 22.30455204 17.76563778 37.73701046 18.22481988 20.39518047 17.34449912 21.51803435 19 18217284 11.47583038 40.30861996 47.18783175 733048 5552618 19791 www 1274782 MAM 3659575504 Add 27.49239334 be 1642813907 364 2848141625 C 2981526917 253150N 23-31214098 213100 18.50312054 17.24685873 w 2584335259 ASKERESZ 29.34261463 BA 40.00232827 26.34952211 2104086768 4013800852 18.78545039 41.51844076 47.00070592 VE BE View Tell me wwwwwwwww Wrap Text 3 Merge & Center 35332743 MAMINIM 11.59375504 28.49239334 www 17.42813907 # 2948141625 w 30.81526917 Sepwww 24.31214090 14.9012054 38-24685873 26.84335259 www 30.34241463 41.00252627 THE 27.34952211 CHAN 22.04006768 4113000052 15.78545039 42.51464076 48.09070592 Low permanent earning ratio 9990626622 21.9307161 1999249236 2630015217 25.10455204 18.76543778 38.73701046 15.22481988 21.29518047 1894449982 24.51803435 20.18217294 2247583038 41.30845996 4818783175 11 INNAN wwww.. SEPORTS SE PRECIENTLE 2347583038 413000594 49.14783175 22.37530448 24645552418 www www 36.33274783 Women 32.59575504 com Stack price this year 3604256698 23.99293664 22.3107161 20.99241234 27.30015217 24.10455204 19.76543779 39.73703046 20.23481984 22.29518047 19.94449982 PEEGEZEPT MEENA 18.43013007 pepened 48141635 po www 31214000 190312054 SOMORN 19.24685873 www 2784335259 3136261463 Moned 42.00232827 powod 28.34952211 23.0466768 42-13000012 20.78545039 41.53864074 4500070592 + CHEMESTE wwwwww General T 6% - $ D H Mock price the year 3704296498 24.99291664 23.9307161 21.99249236 28 30015217 25.10455204 20.76563778 40.73701046 21 2241988 33.29518047 20.94449982 EMONTEER SEPORTS DE 7218217284 2447563038 43.30845996 50.18783175 25.97330468 wwwwwww 17.13274782 www.w 35.59375504 000000 30,49239334 19.43813907 www 31.48141635 3281526917 26.31214094 21.90112054 20.24685873 povoleted 28.84335259 TOMMAX 3214261463 ****** 43.00232827 9 29.34952211 24.040678 43.13800053 21.78545039 44.51854016 10.09070583 ALANLAR 214 pourvoed 38.04286695 25.99293666 $ 24.9307361 $ 22.992492365 29.300152175 2610455204 21.765437765 41.73701046 5 22.2248185 24.295180475 23.9440935 27.518034355 23.382172843 25.47583038 5 44.3084599 $1.16781755 24.97550468 S 2845552418 S 38.132747825 34.595755045 31.492393345 www 30428139075 12.481416255 31813269175 www 27-31214008 22.00132014 3 www 21.34685873 poten 29.843352595 www 33.34261463 5 MODER 44.00252827 5 30.34952211 5 25.04006708 22 44,138008535 22 78565039 1 45.31864076 $ 5100592 5 MASCHE A MASHOEY Conditional Format Formatting as Table T Prejected Return M Call Styles 0.16 Projected FO 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 1.00 0.35 0.26 0.29 021 0.25 0.32 bon 0.34 0.31 Dew 5.00 8.27 5.00 $ 0.31 Pop 5.00 $ 1.001 5.00 $ S 1.00 1 1.001 5.00 $ 1.00 $ 1.00 13 5.00 1 100 1 1.00 1 PAPE 5.00 $ $.00 $ 1.000 Pemass 3.00 3 100 1 5.00 $ 3.00 $ 1.00 $ 5.00 $ 5.00 5.00 1.001 S 1.00 1.00 1 5.00 $ 1.00 1 1.00 H F 770 ren 6.21 0.25 0.26 DON 0.13 SOM WB tro - Delete- Format Price to farming sigh/Low 0914110544 0.8695251 0843205561 08443677 1 053229 0870155457 0.840183331 0.022554684 d 0.343951724 www 0.859123054 1 wwwwwwww 0841642652 Open 077410 PRESETSED NAMPINAS 08535 wwwwwwww 6377376001 www 0337743619 8147066 3847147938 a 0.11 0.24 BU www 0:11 MOSSEL 0.16 3.914609583 6.17 panossa ARUAN 08470674 AM 6:20 AM 0.35 8.827064562 0.0834001 15 ww 0:39 ww 6.34 ww 1 0876482 9.21 ww 0.34527 6.30 33 A11 0.33 ASSAL S 0888240487 0.21 0.14 O SOLLESISE 0.11 0926013423 0.21 0.26 0.13 0.30 013 031 veciente d SOOS TOPCON ASLED POCKED 09270/4739 27-C Sert & Fine Filter CHONCERING 0029442712 09767894 2 33 32 T T 1 L Edin View Insert Format Tools Data Window Help ww Page Layout Formulas Data Review View Tell me 11 EX Wrap Text- Cabr (Body) BIL -A A A- 4 Marge & Centr 02 :x & F2*82/2 C D F 4 H 0.46179 2.31999) 31.59 BON track price Pamant Trasteryal Tapered Total inspected rock Permanent Projected t 199294 LS8204 18.39072 14753 0324834 18 416993491401072 0.363023 17640 1.40 2.50581379 39523066431 1504209285 82% S 79% 5 20.48 18.34 38.77 17.34 28.36 1864 21.36 151 5 1.35 S 3.00 $ 139 1 4.538611792 5 1633040935 23349679755 1894454034 S WIN S 87% 5 BIN S N INS 1.75 S LAS S T 143 f 1.34 S 4.21 3 4109 45.40 2035 34.75 31:11 SINS AINS INS 3575701 3550037 0433571 41 11 11.5445 1313074 8150819 1.501933 122151801303442 443 2.346624 1937:38217 147758 6269124 1.346704 14184754 1753956 0.354551 23034 15 38.30000 1431041 0484247 4317288 2445 34783 41185740298462 4433036 37143713 1.454545 0338522233348 3032.13775 3247004 0.76765401555 21 2859576 2.466462 0.335.79 2801251 23 14.428141096275 0.191468124774 25 2741527 2.364399 02814873454096 27 14.90312 1,108007 0174519 1374529 21 2184335 101185 0.200201 3212001 302734161 1472526 0394756 2347241 32 2434 1 348 2798873 118.000 144ses 6312054179643 331678545 L445432 $28182 LT33432) 174509071 4.322304 0.487 4X100 39 15.66434 1.36097 03492117 403217542105243 054974 342201 1.583 2001 252 1 122 1 15.45 30.29 RINS S 347 S INS 147 1 16.30 26.01 2.37 S 29.70 2.34 S 2015 1.57 41 314) B 0 111 42060859 1732904 0454147 216887 4512397080863885 0223299 14714 4262441 2315000 0.500731 2.830753 53 2536508 2.343588 2541876 2.783863 55: 54.63833 188 178713425 SLTS 636561314518 330.10933.791143 06749 S 11.7762 2063047110451452 42100117334 0220371 19471 373551595 8521217 082879 4350012 68378244 1433845 0.25007 1681753 71 2548525 2.312852 043378 3.34167 Ar Shoat! High permanentang Excel Home insert LOO Fatt N 1 . # at 11 41 3.4 14 AS SE 31 18 19 20 n LE 12 * 24 21 SE AR 24 A H TE 31 ( M 35 WE AF H D WEL -DGA5U ps P 5 COMMERCE 4400920115 48280934255 2.20253100 43410115 KOT S 1.353370674 $ASSESPOR LAS 24132779 3334453809 3.030382704 S 19450973285 1 SWISSENT IMELLISES 18462829235 35283075255 1.2299166835 2:33102135 1471512547 S 101205 300135 S 753645 23204497 S 470213922 S HERUNGE FOT 5 SE 3337940354 S ww 20.61 18:19 49.11 16.91 RCH 14.35 22.24 13.34 28.40 3741 15 30 18:10 323 7931 3180 18:39 19:34 1410 $ Low permanentang ratio 28 SNI MONS INS KINS RIN 3 BONS BONS BUNS BANS 71% S 79% 5 KIN BINS BTH S TON BINS 8. S INS AINS IN AINS acet3110 project 2 Accounting Project SOFT 4.04 $ 125 1 2.31 5 1.33 5 1455 0.00 2.80 204 $ 127 1 1305 240 3 SHE 6%-5 1855 2.89 1 152 1 2.42 $ ISCRE Pro 0.08 KINY 0.0104914 6054324 0.00542151 1 0.09 10.411 1 600 147 0.00 0.08 9231481 0.003041 0.09 02419 200330576 4.00 400201 4.09 10 20454 0.001154319 4 0.09 10.46436 1 0.00 11.19342 0.09 10.776 DOP $33621 1 0.0 00012180 1 1 2006 1 DR SHI 20 KATHIS 1 000 $300 1 * # 11401s 1 030 008111406 0010 B0941042 com BARZ 600 3700 0.001124191 DO 16464 0.001260004 4 0.00 33001 1 4 HE WAS 28 MacBook Pro T T P 1 E 1 1 1 E 1 t t Condal Format Cel Formatting an Table Styles M D M 45 4 A FRA 11 " 36 A RA D insert D H- o High Permanent Earnings Firm LOS Fi f WAME .O. Find DAPE Thu Apr 28 10:10 PM Comments S W 11 Any Da A 100% Home 1- Paste 022 . 1 393 32 M 13 38 et DE 19 24 23 24 25 24 T IN 31 HE 16 31 11 M 18. 34 45 24 AP X B 18 Bet IN Draw fx D ( 10 me Mock prem Earnings Transitory (Total Ear 112008 2330035217 3.196531792 0901337 4098069 2014141412 1.790314144 0 1.21945 1396175227 10 201005530 T15NSERTM 16.224810 18.29518047 22 22.45552418 32 86389793 25.49239334 26 26.48141425 18 19 ** 24 24 25 25.31214098 28 15.34685879 35 38.00232827 34 38.13800832 36 355586407 38 17.08724144 44 1753541115 452840308254 47 22.30378224 413.52171254 145414750 30 15.4847538 5 25.90952645 53 1953 2665154 2541665 $22.22 0.778744 2549082 249766951954- BAR343 170228 1490091 $ 15.45 175777 0.543075 191975 1799633 5 11.08 1890487685 8.742019 2.433507 2.3141725 1741 1374841629 0417504 2.597346 25725975 23:29 3.313537549 1.222579 4516117 420476330.48 2564011226 0.770617 3334629 3.4628295 26.47 2391121286 0837328 342845 342845 5 26.48 1808340154 0.50645 2.3152 2.2067 5 20.31 3.281706756 0534587 1.796294 1821928 $15.00 3276876877 1046046 4922923 496109238.30 4.098213119 1204087 5382296 5218367 $36.98 41047607161206863 5.311724 5024391 5 37.38 1.5643897920440695 2046885190592951591 1.57753794 0643657 2221195 2.18964437.33 2639951696 0.726209 3.365159 1417938 $28.85 1366478140518927 2505406 24070825 2181 1202966941 0.510246 1.713213 1614976 5 12.7 1048177906 437684 1425014 1.3411463 $13.49 1442278861 0.592008 2.034287 204873 $15.59 2044207976 0670069 2-714277 3571383 1981 185120496 0820175 2.671419 2.59737 $14.99 34 3236434383 1064329635 0633599 1.698129 1629812 5 12.30 541542346744 3.75509731 632504 2548203 240292552949 58189032509 1343829236 DAFLE99 2.015728 1876784 17.40 312887033 0,932118 4060988 4.354855 $ 30.96 1321913076 0509454 2031405 1.940095 $16.76 1.239471444 0.438653 1478134 1614351 5 13.61 4.646666685 1.266321 5314994 5.729047 5.44.09 2.006425518 0645038 2.731864 2.793873 $ 22.65 3.438162954 0719323 3357686 3.255221 5 26.38 2.203126661 0637532 283645 24185445 20.30 1.339377752 0383848 1705625 1.756417 $ 16.42 169572016 0546037 3.343758 2.309587 5 18.61 2516422657 1141087 3457509 1431031 5.2314 40 302615260 17.5471301 4114 12677599 64 45.52014125 22 1462932 6254450 702255082245 74 16.1246526 1918.06595096 NO 3464842991 ************ Sheett High permanentang 19 (Apog) 2 n MEY Page Layout Formulas Data Review 11 -AA MM PAN wap x FDMerge & Center F 4 78% @ 0.051 9.261484 30.471 4364542 0 a 6 0 0 0 B 0 D L * 0 Projected 1 Projected 1 Permanent Projected Projected to a High/Low 42579533.29 1.25 $ 0.04 7810016 77% 51.00 500.05) 8743517 70% (0.541500001 7.82557 72% 3 0.13 $ 72% 5 01.17) 5 ON sas 0.05) 7.521123 76% $10.17) 5 001) 8.647242 73% 5 12.401 $ 10.07) 7.24535 77% $0.98 $ 0.04 7.644747 76% $ 7.724021 78% $(100) $10.05) 9.2012 71N022 1 0.014952 79% 5 0.30 5001 7.719464 76% (141 07.085826 77% 0.14 $0.05) 7.43 77% $0.11078347922 PINS 1025) 5 001 7912590 78% 0.45 $ 0.03 8.44038 0 78% 0.061918 D 70% 1076) $30017892004 D 74% 10041020443 D HINS 0115 0017611863 D 75% 5 11 10 5 10.051 7703533 6% 10.34) 1001 7.312175 63% 1034 po4 7.575852 69% 0.265 60 7563058 77% 5 (13050507) 30 77% $0.30 $0.02 7.451764 75% 10.7915 000 1437934 74% (0.52) 79% 5 (1431 S 76% 50.50 $ 77% $ 0.79 5 78% 51.755 78% 76% 9 0 0 000408418195 BOK 7495721 0 0.028100449 GOKOMOT 7544 0 0.50 $ 0.00 $476027 055 500 $1.5) D 05883 0 13.066744653 Takov & A OVO H View Tell me $ *** Low permanent earning ratio 28 $ werhe + acet3110 project 2 General 6%-$ 0 M M 0 D 0 0 0 D 0 0 a M M A in 25 Sk M 100 1 10 " E 2. MacBook Pro N tv NMA Conditional Format CAR Formatting as Table Styles P R Low Permanent Earnings Firms E 0 4244 LIFE: . the De Format +++ Lig MESSA T T 13- 28-0. Sert & Find & Select GEE ty nu Share 101 LOO Aym E
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
