Question

# Use the data for ATT to calculate the latest values of the: Bollinger Bands and Stochastic...

Use the data for ATT to calculate the latest values of the: Bollinger Bands and Stochastic Oscillator. ∑ (x-mean)^2 is 614.712.  Hint: Bollinger Bands use 20 days of data, Stochastic Oscillator uses 14 days.

 Date Copmany XYZ 09/08/2017 331.5 12/08/2017 330 13/08/2017 332.3 14/08/2017 327.2 15/08/2017 326.6 16/08/2017 326.8 19/08/2017 323.2 20/08/2017 329.2 21/08/2017 328.4 22/08/2017 331.5 23/08/2017 333.3 26/08/2017 333.3 27/08/2017 327.2 28/08/2017 324 29/08/2017 331.8 30/08/2017 326.3 02/09/2017 339.2 03/09/2017 338.9 04/09/2017 341.4 05/09/2017 343.5

must show all work step by step

```Middle Bollinger Band = 20-day simple moving average (SMA) => Using AVERAGE function in Excel = 331.28
Upper Bollinger Band = 20-day SMA + (20-day standard deviation of price x 2) => Using STDEVPA function in excel = 331.28 + (5.54397*2) = 342.368
Lower Bollinger Band = 20-day SMA - (20-day standard deviation of price x 2) => Using STDEVPA function in excel = 331.28 - (5.54397*2) = 320.192```

Stochastic Oscillator (%K) Is calculated as:

%K = (C - L14) / (H14 - L14) *100

where

C = The most recent closing price => 343.5

L14 = The lowest price traded of the 14 previous days => using excel MIN = 323.2

H14 = The highest price traded of the same 14-day period => using excel MAX = 343.5

%K = 100%

Let me know in case of any issues. Enjoy learning. Good luck!