nature philo Flashcards
relative reference
=B2
absolute reference
=$B$2
absolute column reference
=$B2
absolute row reference
=B$2
Sum
=SUM(range)
product
=PRODUCT(range)
square root
=SQRT(number)
exponantial
=EXP(number)
logarithms
=LN(number)
COUNT
a count if the cells containing numbers in a dataset
=COUNT(range)
count the number of non-blank cells in a dataset
=COUNTA(range)
smallest value
=MIN(range)
largest value
=MAX(range)
k-th smallest value
=SMALL(range, k)
k-th largest value
=LARGE(range, k)
average value
=AVERAGE(range)
the median value, half the numbers are smaller and half are larger than this value
=MEDIAN(range)
the variance, a measure of hwo spread out the data is
=VAR.S(range)
the standard deviation, a measure of how spread out the data is
=STEDV.S(range)
count the number of empty cells in a range of cells
=COUNTBLANK(range)
count the number of cells that meet a criterion
=COUNTIF(range, criteria)
applies criteria to cells across multiple ranges and counts the number of times all criteria are met
=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ….)
adds all of its arguments that meet mutliple criteria
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2]…)
returns the average of all the cells in a range that meets a given criteria
=AVERAGEIF(range, criteria, [average_range)