Hello,

I have a Math project that needs to be completed. However, I do not understand Excel calculations. Can someone help me. I have the directions/rubrik.

PowerPoint Presentation

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

Include Stock Analysis and Compound Interest Comparison

Use Excel Functions for Calculations

1.Stock Analysis

a.Pull 12 Months of daily stock prices (1 Jul 2019 thru 1Jul 2020)

From Yahoo Finance.

i.For Two (2) Stocks (TESLA & UPS)

ii.Note:Can't be in the same Industry

iii.Go to Historical Data, set dates as 1 July 2019 thru 1 Jul 2020), click done, then click apply.

iv.Convert csv file to Excel worksheet.

2.For the Months of JUL 2019 thru March 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 April 2020 thru June 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.Calculate Compound Interest (include in PowerPoint Presentation)

a.Initial Investment = $0

b.Monthly Contribution = $500 (40 years) and $1,000 (20 years)

c.Length in Time in Years = 40 ($500) and 20 ($1,000)

d.Estimated Interest Rate = 8

e.Interest Rate Variance = 2

f.Compound Frequency = Annual

g.https://www.investor.gov/

a.https://www.investor.gov/financial-tools-calculators/calculators/compound-interest-calculator

b.Compare & Present Results in PowerPoint Slides

c.Include Graphs in your PowerPoint Slides