Visit theNASDAQ historical prices weblink by typing into your browser https://finance.yahoo.com/quote/GOOG/history.
We are going to be looking at a specific time period in Alphabet Inc.’s history. Set your dates by clicking on the blue dates after “Time Period”. Use a Start Date of 8/11/2018 and an End Date of 8/10/2019. Click the “Done”button.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 (see graphic below).
The downloaded data set will have multiple columnsand should look like the table below. Only use the column labeled “Close” and copy that data to a new spreadsheet.Make sure to copy the data to a new spreadsheet and save it either as a .xls or .xlsx file. A .csv file will not save your formulas and I need to be able to see your work.
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 z-score methods you learned in sections 6.1–6.3 of the course textbook for normal distributions to answer the questions. Do NOT count the number of data points.
Complete this portion of the assignment within a single Excel file or you may use your TI calculator. Show your work or explain how you obtained each of your answers.Answers with no work and no explanation will receive no credit.
If you need some assistance with the basics of using EXCEL and functions, please copy the following links into your browser and review this information: