Data Engineering Zoomcamp 2024
Workshop 2: Streaming with SQL Statistics
Distribution of scores and reported study time for this homework.
Score distribution
All values are points.
| Metric |
Min |
Q1 |
Median |
Average |
Q3 |
Max |
| Questions score |
- |
3.0 |
3.0 |
2.7 |
3.0 |
3 |
| Learning in public score |
- |
0.0 |
0.0 |
0.8 |
1.0 |
7 |
| Total score |
- |
3.0 |
3.0 |
3.6 |
4.0 |
11 |
Questions score
- Min
- -
- Median
- 3.0
- Max
- 3
- Q1
- 3.0
- Avg
- 2.7
- Q3
- 3.0
Learning in public score
- Min
- -
- Median
- 0.0
- Max
- 7
- Q1
- 0.0
- Avg
- 0.8
- Q3
- 1.0
Total score
- Min
- -
- Median
- 3.0
- Max
- 11
- Q1
- 3.0
- Avg
- 3.6
- Q3
- 4.0
Time distribution
All values are hours reported by students.
| Metric |
Min |
Q1 |
Median |
Average |
Q3 |
Max |
| Lectures |
0.0 |
2.0 |
3.0 |
4.9 |
5.0 |
72.0 |
| Homework |
0.0 |
2.0 |
2.0 |
3.3 |
4.0 |
40.0 |
Lectures
- Min
- 0.0
- Median
- 3.0
- Max
- 72.0
- Q1
- 2.0
- Avg
- 4.9
- Q3
- 5.0
Homework
- Min
- 0.0
- Median
- 2.0
- Max
- 40.0
- Q1
- 2.0
- Avg
- 3.3
- Q3
- 4.0
Question breakdown
Correctness and answer distribution per question.
1. Highest average trip time
224 / 245 correct
(91.4%)
1
Yorkville East, Steinway
224 (91.4%)
2
Murray Hill, Midwood
9 (3.7%)
3
East Flatbush/Farragut, East Harlem North
5 (2.0%)
4
Midtown Center, University Heights/Morris Heights
7 (2.9%)
2. Number of trips
213 / 245 correct
(86.9%)
1
5
12 (4.9%)
2
3
10 (4.1%)
3
10
10 (4.1%)
4
1
213 (86.9%)
3. Top 3 busiest zones
218 / 245 correct
(89.0%)
1
Clinton East, Upper East Side North, Penn Station
8 (3.3%)
2
LaGuardia Airport, Lincoln Square East, JFK Airport
218 (89.0%)
3
Midtown Center, Upper East Side South, Upper East Side North
11 (4.5%)
4
LaGuardia Airport, Midtown Center, Upper East Side North
6 (2.4%)
Calculated:
13 October 2024, 16:29