Statistical functions poisson, prob, quartile, skew, slope, standardize

Excel Function POISSON

The POISSON() function is used to determine the Poisson probability mass function for a set of variables.

This function can also be used to calculate the cumulative Poisson distribution function.

The syntax is as follows:

POISSON(x,mean,cumulative)

x mean POISSON() Formula
20 21 0.47097436386771 =POISSON(L4,M4,TRUE)
25 45 3.94834851198384E-04 =POISSON(L5,M5,FALSE)
34 38 5.48639874778975E-02 =POISSON(L6,M6,FALSE)
45 42 0.711662405542877 =POISSON(L7,M7,TRUE)

 

 

Excel Function PROB

The PROB() function is used to determine the probability associated with a range of values from a given list.

The syntax is as follows:

PROB(x,probability,[lower],[upper])

x Probability PROB() Formula
0 0.1 0.22 =PROB(L$16:L$23,M$16:M$23,3)
1 0.15 0.21 =PROB(L$16:L$23,M$16:M$23,4)
2 0.17 0.09 =PROB(L$16:L$23,M$16:M$23,5)
3 0.22 0.15 =PROB(L$16:L$23,M$16:M$23,1)
4 0.21 0.54 =PROB(L$16:L$23,M$16:M$23,1,3)
5 0.09 0.25 =PROB(L$16:L$23,M$16:M$23,0,1)
6 0.05 0.17 =PROB(L$16:L$23,M$16:M$23,2)
7 0.01 0.15 =PROB(L$16:L$23,M$16:M$23,1)

 

 

Excel Function QUARTILE

The QUARTILE() function returns the quartile value of a given set of values.

Quarters are value that divides the set into quarters.

The syntax is as follows:

QUARTILE(array_values, quarters)

values quarter QUARTILE() Formula
20 0 14 =QUARTILE(L$31:L$35,M31)
25 1 18 =QUARTILE(L$31:L$35,M32)
34 2 20 =QUARTILE(L$31:L$35,M33)
14 3 25 =QUARTILE(L$31:L$35,M34)
18 4 34 =QUARTILE(L$31:L$35,M35)

 

 

Excel Function SKEW

The SKEW() function is used to calculate the skewness of the distribution of given values.

The skew is nothing but the asymmetry or deviation of the distribution from mean.

The syntax is as follows:

SKEW(num1,num2,�num255)

quarter SKEW() Formula
21 0.64696859492152 =SKEW(L44:L46)
14 0.852357657130471 =SKEW(L44:L45,34)
32 1.75591667437576 =SKEW(L44:L48)
67 1.03428797900875 =SKEW(L44:L47,89,L48)
19 0.732880613838724 '=QUARTILE(L$31:L$35,M35)

 

 

Excel Function SLOPE

The SLOPE() function is used to calculate the slope of a linear line for a given set of x and y values.

The syntax is as follows:

SLOPE(x_array,y_array)

X Y SLOPE() Formula
12 8 0.331983805668016 =SLOPE(M57:M59,L57:L59)
43 12 0.129032258064516 =SLOPE(M57:M58,L57:L58)
32 44 -7.96545105566219E-02 =SLOPE(M57:M60,L57:L60)
23 67 -0.205183585313175 =SLOPE(M57:M61,L57:L61)
5 41 -1.3968253968254 =SLOPE(M57:M59,L59:L61)

 

 

Excel Function STANDARDIZE

The STANDARDIZE() function returns a normalized value based on given mean and standard deviation.

The syntax of the function is as follows:

STANDARDIZE(value,mean,standard deviation)

x value mean sd STANDARDIZE() Formula
2 14 9 -1.33333333333333 =STANDARDIZE(L69,M69,N69)
13 11 35 5.71428571428571E-02 =STANDARDIZE(L70,M70,N70)
34 17 21 0.80952380952381 =STANDARDIZE(L71,M71,N71)
21 26 20 -0.25 =STANDARDIZE(L72,M72,N72)
45 4 10 4.1 =STANDARDIZE(L73,M73,N73)

 

You can find similar Excel Questions and Answer hereunder

1) statistical functions maxa median mina mode normdist norminv

2) Excel 2010 vba replacement of application filesearch in Excel

3) Vba delete entire row if contains certain text in Excel

4) Autofill a b c d aa ab in Excel

5) Filtering the value field in a pivot table in Excel

6) statistical functions stdev stdeva stdevp stdevpa steyx

7) Userform initialize vs userform show in Excel

8) statistical functions countifs expondist forecast frequency gammadist

9) Generate a list of unique values in Excel

10) How to read a value from a cell in vba in Excel

 

Here the previous and next chapter