Case Study The Case Study is worth 50 points according to the following rubric Category Criteria Scoring Introduction of data Describe your dataset and an overview of questions you will be analyzing and explain the big picture of this project Excellent (4 5 5 pts) Very good (3 5 4 pts) Good (2 5 3 pts) Limited (1 5 2 pts) Poor (0 1 pts) Question Answers Effectively answers the questions presented Results are accurate Excel results are included Excellent (18 20pts) Very good (16 17 5 pts) Good (14 15 5 pts) Limited (12 13 5 pts) Poor (1 11 5 pts) Inferential insights Describe how the answers and results should be interpreted Summarizes the major results Intended message is communicated clearly to a wide audience Provides an interpretation and relates results back to the question of interest and to a big project as a whole Excellent (13 5 15 pts) Very good (12 12 5 pts) Good (10 5 11 5 pts) Limited (9 10 pts) Poor (1 8 5 pts) Length Labeling Format Meet the minimum requirement of length for your written report Visualizations, sources, and figures are labeled Report is a submitted as a word written document and not Excel file Results are within the written interpretations Excellent (4 5 5 pts) Very good (3 5 4 pts) Good (2 5 3 pts) Limited (1 5 2 pts) Poor (0 1 pts) Conclusion of Findings Effectively summarizes the big picture and results from the case study Excellent (4 5 5 pts) Very good (3 5 4 pts) Good (2 5 3 pts) Limited (1 5 2 pts) Poor (0 1 pts) You will be submitting a written report in a Word document (not Excel) The data analysis is done in Excel, but the final submission is a report of your findings from Excel You will need to copy and paste the Excel results into your Word document SCREENSHOTS are not acceptable to include in a written report Copy paste all the Excel outputs and results from the templates and from the Data Analysis Tookpak For each question explain what you did and why, interpret the results, and think about the consequences and the decisions that the company might make from each results The written report should be at least 1000 words (not including Excel outputs) Label and refer to the graphs as Figure 1, Figure 2, etc Don't submit the Excel results separately For example, they shouldn't be at the end of your report or in an appendix Your Excel outputs should be copied and pasted within the written text of your report and look somewhat like the following example You work for a company and your manager has identified some questions she would like you to answer using the Flight Data dataset The dataset is a sample of booked flights in Asia and It includes many variables about the details of those flights Questions to Answer Using that dataset and concepts learned in this course, answer the following questions Use a 95 confidence level for every interval and test Write an introduction of the dataset and analysis from the perspective of you submitting an analytic report to your manager Then, answer the following The report should include all of the Excel outputs in addition to your written findings Copy paste all the Excel outputs and results from the templates and from the Data Analysis Tookpak What does the distribution of the average Total Fare look like Explore this by constructing a confidence interval that estimates the average Total Fare of all flights What does the distribution of the proportion of flights that are Direct, 1 stop, or 2 stops look like Explore this constructing three separate confidence intervals for the proportion of flights that are direct, 1 stop, or 2 stops Is there a difference in the average Total Fare between the three categories of Stopovers (Direct, 1 stop, 2 stops) Explore this by constructing a hypothesis test that looks to see if there is a significant difference in the average total fare between the three categories of Stopovers (This is an ANOVA test) Generate a model that predicts the Total Fare based off of four explanatory variables (Duration Hrs, Base Fare, Tax Surcharge, and Days before Departure) Explore this by constructing a multiple regression analysis Then, best fit the model using the P value approach Evaluate and interpret the best fit model (in the previous question) for its usefulness and application Explore this by interpreting the adjusted R square statistic and the standard error of the estimates Interpret each of the slope coefficients of the x variables in context to the problem from your best fit model, including all the units of the x variables and y variable Make some overall conclusions about the analysis as a whole in context to the data analysis you conducted You work for a company and your manager has identified some questions she would like you to answer using the Flight Data dataset The dataset is a sample of booked flights in Asia and It includes many variables about the details of those flights Questions to Answer Using that dataset and concepts learned in this course, answer the following questions Use a 95 confidence level for every interval and test Write an introduction of the dataset and analysis from the perspective of you submitting an analytic report to your manager Then, answer the following The report should include all of the Excel outputs in addition to your written findings Copy paste all the Excel outputs and results from the templates and from the Data Analysis Tookpak What does the distribution of the average Total Fare look like Explore this by constructing a confidence interval that estimates the average Total Fare of all flights What does the distribution of the proportion of flights that are Direct, 1 stop, or 2 stops look like Explore this constructing three separate confidence intervals for the proportion of flights that are direct, 1 stop, or 2 stops Is there a difference in the average Total Fare between the three categories of Stopovers (Direct, 1 stop, 2 stops) Explore this by constructing a hypothesis test that looks to see if there is a significant difference in the average total fare between the three categories of Stopovers (This is an ANOVA test) Generate a model that predicts the Total Fare based off of four explanatory variables (Duration Hrs, Base Fare, Tax Surcharge, and Days before Departure) Explore this by constructing a multiple regression analysis Then, best fit the model using the P value approach Evaluate and interpret the best fit model (in the previous question) for its usefulness and application Explore this by interpreting the adjusted R square statistic and the standard error of the estimates Interpret each of the slope coefficients of the x variables in context to the problem from your best fit model, including all the units of the x variables and y variable Make some overall conclusions about the analysis as a whole in context to the data analysis you conducted Airline Source Destination Departure Date Time Arrival Date Tim Duration Hrs Stopovers Aircraft Type Class Booking Source Base Fare Tax Surcharge Total Fare Seasonality Days Before Departure 1 Malaysian Airlines CXB CCU 11 17 25 6 25 11 17 25 7 38 1 219526454 Direct Airbus A320 Economy Online Website 21131 22502 5169 683753 26300 90877 Regular 10 2 Cathay Pacific BZL CGP 3 16 25 0 17 3 16 25 0 53 0 608638013 Direct Airbus A320 First Class Travel Agency 11605 39547 200 11805 39547 Regular 14 3 British Airways ZYL KUL 12 13 25 12 03 12 13 25 14 44 2 689650557 1 Stop Boeing 787 Economy Travel Agency 39882 49935 11982 3749 51864 87425 Winter Holidays 83 4 Singapore Airlines RJH DAC 5 30 25 3 21 5 30 25 4 02 0 686053648 Direct Airbus A320 Economy Direct Booking 4435 60734 200 4635 60734 Regular 56 5 British Airways SPD YYZ 4 25 25 9 14 4 25 25 23 17 14 05560923 1 Stop Airbus A350 Business Direct Booking 59243 80615 14886 57092 74130 37707 Regular 90 6 IndiGo ZYL SPD 6 18 25 18 28 6 18 25 19 33 1 08506574 Direct Airbus A320 Business Travel Agency 5036 39416 200 5236 39416 Regular 70 7 US Bangla Airlines SPD BZL 10 25 25 22 41 10 25 25 23 45 1 078155488 Direct Airbus A320 Business Direct Booking 7397 669874 200 7597 669874 Regular 28 8 AirAsia JSR LHR 12 28 25 1 38 12 28 25 10 30 8 880375527 1 Stop Airbus A350 Economy Online Website 11946 81358 7792 022037 19738 83562 Winter Holidays 12 9 Etihad Airways SPD KUL 7 6 25 21 52 7 7 25 1 09 3 296281693 Direct Boeing 787 Business Travel Agency 74973 62187 17246 04328 92219 66515 Regular 23 10 US Bangla Airlines DAC DEL 4 14 25 23 19 4 15 25 1 54 2 595620253 Direct Boeing 787 First Class Direct Booking 116951 6454 19542 74682 136494 3923 Regular 41 11 Gulf Air CXB DEL 7 12 25 20 38 7 12 25 23 32 2 908250273 Direct Boeing 787 Business Online Website 42416 10568 8362 415852 50778 52153 Regular 18 12 Etihad Airways ZYL LHR 1 10 26 22 44 1 11 26 6 49 8 097631764 1 Stop Airbus A350 First Class Travel Agency 76405 94683 17460 89202 93866 83885 Winter Holidays 48 13 Emirates JSR ZYL 4 28 25 9 19 4 28 25 10 33 1 241106695 Direct Airbus A320 Business Travel Agency 6809 924096 200 7009 924096 Regular 67 14 Emirates RJH YYZ 11 4 25 12 30 11 5 25 2 25 13 92327945 1 Stop Boeing 777 Economy Direct Booking 42342 72806 12351 40921 54694 13727 Regular 90 15 Biman Bangladesh Airlines CXB YYZ 11 3 25 10 15 11 4 25 1 20 15 0919049 1 Stop Boeing 777 Business Travel Agency 43227 96194 12484 19429 55712 15623 Regular 45 16 NovoAir RJH CGP 9 8 25 12 30 9 8 25 13 55 1 429665104 Direct Airbus A320 First Class Direct Booking 10841 30302 200 11041 30302 Regular 48 17 FlyDubai CXB RJH 2 22 26 23 32 2 23 26 1 08 1 612434591 Direct Airbus A320 Economy Direct Booking 2786 29484 200 2986 29484 Winter Holidays 67 18 NovoAir ZYL SPD 11 18 25 7 21 11 18 25 8 18 0 960243512 Direct Airbus A320 Economy Direct Booking 3199 388832 200 3399 388832 Regular 52 19 Saudia CGP CCU 12 22 25 16 09 12 22 25 17 22 1 218343564 Direct Airbus A320 Business Online Website 140806 234 23120 93511 163927 1691 Winter Holidays 76 20 Thai Airways SPD JSR 1 12 26 10 06 1 12 26 10 57 0 862968717 Direct Airbus A320 First Class Online Website 10963 8108 200 11163 8108 Winter Holidays 38 21 Gulf Air ZYL DEL 5 17 25 20 06 5 17 25 22 47 2 68928363 Direct Boeing 737 Business Travel Agency 131458 0712 21718 71067 153176 7818 Regular 19 22 Singapore Airlines DAC YYZ 4 2 25 20 21 4 3 25 10 35 14 23456762 1 Stop Boeing 777 Business Direct Booking 130089 5673 25513 43509 155603 0023 Eid 27 23 Saudia BZL CXB 3 4 25 5 03 3 4 25 5 45 0 709442578 Direct Airbus A320 Economy Direct Booking 3827 894015 200 4027 894015 Regular 15 24 Kuwait Airways DAC IST 3 14 25 22 46 3 15 25 5 31 6 766236259 1 Stop Boeing 777 Business Direct Booking 92915 70608 17937 35591 110853 062 Regular 64 25 Air India BZL DXB 4 2 25 9 07 4 2 25 13 15 4 136763254 Direct Boeing 787 First Class Direct Booking 131541 4181 23731 21272 155272 6308 Eid 74 26 Emirates CXB BZL 3 2 25 5 10 3 2 25 5 53 0 725931688 Direct Airbus A320 First Class Online Website 10280 50155 200 12576 60186 Regular 3 27 FlyDubai CGP DEL 6 13 25 15 23 6 13 25 18 12 2 829321723 Direct Boeing 787 First Class Online Website 44178 19074 8626 728611 52804 91935 Regular 31 28 Kuwait Airways ZYL DEL 5 2 25 1 04 5 2 25 3 50 2 769580166 Direct Boeing 737 Economy Travel Agency 38828 39908 7824 259861 46652 65894 Regular 75 29 Etihad Airways SPD CXB 5 17 25 8 34 5 17 25 9 26 0 877167343 Direct Airbus A320 First Class Online Website 11427 29956 200 11627 29956 Regular 12 30 US Bangla Airlines ZYL DXB 2 8 26 2 14 2 8 26 6 12 3 97069126 1 Stop Boeing 737 Business Direct Booking 89500 24333 17425 0365 106925 2798 Winter Holidays 90 31 Air Astra JSR SIN 1 29 26 17 07 1 29 26 20 38 3 521957274 Direct Boeing 737 Economy Direct Booking 10049 92273 7507 48841 17557 41114 Winter Holidays 84 32 AirAsia SPD BKK 1 21 26 0 30 1 21 26 3 30 3 011053367 1 Stop Boeing 787 Business Direct Booking 149105 7413 28365 8612 177471 6025 Winter Holidays 34 33 NovoAir JSR CGP 4 17 25 4 17 4 17 25 5 15 0 967599516 Direct Airbus A320 First Class Direct Booking 12108 86488 200 12308 86488 Regular 42 34 Gulf Air JSR SIN 2 4 25 1 18 2 4 25 4 35 3 292682693 1 Stop Boeing 737 First Class Online Website 131807 1354 25771 07031 157578 2057 Regular 28 35 Singapore Airlines CGP JSR 6 20 25 10 28 6 20 25 11 29 1 031768606 Direct Airbus A320 Economy Direct Booking 2559 775534 200 2759 775534 Regular 78 36 Air India CXB DEL 12 2 25 8 01 12 2 25 10 53 2 875249901 1 Stop Boeing 737 First Class Online Website 59474 57647 10921 18647 70395 76295 Winter Holidays 12 37 Air India CGP DEL 10 2 25 8 04 10 2 25 10 47 2 730879963 Direct Boeing 787 Business Travel Agency 92544 76016 15881 71402 108426 4742 Regular 42 38 Air India RJH JSR 5 5 25 12 31 5 5 25 13 01 0 5 Direct Airbus A320 Business Direct Booking 6290 514205 200 6490 514205 Regular 76 39 IndiGo BZL SIN 10 6 25 7 48 10 6 25 11 01 3 227268312 Direct Boeing 787 First Class Travel Agency 276265 4528 47439 81791 323705 2707 Regular 14 40 Biman Bangladesh Airlines CXB YYZ 3 11 25 19 42 3 12 25 11 13 15 52208376 1 Stop Airbus A350 First Class Online Website 108467 8378 22270 17567 130738 0134 Regular 60 41 British Airways JSR DOH 1 12 26 15 18 1 12 26 19 54 4 614482927 1 Stop Boeing 787 First Class Travel Agency 279130 8776 45869 63163 325000 5092 Winter Holidays 86 42 Qatar Airways CGP ZYL 3 3 25 12 30 3 3 25 13 26 0 93610711 Direct Airbus A320 Business Direct Booking 5589 928587 200 5789 928587 Regular 61 43 Malaysian Airlines ZYL DAC 10 1 25 12 00 10 1 25 12 36 0 608724217 Direct Airbus A320 Economy Direct Booking 3240 844749 200 3440 844749 Regular 14 44 Air Arabia RJH DXB 4 5 25 11 42 4 5 25 15 14 3 534804894 Direct Boeing 737 Economy Online Website 12779 45712 5916 918567 18696 37568 Regular 52 45 Air Arabia RJH YYZ 2 18 25 9 38 2 19 25 0 18 14 66919956 1 Stop Boeing 777 Economy Direct Booking 6484 838386 6972 725758 13457 56414 Regular 39 46 Saudia BZL DOH 12 29 25 23 54 12 30 25 4 01 4 129175212 1 Stop Boeing 787 First Class Direct Booking 159875 8422 27981 37633 187857 2185 Winter Holidays 32 47 Thai Airways SPD DAC 11 25 25 18 23 11 25 25 19 09 0 783007477 Direct Airbus A320 Business Direct Booking 8887 917374 200 9087 917374 Regular 11 48 SriLankan Airlines ZYL BZL 5 26 25 12 34 5 26 25 13 28 0 9076138 Direct Airbus A320 First Class Travel Agency 10444 21879 200 10644 21879 Regular 80 49 FlyDubai ZYL RJH 1 8 26 4 27 1 8 26 5 33 1 100098149 Direct Airbus A320 Business Travel Agency 7782 76598 200 7982 76598 Winter Holidays 14 50 Saudia JSR ZYL 5 5 25 2 54 5 5 25 4 05 1 197954497 Direct Airbus A320 Business Travel Agency 7770 564068 200 7970 564068 Regular 35 51 AirAsia CGP ZYL 10 29 25 3 51 10 29 25 4 46 0 924254851 Direct Airbus A320 Business Online Website 8915 708871 200 9115 708871 Regular 7 52 AirAsia CXB IST 3 16 25 23 12 3 17 25 6 41 7 496287891 1 Stop Airbus A350 Business Travel Agency 111243 8754 20686 58131 131930 4567 Regular 69 53 Gulf Air CXB JSR 4 9 25 20 38 4 9 25 21 43 1 085205134 Direct Airbus A320 First Class Direct Booking 10177 45048 200 10377 45048 Regular 25 54 Saudia CGP KUL 8 6 25 0 38 8 6 25 3 24 2 767653785 Direct Boeing 787 Economy Travel Agency 47658 70818 13148 80623 60807 5144 Regular 81 55 US Bangla Airlines SPD CCU 1 25 26 14 49 1 25 26 15 56 1 124545947 Direct Airbus A320 First Class Travel Agency 228613 6896 36292 05344 264905 743 Winter Holidays 69 56 Singapore Airlines BZL RJH 2 26 26 14 03 2 26 26 14 57 0 911553765 Direct Airbus A320 First Class Travel Agency 10220 43625 200 10420 43625 Winter Holidays 71 57 Malaysian Airlines RJH SIN 3 31 25 12 14 3 31 25 15 53 3 665123916 Direct Boeing 737 Business Online Website 110837 4784 22625 62176 133463 1002 Eid 84 58 SriLankan Airlines ZYL CCU 2 12 25 20 13 2 12 25 21 45 1 536022742 Direct Airbus A320 Economy Online Website 11723 53902 3758 530853 15482 06987 Regular 26 59 British Airways BZL JFK 10 18 25 18 56 10 19 25 9 04 14 14209864 2 Stops Airbus A350 Economy Online Website 6750 158376 7012 523756 13762 68213 Regular 8 60 Biman Bangladesh Airlines ZYL CCU 3 26 25 22 47 3 27 25 0 10 1 393668951 Direct Airbus A320 Economy Online Website 16359 00865 4453 851297 20812 85994 Regular 76 61 Gulf Air CGP ZYL 5 23 25 0 03 5 23 25 1 08 1 087960082 Direct Airbus A320 Business Online Website 5849 763414 200 6049 763414 Regular 77 62 Saudia BZL IST 12 11 25 5 36 12 11 25 12 07 6 51693468 1 Stop Boeing 777 First Class Travel Agency 40848 34611 10127 25192 50975 59803 Winter Holidays 85 63 SriLankan Airlines CXB SIN 11 6 25 11 39 11 6 25 14 43 3 083086168 Direct Boeing 787 Economy Travel Agency 17042 76893 8556 415339 25599 18427 Regular 40 64 Air India CXB DAC 5 22 25 20 18 5 22 25 21 20 1 048082913 Direct Airbus A320 Economy Online Website 3437 727791 200 3637 727791 Regular 16 65 Emirates JSR RJH 8 5 25 17 51 8 5 25 18 21 0 5 Direct Airbus A320 Business Direct Booking 7430 165341 200 7630 165341 Regular 61 66 Emirates RJH SIN 11 27 25 20 22 11 27 25 23 58 3 603712739 Direct Boeing 787 Economy Online Website 14991 2793 8248 691894 23239 97119 Regular 50 67 Emirates CXB DOH 2 14 25 4 54 2 14 25 9 38 4 743909808 Direct Boeing 737 First Class Direct Booking 29246 99573 8387 049359 37634 04508 Regular 30 68 SriLankan Airlines DAC BKK 4 1 25 23 39 4 2 25 2 17 2 634417568 Direct Boeing 787 Economy Direct Booking 19916 33568 8987 450351 28903 78603 Eid 10 69 Saudia ZYL JSR 4 3 25 16 29 4 3 25 17 37 1 149522839 Direct Airbus A320 Business Direct Booking 4185 108261 200 4385 108261 Regular 77 70 Malaysian Airlines SPD DXB 1 8 26 18 20 1 8 26 21 54 3 581720119 Direct Boeing 787 Business Direct Booking 18755 73577 6813 360365 25569 09613 Winter Holidays 65 71 Emirates BZL RJH 9 29 25 9 25 9 29 25 10 11 0 773295302 Direct Airbus A320 Business Direct Booking 8949 739069 200 9149 739069 Regular 48 72 Cathay Pacific RJH JED 2 25 25 11 03 2 25 25 16 19 5 282413134 1 Stop Boeing 777 Business Travel Agency 24049 12042 7607 368063 31656 48848 Regular 41 73 Singapore Airlines JSR CGP 8 5 25 17 18 8 5 25 18 20 1 037265028 Direct Airbus A320 First Class Travel Agency 8545 879516 200 8745 879516 Regular 89 74 Etihad Airways CXB RJH 11 8 25 12 29 11 8 25 14 11 1 711153278 Direct Airbus A320 Economy Direct Booking 2340 772004 200 2540 772004 Regular 28 75 Singapore Airlines CGP SIN 8 14 25 13 12 8 14 25 16 22 3 182107402 1 Stop Boeing 787 Economy Travel Agency 42123 41863 12318 51279 54441 93142 Regular 41 76 Air Astra JSR JFK 3 4 26 3 29 3 4 26 17 11 13 7153457 1 Stop Airbus A350 Business Travel Agency 47195 0713 13079 26069 60274 33199 Regular 86 77 Saudia CGP JSR 4 28 25 6 31 4 28 25 7 31 1 004306591 Direct Airbus A320 First Class Travel Agency 9625 935384 200 9825 935384 Regular 34 78 Emirates BZL YYZ 9 13 25 12 09 9 14 25 2 22 14 23093105 1 Stop Boeing 777 Economy Online Website 23618 59857 9542 789785 33161 38835 Regular 58 79 AirAsia ZYL BZL 3 17 25 23 08 3 18 25 0 06 0 981396782 Direct Airbus A320 First Class Direct Booking 11612 76839 200 11812 76839 Regular 14 80 US Bangla Airlines ZYL SPD 8 12 25 7 29 8 12 25 8 35 1 104618714 Direct Airbus A320 Economy Online Website 2698 699088 200 2898 699088 Regular 79 81 Vistara JSR YYZ 10 9 25 3 00 10 9 25 16 45 13 76154982 1 Stop Boeing 777 First Class Direct Booking 148048 521 28207 27815 176255 7991 Regular 74 82 British Airways JSR BKK 3 1 25 7 24 3 1 25 10 05 2 689199349 1 Stop Boeing 737 First Class Online Website 110146 5627 22521 98441 132668 5471 Regular 8 83 Vistara JSR DXB 10 8 25 16 44 10 8 25 20 13 3 488882967 1 Stop Boeing 737 Economy Travel Agency 32017 38845 8802 608268 40819 99672 Regular 5 84 Etihad Airways RJH CGP 5 22 25 6 56 5 22 25 8 23 1 458642595 Direct Airbus A320 First Class Travel Agency 11831 46827 200 12031 46827 Regular 48 85 Air Astra JSR DXB 3 31 25 12 24 3 31 25 16 08 3 737968507 1 Stop Boeing 737 First Class Direct Booking 81076 5139 16161 47709 97237 99099 Eid 51 86 Gulf Air RJH BKK 9 19 25 4 30 9 19 25 7 33 3 057784243 Direct Boeing 787 Business Direct Booking 125853 8586 24878 0788 150731 9374 Regular 49 87 Thai Airways JSR CXB 4 12 25 18 42 4 12 25 19 55 1 221247593 Direct Airbus A320 Business Online Website 9904 29165 200 10104 29165 Regular 8 88 IndiGo DAC RJH 10 31 25 0 38 10 31 25 1 18 0 669711635 Direct Airbus A320 First Class Direct Booking 11379 96539 200 11579 96539 Regular 53 89 Saudia ZYL JFK 6 26 25 21 00 6 27 25 10 36 13 61290141 2 Stops Boeing 777 Business Direct Booking 81093 07186 18163 96078 99257 03264 Regular 78 90 AirAsia CGP JED 7 19 25 18 04 7 19 25 23 59 5 925472546 2 Stops Airbus A350 Business Online Website 90603 72517 17590 55878 108194 2839 Regular 49 91 Gulf Air RJH SIN 6 20 25 14 10 6 20 25 17 44 3 573913662 Direct Boeing 737 Business Travel Agency 40664 82296 12099 72344 52764 54641 Regular 15 92 US Bangla Airlines JSR IST 12 16 25 17 21 12 16 25 23 49 6 474495913 1 Stop Boeing 777 Business Direct Booking 88557 3301 17283 59952 105840 9296 Winter Holidays 31 93 Malaysian Airlines JSR JFK 10 29 25 8 41 10 29 25 21 49 13 1458004 1 Stop Airbus A350 Economy Travel Agency 24169 80102 9625 470153 33795 27117 Regular 78 94 Cathay Pacific CXB SPD 9 1 25 17 59 9 1 25 18 52 0 8841424 Direct Airbus A320 First Class Travel Agency 11655 36559 200 11855 36559 Regular 73 95 Biman Bangladesh Airlines ZYL BZL 12 23 25 15 59 12 23 25 16 55 0 935792563 Direct Airbus A320 First Class Online Website 12819 55001 200 13019 55001 Winter Holidays 27 96 FlyDubai ZYL LHR 11 7 25 4 45 11 7 25 14 07 9 380587028 1 Stop Boeing 777 Business Direct Booking 133018 5996 25952 78994 190765 6675 Regular 2 97 British Airways CGP DEL 5 1 25 3 47 5 1 25 6 14 2 451861203 Direct Boeing 787 First Class Travel Agency 298096 9212 46714 53818 344811 4594 Regular 19 98 NovoAir ZYL DXB 6 23 25 14 16 6 23 25 18 42 4 440802777 Direct Boeing 737 Business Direct Booking 15528 10454 6329 215681 21857 32022 Regular 86 99 Vistara CXB DAC 10 5 25 15 27 10 5 25 16 28 1 019761989 Direct Airbus A320 Economy Online Website 3592 077014 200 3792 077014 Regular 30 100 Air Astra JSR DAC 12 21 25 2 49 12 21 25 3 19 0 5 Direct Airbus A320 Economy Travel Agency 3286 564171 200 3486 564171 Winter Holidays 69 101 Air India RJH DAC 5 5 25 6 46 5 5 25 7 21 0 598750248 Direct Airbus A320 First Class Online Website 14178 83402 200 14378 83402 Regular 29 102 Malaysian Airlines BZL JFK 2 12 26 2 33 2 12 26 17 17 14 74345569 1 Stop Boeing 777 Business Online Website 138574 3739 26786 15609 165360 53 Winter Holidays 78 103 Air Astra CXB CCU 7 3 25 12 50 7 3 25 14 04 1 238794914 Direct Airbus A320 Business Travel Agency 29806 87801 6471 031702 36277 90971 Regular 49 104 IndiGo SPD RJH 4 8 25 23 16 4 8 25 23 48 0 536116659 Direct Airbus A320 Economy Travel Agency 2303 514391 200 2503 514391 Regular 73 105 Lufthansa JSR JFK 8 26 25 10 54 8 27 25 1 32 14 64853739 1 Stop Boeing 777 First Class Direct Booking 83102 42027 18465 36304 101567 7833 Regular 87 106 Air Arabia SPD DXB 6 4 25 10 40 6 4 25 14 02 3 379857733 Direct Boeing 737 Economy Direct Booking 70364 20993 14554 63149 84918 84142 Hajj 18 107 Turkish Airlines JSR SIN 8 2 25 2 59 8 2 25 6 00 3 02521746 Direct Boeing 787 First Class Direct Booking 189760 1664 34464 02496 224224 1913 Regular 74 108 Air Arabia BZL DEL 11 10 25 15 45 11 10 25 17 57 2 207528282 Direct Boeing 787 First Class Travel Agency 130523 3347 21578 5002 182522 2019 Regular 2 109 Kuwait Airways DAC KUL 1 9 26 23 25 1 10 26 2 29 3 081093342 Direct Boeing 737 Business Travel Agency 118112 17 23716 82549 141828 9955 Winter Holidays 25 110 FlyDubai ZYL JFK 12 30 25 3 01 12 30 25 16 00 12 99464877 2 Stops Boeing 777 Economy Direct Booking 36363 09337 11454 46401 47817 55738 Winter Holidays 69 111 US Bangla Airlines CGP BZL 3 23 25 18 08 3 23 25 18 44 0 60524608 Direct Airbus A320 First Class Direct Booking 13705 25489 200 16686 30587 Regular 1 112 Biman Bangladesh Airlines ZYL CCU 12 22 25 21 56 12 22 25 23 23 1 460545609 Direct Airbus A320 Economy Online Website 58816 17697 10822 42655 69638 60352 Winter Holidays 10 113 Cathay Pacific SPD JSR 12 15 25 12 14 12 15 25 13 05 0 864142556 Direct Airbus A320 First Class Online Website 14876 20484 200 15076 20484 Winter Holidays 41 114 IndiGo RJH LHR 6 11 25 17 54 6 12 25 2 51 8 953086657 1 Stop Airbus A350 First Class Direct Booking 269691 6175 46453 74263 316145 3601 Regular 47 115 Air India ZYL BZL 3 11 25 3 32 3 11 25 4 35 1 055299026 Direct Airbus A320 First Class Online Website 11925 42648 200 12125 42648 Regular 44 116 Saudia JSR SIN 1 7 26 4 26 1 7 26 7 37 3 190548974 1 Stop Boeing 737 First Class Online Website 72936 06207 16940 40931 89876 47138 Winter Holidays 83 117 Thai Airways SPD JSR 5 10 25 11 53 5 10 25 12 54 1 020802939 Direct Airbus A320 Business Online Website 8832 159896 200 9032 159896 Regular 16 118 Saudia ZYL DXB 10 15 25 10 17 10 15 25 14 24 4 129232842 Direct Boeing 737 Business Travel Agency 113088 4907 20963 2736 134051 7643 Regular 64 119 SriLankan Airlines CGP JFK 9 26 25 6 49 9 26 25 21 30 14 68938064 1 Stop Boeing 777 First Class Online Website 114871 1476 23230 67213 138101 8197 Regular 54 120 US Bangla Airlines SPD DAC 9 6 25 20 28 9 6 25 21 25 0 951808757 Direct Airbus A320 First Class Travel Agency 8069 322936 200 8269 322936 Regular 68 121 SriLankan Airlines DAC BZL 6 8 25 7 45 6 8 25 8 15 0 5 Direct Airbus A320 Economy Online Website 4446 614793 200 4646 614793 Hajj 86 122 Air Astra RJH JFK 8 23 25 1 34 8 23 25 14 32 12 98159377 1 Stop Boeing 777 First Class Travel Agency 77587 87813 17638 18172 95226 05985 Regular 70 123 Air Arabia CGP SPD 12 19 25 9 58 12 19 25 11 41 1 730673494 Direct Airbus A320 Economy Direct Booking 2627 187416 200 2827 187416 Winter Holidays 80 124 US Bangla Airlines JSR DXB 8 31 25 23 20 9 1 25 3 06 3 768515525 1 Stop Boeing 737 Economy Online Website 41922 23572 10288 33536 52210 57107 Regular 89 125 Saudia JSR KUL 1 19 25 2 23 1 19 25 5 15 2 866689017 Direct Boeing 787 First Class Travel Agency 53547 77125 14032 16569 67579 93693 Regular 9 126 Saudia DAC IST 8 2 25 22 39 8 3 25 4 54 6 264817512 1 Stop Boeing 777 Economy Online Website 30641 73748 8596 260622 39237 9981 Regular 52 127 Malaysian Airlines JSR JFK 10 10 25 18 57 10 11 25 7 47 12 84929811 1 Stop Airbus A350 Economy Online Website 39366 01538 11904 90231 51270 91769 Regular 84 128 Singapore Airlines CXB SPD 12 13 25 12 25 12 13 25 13 20 0 923230337 Direct Airbus A320 First Class Online Website 16218 80386 200 19702 56463 Winter Holidays 2 129 Biman Bangladesh Airlines CXB BZL 9 12 25 23 12 9 12 25 23 58 0 773036118 Direct Airbus A320 Economy Direct Booking 3260 133581 200 3460 133581 Regular 70 130 Biman Bangladesh Airlines SPD DEL 6 15 25 21 04 6 15 25 22 55 1 85003952 1 Stop Boeing 737 Business Direct Booking 79113 58761

The Answer is in the image, click to view ...

Question: Case Study The Case Study is worth 50 points according to the following rubric Category Criteria Scoring Introduction of data Describe your dataset and an

Case Study

The Case Study is worth 50 points according to the following rubric

Category	Criteria	Scoring
Introduction of data	Describe your dataset and an overview of questions you will be analyzing and explain the big picture of this project	Excellent (4.5-5 pts) Very good (3.5-4 pts) Good (2.5-3 pts) Limited (1.5-2 pts) Poor (0-1 pts)
Question Answers	Effectively answers the questions presented Results are accurate Excel results are included	Excellent (18-20pts) Very good (16-.17.5 pts) Good (14-15.5 pts) Limited (12-13.5 pts) Poor (1-11.5 pts)
Inferential insights	Describe how the answers and results should be interpreted Summarizes the major results Intended message is communicated clearly to a wide audience Provides an interpretation and relates results back to the question of interest and to a big project as a whole	Excellent (13.5-15 pts) Very good (12-12.5 pts) Good (10.5-11.5 pts) Limited (9-10 pts) Poor (1-8.5 pts)
Length/Labeling/Format	Meet the minimum requirement of length for your written report Visualizations, sources, and figures are labeled Report is a submitted as a word/written document and not Excel file Results are within the written interpretations.	Excellent (4.5-5 pts) Very good (3.5-4 pts) Good (2.5-3 pts) Limited (1.5-2 pts) Poor (0-1 pts)
Conclusion of Findings	Effectively summarizes the big picture and results from the case study	Excellent (4.5-5 pts) Very good (3.5-4 pts) Good (2.5-3 pts) Limited (1.5-2 pts) Poor (0-1 pts)

You will be submitting a written report in a Word document (not Excel).
The data analysis is done in Excel, but the final submission is a report of your findings from Excel
You will need to copy and paste the Excel results into your Word document. SCREENSHOTS are not acceptable to include in a written report. Copy/paste all the Excel outputs and results from the templates and from the Data Analysis Tookpak.
For each question explain what you did and why, interpret the results, and think about the consequences and the decisions that the company might make from each results.
The written report should be at least 1000 words (not including Excel outputs).
Label and refer to the graphs as Figure 1, Figure 2, etc.
Don't submit the Excel results separately. For example, they shouldn't be at the end of your report or in an "appendix".
Your Excel outputs should be copied and pasted within the written text of your report and look somewhat like the following example:You work for a company and your manager has identified some questions she would like you to answer using the Flight Data dataset. The dataset is a sample of booked flights in Asia and It includes many variables about the details of those flights.

Questions to Answer

Using that dataset and concepts learned in this course, answer the following questions. Use a 95% confidence level for every interval and test.

Write an introduction of the dataset and analysis from the perspective of you submitting an analytic report to your manager. Then, answer the following. The report should include all of the Excel outputs in addition to your written findings. Copy/paste all the Excel outputs and results from the templates and from the Data Analysis Tookpak.

What does the distribution of the average Total Fare look like?

Explore this by constructing a confidence interval that estimates the average Total Fare of all flights.

What does the distribution of the proportion of flights that are Direct, 1 stop, or 2 stops look like?

Explore this constructing three separate confidence intervals for the proportion of flights that are direct, 1 stop, or 2 stops.

Is there a difference in the average Total Fare between the three categories of Stopovers (Direct, 1 stop, 2 stops)?

Explore this by constructing a hypothesis test that looks to see if there is a significant difference in the average total fare between the three categories of Stopovers. (This is an ANOVA test)

Generate a model that predicts the Total Fare based off of four explanatory variables (Duration Hrs, Base Fare, Tax/Surcharge, and Days before Departure).

Explore this by constructing a multiple regression analysis. Then, best fit the model using the P-value approach.

Evaluate and interpret the best-fit model (in the previous question) for its usefulness and application.

Explore this by interpreting the adjusted R-square statistic and the standard error of the estimates. Interpret each of the slope coefficients of the x-variables in context to the problem from your best-fit model, including all the units of the x-variables and y-variable.

Make some overall conclusions about the analysis as a whole in context to the data analysis you conducted.

You work for a company and your manager has identified some questions she would like you to answer using the Flight Data dataset. The dataset is a sample of booked flights in Asia and It includes many variables about the details of those flights.