Question

1 Approved Answer

Posted on Jul 22, 2024

Average P/E Ratio Average Yield 1 OVER PEO 115 19 106 6953 212 235 16.1 404 12.4 J. 2.6 TOT DESH 9 B 1 Company

Average P/E Ratio Average Yield 1 OVER PEO 115 19 106 6953 212 235 16.1 404 12.4 J. 2.6 TOT DESH 9 B 1 Company Type 2 MPC Abertson's 4 Allstate 5 Amer 6 American 7 American Store 8 moto 9 Roco Chemical 30 e 11 Atlantic 22 Bach Lomb 13 enero 14 Bricolo 15 ton 15 CM Power 17 O 11 DE 19 De 20 Dato 21 D 22 cm 23 DO 24 ORE 25 Cantes 26 27 min Dividends per Share 09 022 16 0.63 1 0.36 11 0.6 3 14 1.4 3.1 1.4 51 28 23 11 283 104 113 2 1.52 0.1 002 22 09 220 THE 51 12 013 0.4 016 201 C D Total Revenues Total Assets Return on Equity Earnings per Share 7251 29454 171 2.00 4 14690 5219 214 2.00 6 20106 201 3.56 7935 02 0.00 3362 30520 71 2.10 4 1919 12:2 2 36287 32410 167 2.76 3995 *11 62 1:14 14310 7777 95 3.8 2 19272 25322 5:41 1916 5 0.19 5 5130 3707 115 106 5 16701 404 3.14 1777 113 954 2299 24 41950 16 4.95 1493 SON199 HE BE 1.59 16151 17 681 5592 92 7678 75 2015 2 20018 2010 235 2. 13 1 4663 42942 213 2200 2 5773 163 1.23 0.16 E ZET 79.6 152 114 224 162 15.7 177 116 13 2733 18 VE 19 STOL 320 3.6 53 21 13 3.91 123 136 SUSE VEO CEO 19 02 27001 15108 100 101 26 0.71 025 10 11 120 17.1 144 16 100 31 3 2 TOT TELE LE 15 1 0. 02 33 TL 34 The SO 11 365 VET C 078 23 13 11 16 OU 05 10 220 LE Finance US International Stock Marke Hip intball 100% K24 G D 5557 2 2 111 ST 5 11 152 1.4 13 2.3 15 22 2270 120 122 2011 10S 1225 US 0.62 161 0:54 1 15 104 0.85 0.77 403 34 26.6 145 ITE 1866 ET 2578 EET 160 3.42 2:41 24.1 12.2 5 S7 38 Great 39 Green Mountain Power Compa 40 Haro 41 Hece 41 Hours 43 Not 44 Toronto 45 buty 46 The 47 41 L 49 Londres 50 M 51 DS EE 23 15 13 21 311 145 267 111 TOS 04 19 IVO 267 0.70 021 2766 ISCELL 660 219 499 1674 3010 2868 126 3002 145 64 16 2 1550 350 CS 200 9930 1 2015 11 79 166 2.9 17 24 12 21 17 29 1.96 1.01 00 0.66 12 0.5 110 169 0.5 212 05 0.30 20 160 206 1 316 53 Mert CE 2:47 1.11 11.50 3.53 110 2107 401 04 160 200 0.83 2.1 LE 04 172 217 2012 4326 43555 10110 200 TE SS MO 56 MB 57 08 650 2514 1 VIE 18 I HELE 01 SMO 40 09 20 13 161 1441 2010 72 12) 12 115 21 101 141 12:4 10 04 1.6 > 144 12 D3 19 15 3 11 06 D 21 41 20 15 14 06 08 08 217 12 CE 67 77 FE 260 173 09 3. 16 11 313 1 0. 1.00 SE 3 70 71 3304 710 US 10110 100 14 LE 361 1 52 124 10 17 15 SEO 15 20.1 25 114 HE ma 24 75 13 1 CU Am 0.88 VSE 5 17 0.51 361 11 31 3 12500 1710 1024 BOT 1.34 0.35 2 140 270 51 19.0 251 215 114 1 3 Et LEE 2 3.54 13 70 71 Farmace Upjohn 72 Petroleum 73 Poe Brown 74 PPC 75 PPL 76 Progede 77 70 udda 79 Scherine Pour 80 oints 1533 10110 13860 134 CRB 9485 75.00 3900 355 6307 13700 YA 304 4190 ICS 3 2.2 021 22 13 1 124 16 16 12 19 134 17 ME 174 272 2 1.67 0.24 063 032 0.24 092 0.11 1 2.11 102 1195 2.94 12 2300 5 1 5 03 10 TH 4667 1225 512 20.3 20.5 11 167 20.9 263 125 200 50 2114 LENE 125 7 2009 00 7500 33 mec 14 T 85 The com 85 Taman 87 29600 2610 10967 437 1. 2.39 32 2.54 016 17 050 193 TUS 8,2 143 23 12 161 FO 30 PO IT 16 5593 100 TE 100 16 15 1 107 SO 0. 010 0 45 121 20 1720 SE 5 points 155 16 DELE 02 90 C 1 Corpo 32 UNCA S UN 56 5 V 56 WWE 209 15.2 126 9.4 13700 10365 20 031 61 > 1 22 1 14 15 2.03 104 173 OY 0:42 051 CSE 5756 2100 23 13 SEO OC 2 . 2319 2531 205 27.2 24 CSC 20 LE 1 LT 35 W 300 WITCO 101 200 QUESTION 7 Use the Financial database from "Excel Databases.xls" on Blackboard. Use Total Revenues, Total Assets, Return on Equity, Earnings Per Share, Average Yield, and Dividends Per Share to predict the average P/E ratio for a company. Use Excel to perform a forward selection regression analysis. Assume a 5% level of significance. Identify observation 2 in the original dataset. Use the observed values from observation 2 to find the predicted value y-hat based on your final model selected. Write your answer as a number and round your final answer to a whole number. Average P/E Ratio Average Yield 1 OVER PEO 115 19 106 6953 212 235 16.1 404 12.4 J. 2.6 TOT DESH 9 B 1 Company Type 2 MPC Abertson's 4 Allstate 5 Amer 6 American 7 American Store 8 moto 9 Roco Chemical 30 e 11 Atlantic 22 Bach Lomb 13 enero 14 Bricolo 15 ton 15 CM Power 17 O 11 DE 19 De 20 Dato 21 D 22 cm 23 DO 24 ORE 25 Cantes 26 27 min Dividends per Share 09 022 16 0.63 1 0.36 11 0.6 3 14 1.4 3.1 1.4 51 28 23 11 283 104 113 2 1.52 0.1 002 22 09 220 THE 51 12 013 0.4 016 201 C D Total Revenues Total Assets Return on Equity Earnings per Share 7251 29454 171 2.00 4 14690 5219 214 2.00 6 20106 201 3.56 7935 02 0.00 3362 30520 71 2.10 4 1919 12:2 2 36287 32410 167 2.76 3995 *11 62 1:14 14310 7777 95 3.8 2 19272 25322 5:41 1916 5 0.19 5 5130 3707 115 106 5 16701 404 3.14 1777 113 954 2299 24 41950 16 4.95 1493 SON199 HE BE 1.59 16151 17 681 5592 92 7678 75 2015 2 20018 2010 235 2. 13 1 4663 42942 213 2200 2 5773 163 1.23 0.16 E ZET 79.6 152 114 224 162 15.7 177 116 13 2733 18 VE 19 STOL 320 3.6 53 21 13 3.91 123 136 SUSE VEO CEO 19 02 27001 15108 100 101 26 0.71 025 10 11 120 17.1 144 16 100 31 3 2 TOT TELE LE 15 1 0. 02 33 TL 34 The SO 11 365 VET C 078 23 13 11 16 OU 05 10 220 LE Finance US International Stock Marke Hip intball 100% K24 G D 5557 2 2 111 ST 5 11 152 1.4 13 2.3 15 22 2270 120 122 2011 10S 1225 US 0.62 161 0:54 1 15 104 0.85 0.77 403 34 26.6 145 ITE 1866 ET 2578 EET 160 3.42 2:41 24.1 12.2 5 S7 38 Great 39 Green Mountain Power Compa 40 Haro 41 Hece 41 Hours 43 Not 44 Toronto 45 buty 46 The 47 41 L 49 Londres 50 M 51 DS EE 23 15 13 21 311 145 267 111 TOS 04 19 IVO 267 0.70 021 2766 ISCELL 660 219 499 1674 3010 2868 126 3002 145 64 16 2 1550 350 CS 200 9930 1 2015 11 79 166 2.9 17 24 12 21 17 29 1.96 1.01 00 0.66 12 0.5 110 169 0.5 212 05 0.30 20 160 206 1 316 53 Mert CE 2:47 1.11 11.50 3.53 110 2107 401 04 160 200 0.83 2.1 LE 04 172 217 2012 4326 43555 10110 200 TE SS MO 56 MB 57 08 650 2514 1 VIE 18 I HELE 01 SMO 40 09 20 13 161 1441 2010 72 12) 12 115 21 101 141 12:4 10 04 1.6 > 144 12 D3 19 15 3 11 06 D 21 41 20 15 14 06 08 08 217 12 CE 67 77 FE 260 173 09 3. 16 11 313 1 0. 1.00 SE 3 70 71 3304 710 US 10110 100 14 LE 361 1 52 124 10 17 15 SEO 15 20.1 25 114 HE ma 24 75 13 1 CU Am 0.88 VSE 5 17 0.51 361 11 31 3 12500 1710 1024 BOT 1.34 0.35 2 140 270 51 19.0 251 215 114 1 3 Et LEE 2 3.54 13 70 71 Farmace Upjohn 72 Petroleum 73 Poe Brown 74 PPC 75 PPL 76 Progede 77 70 udda 79 Scherine Pour 80 oints 1533 10110 13860 134 CRB 9485 75.00 3900 355 6307 13700 YA 304 4190 ICS 3 2.2 021 22 13 1 124 16 16 12 19 134 17 ME 174 272 2 1.67 0.24 063 032 0.24 092 0.11 1 2.11 102 1195 2.94 12 2300 5 1 5 03 10 TH 4667 1225 512 20.3 20.5 11 167 20.9 263 125 200 50 2114 LENE 125 7 2009 00 7500 33 mec 14 T 85 The com 85 Taman 87 29600 2610 10967 437 1. 2.39 32 2.54 016 17 050 193 TUS 8,2 143 23 12 161 FO 30 PO IT 16 5593 100 TE 100 16 15 1 107 SO 0. 010 0 45 121 20 1720 SE 5 points 155 16 DELE 02 90 C 1 Corpo 32 UNCA S UN 56 5 V 56 WWE 209 15.2 126 9.4 13700 10365 20 031 61 > 1 22 1 14 15 2.03 104 173 OY 0:42 051 CSE 5756 2100 23 13 SEO OC 2 . 2319 2531 205 27.2 24 CSC 20 LE 1 LT 35 W 300 WITCO 101 200 QUESTION 7 Use the Financial database from "Excel Databases.xls" on Blackboard. Use Total Revenues, Total Assets, Return on Equity, Earnings Per Share, Average Yield, and Dividends Per Share to predict the average P/E ratio for a company. Use Excel to perform a forward selection regression analysis. Assume a 5% level of significance. Identify observation 2 in the original dataset. Use the observed values from observation 2 to find the predicted value y-hat based on your final model selected. Write your answer as a number and round your final answer to a whole number