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. click “update”.

If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed within $45 of the mean for that year?

Solution

P( -45 / 236 / srqt(30) < z<45 / 236 / srqt(30) )

P( -1.04<z<1.04) = 1 -0.1492 -0.1492 = 0.7016