ExCel Flashcards
1
Q
Mean
A
=average(number1:number2)
2
Q
Median
A
=median(number1:number2)
3
Q
Mode
A
=mode.sngl(number1:number2)
4
Q
Sample Varience
A
=var.s(number1:number2)
5
Q
Population varience
A
=var.p(number1:number2)
6
Q
Minimum
A
=min(number1:number2)
7
Q
Maximum
A
=max(number1:number2)
8
Q
Range
A
= highlight max - highlight min
9
Q
Standard Deviation
A
=stdev(number1:number2)
10
Q
Standard error of mean (same as standard error)
A
Standard deviation divided by square root of n (no. values in data set)
=stdev(number1:number2)/SQRT(COUNT(number1:number2))
ALWAYS REMEMBER THE 2ND BRACKET
11
Q
Square root
A
=SQRT(highlight)
12
Q
Sum
A
=sum(number 1:number 2)
13
Q
Number of values
A
=count(number1:number2)
14
Q
Median
A
=median(number1:number2)
15
Q
Range
A
=max(number1:number2)-min(number1:number2)
