Lesson 3: Data Visualization

Question 1

Sources of Data

Answer 1

• Manual
• Automated

Question 2

__________ is a measure that captures the typical user’s experience.

Answer 2

Median

Question 3

__________ is a measure of symmetry

Answer 3

Skewness

Question 4

We use ____________ if the NUMBER OF DATA” is BIGGER than the range.

Answer 4

Frequency distribution

Question 5

We use _______________ if the RANGE is bigger than the number of data.

Answer 5

Histogram

Question 6

Title
Horizontal axis = Bins
Vertical axis = Frequency
Overflow
Underflow

Answer 6

Histogram Distribution

Question 7

________ is used for qualitative particularly nominal value

Answer 7

Mode

Question 8

____________ The statistical measure that identifies a single value as representative of an entire distribution.

Answer 8

Central Tendency

Question 9

____________ A graph or dataset organized to show the frequency of occurence of each possible outcome of a repeatable event observed many times.

Answer 9

Frequency Distribution

Question 10

The middle number in a sorted ascending or descending list of numbers.

Answer 10

Median

Question 11

A type of distribution in which more values are concentrated on the right side of the distribution graph while the left tail of the distribution graph is longer.

Answer 11

Negatively skewed

Question 12

A set of data, difference between the largest and smallest values

Answer 12

Range

Question 13

The value that appears most frequently in a dataset.

Answer 13

Mode

Question 14

Excel formula to get the mean of a dataset

Answer 14

=AVERAGE (defined dataset)

Question 15

The distributions that occur when the long tail is on the right side of the distribution.

Answer 15

Positively Skewed

Question 16

The average of the given set of values

Answer 16

Mean

Question 17

A chart that plots the distribution of a numeric variable’s values as a series of bars.

Answer 17

Histogram

Question 18

> +1

Answer 18

Positively skewed

Question 19

<-1

Answer 19

Negatively skewed

Question 20

(-1, +1)

Answer 20

Relatively Symmetric

Question 21

How to find the typical Value?

Answer 21

1. Get the range
2. Central Tendencies
3. No. of data
4. Check if it is Frequency distribution or Histogram
5. Visualize

Question 22

Steps for Histogram distribution

Answer 22

1. Define column
2. Find range
3. Count data set
   - If range is bigger than the data = Histogram
4. Highlight DATA SET/ Define column
5. Insert - Histogram

Question 23

Steps for Frequency Distribution

Answer 23

1. Get the range
2. Check if frequency or Histogram =COUNT(Dataset)
3. Create a list from Minimum value to Maximum Value
4. Get the Frequency “Frequency of (name of data) =COUNTIF (Dataset, specific value)
5. Highlight both column minimum & maximum list and the frequency of dataset
6. Insert - frequency distribution
7. Since we only need the frequency of a dataset, delete the min&max list

Question 24

Format of skewdness

Answer 24

=SKEW (Dataset)
answer,
comment if within (-1,1) symmetrical distribution, Typical Value = mean
if <1 positively skewed, Typical Value = median
if <-1 negatively skewed, Typical Value = median

Question 25

Visualization Histogram: Positively skewed.

Answer 25

•Skewed to the right
•The right tail is longer
•Mean dragged to the right
•Values of data extend to the right

Question 26

Visualization Histogram: Negatively skewed.

Answer 26

•Skewed to the left
•The left tail is longer
•Mean to the left of the median
•Values of data extend to the left

Question 27

Visualization Histogram: Symmetric Distribution

Answer 27

the mean, median, mode almost coincide

Question 28

Scatter Plots and Correlation Examples:

Answer 28

1. Positive Correlation
2. Negative Correlation
3. No Correlation

Question 29

Scatter Plot Relationship

Answer 29

1. Positive Relationship
2. Negative Relationship
3. No Relationship