Consider the data from the Russell 1000 stocks. Compute the number and proportion of stocks whose price increased during 2015. We will consider this the sample proportion of stocks of stocks whose price increased. Suppose we wish to test the hypothesis that the probability that a randomly picked stock will increase in price is 1/2. To test this hypothesis we can perform the following steps: Let x be the number of stocks whose price increased in your sample. Let the sample size, n, be the number of stocks for which you have an opening and closing price for the year. Let X be represent the number of stocks in a random sample of size n whose price increased. We are assuming X has a binomial distribution with p, probability of a success, having the value 1/2. Compute P(X≥x) and P(X≤x). Let pv=2*min[P(X≥x), P(X≤x)]. pv is a measure of how unlikely the assumption that p=1/2 is. When pv<0.05 we will not believe that p=1/2. You must report of you belive p=1/2 or not. You will hand in an Excel file with the following information: Column 1- Ticker of stock Column 2- Opening price Column 3- Closing price Column 4- Flag which is +1 if stock increased, 0 if stock did not increase. Bottom of Column 4 (appropriately labeled in Column 3): Total number of stocks that increased. In next row: sample proportion of stocks that increased. Again appropriately labeled in Column 3. Following row: P(X≤x). Use binomial.dist or MegaStat for this computation. If using Megastat include the Output Sheet. Label result in Column 3. Following row: P(X≥x). Use binomial.dist or MegaStat for this computation.Label result in Column 3. Following row: Compute pv. Label result in Column 3. Skip row and in Column 1. State if you believe p=1/2 or not and explain why.