1, calculate the average value of the selected data first.
2. Secondly, calculate the standard deviation of the selected data.
3. Calculate the risk probability of the selected data (lower than the * * value).
4. Step: Select the cells in the sheet 1 table, select the insert function NORMDIST, open and pop up the dialog box, and select and enter the * * value in the X column; Enter the average value of the selected data in the mean column, select the standard deviation value of the data in the Standard-devl column, fill in true in the cumulative column, and click OK to get the risk probability lower than the * * value.