Excel

Question 1

Which form of the excel formula will keep the selected range constant?

1) =Countif($C$3:$C$1002,E3)
2) =Countif($C3:$C1003,E3)
3) =Countif(C$3:C$1002,E3)
4) =Countif(C$3:C1002$,E3)

Answer 1

A

Question 2

Qualitative

Answer 2

Nominal/categorical data
Pie charts or bar charts

Nationality, Gender, Eye Colour

Question 3

Ordinal

Answer 3

Explicitly ranked or ordered but the levels/steps aren’t necessarily the same size

• Level of satisfaction / education
• Good bad okay
  Ranked or ordered

Question 4

Quantitative

Answer 4

A count or measure

• fully numeric data
• histograms, box plot, scatter plot

Weight, height, temp