Go to httpswwwgooglecomfinancehistoricalqNASDAQGOOG Set the

Go to https://www.google.com/finance/historical?q=NASDAQ:GOOG

Set the date range to be 7/1/2014 to 7/1/2015. Complete this assignment within a single Excel file. Show your work or explain how you obtained each of your answers. Answers with no work and no explanation will receive no credit.

If a person bought one share of Google stock within the last year, what is the probability that the stock on that day closed at more than $600?

Solution

using mean = 533.73

SD = 6.11

n = 30

P( x > 600 )

P( z > 600-533.73 / (6.1 )

P( z >10.86) = 0.000005