(stats) Lecture 5 - Outliers

=ROUND(cell,-1)

The round off formula is:

=MIN(all data values)

The Minimum excel formula is:

=MAX(all data values)

The Maximum excel formula is

Outlier

An — is an extremely high or extremely low value in our data.

=QUARTILE.EXC(all data values,1)

The Q1 excel formula is;

=QUARTILE.EXC(all data values,2)

The Q2 excel formula is:

=QUARTILE.EXC(all data values,3)

The Q3 excel formula is:

=Q3-Q1

The Interquartile Range excel formula is:

=Q1-1.5*IQR

The Lower Limit excel formula is:

=Q3+1.5*IQR

The Upper Limit excel formula is:

Box Plot

A — is a graphical summary of data that is based on a five-number summary. The key to the development of a — is the computation of the median and the quartiles Q1 and Q3.

Probability

— is a numerical measure of the likelihood that an event will occur. — values are always assigned on a scale from 0 to 1. A — near zero indicates an event is quite unlikely to occur. A probability near one indicates an event is almost certain to occur.

=