## 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)