Close	Volume
29.15	13380200
29	8782400
29.72	9412000
29.67	8597700
30.37	10083800
29.28	7769100
29.07	7112900
28.87	7716300
30.13	10216900
31.12	7945400
32	7843800
31.87	7781600
32.62	7200800
32.06	7844500
31.41	7203400
32.53	19214800
33.05	6709800
33.28	6729300
32.71	8077300
33.22	7532800
32.42	9319200
33.75	10732700
31.5	15912400
31.37	10434300
31.08	28787400
28.02	51963500
26.94	1.31E+08
27.38	65861400
27.01	44923600
27.14	41138100
26.7	37095400
26.71	32678300
25.99	27893900
26.79	41236200
26.75	35916100
27.05	31793500
28.03	52746600
29.46	54551400
29.56	42302900
29.11	36967500
29.53	28746600
29.49	22421400
29.6	8115100
28.98	16927100
29.02	25252400
29.06	22517600
28.65	22504300
27.86	32816100
27.68	20977300
27.89	23602700
28.42	23281700
28.69	23569900
28.49	25431600
30.05	57382500
29.75	38250700
30.13	35375100
29.99	33799700
30.45	95455100
30.33	31209100
30.44	12938600
30.67	22200800
30.17	18462200
29.74	18805900
29.74	16228400
30.99	20578900
31.37	18822700
31.58	21204700
32.81	30119600
33.93	43944400
33.97	29385500
34.01	34266400
34.14	16915800
34.84	26019000
35.01	20762200
34.68	21947800
35.13	17251200
37.6	48746700
37.04	29765200
37.4	21366000
36.8	21598000
36.3	18818000
37.01	28974000
36.99	16863000
36.68	22847000

For this assignment, you will use the columns titled Close and Volume from the excel sheet you downloaded. The Close column represents the price of the stock when the market closed for that day, and the Volume represents the number of stocks that were traded on that day. You may use COUNTIF, and AND Excel functions in questions 2 and 4, LOOKUP or VLOOKUP or XLOOKUP functions for question 5 or use filter from data tab and define your filtration criteria. 1. For the close price, use the minimum, the maximum, and the quartiles you calculated in Assignment I to categorize the closing price into four segments. Each category will be an event that the closing stock price will fall into during that period. Clearly define each of those events, remember that the close price is continuous. Name the events CI, C2, C3, and C4, respectively. 2. What is the probability of each of the events you defined in 1? 3. For the volume, take the range divide it by 4. Segment the volume into four segments as follows: a. [Minimum volume, Minimum volume + range/4) b. [Minimum volume + range/4. Minimum volume + range/2) c. Minimum volume + range/2, Minimum volume + 3*range/4) d. [Minimum volume + 3*range/4, Maximum volume) Clearly define the boundaries of those events. Although the volume is discrete, you may assume it is continuous. Name the events VI, V2, V3, and V4, respectively. For this assignment, you will use the columns titled Close and Volume from the excel sheet you downloaded. The Close column represents the price of the stock when the market closed for that day, and the Volume represents the number of stocks that were traded on that day. You may use COUNTIF, and AND Excel functions in questions 2 and 4, LOOKUP or VLOOKUP or XLOOKUP functions for question 5 or use filter from data tab and define your filtration criteria. 1. For the close price, use the minimum, the maximum, and the quartiles you calculated in Assignment I to categorize the closing price into four segments. Each category will be an event that the closing stock price will fall into during that period. Clearly define each of those events, remember that the close price is continuous. Name the events CI, C2, C3, and C4, respectively. 2. What is the probability of each of the events you defined in 1? 3. For the volume, take the range divide it by 4. Segment the volume into four segments as follows: a. [Minimum volume, Minimum volume + range/4) b. [Minimum volume + range/4. Minimum volume + range/2) c. Minimum volume + range/2, Minimum volume + 3*range/4) d. [Minimum volume + 3*range/4, Maximum volume) Clearly define the boundaries of those events. Although the volume is discrete, you may assume it is continuous. Name the events VI, V2, V3, and V4, respectively