I first determined that I would utilize data from the 500 companies that comprise the NASDAQ 500 Stock Index. I gathered this information from the NASDAQ.com web site. I placed this downloaded listing of information into an Excel spreadsheet in alphabetical order. (See Appendix A) In order to view the full listing of 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

Data Compilation & Statistic Calculation

I then had to research the individual current stock prices of each of the 50 companies from my sample data from Project III as well as my 30 companies from my sample data from this project. (See Appendix B) I obtained this data from the DailyStocks.com web site on November 24th, 2003. Therefore, the stock prices are current as of that day. I placed each of these stock prices into my spreadsheet respectively, as is evident from Appendix B. In order to organize the data so that it would be more useful to me, 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 of 25.8590277 (or 25.86). I utilized Excel to also assist me in computing the average stock price for the 50 stocks from the first index in Project III. My calculations gave me the mean of 38.887 (or 38.89).

Some topics in this essay:
Project III, Hypothesis Test, Stock Index, Empirical Rule, Population Based, , stock prices, Statistic Calculation, Sample Selection, stock price, standard deviation, mean stock, project iii, sample data, 30 companies, hypothesis test, reject ho, null hypothesis, mean stock price, mean standard deviation, step testing hypothesis, sample prices stocks, 3118 standard deviation,