1. Hypothesis Testing of a Sample of Stock Prices
... 500, you will need to double click on the embedded Excel image and use the scroll bar to see the list in its entirety. To choose my sample of 30 companies, I utilized the Excel function of "=RAND()" to assign random numbers to each of the 500 companies on my list. I then selected ... I sorted the spreadsheet by the stock prices in ascending order. I then utilized Excel to assist me in finding the mean and standard deviation of the sample prices of the stocks on my list of 30 companies. My calculations gave me the mean of 31.17966667 (or 31.18) and the standard deviation ... the mean pri...
- Word Count: 1315
- Approx Pages: 5
- Has Bibliography
- Grade Level: High School