Question

Use the results to answer the following questions 1. Which airline did not experience a decline in stock price? 2. What month had the highest stock price change? 3. Which airline showed the greatest change in stock prices (in terms o percentage) from August to December 2014 4. When did American Airlines have a negative percent change in stock price Paste 1 year southwest lunited anair american 13.19 5.5 2.1 2.63 1.72 12.87 15.94 9.24 0.08 8.75 16.54 17.36 10.51 5.66 8.67 11.29 16.01 5.4 3.6 2.79 14-Aug 14-Sep 14-Oct 14-Nov 21.29 13.23 13.32 14-Dec 1.2 Stock Price Change 10 25 Q 20 12 13 14 10 15 16 18 19 southwest united ryanair american delta 24 Aug-14Sep-14Oct-14 Nov-14 Dec-14 26 27 28 29 32 35 Sheet1 Sheet2 Ready

Answer 1

The conclusion would be based on the price chart provided by you.

(1) SOUTHWEST AIRLINE

(as no bar in the chart falls below the x axis)

(4) American airlines have negative percent change in stock prices in the month of SEP-14(as the bar is below the x axis)

(3) use the following formula for calculating change:

(ending price-starting price)/starting price

you can calculate it in excel with more ease as:

sw.	change	uni.	change	rya.	change	amer.	change	delta	change
13.19	-0.58302	2.63	-1.65399	3.6	-0.225	0.08	-110.375	5.66	-2.5318
5.5	-0.61818	-1.72	-8.48256	2.79	-1.56631	-8.75	-2.89029	-8.67	-2.30219
2.1	9.138095	12.87	0.238539	-1.58	-9.37342	16.54	0.049577	11.29	0.418069
21.29	-0.94364	15.94	-0.42033	13.23	0.006803	17.36	-0.39459	16.01	-0.66271
1.2		9.24		13.32		10.51		5.4
average	1.748315		-2.57958		-2.78948		-28.4026		-1.26966
change

you can see that the American airlines have lost more stock prices over the period from august to December.

(2) for this, you can proceed with the same manner in excel as in (3). Note that instead of calculating the change vertically(i.e row wise) you have to calculate the change horizontally (i.e column wise) since you are asked to calculate the price change through months.