Computer Lab excel

0.0(0)
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
Card Sorting

1/7

encourage image

There's no tags or description

Looks like no tags are added yet.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

8 Terms

1
New cards

Average Calculation

=Average(C2,:F2)

2
New cards

Mean (average score)

=Average(F2:F61)

3
New cards

Maximum (highest score)

Max(F2:F61)

4
New cards

Minimum (lowest score)

=Min(F2:F61)

5
New cards

Mode (Most common score)

=Mode(F2:F61)

6
New cards

Standard deviation (spread of data)

=STDEV(F2:F61)

7
New cards

Countif, determine number of total scores in data greater than or equal to 10.

=Countif(f2:f61,">=10")

8
New cards

SUMIF, from whole data set determine sum of scores greater than 3.

=SUMIF(C2:E61,">3")