Question
This is all I have received. OBJECTIVE: To use a random number generator to randomly extract a sample from a data source then appropriately represent
This is all I have received.
OBJECTIVE: To use a random number generator to randomly extract a sample from a data source then appropriately represent data in a table and to use the data in the table to calculate sample statistics and conduct a one-sample hypothesis test. Go to Nasdaq stock screener (or Yahoo!Finance website or any other). On the left under "EXCHANGE," you will see three stock exchanges: NASDAQ, NYSE, and AMEX. You will choose (i.e. click on) one of these exchanges and then click "Apply" on the bottom to apply the filter. Next, click the "Download CSV" on the top right above the table of stocks. This will allow you open and download the complete listing of stocks on each of these 3 exchanges (i.e. their population of values). Download the listing (population) of these stocks into an excel spreadsheet. Focus on the column of stock symbols only. You then have the option to use either of the aforementioned random number generators to randomly select 25 stocks from the population. Use a random number generator of your choice (many people use either www.random.org or the RandBetween(bottom, top) function in Excel). On random.org, under "Lists and String and Maps, Oh My!", you will see several options for how to take a random sample. The easiest is the "List Randomizer". Clicking on that option shows you a box into which you can cut and paste your total list of stocks downloaded from Nasdaq.com. Then you simply click on randomize and your total listing of all stocks is randomly sorted. You can then select any 25 stocks. Look up the closing stock price at the end of trade for each of these 25 stocks. Put all of this information in a table (see the Table 1 below for the format). Be sure that your table is numbered, has a title that reflects the contents of the table and which stock exchange you sampled from, and has the list of the 25 stocks and their closing price. You may type in the ticker symbol for the stock's name if you wish. Tell which date you sampled the data and the web source address of the data below the table. You should also use Excel to calculate the mean, variance, and standard deviation of the closing stock prices and report these values also. In addition to the table, create a paragraph which should begin by talking about how the data was randomly sampled, then the website used, date sampled, and the basic summary statistics, i.e. the sample mean, variance and std. deviation. Finally, conduct a hypothesis test about the mean value of the closing prices of the 25 different stocks you chose. The test you are conducting is trying to prove if the average closing price of the stocks you chose is significantly different from $10.
Conduct the test at the .05 level of significance. In addition to the hypothesis test results, create a paragraph which should begin by talking about your hypothesis, then describe the testing procedure, and provide a conclusion and discussions on the hypothesis test.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started