For this assignment, you will apply statistical inference to business decision scenarios.
Practical Application Scenario 1
Using the Yahoo Finance Web site (will provide guide), download a separate five years of daily data for a stock that begins with the first letter of your first name this time ( which is A). Be sure that you match the exact dates that you used for the initial stock data, so that you can combine the spreadsheets by pasting.
For example:
You are to download a second stock data in addition to the data you have been using. What this means is to match the data by day, month , and year. For example , January 5, 2007 data for stock A should match that for Stock B.
The data set up will look like:
Date Stock A Stock B
1/5/2017 1000 2000
1/6/2017 1200 1950
etc
Now, you are interested in seeing if the mean daily closing volume of the two stocks are statistically different when accounting for daily volatility of the market. In other words, you want to conduct a matched t-test using Date as the variable for pairing. To complete this analysis, do the following:
1.State the null and alternative hypotheses via both an explanation and a math equation..
2.Identify the appropriate statistical test. State this clearly..
3.Conduct the test and state whether to accept or reject the null hypothesis using the p-value and an alpha of .05. You may solve the equation manually, use the Hypothesis Tester – Single Sample file provided in Resources, or use the SAS Enterprise Guide. You may also use the Hypothesis Tester multimedia piece provided in Resources to review the process for this equation.. (I can provide if you want)
4.Report the rejection or acceptance of the null in terms of the scenario results using laymen’s terms. For this scenario, write a three-sentence paragraph that details why you can be statistically confident that the mean adjusted closing price has increased, decreased, or remained the same, and what would happen if alpha was .01..
You will need to use Excel or SAS to complete this test.
Practical Application Scenario 2
Now, use only the original stock data, those data associated with the first letter of your last name ( will provide). You are interested in whether the mean daily adjusted closing price for the last three years has increased from the mean daily closing price of the first two years. Conduct a hypothesis test by doing the following.
1.State the null and alternative hypotheses via both an explanation and a math equation..
2.Identify the appropriate statistical test. State this clearly..
3.Conduct the test and state whether to accept or reject the null hypothesis using the p-value and an alpha of .05. You may solve the equation manually, use the Hypothesis Tester – Single Sample file provided in Resources, or use the SAS Enterprise Guide. You may also use the Hypothesis Tester multimedia piece provided in Resources to review the process for this equation..
4.Report the rejection or acceptance of the null in terms of the scenario results using laymen’s terms. For this scenario, write a three-sentence paragraph that details why you can be statistically confident that the mean adjusted closing price has increased, decreased, or remained the same, and what would happen if alpha was .01..
You will need to use Excel or SAS to complete this test.
Practical Application Scenario 3
You are interested in knowing whether there are differences in the mean daily adjusted closing price for a specific stock. For this practical application, go back to Yahoo! Finance and download five-years of monthly data for the stock beginning with the first letter of your last name (which is V). To do so simply requires you to change the frequency to monthly. Then conduct a test to see whether there are monthly differences in the mean adjusted closing prices.
1.State the null and alternative hypotheses via both an explanation and a math equation..
2.Identify the appropriate statistical test. State this clearly..
3.Conduct the test and state whether to accept or reject the null hypothesis using the p-value and an alpha of .05. You may solve the equation manually, use the Hypothesis Tester – Single Sample file provided in Resources, or use the SAS Enterprise Guide. You may also use the Hypothesis Tester multimedia piece provided in Resources to review the process for this equation..
4.Report the rejection or acceptance of the null in terms of the scenario results using laymen’s terms. For this scenario, write a three-sentence paragraph that details why you can be statistically confident that the mean adjusted closing price has increased, decreased, or remained the same, and what would happen if alpha was .01..
Assignment Submission
You must submit two documents. First, you must compile all of your answers in a Microsoft Word file, pasting in the tables and graphics you created to demonstrate your work (submitted as a .docx file). Second, you must upload the raw on excel.
