Professor Florence Neymotin

Assignment 2

Due Date: 9-27-20

Maximum Points 2 Points

Directions

Assignment 2 is an individual-based project which requires you to obtain the following statistics

for the hypothetical stock prices for the major US banks based on the data provided for this

course:

1. Average weekly stock prices for all of the banks combined

2. Average weekly standard deviations for all the banks combined

3. 95% Cls for each week for all of the banks combined

Create a column for the average weekly stock prices as well as a column for the standard

deviation for each week. To report the parameters for the 95% CI, create two columns. The

statistics for the first week are the following:

Ma,jor US Banks 95% CI

BOA Citibank Chase PNC Wells Fargo ,A. verage ,S. IDV LB UB 91.45 79.82 91.56 91.48 74.18 85.70 8.19 61.14 110.258

In addition to obtaining the statistics discussed above, create a graph displaying the weekly

average stock prices for all of the banks combined. After graphing the weekly average stock

prices, chose Citibank, Chase, PNC, or Wells Fargo, create a monthly Hi-Low chart based on the

hypothetical stock prices reported for your selected bank.

Use the sample memo created for Assignment 2 to report your findings. Address each of the

following questions:

1. What is the decision-making or management issue being addressed?

2. What data are used to answer the decision-making or management issues?

3. What is the analytical method used to analyze the data? 4. What are the findings of the data analyses?

5. What are the decision-making I management implications of the findings