Stats 101

Steph Locke

2021-04-28

Aim

Aim

  • Predict the ages of SQL Saturday Exeter attendees

Our data

Our data

We have the results from our survey.

Our sample has 30 records but with basic data cleansing we will be working with 28.

Results

Age Distribution

Experience Distribution

Field Distribution

All data

Sampling

Training

Holdout

One size fits all

One size fits all

We could take some measure of central tendency to predict the age of attendees.

Mean Median Mode
38 37 45

Results

Assessing results

variable LSE
Median 279
Mean 348
Mode 1223

Line of best fit

Model

Results

Assessing results

variable LSE
expLMres 225.4772
Median 279.0000
Mean 348.0000
Mode 1223.0000

Complex linear regression

Complex linear regression

  • \(y=m_1 x_1 +...+ m_n x_n +c\)
  • Contrasts

Model

Results

Assessing results

variable LSE
fieldLMres 134.0936
expLMres 225.4772
Median 279.0000
Mean 348.0000
Mode 1223.0000