Scenario 1Using the Yahoo Finance Web site as in Module 1, download a separate five years of daily data for a stock that begins with the first letter of your first name this time. 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.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:Now, use only the original stock data, those data associated with the first letter of your last name. 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.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. 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.