Bosses, how to call in the vba excel's built-in normsinv function, tried many times [face]
Save the children!

CodePudding user response:

1. Has the need to keep your Data sorting, as shown in figure Data column on
2. Give each data label [Cumulative Frequency]
3. Calculate possibility aim-listed Probability=(Cumulative_Frequency 0.5)/28
4. To calculate the aim-listed Probability NormSinV function called=& gt; NormSinv (aim-listed Probability)

CodePudding user response:

3. Calculate possibility aim-listed Probability=(Cumulative_Frequency 0.5)/28
28 is the total number of your data, it is the rows in the table

CodePudding user response:

28 is the total number of your data, it is the rows in the table