here is what I need: Case study only " North- South airlines" the study begin from the page 127 to 128. I need it in 4 Pages.
Again dear Expert, please make sure to include the good chart made in excel software along with graphs and linear regression formula that you have used made in excel as well very easy and simple to understand.
2. Problem Statement
This should include background information on the organization and a description of the problems that the organization has encountered.
3. Analysis
You should address the pertinent areas of consideration.Analyze the considerations and determine their relative importance.Investigate all the possibilities of how the quantitative methods are used in the case study. The analysis must be supported by qualitative and quantitative information such as the outputs from Excel, graphs, quantitative models, and calculation.
4. Discussion Questions( located at the end of case study announcement on right top end corner of the page 128.)
There are several discussion questions included in the case study.You must answer all questions.
5. Conclusions and Recommendations
Draw conclusions from your analysis based on the principles of quantitative methods.
Develop recommendations as if you were a consultant.
Document Preview:
REGRESSION MODELS TEAM w ERA AVG MONTH DJIA STOCK I STOCK2 New York Yankees 103 0.283 4.26 11,168 48.5 32.4 Los Angeles Angels 0.285 97 4.45 2 11,150 48.2 31.7 Boston Red Sox 0.270 95 4.35 II, 186 44.5 3 31.9 Minnesota Twins 0.274 87 4.50 4 II ,381 44.7 36.6 Texas Rangers 0.260 87 4.38 5 11,679 49.3 36.7 Detroit Tigers 0.260 86 4.29 6 12,081 49.3 38.7 Seattle Mariners 0.258 12,222 85 3.87 7 46.1 39.5 Tampa Bay Rays 0.263 84 4.33 8 12,463 46.2 41.2 Chicago White Sox 0.258 79 4.14 12,622 47.7 9 43.3 Toronto Blue Jays 0.266 75 4.47 10 12,269 48.3 39.4 Oakland Athletics 0.262 75 4.26 11 12,354 47.0 40.1 Cleveland Indians 0.264 65 5.06 12 13,063 47.9 42.1 Kansas City Royals 0.259 65 4.83 13 13,326 47.8 45.2 Baltimore Orioles 0.268 64 5.15 (c) Which of the two models is better for predicting (a) Develop a regression model to predict the price the number of victories? of stock 1 based on the Dow Jones Industrial (d) Develop a multiple regression model that in Average. cludes both ERA and batting average. How does (b) Develop a regression model to predict the price of stock 2 based on the Dow Jones Industrial this compare to the previous models? Average. The closing stock price for each of two stocks was ~: 33 (c) Which of the two stocks is most highly corre recorded over a 12-month period. The closing price lated to the Dow Jones Industrial Average over for the Dow Jones Industrial Average (DJIA) was this time period? also recorded over this same time period. These val ues are shown in the following table: Case Study North-South Airline In January 2008, Northern Airlines merged with Southeast Peg was to report back by February 26 with the answer, along Airlines to create the fourth largest U.S. carrier. The new with quantitative and graphical descriptions of the relationship. North-South Airline inherited both an aging fleet of Boeing Peg's first step was to have her staff construct the average 727-300...