Data Engineering Zoomcamp 2024

Workshop 2: Streaming with SQL Statistics

Distribution of scores and reported study time for this homework.

Submissions

245

Median total score

3

Average total score

4

Score distribution

All values are points.

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.

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