Microsoft Excel in ENGR 13300

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

1/26

flashcard set

Earn XP

Description and Tags

Flashcards to go over concepts covered in Excel 3. Excel 1 & 2 not included.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

27 Terms

1
New cards

Count

=COUNT() - Total # of data points in set

2
New cards

Minimum

=MIN() - Smallest value in data set

3
New cards

Maximum

=MAX() - Latest value in data set

4
New cards

Range

=MAX() - MIN() - Difference between min and max values (Helpful to identify outliers)

5
New cards

Mean

=AVERAGE() - Sum of all data points / count of data points (Sensitive to Outliers)

6
New cards

Median

=MEDIAN() - Middle number of data set (Sort data smallest to largest)

7
New cards

Mode

=MODE() - Most frequently occurring numbe

8
New cards

One Mode

=MODE.SNGL() - One commonly occurring number

9
New cards

Multi Mode

=MODE.MULT() - Multiple commonly occurring numbers

10
New cards

Standard Deviation

=STDEV.S() - Measure of variation in data set (Also = variance1/2)

11
New cards

Variance

=VAR.S() - Average of squared difference of each data point from the mean (Also = SD²)

12
New cards

Low Standard Deviation

data points are closer to the mean

13
New cards

Plugin for Histograms

Data Analysis ToolPak (File ⇒ Options ⇒ Add-ins ⇒ press “Go” ⇒ Analysis ToolPak ⇒ Ok)

14
New cards

Where to access Data Analysis ToolPak (To Make Histograms)

Data tab in Alalysis

15
New cards

Bin

A range of values that group a histogram bar

16
New cards

Number of Bins

=ROUND( sqrt(COUNT()), 0 )

17
New cards

Bin Width

=ROUND( RANGE / NUM_BINS)

18
New cards

Bin Upper Limits (Bin Table)

Sets the maximum value (upper limit) for each bin

19
New cards

1st Bin Upper Limit (Bin Table)

=MIN() + BIN_WIDTH - 1

20
New cards

Other Bin Upper Limits (Bin Table)

=1st Bin Upper Limit + BIN_WIDTH

21
New cards

After the Histogram is created you should …

Correctly label the histogram axis and hide the legend

22
New cards

Skew

=SKEW() - Determines distribution symmetry

23
New cards

Normal / Symmetrical Skew

=SKEW() IS 0

<p>=SKEW() IS 0</p>
24
New cards

Skewed Left

=SKEW() IS Negative

25
New cards

Skewed Right

=SKEW() IS Positive

26
New cards

Kurtosis

=KURT() - Measures peakness / flatness of a distribution

<p>=KURT() - Measures peakness / flatness of a distribution</p>
27
New cards

What does Kurtosis compare itself to?

A normal distribution