Week five work in a project and exercises. Project details below and attached.
Visit the NASDAQ historical prices weblink. First, set the date range to be for exactly 1 year ending on the Monday that this course started. For example, if the current term started on April 1, 2014, then use April 1, 2013 – March 31, 2014. (Do NOT use these dates. Use the dates that match up with the current term.) Next, click the link on the right side of the page that says Download to Spreadsheet to save the file to your computer.
This project will only use the Close values. Assume that the closing prices of the stock form a normally distributed data set. This means that you need to use Excel to find the mean and standard deviation. Then, use those numbers and the methods you learned in sections 5.2–5.3 of the course textbook for normal distributions to answer the questions. Do NOT count the number of data points.