Discriptive Stats Flashcards
1
Q
How to calculate the mode
A
=mode (highlight bottom row and hold shift, press end, press the up arrow, down arrow)
2
Q
How to calculate median
A
=median ( highlight data set)
3
Q
How to calculate mean
A
=average( highlight data set)
4
Q
How to calculate percentile?
A
=percentile.exc( highlight data set, 0. Whatever your percentile is)
5
Q
How to work out interquartile value ?
A
= difference between q3 and q1 value
6
Q
How to calculate variance
A
=var.p/s( highlight the data set)
7
Q
How to calculate standard deviation
A
Steve.p/s (highlight data set)