The project is about airline revenue and the factors that impact it. All the knowledge you obtain in chapter 4, is enough to do the project.
Revenue of an airline is influenced by several factors, including fuel cost, employees’ salary, operating expenses, maintenance costs, fleet size, available seats. This project aims to find out the influence of some of these factors on revenue for U.S. airline industry for the period of 11 years.
In airline industry one of the variables that represent revenue is “Revenue Passenger mile”.
Attached is the data (revenue passenger mile, fuel cost, salary cost and seat available” of some U.S. airlines for the period of 2005 till 2015. Data has been collected from The Bureau of Transportation Statistics (BTS) database.
Each team should use regression tool to interpret the relation between revenue of airlines and the above mention factors for each year.
Each team should run a regression for each year separately, write the regression equations for each year and compare in which year each of these three factors impacts revenue the most and the least.
Finally, run the regression for whole the period and write the equation line for all observation and interpret the result in terms of the positive/negative influence of factors on revenue.
|
year |
quarter | carrier_name | Fuel cost (000,000) | Salary (000,000) | Average seat miles (000,000) | Revenue Passenger mile (000,000) | |
| 2014 | 1 | American Airlines Inc. | 1,820.97 | 1,477.69 | 76,592.08 | 10,582.29 | |
| 2014 | 2 | American Airlines Inc. | 1,848.52 | 1,519.84 | 79,271.84 | 11,496.72 | |
| 2014 | 3 | American Airlines Inc. | 1,840.16 | 1,495.73 | 80,899.81 | 11,622.45 | |
| 2014 | 4 | American Airlines Inc. | 1,482.13 | 1,496.97 | 78,433.03 | 10,982.28 | |
| 2014 | 1 | Alaska Airlines Inc. | 318.06 | 263.62 | 14,992.37 | 1,963.35 | |
| 2014 | 2 | Alaska Airlines Inc. | 337.92 | 276.94 | 16,192.17 | 2,171.61 | |
| 2014 | 3 | Alaska Airlines Inc. | 350.36 | 273.78 | 17,216.43 | 2,289.97 | |
| 2014 | 4 | Alaska Airlines Inc. | 276.79 | 303.86 | 16,468.02 | 2,116.65 | |
| 2014 | 1 | JetBlue Airways | 463.85 | 349.19 | 20,852.08 | 2,616.91 | |
| 2014 | 2 | JetBlue Airways | 497.26 | 335.01 | 22,779.28 | 2,912.92 | |
| 2014 | 3 | JetBlue Airways | 518.04 | 337.32 | 23,528.60 | 3,064.00 | |
| 2014 | 4 | JetBlue Airways | 435.77 | 350.32 | 22,896.31 | 2,844.41 | |
| 2014 | 1 | Delta Air Lines Inc. | 2,191.20 | 2,102.26 | 94,711.96 | 13,460.82 | |
| 2014 | 2 | Delta Air Lines Inc. | 2,435.70 | 2,425.81 | 109,550.43 | 16,047.02 | |
| 2014 | 3 | Delta Air Lines Inc. | 2,605.49 | 2,497.92 | 117,821.87 | 17,312.32 | |
| 2014 | 4 | Delta Air Lines Inc. | 2,089.33 | 2,334.80 | 102,385.74 | 14,608.75 | |
| 2014 | 1 | Frontier Airlines Inc. | 110.70 | 66.88 | 5,492.58 | 717.32 | |
| 2014 | 2 | Frontier Airlines Inc. | 129.78 | 66.32 | 6,194.93 | 835.44 | |
| 2014 | 3 | Frontier Airlines Inc. | 141.63 | 73.47 | 6,775.41 | 925.54 | |
| 2014 | 4 | Frontier Airlines Inc. | 114.90 | 74.24 | 6,615.24 | 867.83 | |
| 2014 | 1 | Hawaiian Airlines Inc. | 166.33 | 113.86 | 8,088.18 | 1,110.26 | |
| 2014 | 2 | Hawaiian Airlines Inc. | 169.00 | 119.24 | 8,530.87 | 1,184.51 | |
| 2014 | 3 | Hawaiian Airlines Inc. | 175.91 | 120.65 | 9,003.61 | 1,308.91 | |
| 2014 | 4 | Hawaiian Airlines Inc. | 145.62 | 118.92 | 8,532.93 | 1,234.26 | |
| 2014 | 1 | United Air Lines Inc. | 2,253.93 | 2,195.92 | 99,562.00 | 13,853.59 | |
| 2014 | 2 | United Air Lines Inc. | 2,441.23 | 2,247.32 | 110,370.32 | 15,940.16 | |
| 2014 | 3 | United Air Lines Inc. | 2,450.90 | 2,402.58 | 113,818.75 | 16,561.66 | |
| 2014 | 4 | United Air Lines Inc. | 1,896.06 | 2,303.82 | 104,371.59 | 14,803.13 | |
| 2014 | 1 | US Airways Inc. | 817.31 | 756.68 | 37,064.68 | 4,850.37 | |
| 2014 | 2 | US Airways Inc. | 910.87 | 763.02 | 42,721.22 | 5,714.15 | |
| 2014 | 3 | US Airways Inc. | 901.44 | 765.47 | 42,797.10 | 5,651.65 | |
| 2014 | 4 | US Airways Inc. | 667.42 | 713.33 | 37,242.14 | 4,814.87 | |
| 2014 | 1 | Southwest Airlines Co. | 1,261.24 | 1,340.00 | 55,173.46 | 7,125.78 | |
| 2014 | 2 | Southwest Airlines Co. | 1,371.67 | 1,472.42 | 63,036.28 | 6,903.57 | |
| 2014 | 3 | Southwest Airlines Co. | 1,334.88 | 1,435.34 | 63,874.25 | 6,650.69 | |
| 2014 | 4 | Southwest Airlines Co. | 1,114.16 | 1,459.30 | 63,421.77 | 8,022.97 | |
| 2015 | 1 | American Airlines Inc. | 1,031.03 | 1,671.86 | 75,923.24 | 10,511.24 | |
| 2015 | 2 | American Airlines Inc. | 1,149.26 | 1,630.39 | 81,625.00 | 11,659.20 | |
| 2015 | 3 | American Airlines Inc. | 1,532.77 | 2,545.34 | 126,914.65 | 18,111.60 | |
| 2015 | 4 | American Airlines Inc. | 1,242.05 | 2,520.90 | 116,283.51 | 16,293.81 | |
| 2015 | 1 | Alaska Airlines Inc. | 204.36 | 297.90 | 16,695.77 | 2,140.22 | |
| 2015 | 2 | Alaska Airlines Inc. | 234.47 | 303.97 | 17,970.06 | 2,358.63 | |
| 2015 | 3 | Alaska Airlines Inc. | 206.33 | 306.99 | 18,559.50 | 2,451.66 | |
| 2015 | 4 | Alaska Airlines Inc. | 185.06 | 323.65 | 18,609.47 | 2,359.06 | |
| 2015 | 1 | JetBlue Airways | 334.82 | 396.63 | 22,851.64 | 2,908.46 | |
| 2015 | 2 | JetBlue Airways | 371.35 | 396.36 | 24,485.83 | 3,166.36 | |
| 2015 | 3 | JetBlue Airways | 342.23 | 411.56 | 25,991.41 | 3,344.58 | |
| 2015 | 4 | JetBlue Airways | 299.38 | 423.21 | 25,365.14 | 3,173.57 | |
| 2015 | 1 | Delta Air Lines Inc. | 2,423.97 | 2,275.25 | 100,342.79 | 14,031.82 | |
| 2015 | 2 | Delta Air Lines Inc. | 2,177.48 | 2,648.54 | 114,687.64 | 16,430.01 | |
| 2015 | 3 | Delta Air Lines Inc. | 1,719.52 | 2,884.14 | 122,547.57 | 17,751.82 | |
| 2015 | 4 | Delta Air Lines Inc. | 1,524.08 | 2,637.46 | 103,295.93 | 14,876.51 | |
| 2015 | 1 | Frontier Airlines Inc. | 83.79 | 74.48 | 6,865.15 | 871.44 | |
| 2015 | 2 | Frontier Airlines Inc. | 95.51 | 67.14 | 7,678.22 | 986.09 | |
| 2015 | 3 | Frontier Airlines Inc. | 84.16 | 65.28 | 7,887.85 | 1,039.46 | |
| 2015 | 4 | Frontier Airlines Inc. | 70.31 | 106.19 | 8,559.76 | 1,121.54 | |
| 2015 | 1 | Hawaiian Airlines Inc. | 106.96 | 125.60 | 8,443.48 | 1,195.99 | |
| 2015 | 2 | Hawaiian Airlines Inc. | 107.87 | 131.09 | 8,863.41 | 1,245.18 | |
| 2015 | 3 | Hawaiian Airlines Inc. | 101.53 | 132.12 | 9,326.04 | 1,324.22 | |
| 2015 | 4 | Hawaiian Airlines Inc. | 84.45 | 136.89 | 8,769.90 | 1,260.02 | |
| 2015 | 1 | United Air Lines Inc. | 1,324.81 | 2,358.19 | 100,228.00 | 14,183.53 | |
| 2015 | 2 | United Air Lines Inc. | 1,555.46 | 2,562.83 | 114,082.60 | 16,255.15 | |
| 2015 | 3 | United Air Lines Inc. | 1,402.04 | 2,603.53 | 117,983.54 | 17,112.84 | |
| 2015 | 4 | United Air Lines Inc. | 1,108.57 | 2,489.05 | 107,618.57 | 15,378.46 | |
| 2015 | 1 | Southwest Airlines Co. | 833.83 | 1,490.22 | 64,668.39 | 8,178.52 | |
| 2015 | 2 | Southwest Airlines Co. | 957.47 | 1,685.52 | 73,038.10 | 7,915.15 | |
| 2015 | 3 | Southwest Airlines Co. | 889.48 | 1,775.64 | 72,807.00 | 7,871.24 | |
| 2015 | 4 | Southwest Airlines Co. | 753.80 | 1,738.04 | 70,828.09 |
9,374.66 |
In: Operations Management
Problem 5-23
Consider the following time series data.
| Quarter | Year 1 | Year 2 | Year 3 |
| 1 | 4 | 6 | 7 |
| 2 | 2 | 3 | 6 |
| 3 | 3 | 5 | 6 |
| 4 | 5 | 7 | 8 |
| (a) | Choose the correct time series plot. | ||||||||||||
|
|||||||||||||
| _________________ | |||||||||||||
| What type of pattern exists in the data? | |||||||||||||
| _________________ | |||||||||||||
| (b) | Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. | ||||||||||||
| If required, round your answers to three decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) | |||||||||||||
| Value = __________6.667_______ + ___-1______________ Qtr1t + _____-3____________ Qtr2t + __________-2_______ Qtr3t | |||||||||||||
| (c) | Compute the quarterly forecasts for next year based on the model you developed in part (b). | ||||||||||||
| If required, round your answers to three decimal places. | |||||||||||||
|
|||||||||||||
| (d) | Use a multiple regression model to develop an equation to account for trend and seasonal effects in the data. Use the dummy variables you developed in part (b) to capture seasonal effects and create a variable t such that t = 1 for Quarter 1 in Year 1, t = 2 for Quarter 2 in Year 1,… t = 12 for Quarter 4 in Year 3. | ||||||||||||
| If required, round your answers to three decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) | |||||||||||||
| Value = 3.4167______________ + __0.2188______________ Qtr1t + _____-2.1875___________ Qtr2t + __-1.5938_______________ Qtr3t + ___0.4063______________ t | |||||||||||||
| (e) | Compute the quarterly forecasts for next year based on the model you developed in part (d). | ||||||||||||
| Round your interim computations and final answers to three decimal places. | |||||||||||||
|
|||||||||||||
| (f) | Is the model you developed in part (b) or the model you developed in part (d) more effective? | ||||||||||||
| If required, round your intermediate calculations and final answer to three decimal places. | |||||||||||||
|
|||||||||||||
| I only need (f) answered | |||||||||||||
| I only need (f) answered Both MSE needs to be included for part (b) and (d). | |||||||||||||
In: Other
Consider the following game. Ann chooses rows, and Bob chooses columns.
[12 marks]
LMR
|
3 4 |
2 0 |
1 3 |
|
3 2 |
4 4 |
4 0 |
|
0 2 |
1 1 |
0 1 |
U
C
D
(a) Find all pure strategy Nash Equilibria.
(b) Find the set of Rationalizable strategies for each player. Find a dominating strategy for each deletion.
(c) Is there a Nash equilibrium in which Bob puts strictly positive probability on L and M but none on R? If so find it; if not explain why not. (Explanation should be 3 sentances or fewer.)
(d) Is there a mixed strategy Nash equlibrium in which Bob puts strictly positive prob- ability on L and R but none on M? If so find it; If not explain why not. (Explanation should be 3 sentances or fewer.)
(e) Is there a mixed strategy Nash equlibrium in which Bob puts strictly positive prob- ability on M and R but none on L AND Ann puts strictly positive probability on both U and C? If so find it; If not explain why not. (Explanation should be 3 sentances or fewer.)
In: Economics
3.1 Write code that creates an ArrayList object named list and fills list with these numbers (using one or a pair of for or while loops): 0 1 2 3 4 0 1 2 3 4
3.2 Consider the ArrayList object named list containing these Integers: list = { 1, 2, 3, 4, 5, 4, 3, 2, 1, 0 } What are the contents of list after this loop completes? for (int i = 1; i < 10; ++i) { list.set(i, list.get(i) + list.get(i-1)); }
3.3 Write an enhanced for loop that counts how many numbers in an ArrayList object named list are negative. Print the count after the loop terminates.
3.4 Write a method named arrayListSum() that has one parameter pList which is an object of the class ArrayList . The method shall return the sum of the elements of pList.
3.5 Write a method named named arrayListCreate() that has two int parameters pLen and pInitValue. The method shall create and return a new ArrayList object which has exactly pLen elements. Each element shall be initialized to pInitValue.
3.6 Write a void method named insertName() that has two input parameters: (1) pList which is an object of ArrayList link in course schedule where each element of pList is a person's name; and (2) a String object named pName. Assume the names in pList are sorted into ascending order. The method shall insert pName into pList such that the sort order is maintained.
3.7 Write a void method named arrayListRemove() which has two parameters: pList is an object of the ArrayList class and pValue is an int. The method shall remove all elements from pList that are equal to pValue.
In: Computer Science
|
Therapy A |
Therapy B |
Therapy C |
|
5 |
3 |
5 |
|
2 |
2 |
4 |
|
3 |
3 |
3 |
|
1 |
1 |
6 |
|
4 |
4 |
5 |
|
4 |
5 |
6 |
|
3 |
3 |
7 |
|
0 |
2 |
4 |
|
2 |
2 |
7 |
|
4 |
1 |
5 |
Contrast Hypothesis 1: μTherapyA ≠ μTherapyC
Assume now that the clinical psychologist had no a priori hypotheses about the nature of any differences. Instead, the researcher wants to compute all possible pairwise comparisons post-hoc. Use SPSS to compute all possible pairwise comparisons. What are your results? What do you conclude?
In: Statistics and Probability
Suppose C is a m × n matrix and A is a n × m matrix. Assume CA = Im (Im is the m × m identity matrix). Consider the n × m system Ax = b.
1. Show that if this system is consistent then the solution is unique.
2. If C = [0 ?5 1
3 0 ?1]
and A = [2 ?3
1 ?2
6 10] ,,
find x (if it exists) when
(a) b =[1
0
3]
(b) b =[ 7
4
22] .
In: Math
The topic you wish to pursue. (1 paragraph)Identify your purpose: Why are you interested in this topic? (2-3 paragraphs)Define and describe your intended target audience. (1 paragraph)Provide a list of 4 – 8 research questions. (list 4-8 questions)Adhere to APA formatting throughout.
In: Nursing
Consider the following set of vectors in R6
S={[-9 7 -8 3 0 -5], [1 -7 3 2 -8 -8], [-6 -14 1 9 -23 -29], [11 -21 14 1 -16 -11], [8 16 -8 8 10 1], [17 -7 13 -8 8 18]
(a) (2 points) Demonstrate that S is not a basis for R6.
(b) (4 points) Let H = Span S. Find a basis for H and determine its dimension.
(c) (2 points) Determine whether v= [1,1,1,−1,−1,−1] ^T belongs in H or not.
(d) (6 points) Find a basis for R6 consists of the basis vectors of H found in part (b) and some additional linearly independent vectors.
(e) (4 points)Suppose A is a 6×6 matrix and T(x) =Ax. Show that T(H), the set of images of vectors of H, is a subspace of R6.
(f) (3 points) Show that dimT(H)≤dimH
(g) (4 points) Suppose A is invertible. Show that dimT(H) = dimH.
(h) (5 points)Suppose K is a 4 dimensional subspace of R6. Show that Hand K must have a nonzero vector in common.Hint: Start with bases for the two subspaces. If H andKonly have the trivial vector in common, then what’s a basis for the subspace H+K?
In: Advanced Math
This problem deals with rolling four fair dice (each number has an equal probability of coming up). The four dice are rolled three times. The three rolls of four dice are:
The probability for each of them is 7.71*10^-4 so
Rank the rolls in terms of probability, with the most likely on the left and least likely on the right
In: Statistics and Probability
Questions #(1) to # (3) are based on the following information.
MacDonald Publishing is considering entering a new line of business. In analyzing the potential business, their financial staff has accumulated the following information:
Year Rate
1 0.33
2 0.45
3 0.15
4 0.07
(1). How much is the total initial investment outlay (total net cash flow at t = 0) and terminal cash flow at t=4?
(2). How much is the Operating Cash Flow at t=1,t=2, t=3, and t=4?
(3). What is the expected net present value (NPV) of the new business?
In: Finance