Term Project Report

Park University Advanced Business Statistics Paper

PowerPoint Presentation

· Prepare a PowerPoint Presentation: minimum of 6 to maximum of 10 pages

· Use Excel Functions for Calculations

1. Stock Analysis

a. Pull 12 Months of daily stock prices (SEP 2019 thru AUG 2020)

i. For Two (2) Stocks

ii. Note: Professor will provide Stocks

2. For the Months of SEP 2019 thru MAY 2020

i. Compute the Average

ii. Compute the Standard Deviation

iii. Compute the Upper & Lower Control Limits at 2 Standard Deviations

3. For the Months of JUN 2020 thru AUG 2020

a. What is the Mean (Average)

b. What is the Median

c. What is the Mode

d. What is the Range (low and high prices)

e. Graph the daily Stock Prices (line graph)

i. Include UCL & LCL

ii. Add Trend Line

iii. Discuss Results (bullets) in PowerPoint Slides

4. Correlation using Excel

a. Perform Correlation Analysis (Data Provided by Professor)

b. Compute Correlation Analysis using Excel

c. Discuss Results

i. Is there a correlation? (positive or negative)

ii. How strong is correlation?

iii. How do you know the strength of Correlation?

iv. www.youtube.com/watch?v=sGlsdHD-lcA

5. Regression using Excel

a. Watch the video below (ii) and display the equation on the chart (like in the video).

i. www.youtube.com/watch?v=g_PH5FKBJJY