Global Company Data Year Ticker 1 Key Data Date Fiscal Symbol 2 116104 20180131 2017 0190A 3 145977 20181231 2018 AAP 4 30059 20180131 2017 AEO 5 64768 20181231 2018 AMZN 6 63643 20180131 2017 ANF 7 61839 20180930 2018 APU 8 11872 20180930 2018 ARKR 9 186858 20180930 2018 ARMK 10 4072 20180731 2018 ASNA 71 23809 20180831 2018 AZO 12 25338 20180228 2017 BBBY 13 2184 20180131 2017 BBY 14 4759 20180930 2018 BDL 15 145041 20181231 2018 BGFV 16 165557 20180331 2017 BGI 17 166684 20180131 2017 BGRP 18 12123 20180131 2017 BIG 19 33718 20180131 2017 BJ 20 25234 20180131 2017 BKE 21 28924 20180430 2017 BKS 22 23208 20180430 2017 BNED 23 21898 20180331 2017 BOOT 24 18675 20180131 2017 BURL 25 142129 20180131 2017 BWTL 26 2807 20180430 2017 CASY 27 2818 20180131 2017 CATO 28 63904 20181231 2018 CBD 29 25108 20180131 2017 CBK 30 3570 20180731 2018 CBRL 31 27981 20180131 2017 CHS 32 179624 20180331 2017 CJD Net Industry Assets Income Sales Classificat Total (Loss) (Net) Ion Code 1201.007 -124.959 2370.118 5621 9040.648 423.847 9580.554 5531 1816.313 200.163 3795.549 5600 162648 10073 232887 5961 2325.692 7.094 3492.69 5651 3925.818 190.522 2822.978 5900 84.737 4.655 159.99 5812 13720,102 567.885 15789.633 5812 3570.5 39.7 6578.3 5621 9346.98 1337.536 11221.077 5531 7040.806 424.858 12349.301 5700 13049 1000 42151 5731 67.265 3.677 113.497 5812 419.561 -3.531 987.581 5940 93.287 11.699 114.378 5944 723.479 -214.31 1891.552 5961 1651.726 189.832 5270.98 5331 3273.856 50.301 12754.589 5399 538.116 89.707 913.38 5651 1749.568 -125.48 3662.28 5940 1039.211 252.566 2203.617 5940 587.941 28.879 677.949 5661 2812.829 384.852 6110.043 5600 20.304 0.475 27.423 5412 3469.927 317.903 7472.124 5412 516.076 8.54 849.981 5621 13651.409 314.104 12757.399 5411 119.364 -22.024 365.906 5621 1527.355 247.62 3030.445 5812 1087.605 101 2282.379 5621 73.813 -17.06 96.113 5912 38 39 40 41 42 43 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 172 163051 7241 3964 27936 4016 150139 26335 31587 174222 160211 31846 24171 13381 3007 24234 184323 24430 24157 13962 25357 171141 11584 122519 22155 187041 12403 5109 145049 185645 65718 4990 22543 5680 20180131 20181231 20180131 20180131 20180131 20180131 20180131 20180131 20181231 20181231 20180531 20180131 20180131 20180630 20180131 20180131 20180930 20181231 20180731 20180228 20180131 20180131 20180630 20181231 20180131 20180131 20180131 20180131 20181231 20181231 20180131 20180930 20180131 20180131 10121 2017 CTRN 2018 CVS 2017 DDS 2017 DEST 2017 DG 2017 DKS 2017 DLTH 2017 DLTR 2018 DNKN 2018 DPZ 2017 DRI 2017 DSW 2017 DXLG 2018 EAT 2017 EVLV 2017 EXPR 2018 EZPW 2018 FCFS 2018 FGP 2017 FINL 2017 FIVE 2017 FL 2018 FLWS 2018 FND 2017 FRAN 2017 FRED 2017 GCO 2017 GME 2018 GNC 2018 GPL 2017 GPS 2018 GTIM 2017 HD 2017 HIBB HOME 327,071 196456 3673.169 162.582 12516.911 4203.939 223.102 16332.8 3456.581 907.385 5469.6 1413.613 240.405 1347.34 249,258 1187.607 1246.92 2107.974 1363.281 675.032 695.708 3961 570.889 1234.091 185.24 597.565 1315.353 5041.6 1527.85 5001.075 7989 60.95 44529 461.846 12172 290 14.574 594 221.324 21.597 1538.96 323.445 23.351 1714.3 229.906 361.972 596 67.304 -18.826 125.882 0.143 19.366 39.059 153.206 -254.581 14.414 102.451 284 40.791 116.187 15.561 -150.185 -111.839 34.7 69.78 157.772 848 -1.034 8630 35.03 31912 755,241 194579 6422.676 405,443 23470.967 8590.472 471.447 22245.5 1321.617 3432.867 8080.1 2799.794 467.976 3135.417 648.22 2138.03 813.515 1780.858 2073.142 1838.956 1278.208 7782 1151.921 1709.848 471.678 1805.405 2907.016 9224.6 2353.523 11600.283 15855 99.24 100904 968.219 5651 5912 5311 5621 5331 5940 5961 5331 5812 5812 5812 5661 5651 5812 5961 5600 5900 5900 5900 5661 5331 5661 5961 5211 5621 5331 5661 5734 5400 5500 5651 5812 5211 5940 63763 2011 G 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 22543 5680 63763 26144 5523 111103 30262 12972 13092 8446 19744 30435 7922 100760 148391 64410 6502 25283 6733 19581 66261 6829 166213 6831 4611 153311 7154 7316 34411 18498 17746 186501 11922 31227 2007 B 20180930 20180131 20180131 20180131 20181231 20180930 20180331 20180930 20180930 20180131 20181231 20180131 20180131 20180131 20180131 20180228 20180131 20180131 20180131 20180131 20180930 20180131 20180930 20180831 20180131 20180930 20181231 20180131 20180331 20181231 20180331 20180331 20180930 20181231 2010021 D 2018 GTIM 2017 HD 2017 HIBB 2017 HOME 2018 HVT 2018 HZO 2017 IFMK 2018 IMKTA 2018 JACK 2017 ICP 2018 JD 2017 JILL 2017 IWN 2017 KGFHY 2017 KIRK 2017 KMX 2017 KR 2017 KSS 2017 LB 2017 LE 2018 LIVE 2017 LOW 2018 LQDT 2018 LUB 2017 M 2018 MBPFY 2018 MCD 2017 MIK 2017 MOGU 2018 MUSA 2017 NEEB 2017 NGL 2018 NGC 2018 NTRI 2017 60.95 44529 461.846 1373,289 4.40.179 640.538 48.942 1824.911 823.397 8413 30411.441 597.557 8115 14682.393 299.197 17486.272 37197 13340 8149 1124.135 141.524 35291 201.832 199.989 19381 6363.839 32811.2 2300.215 570.341 2360.8 64.269 6151.122 307,083 204.237 102 103 1 1.034 8630 35.03 31.812 30.307 39.312 -0.791 97.365 121.371 -116 - 362.27 55.365 437 688.215 5.296 664.112 1907 859 983 28.195 5.923 3447 - 11.615 -33.568 1547 135.678 5924.3 390.498 88.985 213.6 -0.911 -70.875 12.661 58.593 127 KOA 99.24 100904 968.219 950.528 817.836 1177.371 136.689 4092.805 869.69 12506 67175.178 698.145 15478 16538.445 634.117 17977.191 122662 19095 12632 1406.677 199.633 68619 224.514 365.196 24837 2807.499 21025.2 5361.96 155.152 12524 78.692 17282.718 849.042 691.039 107702 5812 5211 5940 5700 5712 5500 5411 5411 5812 5311 5961 5621 5651 5211 5990 5500 5411 5311 5621 5961 5700 5211 5961 5812 5311 5810 5812 5945 5961 5500 5900 5900 5400 5961 5221 98 99 100 101 102 F H 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 126 A 31227 24076 28180 63847 65406 8579 60923 65430 65343 28397 164471 9155 111873 61418 31266 9248 160571 63000 163891 65831 175900 25434 27938 102089 32688 17934 61735 6307 12976 15520 25186 23697 62501 16009 6207 B 20181231 20180131 20181231 20181231 20180331 20180228 20180131 20180131 20180831 20181231 20181231 20180228 20180131 20180930 20180930 20180131 20180131 20181231 20181231 20181231 20180930 20180930 20180131 20180831 20180731 20181231 20180930 20180131 20180131 20180131 20180131 20180831 20180930 20180131 20100121 D 2018 NTRI 2017 OLLI 2018 ORLY 2018 PAG 2017 PETS 2017 PIR 2017 PLAY 2017 PLCE 2018 PSMT 2018 PZZA 2018 OSR 2017 RAD 2017 RH 2018 RICK 2018 RLLME 2017 ROST 2017 RTW 2018 RUSHA 2018 RUTH 2018 SAH 2018 SBH 2018 SBUX 2017 5CVI 2018 SDXAY 2018 SFIX 2018 SEM 2018 SGU 2017 SHLDQ 2017 SHOS 2017 SIG 2017 SMRT 2018 SONC 2018 SPH 2017 SPWH 2017 CCI E 204.237 1038.199 7980.789 10904.5 134.836 772.319 1197.03 940.228 1216.392 570.947 20141 8989.327 1732.866 330.566 198.863 5722.051 302.956 3201.35 254.613 3796.807 2097.414 24156.4 415.58 17737.154 481.585 1675.614 729.971 7262 412.688 5839.6 480.932 531.134 2101.199 379.661 200 A 58.593 127.594 1324,487 471 37.283 11.626 120.949 84.698 74.328 1.646 612 943,47 2.18 21.713 -4.571 1362.753 5.675 139.062 41.68 51.65 258.047 4518.3 18.933 755.686 44.9 158.536 55.505 -383 -95,057 519.3 -24.324 71.205 76.534 17.742 27 232 G 691.039 1077,032 9536.428 22785.1 273.8 1798.522 1139.791 1870.275 3166.702 1573.316 5357 21528.968 2443.381 165.748 281.451 14134.732 926.868 5506.19 452.334 9951.63 3932.565 24719.5 1019.154 23688.619 1226.505 5207.336 1677.837 16702 1719.951 6253 1330.833 423.59 1344.413 809.671 1502275 5961 5331 5531 5500 5912 5700 5810 5600 5331 5812 5812 5912 5712 5810 5961 5651 5621 5500 5812 5500 5990 5812 5661 5812 5961 5411 5900 5311 5700 5944 5651 5812 5900 5940 5651 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 762 25186 23697 62501 16009 63874 10380 65482 18842 3813 13646 178973 11672 25167 187575 29736 13861 11944 12421 178704 29150 18492 170761 11178 21540 11264 3708 105104 11259 11511 65417 162988 20180131 20180831 20180930 20180131 20180131 20180630 20180131 20180331 20180131 20180131 20180131 20180131 20180131 20180131 20181231 20181231 20180630 20180131 20180131 20180131 20180630 20181231 20180731 20181231 20180831 20181231 20181231 20180131 20180131 20181231 20180131 D 2017 SMRT 2018 SONG 2018 SPH 2017 SPWH 2017 SSI 2018 SSY 2017 STRZ 2017 TCS 2017 TGT 2017 TIF 2017 TITN 2017 TIX 2017 TURD 2017 TLYS 2018 TSCO 2018 TTS 2018 TUES 2017 TWMC 2017 ULTA 2017 URBN 2018 VEND 2018 VIPS 2018 VLGEA 2018 W 2018 WBA 2018 WEN 2018 WMMVY 2017 WMT 2017 WSM 2018 YUM 2017 ZUMZ E 480.932 531.134 2101.199 379.661 806.106 26.176 6.998 749.369 38999 5468.1 760.308 14058.015 1999.955 290.111 3085.262 297.63 376.256 247.906 2908.687 1952.78 31.976 6333.776 481.59 1890.85 68124 4292.035 15598.823 204522 2785.749 4130 499.51 -24.324 71.205 76.534 17.742 -37.323 1.593 0.129 19.428 2934 370.1 -7.049 2607.948 96.703 14.7 532.357 10.442 -21.938 42.553 555.234 108.263 -19.536 309.514 25.08 -504.08 5024 460.115 1870.289 9862 259.545 1542 26.802 G 1330.833 423.59 1344,413 809.671 1592.275 52.872 26.525 857.228 71879 4169.8 1202.938 35864.664 3304.346 576.899 7911.046 357.254 1006.332 442.856 5884.506 3616.014 0.891 12289.326 1612.015 6779.174 131537 1589.936 31393.703 496785 5292.359 5688 927,401 H 5651 5812 5900 5910 5651 5912 5812 5700 5331 5944 5500 5651 5600 5600 5200 5700 5331 5735 5990 5651 5900 5961 5411 5961 5912 5812 5331 5331 5961 5812 5651 Required: 1. What is the mean Net Income for 2018 for the retail industry ($ millions)? 02.106.87 O 15,379.43 O 8,695.32 O 544.346 2. What is the mean Sales (net) for 2018 for the retail industry ($ millions)? O 15,379.43 O 2,106.87 O 544.346 O 8,695.32 3. Which is more likely to be negative? Sales (net) or net income? O Net Income O Sales (net) es 4. Which observation is the outlier for return on sales? 0 -0.07 O 0.29 O-0.10 O -21.93 5. What is the maximum net income achieved in 2018 for the retail industry ($ millions)? 496,785 O 10,073 O 204,522 O 9,667 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 28924 23208 21898 18575 142129 2807 2818 63904 25108 3570 27981 179624 165914 66586 156614 29028 13602 163051 7241 3954 27936 4016 150139 26335 31587 Sheet1 20180430 20180430 20180331 20180131 20180131 20180430 20180131 20181231 20180131 20180731 20180131 20180331 20181231 20181231 20180131 20180831 20180430 20180131 20181231 20180131 20180131 20180131 20180131 20180131 20180131 2017 BKS 2017 BNED 2017 BOOT 2017 BURL 2017 BWTL 2017 CASY 2017 CATO 2018 CBD 2017 CBK 2018 CBRL 2017 CHS 2017 CID 2018 CMG 2018 CNXN 2017 CONN 2018 COST 2017 CRMT 2017 CTRN 2018 CVS 2017 DDS 2017 DEST 2017 DG 2017 DKS 2017 DLTH 2017 DLTB 1749.568 1039.211 587.941 2812.829 20.304 3469.927 516,076 13651.409 119.364 1527.355 1087.605 73.813 2265.518 805.355 1900.799 40830 455.584 327.071 196456 3673.169 162.582 12516.911 4203.939 223.102 16332.8 - 125.48 -252.566 28.879 384.852 0.475 317.903 8.54 314.104 -22.024 247.62 101 - 17.06 176.553 64.592 6.463 3134 36.469 14.574 -594 221.324 -21.597 1538.96 323.445 23.351 1714.3 G 3662.28 2203.617 677.949 6110.043 27.423 7472.124 849.981 12757.399 365.906 3030.445 2282.379 96.113 4864.985 2699.489 1515.69 141576 537.528 755.241 194579 6422.676 405.443 23470.967 8590.472 471.447 22245.5 H 5940 5940 5661 5600 5412 5412 5621 5411 5621 5812 5621 5912 5812 5961 5731 5399 5500 5651 5912 5311 5621 5331 5940 5961 5331 45 Ready Global Company Data Year Ticker 1 Key Data Date Fiscal Symbol 2 116104 20180131 2017 0190A 3 145977 20181231 2018 AAP 4 30059 20180131 2017 AEO 5 64768 20181231 2018 AMZN 6 63643 20180131 2017 ANF 7 61839 20180930 2018 APU 8 11872 20180930 2018 ARKR 9 186858 20180930 2018 ARMK 10 4072 20180731 2018 ASNA 71 23809 20180831 2018 AZO 12 25338 20180228 2017 BBBY 13 2184 20180131 2017 BBY 14 4759 20180930 2018 BDL 15 145041 20181231 2018 BGFV 16 165557 20180331 2017 BGI 17 166684 20180131 2017 BGRP 18 12123 20180131 2017 BIG 19 33718 20180131 2017 BJ 20 25234 20180131 2017 BKE 21 28924 20180430 2017 BKS 22 23208 20180430 2017 BNED 23 21898 20180331 2017 BOOT 24 18675 20180131 2017 BURL 25 142129 20180131 2017 BWTL 26 2807 20180430 2017 CASY 27 2818 20180131 2017 CATO 28 63904 20181231 2018 CBD 29 25108 20180131 2017 CBK 30 3570 20180731 2018 CBRL 31 27981 20180131 2017 CHS 32 179624 20180331 2017 CJD Net Industry Assets Income Sales Classificat Total (Loss) (Net) Ion Code 1201.007 -124.959 2370.118 5621 9040.648 423.847 9580.554 5531 1816.313 200.163 3795.549 5600 162648 10073 232887 5961 2325.692 7.094 3492.69 5651 3925.818 190.522 2822.978 5900 84.737 4.655 159.99 5812 13720,102 567.885 15789.633 5812 3570.5 39.7 6578.3 5621 9346.98 1337.536 11221.077 5531 7040.806 424.858 12349.301 5700 13049 1000 42151 5731 67.265 3.677 113.497 5812 419.561 -3.531 987.581 5940 93.287 11.699 114.378 5944 723.479 -214.31 1891.552 5961 1651.726 189.832 5270.98 5331 3273.856 50.301 12754.589 5399 538.116 89.707 913.38 5651 1749.568 -125.48 3662.28 5940 1039.211 252.566 2203.617 5940 587.941 28.879 677.949 5661 2812.829 384.852 6110.043 5600 20.304 0.475 27.423 5412 3469.927 317.903 7472.124 5412 516.076 8.54 849.981 5621 13651.409 314.104 12757.399 5411 119.364 -22.024 365.906 5621 1527.355 247.62 3030.445 5812 1087.605 101 2282.379 5621 73.813 -17.06 96.113 5912 38 39 40 41 42 43 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 172 163051 7241 3964 27936 4016 150139 26335 31587 174222 160211 31846 24171 13381 3007 24234 184323 24430 24157 13962 25357 171141 11584 122519 22155 187041 12403 5109 145049 185645 65718 4990 22543 5680 20180131 20181231 20180131 20180131 20180131 20180131 20180131 20180131 20181231 20181231 20180531 20180131 20180131 20180630 20180131 20180131 20180930 20181231 20180731 20180228 20180131 20180131 20180630 20181231 20180131 20180131 20180131 20180131 20181231 20181231 20180131 20180930 20180131 20180131 10121 2017 CTRN 2018 CVS 2017 DDS 2017 DEST 2017 DG 2017 DKS 2017 DLTH 2017 DLTR 2018 DNKN 2018 DPZ 2017 DRI 2017 DSW 2017 DXLG 2018 EAT 2017 EVLV 2017 EXPR 2018 EZPW 2018 FCFS 2018 FGP 2017 FINL 2017 FIVE 2017 FL 2018 FLWS 2018 FND 2017 FRAN 2017 FRED 2017 GCO 2017 GME 2018 GNC 2018 GPL 2017 GPS 2018 GTIM 2017 HD 2017 HIBB HOME 327,071 196456 3673.169 162.582 12516.911 4203.939 223.102 16332.8 3456.581 907.385 5469.6 1413.613 240.405 1347.34 249,258 1187.607 1246.92 2107.974 1363.281 675.032 695.708 3961 570.889 1234.091 185.24 597.565 1315.353 5041.6 1527.85 5001.075 7989 60.95 44529 461.846 12172 290 14.574 594 221.324 21.597 1538.96 323.445 23.351 1714.3 229.906 361.972 596 67.304 -18.826 125.882 0.143 19.366 39.059 153.206 -254.581 14.414 102.451 284 40.791 116.187 15.561 -150.185 -111.839 34.7 69.78 157.772 848 -1.034 8630 35.03 31912 755,241 194579 6422.676 405,443 23470.967 8590.472 471.447 22245.5 1321.617 3432.867 8080.1 2799.794 467.976 3135.417 648.22 2138.03 813.515 1780.858 2073.142 1838.956 1278.208 7782 1151.921 1709.848 471.678 1805.405 2907.016 9224.6 2353.523 11600.283 15855 99.24 100904 968.219 5651 5912 5311 5621 5331 5940 5961 5331 5812 5812 5812 5661 5651 5812 5961 5600 5900 5900 5900 5661 5331 5661 5961 5211 5621 5331 5661 5734 5400 5500 5651 5812 5211 5940 63763 2011 G 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 22543 5680 63763 26144 5523 111103 30262 12972 13092 8446 19744 30435 7922 100760 148391 64410 6502 25283 6733 19581 66261 6829 166213 6831 4611 153311 7154 7316 34411 18498 17746 186501 11922 31227 2007 B 20180930 20180131 20180131 20180131 20181231 20180930 20180331 20180930 20180930 20180131 20181231 20180131 20180131 20180131 20180131 20180228 20180131 20180131 20180131 20180131 20180930 20180131 20180930 20180831 20180131 20180930 20181231 20180131 20180331 20181231 20180331 20180331 20180930 20181231 2010021 D 2018 GTIM 2017 HD 2017 HIBB 2017 HOME 2018 HVT 2018 HZO 2017 IFMK 2018 IMKTA 2018 JACK 2017 ICP 2018 JD 2017 JILL 2017 IWN 2017 KGFHY 2017 KIRK 2017 KMX 2017 KR 2017 KSS 2017 LB 2017 LE 2018 LIVE 2017 LOW 2018 LQDT 2018 LUB 2017 M 2018 MBPFY 2018 MCD 2017 MIK 2017 MOGU 2018 MUSA 2017 NEEB 2017 NGL 2018 NGC 2018 NTRI 2017 60.95 44529 461.846 1373,289 4.40.179 640.538 48.942 1824.911 823.397 8413 30411.441 597.557 8115 14682.393 299.197 17486.272 37197 13340 8149 1124.135 141.524 35291 201.832 199.989 19381 6363.839 32811.2 2300.215 570.341 2360.8 64.269 6151.122 307,083 204.237 102 103 1 1.034 8630 35.03 31.812 30.307 39.312 -0.791 97.365 121.371 -116 - 362.27 55.365 437 688.215 5.296 664.112 1907 859 983 28.195 5.923 3447 - 11.615 -33.568 1547 135.678 5924.3 390.498 88.985 213.6 -0.911 -70.875 12.661 58.593 127 KOA 99.24 100904 968.219 950.528 817.836 1177.371 136.689 4092.805 869.69 12506 67175.178 698.145 15478 16538.445 634.117 17977.191 122662 19095 12632 1406.677 199.633 68619 224.514 365.196 24837 2807.499 21025.2 5361.96 155.152 12524 78.692 17282.718 849.042 691.039 107702 5812 5211 5940 5700 5712 5500 5411 5411 5812 5311 5961 5621 5651 5211 5990 5500 5411 5311 5621 5961 5700 5211 5961 5812 5311 5810 5812 5945 5961 5500 5900 5900 5400 5961 5221 98 99 100 101 102 F H 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 126 A 31227 24076 28180 63847 65406 8579 60923 65430 65343 28397 164471 9155 111873 61418 31266 9248 160571 63000 163891 65831 175900 25434 27938 102089 32688 17934 61735 6307 12976 15520 25186 23697 62501 16009 6207 B 20181231 20180131 20181231 20181231 20180331 20180228 20180131 20180131 20180831 20181231 20181231 20180228 20180131 20180930 20180930 20180131 20180131 20181231 20181231 20181231 20180930 20180930 20180131 20180831 20180731 20181231 20180930 20180131 20180131 20180131 20180131 20180831 20180930 20180131 20100121 D 2018 NTRI 2017 OLLI 2018 ORLY 2018 PAG 2017 PETS 2017 PIR 2017 PLAY 2017 PLCE 2018 PSMT 2018 PZZA 2018 OSR 2017 RAD 2017 RH 2018 RICK 2018 RLLME 2017 ROST 2017 RTW 2018 RUSHA 2018 RUTH 2018 SAH 2018 SBH 2018 SBUX 2017 5CVI 2018 SDXAY 2018 SFIX 2018 SEM 2018 SGU 2017 SHLDQ 2017 SHOS 2017 SIG 2017 SMRT 2018 SONC 2018 SPH 2017 SPWH 2017 CCI E 204.237 1038.199 7980.789 10904.5 134.836 772.319 1197.03 940.228 1216.392 570.947 20141 8989.327 1732.866 330.566 198.863 5722.051 302.956 3201.35 254.613 3796.807 2097.414 24156.4 415.58 17737.154 481.585 1675.614 729.971 7262 412.688 5839.6 480.932 531.134 2101.199 379.661 200 A 58.593 127.594 1324,487 471 37.283 11.626 120.949 84.698 74.328 1.646 612 943,47 2.18 21.713 -4.571 1362.753 5.675 139.062 41.68 51.65 258.047 4518.3 18.933 755.686 44.9 158.536 55.505 -383 -95,057 519.3 -24.324 71.205 76.534 17.742 27 232 G 691.039 1077,032 9536.428 22785.1 273.8 1798.522 1139.791 1870.275 3166.702 1573.316 5357 21528.968 2443.381 165.748 281.451 14134.732 926.868 5506.19 452.334 9951.63 3932.565 24719.5 1019.154 23688.619 1226.505 5207.336 1677.837 16702 1719.951 6253 1330.833 423.59 1344.413 809.671 1502275 5961 5331 5531 5500 5912 5700 5810 5600 5331 5812 5812 5912 5712 5810 5961 5651 5621 5500 5812 5500 5990 5812 5661 5812 5961 5411 5900 5311 5700 5944 5651 5812 5900 5940 5651 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 762 25186 23697 62501 16009 63874 10380 65482 18842 3813 13646 178973 11672 25167 187575 29736 13861 11944 12421 178704 29150 18492 170761 11178 21540 11264 3708 105104 11259 11511 65417 162988 20180131 20180831 20180930 20180131 20180131 20180630 20180131 20180331 20180131 20180131 20180131 20180131 20180131 20180131 20181231 20181231 20180630 20180131 20180131 20180131 20180630 20181231 20180731 20181231 20180831 20181231 20181231 20180131 20180131 20181231 20180131 D 2017 SMRT 2018 SONG 2018 SPH 2017 SPWH 2017 SSI 2018 SSY 2017 STRZ 2017 TCS 2017 TGT 2017 TIF 2017 TITN 2017 TIX 2017 TURD 2017 TLYS 2018 TSCO 2018 TTS 2018 TUES 2017 TWMC 2017 ULTA 2017 URBN 2018 VEND 2018 VIPS 2018 VLGEA 2018 W 2018 WBA 2018 WEN 2018 WMMVY 2017 WMT 2017 WSM 2018 YUM 2017 ZUMZ E 480.932 531.134 2101.199 379.661 806.106 26.176 6.998 749.369 38999 5468.1 760.308 14058.015 1999.955 290.111 3085.262 297.63 376.256 247.906 2908.687 1952.78 31.976 6333.776 481.59 1890.85 68124 4292.035 15598.823 204522 2785.749 4130 499.51 -24.324 71.205 76.534 17.742 -37.323 1.593 0.129 19.428 2934 370.1 -7.049 2607.948 96.703 14.7 532.357 10.442 -21.938 42.553 555.234 108.263 -19.536 309.514 25.08 -504.08 5024 460.115 1870.289 9862 259.545 1542 26.802 G 1330.833 423.59 1344,413 809.671 1592.275 52.872 26.525 857.228 71879 4169.8 1202.938 35864.664 3304.346 576.899 7911.046 357.254 1006.332 442.856 5884.506 3616.014 0.891 12289.326 1612.015 6779.174 131537 1589.936 31393.703 496785 5292.359 5688 927,401 H 5651 5812 5900 5910 5651 5912 5812 5700 5331 5944 5500 5651 5600 5600 5200 5700 5331 5735 5990 5651 5900 5961 5411 5961 5912 5812 5331 5331 5961 5812 5651 Required: 1. What is the mean Net Income for 2018 for the retail industry ($ millions)? 02.106.87 O 15,379.43 O 8,695.32 O 544.346 2. What is the mean Sales (net) for 2018 for the retail industry ($ millions)? O 15,379.43 O 2,106.87 O 544.346 O 8,695.32 3. Which is more likely to be negative? Sales (net) or net income? O Net Income O Sales (net) es 4. Which observation is the outlier for return on sales? 0 -0.07 O 0.29 O-0.10 O -21.93 5. What is the maximum net income achieved in 2018 for the retail industry ($ millions)? 496,785 O 10,073 O 204,522 O 9,667 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 28924 23208 21898 18575 142129 2807 2818 63904 25108 3570 27981 179624 165914 66586 156614 29028 13602 163051 7241 3954 27936 4016 150139 26335 31587 Sheet1 20180430 20180430 20180331 20180131 20180131 20180430 20180131 20181231 20180131 20180731 20180131 20180331 20181231 20181231 20180131 20180831 20180430 20180131 20181231 20180131 20180131 20180131 20180131 20180131 20180131 2017 BKS 2017 BNED 2017 BOOT 2017 BURL 2017 BWTL 2017 CASY 2017 CATO 2018 CBD 2017 CBK 2018 CBRL 2017 CHS 2017 CID 2018 CMG 2018 CNXN 2017 CONN 2018 COST 2017 CRMT 2017 CTRN 2018 CVS 2017 DDS 2017 DEST 2017 DG 2017 DKS 2017 DLTH 2017 DLTB 1749.568 1039.211 587.941 2812.829 20.304 3469.927 516,076 13651.409 119.364 1527.355 1087.605 73.813 2265.518 805.355 1900.799 40830 455.584 327.071 196456 3673.169 162.582 12516.911 4203.939 223.102 16332.8 - 125.48 -252.566 28.879 384.852 0.475 317.903 8.54 314.104 -22.024 247.62 101 - 17.06 176.553 64.592 6.463 3134 36.469 14.574 -594 221.324 -21.597 1538.96 323.445 23.351 1714.3 G 3662.28 2203.617 677.949 6110.043 27.423 7472.124 849.981 12757.399 365.906 3030.445 2282.379 96.113 4864.985 2699.489 1515.69 141576 537.528 755.241 194579 6422.676 405.443 23470.967 8590.472 471.447 22245.5 H 5940 5940 5661 5600 5412 5412 5621 5411 5621 5812 5621 5912 5812 5961 5731 5399 5500 5651 5912 5311 5621 5331 5940 5961 5331 45 Ready