DABI Quiz 1 - Excel

Primary data

data collected for the purpose of study, typically survey data

Secondary data

data that already exists; historical data, databases, panels, data extracted by web scraping

→a quantitative variable divided into classes becomes an…

ordinal variable

• EX. age groups “0-18” “18-25”

Data: Can I calculate the mean? YES

Quantitative data (numeric data) 

Data: Can I calculate the mean? NO

Qualitative data (categorical data)

Two Parts of Quantitative data (numeric data) 

Discrete (integral… 1, 2, 3)

Continuous (all possible values)

Two Parts of Qualitative data (categorical data)

Nominal (name it)

Ordinal (order it)

EQ: Minimum

=MIN(start:end)

• EX. Age values in a row, B
  =MIN(B2:B243) 

EQ: Quartile 1

=QUARTILE.EXC(start:end,1)

• EX. Age values in a row, B
  =QUARTILE.EXC(B2:B243,1)

EQ: Median

=MEDIAN(start:end)

• EX. Age values in a row, B

=MEDIAN(B2:B243)

EQ: Quartile 3

=QUARTILE.EXC(start:end,3)

• EX. Age values in a row, B

=QUARTILE.EXC(B2:B243,3)

EQ: Maximum

=MAX(start:end)

• EX. Age values in a row, B

=MAX(B2:B243)

EQ: Average

=AVERAGE(start:end)

• EX. Age values in a row, B

=AVERAGE(B2:B243)

EQ: Std Dev

=STDEV.P(start:end)

• EX. Age values in a row, B

=STDEV.P(B2:B243)