1. Download the daily stock data (NKE) from 1/1/2021 to12/31/2021 from Yahoo Finance

2. Find the Minimum, Maximum and Average Stock Price use the'min', 'max' and 'avg' excel functions

3. Z-Table distribution graph. I have attached theZ-Table. Please start from -3 to +3. In order to complete thegraph, you will have to use the following formula (detailedbelow) (you can copy the excel function for all values once youhave completed the first one) Z-Score: -3 (these values will be in one cell) Z-Value: (you will solve for the z-value using thecalculation below)o Calculation: =Norm.S.DIST(x, False)(x is the z-score) Once you solve for this, please select the correct scatter graph

4. Draw (on a piece of paper) the normal distribution graph forthe stock price (with the average stock price being in the centerof the graph). Identify where you believe the stock price will be(between the min and max figures) and shade in the correctarea (refer to chapter seven page 226 graph section 7.2)

5. Once part 4 is completed, refer to chapter seven page 226 section7.3. Replicate the graph with the z-score data ranging from -3to +3 with the respective stock price ranges. Once completed ,identify the percentage range of data for the following:a. If area is less than or equal to 1.0 (what percentage is that?)b. If the area is less than or equal to -0.5 (what percentage isthat)i. Note, you can refer to the z-table for the percentages