To work on the results of the survey we need to know some statistics ideas here we are going to summarize you the most important concepts:
POPULATION & SAMPLE
VARIABLE: Type of data, if we have one type of data (students results) we'll have one-dimensional statistics and we have two types (students results and study time) we'll have two-dimensional statistics.
IF WE ARE IN ONE-DIMENSIONAL STATISTICS WE HAVE THE FOLLOWING:
MEAN, MODE AND MEDIAN
RANGE, VARIANCE AND STANDARD DEVIATION, they measure de deviation from the variable value.
FUNCTIONS IN SPREADSHEET USED FOR STATISTICAL CALCULATIONS:
ONE-DIMENSIONAL STATISTICS:
AVERAGE (data_x) → Average value from a group of numbers
SUMSQ (data_x) → Sum of squares of a group of numbers.
VAR(data_x) → Variance from a group of numbers.
STDEVP(data_x ) → Standard deviation of a group of numbers (population)