Guess The Distributions

Download Report

Transcript Guess The Distributions 

Guess The Distributions
Microsoft Excel Formulas
• To find the mean of a set of numbers…
=AVERAGE(array1)
• To find the Quartiles of a set of number…
=QUARTILE(array1,0)
• To change the Quartile, change the second
number… Lowest use “0”, Q1 use “1”,
median use “2”, etc.
• To find the Standard Deviation of a set of
numbers…
=STDEV(array1)