Module 4

Question 1

Data visualization: Scatter plot
-represent values for ___________
-used to observe ______

Answer 1

• two different numeric variables
  -relationships between two numerical variables

Question 2

Data visualization: bar chart
-presents ______
- sometimes called ___

Answer 2

• categorical data with rectangular bars with heights porportional to the values that they represent
• coloum chart

Question 3

Lin chart
- provides grpahical representation of ____

Answer 3

• time dependent variables

Question 4

pie chart
- illustrates___

Answer 4

-numerical proportion

Question 5

IF functions makes _____ between a value and what you expect

Answer 5

• logical comparisions

Question 6

IF function in excel

Answer 6

=IF(C2=”Yes”,1,0)
=IF(C2=”WI”, “MI”, C2)