Questions
The project is about airline revenue and the factors that impact it. All the knowledge you...

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...

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.
 
(i) cameba01h.p5-23_g1.JPG (ii) cameba01h.p5-23_g2.JPG
       
(iii) cameba01h.p5-23_g3.JPG (iv) cameba01h.p5-23_g4.JPG
  _________________
  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.
 
Quarter 1 forecast _____5.667____________
Quarter 2 forecast _____3.667____________
Quarter 3 forecast _______4.667__________
Quarter 4 forecast ______6.667___________
   
(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.
 
Quarter 1 forecast _8.9167________________
Quarter 2 forecast ___6.9167______________
Quarter 3 forecast 7.9167_________________
Quarter 4 forecast _9.9167________________
   
(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.
 
  Model developed in part (b) Model developed in part (d)
MSE _________________ _________________
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...

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...

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

A clinical psychologist compares 3 different therapies for treatment of manic-depressive disorder. Clients are assigned at...

  1. A clinical psychologist compares 3 different therapies for treatment of manic-depressive disorder. Clients are assigned at random to the different therapies, they undergo treatment for the same 6-month period, then all are assessed. The assessment consists of counting the number of manic-depressive episodes in the 2-month period following completion of therapy treatment. The results are tabled below. Use SPSS and the steps of hypothesis-testing to find out whether type of therapy matters.

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

  1. State your hypotheses.
  1. Determine the characteristics of the comparison distribution.

  1. Determine the cut-off value for a 5% significance level.
  1. Using SPSS, determine the observed F ratio.

  1. Decide whether or not to reject the null and give a verbal explanation.
  1. Calculate and interpret h2.

  1. Compute the power of the test. How many subjects are needed to detect an effect with a power of .80 and the given effect size?
  1. Assuming a real difference exists, you have a number of a priori hypotheses about the nature of the differences. Using SPSS, compute the following planned contrast, state the rejection level that you used, and state your conclusions (i.e., if you have differences, interpret the difference . . . don’t just state that the means are different):

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....

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...

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...

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...

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:

  1. {6, 6, 6, 6}
  2. {1, 2, 3, 4}
  3. {2, 5, 4, 3}

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...

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:

  • The new business will require a capital expenditure of $5 million at t = 0. This expenditure will be used to purchase new equipment.
  • This equipment will be depreciated according to the following depreciation schedule:

Year                   Rate

1                      0.33

2                      0.45

3                      0.15

4                      0.07

  • The equipment will have no salvage value after four years.
  • If MacDonald goes ahead with the new business inventories will rise by $600,000 at t = 0, and its accounts payable will rise by $300,000 at t = 0. This increase in net operating working capital will be recovered at t = 4.
  • The new business is expected to have an economic life of four years. The business is expected to generate sales of $4 million each year from t = 1 to t=4. Each year, operating costs excluding depreciation are expected to be 80 percent of sales.
  • The company’s tax rate is 40 percent.
  • The company’s weighted average cost of capital is 10 percent.
  • The company is very profitable, so any accounting losses on this project can be used to reduce the company’s overall tax burden.

(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