Question

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

Answer #1

Middle Bollinger Band = 20-day simple moving average (SMA) => Using AVERAGE function in Excel =331.28Upper Bollinger Band = 20-day SMA + (20-day standard deviation of price x 2) => Using STDEVPA function in excel = 331.28 + (5.54397*2) =342.368Lower 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!

Write the null and alternative hypothesis for a two-tailed test
for each of the following variables: (10 points)
Student Ht Wt Age (Yrs) Shoe Size Waist Size Pocket
Change
01 64 180 39 07 36 018
02 66 140 31 09 30 125
03 69 130 31 09 25 151
04 63 125 36 07 25 011
05 68 155 24 08 31 151
06 62 129 42 06 32 214
07 63 173 30 08 34 138
08 60...

Use the below data on Company A share price to calculate for
each day: the 3 day simple moving average and the exponential
moving averaging, with a smoothing weight of 0.8.
Date
Company A
23/08/2018
163.0
26/08/2018
163.0
27/08/2018
167.0
28/08/2018
167.5
29/08/2018
163.5
30/08/2018
165.5
must show all work step by step

Patient #
Service
Discharge Date
Admit Date & Time
Procedure Start Time
Procedure End Time
Physician Action
Quality Code
Notes
2
CD
12/23/14
12/23/2014;1230
12/23/2014;1620
No time noted on update stamp
3
EN
12/04/14
12/04/2014; 0704
12/04/2014;0915
H&P dated June 2014
4
EN
12/10/14
12/10/2014;0647
12/10/2014;0844
No update stamp; signed, dated & timed at 0505
5
EN
12/19/14
12/19/14
12/19/2014;1426
Op report dictated 12/22
6
EN
12/09/14
12/07/201;0614
12/07/2014;0751
No date/time on limited exam
7
GS
12/26/14
12/26/14
H&P dated...

The following data are believed to have come from a normal
distribution. Use the goodness of fit test and = .05 to
test this claim. Use Table 12.4.
18
23
21
24
18
22
18
22
19
13
10
20
17
20
20
20
17
14
24
23
22
43
28
27
26
29
28
33
22
28
Using six classes, calculate the value of the test statistic (to
2 decimals).______
The p value is ? _________
Conclusion? Cannot reject assumption...

Find the total amount of ’Deposit’ transactions at the
bank.
Find the list of transactions (statement) of September 2019
(09/01/2019 to 09/30/2019) for account ’1111222233331441’ (note:
look at the date format).
Find the balance of ’1111222233331441’ before 09/01/2019 ((not
including 09/01/2019).
Find the name of the customer that deposited the highest amount
with one transaction (include the transaction amount).
Bank.sql is under this statement.
DROP DATABASE IF EXISTS Bank;
CREATE DATABASE Bank;
USE Bank;
DROP TABLE IF EXISTS transaction;
DROP...

For each account of the previous question, compute the Balance,
and return a table that shows the account number, type, and balance
for each account (hint: use UNION).
The list of customer names that have transactions greater than
or equal to one thousand dollars.
A) Answer this question using only nested queries (i.e., each
select is over only one table). B) Answer this query using
joins.
Bank.sql is under this statement.
DROP DATABASE IF EXISTS Bank;
CREATE DATABASE Bank;
USE...

Rounded to the nearest whole number, what is the standard
deviation for Google weekly closing prices from December 12, 2008
to December 4, 2009? Use the data set Google Closing Prices.xlsx
(in section 11 of this module) to determine your answer. NOTE: The
standard deviation function in Excel (for recent versions) has .p
for a population and .s for a sample. we're treating everything as
a sample!
4-Dec-09
585.01
27-Nov-09
579.76
20-Nov-09
569.96
13-Nov-09
572.05
6-Nov-09
551.1
30-Oct-09
536.12
23-Oct-09...

2. The following data was collected for zero coupon Treasury
bonds. Based on this information, compute the risk-free rates for
the 6month – 10-year horizon, in increments of 6 months (i.e.,
compute risk-free rates for 6 months, 1-year, 1.5- year, etc.)
Maturity
Price
Risk-free rate
0.5
98:26
1.0
97:15
1.5
96:31
2.0
96:09
2.5
95:04
3.0
94:18
3.5
93:14
4.0
91:04
4.5
90:18
5.0
89:13
5.5
86:19
6.0
85:30
6.5
84:23
7.0
83:20
7.5
82:19
8.0
81:12
8.5
80:03
9.0...

Demand for jelly doughnuts on Saturdays at Don’s Doughnut Shoppe
is shown in the following table.
Demand
(dozens)
Relative
Frequency
Demand
(dozens)
Relative
Frequency
19
.01
25
.10
20
.05
26
.11
21
.12
27
.10
22
.18
28
.04
23
.13
29
.02
24
.14
a-1.
Determine the optimal number of doughnuts, in dozens, to stock
if labor, materials, and overhead are estimated to be $3.20 per
dozen, doughnuts are sold for $4.80 per dozen, and leftover
doughnuts at...

Demand for jelly doughnuts on Saturdays at Don’s Doughnut Shoppe
is shown in the following table.
Demand
(dozens)
Relative
Frequency
Demand
(dozens)
Relative
Frequency
19
.01
25
.10
20
.05
26
.11
21
.12
27
.10
22
.18
28
.04
23
.13
29
.02
24
.14
a-1.
Determine the optimal number of doughnuts, in dozens, to stock
if labor, materials, and overhead are estimated to be $2.65 per
dozen, doughnuts are sold for $4.80 per dozen, and leftover
doughnuts at...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 28 minutes ago

asked 34 minutes ago

asked 58 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago

asked 2 hours ago

asked 3 hours ago