PROJECT 3 INSTRUCTIONS Based on Brase & Brase: sections6.1-6.3 Visit the NASDAQ historical prices weblink. First, set thedate range to be for exactly 1 year ending on the Monday that thiscourse started. For example, if the current term started on April1, 2018, then use April 1, 2017 – March 31, 2018. (Do NOT use thesedates. Use the dates that match up with the current term - MYCOURSE STARTED ON JANUARY 14, 2018.) Do this by clicking on theblue dates after “Time Period”. Next, click the “Apply” button.Next, click the link on the right side of the page that says“Download Data” to save the file to your computer. This projectwill only use the Close values. Assume that the closing prices ofthe stock form a normally distributed data set. This means that youneed to use Excel to find the mean and standard deviation. Then,use those numbers and the methods you learned in sections 6.1-6.3of the course textbook for normal distributions to answer thequestions. Do NOT count the number of data points. Complete thisportion of the assignment within a single Excel file. Show yourwork or explain how you obtained each of your answers. Answers withno work and no explanation will receive no credit. 1. a) Submit acopy of your dataset along with a file that contains your answersto all of the following questions. b) What the mean and StandardDeviation (SD) of the Close column in your data set? c) If a personbought 1 share of Google stock within the last year, what is theprobability that the stock on that day closed at less than the meanfor that year? Hint: You do not want to calculate the mean toanswer this one. The probability would be the same for any normaldistribution. (5 points) 2. If a person bought 1 share of Googlestock within the last year, what is the probability that the stockon that day closed at more than $950? (5 points) 3. If a personbought 1 share of Google stock within the last year, what is theprobability that the stock on that day closed within $50 of themean for that year? (between 50 below and 50 above the mean) (5points) 4. If a person bought 1 share of Google stock within thelast year, what is the probability that the stock on that dayclosed at less than $800 per share. Would this be consideredunusal? Use the definition of unusual from the course textbook thatis measured as a number of standard deviations (5 points) 5. Atwhat prices would Google have to close in order for it to beconsidered statistically unusual? You will have a low and highvalue. Use the definition of unusual from the course textbook thatis measured as a number of standard deviations. (5 points) 6. Whatare Quartile 1, Quartile 2, and Quartile 3 in this data set? UseExcel to find these values. This is the only question that you mustanswer without using anything about the normal distribution. (5points) 7. Is the normality assumption that was made at thebeginning valid? Why or why not? Hint: Does this distribution havethe properties of a normal distribution as described in the coursetextbook? Real data sets are never perfect, however, it should beclose. One option would be to construct a histogram like you did inProject 1 to see if it has the right shape. Something in the rangeof 10 to 12 classes is a good number. (5 points) There are also 5points for miscellaneous items like correct date range, correctmean, correct SD, etc.