Use the P/E median test and regression approach to evaluate the overvaluation/undervaluation of each firm.
Year 2015 2017 2016 2018 2015 2016 2016 2016 2018 2018 2015 2017 2015 2017 2017 2014 2014 2015 2017 2014 2016 2018 2014 2018 2014 Name Growth AMERICAN AIRLINES GROUP | -0.0389215 JETBLUE AIRWAYS CORP 0.0577503 DELTA AIR LINES INC -0.0261645 DELTA AIR LINES INC 0.0774416 DELTA AIR LINES INC 0.0084733 AMERICAN AIRLINES GROUP | -0.0197609 JETBLUE AIRWAYS CORP 0.0336658 CHINA EASTERN AIRLINES CO -0.0180043 SOUTHWEST AIRLINES 0.0375041 AMERICAN AIRLINES GROUP | 0.0552989 CHINA EASTERN AIRLINES CO -0.0019862 CHINA EASTERN AIRLINES CO 0.1056487 JETBLUE AIRWAYS CORP 0.102974 SOUTHWEST AIRLINES 0.0365239 DELTA AIR LINES INC 0.0404904 CHINA EASTERN AIRLINES CO -0.0028711 JETBLUE AIRWAYS CORP 0.0691049 SOUTHWEST AIRLINES 0.0560602 AMERICAN AIRLINES GROUP 0.050448 AMERICAN AIRLINES GROUP I 0.5966607 SOUTHWEST AIRLINES 0.039546 CHINA EASTERN AIRLINES CO 0.0641697 SOUTHWEST AIRLINES 0.0511893 JETBLUE AIRWAYS CORP 0.0916607 DELTA AIR LINES INC 0.068541 P/E 3.47605 6.252084 8.219758 8.622416 8.722174 8.851105 9.954598 9.982322 10.41987 10.47466 10.55881 10.72809 10.77297 11.04377 11.07159 11.18007 12.25575 12.78576 12.89249 12.97904 13.66293 20.19618 25.16825 26.14021 61.60006 P/B 0.5463749 0.7331704 0.7012153 0.5629908 0.7429623 0.4619409 0.7964098 0.2114716 0.9787368 0.2441436 0.2419557 0.296167 0.8421825 1.534077 0.7431338 0.2298996 0.6269363 1.308453 0.4813737 0.8545746 1.316655 0.2279727 1.415403 0.4713562 0.7500682 ROE 1.350488 0.2372776 0.3559046 0.2874991 0.4171429 0.7070013 0.1891353 0.0909606 0.2501776 -8.35503 0.1212745 0.1145593 0.2109034 0.3344199 0.2571531 0.1137652 0.1585607 0.2964121 0.4887927 1.426027 0.2658453 0.0465109 0.1676753 0.0407721 0.0747759 Year 2015 2017 2016 2018 2015 2016 2016 2016 2018 2018 2015 2017 2015 2017 2017 2014 2014 2015 2017 2014 2016 2018 2014 2018 2014 Name Growth AMERICAN AIRLINES GROUP | -0.0389215 JETBLUE AIRWAYS CORP 0.0577503 DELTA AIR LINES INC -0.0261645 DELTA AIR LINES INC 0.0774416 DELTA AIR LINES INC 0.0084733 AMERICAN AIRLINES GROUP | -0.0197609 JETBLUE AIRWAYS CORP 0.0336658 CHINA EASTERN AIRLINES CO -0.0180043 SOUTHWEST AIRLINES 0.0375041 AMERICAN AIRLINES GROUP | 0.0552989 CHINA EASTERN AIRLINES CO -0.0019862 CHINA EASTERN AIRLINES CO 0.1056487 JETBLUE AIRWAYS CORP 0.102974 SOUTHWEST AIRLINES 0.0365239 DELTA AIR LINES INC 0.0404904 CHINA EASTERN AIRLINES CO -0.0028711 JETBLUE AIRWAYS CORP 0.0691049 SOUTHWEST AIRLINES 0.0560602 AMERICAN AIRLINES GROUP 0.050448 AMERICAN AIRLINES GROUP I 0.5966607 SOUTHWEST AIRLINES 0.039546 CHINA EASTERN AIRLINES CO 0.0641697 SOUTHWEST AIRLINES 0.0511893 JETBLUE AIRWAYS CORP 0.0916607 DELTA AIR LINES INC 0.068541 P/E 3.47605 6.252084 8.219758 8.622416 8.722174 8.851105 9.954598 9.982322 10.41987 10.47466 10.55881 10.72809 10.77297 11.04377 11.07159 11.18007 12.25575 12.78576 12.89249 12.97904 13.66293 20.19618 25.16825 26.14021 61.60006 P/B 0.5463749 0.7331704 0.7012153 0.5629908 0.7429623 0.4619409 0.7964098 0.2114716 0.9787368 0.2441436 0.2419557 0.296167 0.8421825 1.534077 0.7431338 0.2298996 0.6269363 1.308453 0.4813737 0.8545746 1.316655 0.2279727 1.415403 0.4713562 0.7500682 ROE 1.350488 0.2372776 0.3559046 0.2874991 0.4171429 0.7070013 0.1891353 0.0909606 0.2501776 -8.35503 0.1212745 0.1145593 0.2109034 0.3344199 0.2571531 0.1137652 0.1585607 0.2964121 0.4887927 1.426027 0.2658453 0.0465109 0.1676753 0.0407721 0.0747759
