Data Dive Week 06
Dhruv Raghav
2023-09-29
Data Description
- Rows: 119391
- Columns: 32
Load Libraries
library(dplyr)##
## Attaching package: 'dplyr'## The following objects are masked from 'package:stats':
##
## filter, lag## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, unionlibrary(ggplot2)
library(summarytools)Load Dataset
hotel_data <- read.csv("G:/semester_1/4_Statistics_R/syllabus/lab/week6/hotel_bookings.csv")
# Would like to just see and display only the first 10 rows of the dataset
head(hotel_data, 10)## hotel is_canceled lead_time arrival_date_year arrival_date_month
## 1 Resort Hotel 0 342 2015 July
## 2 Resort Hotel 0 737 2015 July
## 3 Resort Hotel 0 7 2015 July
## 4 Resort Hotel 0 13 2015 July
## 5 Resort Hotel 0 14 2015 July
## 6 Resort Hotel 0 14 2015 July
## 7 Resort Hotel 0 0 2015 July
## 8 Resort Hotel 0 9 2015 July
## 9 Resort Hotel 1 85 2015 July
## 10 Resort Hotel 1 75 2015 July
## arrival_date_week_number arrival_date_day_of_month stays_in_weekend_nights
## 1 27 1 0
## 2 27 1 0
## 3 27 1 0
## 4 27 1 0
## 5 27 1 0
## 6 27 1 0
## 7 27 1 0
## 8 27 1 0
## 9 27 1 0
## 10 27 1 0
## stays_in_week_nights adults children babies meal country market_segment
## 1 0 2 0 0 BB PRT Direct
## 2 0 2 0 0 BB PRT Direct
## 3 1 1 0 0 BB GBR Direct
## 4 1 1 0 0 BB GBR Corporate
## 5 2 2 0 0 BB GBR Online TA
## 6 2 2 0 0 BB GBR Online TA
## 7 2 2 0 0 BB PRT Direct
## 8 2 2 0 0 FB PRT Direct
## 9 3 2 0 0 BB PRT Online TA
## 10 3 2 0 0 HB PRT Offline TA/TO
## distribution_channel is_repeated_guest previous_cancellations
## 1 Direct 0 0
## 2 Direct 0 0
## 3 Direct 0 0
## 4 Corporate 0 0
## 5 TA/TO 0 0
## 6 TA/TO 0 0
## 7 Direct 0 0
## 8 Direct 0 0
## 9 TA/TO 0 0
## 10 TA/TO 0 0
## previous_bookings_not_canceled reserved_room_type assigned_room_type
## 1 0 C C
## 2 0 C C
## 3 0 A C
## 4 0 A A
## 5 0 A A
## 6 0 A A
## 7 0 C C
## 8 0 C C
## 9 0 A A
## 10 0 D D
## booking_changes deposit_type agent company days_in_waiting_list
## 1 3 No Deposit NULL NULL 0
## 2 4 No Deposit NULL NULL 0
## 3 0 No Deposit NULL NULL 0
## 4 0 No Deposit 304 NULL 0
## 5 0 No Deposit 240 NULL 0
## 6 0 No Deposit 240 NULL 0
## 7 0 No Deposit NULL NULL 0
## 8 0 No Deposit 303 NULL 0
## 9 0 No Deposit 240 NULL 0
## 10 0 No Deposit 15 NULL 0
## customer_type adr required_car_parking_spaces total_of_special_requests
## 1 Transient 0.0 0 0
## 2 Transient 0.0 0 0
## 3 Transient 75.0 0 0
## 4 Transient 75.0 0 0
## 5 Transient 98.0 0 1
## 6 Transient 98.0 0 1
## 7 Transient 107.0 0 0
## 8 Transient 103.0 0 1
## 9 Transient 82.0 0 1
## 10 Transient 105.5 0 0
## reservation_status reservation_status_date total_guests CLASS season
## 1 Check-Out 7/1/2015 2 MEDIUM CLASS summer
## 2 Check-Out 7/1/2015 2 MEDIUM CLASS summer
## 3 Check-Out 7/2/2015 1 HIGH CLASS summer
## 4 Check-Out 7/2/2015 1 HIGH CLASS summer
## 5 Check-Out 7/3/2015 2 HIGH CLASS summer
## 6 Check-Out 7/3/2015 2 HIGH CLASS summer
## 7 Check-Out 7/3/2015 2 MEDIUM CLASS summer
## 8 Check-Out 7/3/2015 2 MEDIUM CLASS summer
## 9 Canceled 5/6/2015 2 HIGH CLASS summer
## 10 Canceled 4/22/2015 2 LOW CLASS summer# Set 1: Variables and Calculated Column
set1_response <- "adr"
set1_explanatory <- c("lead_time", "previous_bookings_not_canceled")
hotel_data$total_guests <- hotel_data$adults + hotel_data$children + hotel_data$babies
# Visualization for Set 1
ggplot(hotel_data, aes(x = lead_time, y = adr)) +
geom_point() +
geom_smooth(method = "lm") +
labs(title = "Relationship between Lead Time and ADR")## `geom_smooth()` using formula = 'y ~ x'
Conclusion drawn from Set 1
- The scatter plot shows a relationship between lead time and ADR (Average Daily Rate).
- The trendline indicates a slightly negative linear relationship; as lead time increases, ADR tends to decrease.
- There is a fair amount of variability in ADR for shorter lead times.
# Calculate correlation for Set 1
correlation_set1 <- cor(hotel_data[, c("lead_time", "adr")])
correlation_set1## lead_time adr
## lead_time 1.00000000 -0.06307685
## adr -0.06307685 1.000000002. Explanation based on visualization:
- In Set 1, I calculated the correlation coefficient between “lead_time” (lead time) and “adr” (average daily rate).
- The correlation coefficient indicates the strength and direction of the linear relationship between these two continuous variables.
- A positive value suggests a positive linear relationship, while a negative value suggests a negative linear relationship. The closer the coefficient is to 1 or -1, the stronger the linear relationship. A coefficient close to 0 suggests little to no linear relationship. Based on the scatter plot visualization, I observed a slight positive trend between lead time and ADR. The correlation coefficient, if close to 1, would confirm this observation.
# Calculate summary statistics for ADR
mean_adr <- mean(hotel_data$adr)
sd_adr <- sd(hotel_data$adr)
# Identify potential outliers
potential_outliers_adr <- hotel_data$adr[
abs(hotel_data$adr - mean_adr) > 2 * sd_adr
]
potential_outliers_adr## [1] 0.00 0.00 0.00 225.00 210.00 0.00 0.00 0.00 0.00
## [10] 213.75 230.67 216.13 0.00 0.00 0.00 210.00 210.00 249.00
## [19] 241.50 214.00 0.00 0.00 214.00 240.64 207.00 0.00 0.00
## [28] 210.00 217.05 233.00 222.67 210.00 0.00 240.00 233.05 209.00
## [37] 0.00 210.00 219.43 0.00 240.00 250.33 280.74 0.00 0.00
## [46] 219.50 214.00 252.00 233.00 211.00 211.00 237.00 222.14 210.78
## [55] 209.60 209.60 0.00 205.00 220.55 0.00 0.00 221.00 230.50
## [64] 230.50 211.00 241.00 211.00 0.00 0.00 242.60 268.00 217.20
## [73] 239.30 0.00 267.00 226.00 211.00 277.50 221.00 205.00 250.00
## [82] 208.00 211.75 246.00 205.00 252.00 276.43 228.00 205.00 207.00
## [91] 211.50 210.33 211.00 277.00 214.00 0.00 254.00 221.00 211.00
## [100] 205.00 233.00 0.00 0.00 211.00 207.00 214.00 241.00 274.93
## [109] 211.00 252.00 258.33 211.00 211.00 255.00 211.00 243.00 222.20
## [118] 243.00 0.00 203.00 266.40 236.00 271.00 232.00 223.00 209.00
## [127] 229.00 266.00 262.00 234.00 242.50 208.00 248.00 209.20 299.33
## [136] 218.00 248.00 223.99 214.00 209.40 225.90 213.00 213.00 236.00
## [145] 229.67 239.50 0.00 220.40 241.00 241.00 211.00 241.00 0.00
## [154] 0.00 222.07 229.00 213.50 236.00 248.00 260.71 222.00 221.43
## [163] 218.50 211.00 211.00 259.00 229.00 206.00 233.00 231.60 261.40
## [172] 209.60 219.33 206.60 0.00 211.00 208.00 211.00 0.00 0.00
## [181] 0.00 0.00 208.14 0.00 0.00 0.00 208.00 0.00 212.83
## [190] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [199] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [208] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [217] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [226] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [235] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [244] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 204.33 0.00
## [253] 0.00 0.00 0.00 0.00 0.00 221.20 0.00 0.00 0.00
## [262] 0.00 332.00 270.00 276.60 0.00 0.00 0.00 0.00 0.00
## [271] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [280] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [289] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [298] 0.00 0.00 0.00 232.00 0.00 214.00 220.00 206.33 208.56
## [307] 225.00 220.00 220.00 272.00 222.00 219.00 219.00 224.00 260.00
## [316] 238.63 225.80 235.00 204.00 231.43 237.33 280.00 203.00 215.33
## [325] 212.14 236.67 212.00 209.00 209.00 240.00 240.00 224.00 224.00
## [334] 212.00 239.00 227.00 204.44 242.00 250.00 237.00 233.00 209.00
## [343] 252.00 287.00 210.00 0.00 259.00 212.00 227.00 247.00 252.00
## [352] 240.00 207.00 207.00 240.00 240.00 207.00 207.00 216.00 211.00
## [361] 209.00 212.00 204.00 226.00 259.00 210.00 224.43 240.00 210.00
## [370] 223.00 207.00 205.00 212.00 209.00 209.00 227.00 288.00 222.33
## [379] 209.71 226.00 226.00 226.00 226.00 262.00 222.00 226.00 209.00
## [388] 243.32 259.00 219.80 211.00 209.00 209.10 241.00 210.43 205.00
## [397] 204.00 222.00 292.00 209.00 259.00 266.50 209.00 253.57 241.00
## [406] 204.50 240.00 232.00 204.00 259.00 212.14 256.50 212.00 0.00
## [415] 209.00 252.00 209.00 244.50 282.00 250.00 240.00 221.00 219.00
## [424] 283.32 231.00 211.00 211.00 204.00 231.00 272.70 221.00 230.00
## [433] 240.00 209.00 231.00 246.00 241.00 236.00 259.00 233.00 221.00
## [442] 299.00 245.67 209.00 248.75 248.89 298.00 289.00 262.00 209.00
## [451] 251.00 213.00 224.00 205.00 274.00 230.00 299.00 241.00 273.00
## [460] 269.00 269.00 254.00 259.00 236.71 211.00 211.00 259.00 243.63
## [469] 231.00 219.00 243.63 369.00 262.00 278.60 246.50 271.00 216.00
## [478] 234.00 206.78 222.50 218.00 205.67 240.00 240.00 216.00 254.31
## [487] 209.00 240.00 205.00 261.50 205.00 240.00 205.00 240.00 214.00
## [496] 246.00 259.00 224.00 224.00 209.00 225.67 219.00 231.50 226.50
## [505] 231.50 251.00 241.00 209.00 210.86 256.00 209.00 216.00 259.00
## [514] 291.00 241.00 204.00 249.00 219.00 225.67 221.00 219.00 225.67
## [523] 214.00 251.50 234.60 234.00 205.00 209.00 279.00 209.00 209.00
## [532] 241.00 259.00 241.00 254.00 277.67 299.00 227.92 258.00 247.67
## [541] 269.00 263.00 235.57 309.00 289.90 241.00 230.00 216.00 248.16
## [550] 261.00 214.99 217.14 236.67 236.50 259.00 216.50 219.00 219.00
## [559] 256.00 219.00 246.00 231.00 221.00 211.00 209.71 209.71 246.00
## [568] 231.00 221.00 209.00 229.00 219.00 217.33 230.00 219.00 314.50
## [577] 266.50 209.00 258.00 212.00 216.50 286.79 209.00 219.00 281.00
## [586] 239.00 219.00 239.00 231.00 219.00 274.00 219.00 227.92 214.00
## [595] 214.00 275.00 237.00 222.00 222.00 222.00 237.00 247.33 237.00
## [604] 256.75 222.00 288.00 222.00 251.86 238.16 208.48 226.14 212.00
## [613] 210.67 259.00 234.00 274.00 227.00 203.89 209.00 304.00 286.00
## [622] 329.00 231.00 231.00 231.00 211.00 235.67 281.00 214.00 226.73
## [631] 251.73 274.00 206.50 205.00 219.00 231.00 249.00 229.00 271.00
## [640] 322.00 241.00 209.00 287.00 224.00 239.00 239.10 219.00 204.00
## [649] 248.00 220.49 269.00 229.00 214.60 214.00 214.00 226.50 209.00
## [658] 205.67 265.67 249.50 204.50 211.00 240.00 249.50 262.00 253.00
## [667] 206.71 209.86 207.25 232.25 206.71 322.00 269.00 209.00 209.50
## [676] 234.00 221.00 240.00 243.80 213.80 204.75 241.75 247.57 221.00
## [685] 246.67 246.67 231.80 231.80 223.29 0.00 216.00 234.00 227.10
## [694] 221.00 204.00 240.60 252.00 219.00 264.00 216.00 219.00 254.00
## [703] 0.00 0.00 246.00 221.07 292.40 212.86 233.00 217.00 0.00
## [712] 0.00 246.02 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [721] 0.00 340.00 384.00 250.00 302.11 250.00 0.00 382.00 275.00
## [730] 229.40 275.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [739] 0.00 0.00 0.00 206.50 243.00 203.21 223.00 0.00 0.00
## [748] 213.00 0.00 0.00 209.00 213.00 0.00 210.00 207.00 225.50
## [757] 228.00 228.00 203.00 262.50 203.00 210.86 223.00 207.00 212.00
## [766] 208.00 213.33 215.00 223.00 228.00 228.00 233.00 0.00 260.00
## [775] 212.00 238.00 0.00 0.00 0.00 273.00 261.00 248.00 248.00
## [784] 311.00 212.00 203.67 248.00 258.00 228.00 288.00 228.00 222.00
## [793] 222.00 238.00 209.00 216.00 248.00 265.00 260.00 206.00 220.00
## [802] 211.00 250.00 243.00 217.50 204.29 238.00 300.86 203.11 292.00
## [811] 206.33 206.57 238.71 243.71 232.00 208.73 259.86 204.70 0.00
## [820] 242.00 211.03 223.57 219.14 241.00 264.00 247.00 241.00 265.00
## [829] 274.67 204.00 204.00 210.00 270.00 239.00 303.00 242.75 212.00
## [838] 212.00 293.00 222.00 222.00 232.00 210.00 210.00 275.00 260.00
## [847] 230.86 218.00 270.00 210.00 260.00 219.50 207.50 272.00 230.30
## [856] 203.00 215.00 219.00 293.33 253.25 311.00 217.71 240.00 233.10
## [865] 289.60 214.00 205.33 240.00 252.00 252.00 232.00 229.00 209.00
## [874] 229.00 212.00 234.67 242.00 0.00 210.00 213.00 212.54 203.71
## [883] 216.93 338.00 230.00 229.00 302.00 243.16 209.50 207.00 342.29
## [892] 274.45 244.00 216.25 234.56 207.00 219.50 290.67 290.67 260.00
## [901] 255.00 226.00 255.00 225.00 306.00 232.91 303.00 249.50 210.00
## [910] 250.00 209.58 217.50 237.34 245.00 237.00 289.00 229.00 229.00
## [919] 278.00 289.50 317.00 353.00 257.00 315.00 244.00 265.00 244.00
## [928] 212.00 220.00 212.00 208.05 212.00 230.00 248.00 205.00 278.57
## [937] 225.00 219.00 315.00 234.00 208.05 245.00 277.00 270.71 277.00
## [946] 244.00 225.00 213.00 206.00 228.00 292.00 237.00 305.00 237.00
## [955] 299.00 224.00 224.00 232.00 232.00 245.00 262.00 292.00 224.00
## [964] 213.33 215.33 211.30 244.00 206.62 221.60 255.00 212.16 209.00
## [973] 205.00 205.00 224.16 245.00 212.16 255.00 221.00 245.00 220.00
## [982] 206.12 267.86 245.00 221.00 220.00 266.50 292.00 222.00 212.14
## [991] 222.00 292.00 257.00 205.00 0.00 249.00 229.50 279.50 310.00
## [1000] 245.00 205.00 205.00 257.00 315.00 252.00 224.44 278.00 315.00
## [1009] 205.00 205.00 220.00 287.00 225.00 237.50 244.00 363.00 363.00
## [1018] 248.00 220.00 246.00 225.00 305.00 219.29 204.62 244.00 242.10
## [1027] 229.33 266.60 266.60 206.90 257.00 205.00 252.00 311.70 294.86
## [1036] 219.00 212.17 250.00 230.00 229.00 248.00 299.00 205.00 309.10
## [1045] 257.00 212.00 224.00 218.00 220.00 229.17 266.30 228.57 227.80
## [1054] 209.00 230.00 230.00 230.00 218.00 218.18 231.00 301.43 258.27
## [1063] 215.71 242.25 315.71 244.72 450.00 202.92 264.00 300.40 300.40
## [1072] 253.33 241.60 257.34 213.75 229.00 205.00 205.00 225.00 205.00
## [1081] 205.00 205.00 213.75 205.00 215.67 213.33 266.00 282.29 230.00
## [1090] 250.00 270.00 205.00 269.50 212.50 212.50 230.00 283.60 223.75
## [1099] 378.00 244.00 206.00 358.75 220.00 203.13 328.00 230.00 252.00
## [1108] 330.00 204.18 220.00 214.00 214.00 259.33 214.00 230.00 292.00
## [1117] 250.00 269.00 298.00 378.00 230.00 310.00 262.00 230.00 230.00
## [1126] 231.00 206.00 206.00 220.00 239.00 323.00 252.00 297.00 269.00
## [1135] 239.00 239.00 239.00 220.00 239.00 225.60 259.00 207.30 303.70
## [1144] 218.00 230.00 250.00 206.00 294.50 216.00 275.00 240.00 378.00
## [1153] 240.00 220.00 220.00 317.00 262.00 298.00 248.33 207.18 212.00
## [1162] 206.00 220.00 252.00 230.00 262.00 292.00 292.00 220.00 215.00
## [1171] 206.00 216.00 231.84 297.00 230.00 259.00 258.00 392.00 294.50
## [1180] 280.00 273.25 230.00 222.00 230.00 230.00 270.00 264.29 250.00
## [1189] 231.60 230.00 252.00 250.00 259.43 262.00 229.52 297.38 230.00
## [1198] 210.00 300.00 232.33 303.20 340.00 230.00 256.57 262.00 212.00
## [1207] 208.57 225.50 228.00 207.00 232.00 232.00 230.00 225.33 261.00
## [1216] 230.00 437.00 249.00 219.60 230.00 207.23 225.00 230.00 264.00
## [1225] 230.00 388.00 204.67 215.00 249.00 274.50 262.00 221.00 254.00
## [1234] 310.00 208.67 240.00 262.00 209.86 297.00 308.00 246.80 209.00
## [1243] 259.00 209.00 244.00 230.00 224.33 230.00 230.00 273.00 245.00
## [1252] 224.00 231.43 270.00 230.00 310.00 230.00 208.80 249.00 230.00
## [1261] 229.00 230.00 252.00 230.00 230.00 264.00 308.00 215.00 215.00
## [1270] 262.00 241.00 289.80 378.00 338.00 311.50 212.00 318.00 240.00
## [1279] 289.80 247.00 217.60 222.00 217.60 222.00 290.00 260.00 238.57
## [1288] 270.00 290.00 217.50 270.00 217.50 237.50 213.00 230.00 230.00
## [1297] 282.00 262.00 220.00 270.00 249.00 330.00 250.00 265.00 257.60
## [1306] 257.60 250.00 231.60 227.22 234.00 212.00 238.00 250.00 218.00
## [1315] 340.00 214.84 248.00 238.00 203.75 230.00 205.60 235.71 204.00
## [1324] 230.00 247.20 227.10 244.00 244.00 270.00 250.00 268.00 236.00
## [1333] 343.00 254.00 230.00 289.60 255.45 255.45 234.62 204.74 260.00
## [1342] 270.00 340.00 270.00 244.00 297.00 378.00 295.50 242.00 232.00
## [1351] 230.00 240.91 278.14 206.51 260.00 280.00 230.00 237.50 319.00
## [1360] 268.00 225.60 270.00 216.67 222.00 225.71 205.71 204.00 238.57
## [1369] 230.00 252.00 240.00 255.00 220.00 208.05 239.14 229.43 208.05
## [1378] 204.75 207.00 216.67 250.00 260.00 270.00 249.00 229.00 331.33
## [1387] 214.00 251.43 259.00 249.00 235.00 207.00 240.00 243.33 303.33
## [1396] 295.67 295.67 220.00 242.00 342.17 262.38 284.86 251.43 340.86
## [1405] 251.00 299.43 294.29 293.86 245.30 205.14 290.00 290.00 242.00
## [1414] 229.00 244.16 222.00 295.00 289.80 253.80 230.00 236.67 230.00
## [1423] 230.00 236.00 230.00 218.25 286.25 206.00 230.00 206.00 341.00
## [1432] 206.00 230.00 312.00 215.33 232.50 250.00 215.33 297.00 215.33
## [1441] 265.00 293.60 210.00 225.00 210.00 213.50 328.00 228.57 212.50
## [1450] 210.00 210.00 233.33 230.00 284.00 290.00 207.00 207.00 230.00
## [1459] 222.50 207.50 219.45 248.10 0.00 217.50 223.50 203.75 205.00
## [1468] 0.00 0.00 209.40 0.00 0.00 209.00 0.00 0.00 228.00
## [1477] 0.00 214.92 212.00 224.00 253.00 254.00 236.50 208.00 0.00
## [1486] 205.03 212.31 0.00 203.40 0.00 305.00 222.20 214.00 241.00
## [1495] 233.92 225.60 335.00 0.00 0.00 0.00 0.00 0.00 230.84
## [1504] 225.00 245.50 288.10 275.25 367.00 0.00 239.00 229.50 216.50
## [1513] 251.00 225.50 232.00 209.00 244.00 237.00 207.00 211.20 210.50
## [1522] 227.86 237.00 0.00 -6.38 0.00 225.00 211.00 0.00 508.00
## [1531] 0.00 0.00 204.33 0.00 0.00 0.00 0.00 0.00 236.00
## [1540] 0.00 317.00 318.82 232.00 206.22 252.00 214.00 0.00 0.00
## [1549] 207.00 221.43 248.00 0.00 207.00 209.00 252.00 241.00 204.00
## [1558] 211.00 256.00 217.00 210.00 244.00 227.40 209.17 209.17 209.40
## [1567] 247.00 210.43 219.90 211.00 221.00 0.00 0.00 222.00 0.00
## [1576] 223.00 211.00 213.00 244.00 225.08 208.20 217.83 206.00 204.00
## [1585] 211.00 211.00 221.00 236.00 209.00 211.00 207.85 241.00 252.00
## [1594] 297.50 243.00 253.00 207.00 232.00 213.00 242.67 237.45 225.45
## [1603] 203.24 212.40 211.00 241.00 241.00 211.00 236.93 219.00 233.00
## [1612] 218.60 229.00 266.00 219.30 252.00 235.71 208.00 234.29 218.83
## [1621] 279.00 211.00 217.00 229.00 271.00 204.00 210.00 213.40 244.00
## [1630] 274.00 206.34 219.00 209.00 0.00 241.00 0.00 239.00 209.20
## [1639] 225.28 215.00 258.43 218.50 235.07 234.67 211.00 229.60 209.00
## [1648] 239.65 203.00 264.50 208.43 218.30 256.50 244.00 219.25 0.00
## [1657] 0.00 259.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [1666] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [1675] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [1684] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [1693] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [1702] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [1711] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [1720] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [1729] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [1738] 0.00 0.00 0.00 284.00 300.00 224.00 224.67 224.67 305.00
## [1747] 222.50 224.67 224.67 237.33 237.33 237.33 237.33 237.33 224.67
## [1756] 305.00 224.67 224.67 305.00 224.67 245.33 245.33 245.33 245.33
## [1765] 224.67 224.67 237.33 224.67 224.67 224.67 305.00 224.67 224.67
## [1774] 203.95 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [1783] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [1792] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [1801] 0.00 226.67 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [1810] 0.00 213.60 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [1819] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [1828] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [1837] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [1846] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [1855] 0.00 0.00 0.00 0.00 245.20 0.00 0.00 0.00 0.00
## [1864] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [1873] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [1882] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [1891] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [1900] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [1909] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [1918] 0.00 0.00 0.00 217.14 0.00 0.00 215.60 206.10 0.00
## [1927] 0.00 0.00 0.00 206.00 0.00 0.00 0.00 0.00 0.00
## [1936] 0.00 0.00 218.10 0.00 0.00 0.00 0.00 0.00 0.00
## [1945] 227.00 237.00 232.40 0.00 0.00 206.00 0.00 206.00 0.00
## [1954] 249.00 274.00 254.00 0.00 0.00 0.00 0.00 0.00 218.33
## [1963] 252.17 204.33 236.00 219.00 224.00 222.00 0.00 209.10 230.00
## [1972] 219.00 204.00 0.00 204.60 211.00 246.00 208.50 0.00 212.00
## [1981] 211.80 282.00 311.33 0.00 209.57 0.00 0.00 212.00 224.00
## [1990] 226.00 208.00 214.87 217.00 213.75 249.50 244.00 219.00 0.00
## [1999] 240.86 206.36 204.00 263.57 262.50 239.00 217.67 224.40 213.70
## [2008] 287.50 271.00 231.00 271.00 210.00 0.00 296.00 217.08 0.00
## [2017] 0.00 0.00 219.10 271.00 206.17 203.33 227.00 203.00 208.34
## [2026] 0.00 224.50 249.00 230.00 232.00 231.88 295.00 243.00 205.50
## [2035] 205.50 203.40 204.00 203.50 224.00 203.86 210.00 207.00 210.71
## [2044] 219.00 257.00 276.60 224.00 203.67 252.60 252.60 205.70 271.00
## [2053] 207.50 259.00 209.00 253.00 241.00 278.00 223.00 281.00 216.50
## [2062] 209.00 217.00 235.00 206.00 231.00 226.00 241.00 212.00 240.00
## [2071] 208.00 249.00 214.33 239.00 215.00 210.42 318.00 209.00 213.55
## [2080] 276.00 259.00 229.00 242.00 210.00 206.00 212.00 231.00 205.00
## [2089] 222.00 308.40 222.00 232.00 219.00 220.50 213.75 221.00 237.75
## [2098] 0.00 0.00 214.00 209.00 215.00 227.00 274.00 301.00 210.00
## [2107] 208.50 216.00 221.00 229.00 251.00 221.10 218.11 260.33 248.00
## [2116] 241.00 226.33 209.71 0.00 209.00 207.00 281.00 212.50 237.67
## [2125] 207.05 302.86 288.10 236.00 219.00 217.43 231.00 0.00 257.00
## [2134] 307.00 231.00 215.10 0.00 0.00 264.00 233.00 221.50 274.00
## [2143] 282.00 229.00 240.50 209.00 221.00 215.50 209.00 241.00 241.00
## [2152] 203.00 0.00 265.83 211.00 251.00 251.00 219.00 205.00 216.57
## [2161] 210.00 241.00 216.98 211.00 221.00 221.38 263.00 340.71 223.00
## [2170] 224.50 210.51 221.00 240.57 229.50 203.59 283.00 252.00 283.20
## [2179] 273.50 253.00 263.00 226.00 336.50 259.00 0.00 219.00 253.00
## [2188] 251.00 251.83 246.00 219.00 318.71 221.00 234.17 232.33 268.33
## [2197] 231.00 352.00 215.67 221.00 221.00 335.00 203.00 212.05 249.00
## [2206] 251.00 359.00 236.00 214.86 253.50 310.00 206.00 239.08 353.67
## [2215] 269.00 269.00 276.00 223.00 209.00 230.00 210.60 245.00 218.51
## [2224] 209.00 223.00 203.00 313.71 209.75 211.00 207.33 271.00 240.00
## [2233] 203.11 236.00 262.60 209.00 216.00 288.00 234.70 227.00 229.00
## [2242] 268.00 227.00 229.00 0.00 211.00 244.00 231.17 241.50 219.00
## [2251] 243.50 221.00 216.00 204.50 218.67 211.25 269.00 207.76 229.71
## [2260] 246.20 207.05 242.33 276.00 256.00 268.00 231.00 229.00 357.00
## [2269] 231.00 216.00 224.00 246.00 261.00 227.10 243.00 211.00 221.00
## [2278] 219.00 224.00 261.00 219.00 239.00 244.00 221.00 215.00 215.00
## [2287] 286.00 327.40 233.00 296.00 251.07 327.60 235.29 227.10 203.29
## [2296] 329.00 213.57 268.50 221.00 244.67 229.00 219.00 256.00 209.00
## [2305] 216.50 281.00 243.00 272.67 213.00 211.00 253.00 249.67 263.00
## [2314] 254.00 271.00 209.00 241.00 221.00 279.00 243.17 239.67 234.00
## [2323] 211.00 221.00 221.00 221.00 215.00 239.00 263.00 279.00 241.00
## [2332] 270.00 251.00 227.67 206.10 359.00 322.00 207.33 212.80 203.10
## [2341] 315.38 209.00 215.10 236.00 306.00 209.00 286.00 216.66 278.50
## [2350] 253.00 235.00 235.00 235.00 0.00 204.10 253.16 225.00 299.00
## [2359] 231.76 250.00 230.00 236.00 221.00 270.50 219.00 293.00 261.00
## [2368] 243.00 253.00 219.00 253.00 261.00 257.67 228.60 271.00 235.67
## [2377] 216.33 224.00 219.00 208.80 251.00 209.10 222.00 209.00 221.00
## [2386] 219.00 301.20 242.00 329.00 230.60 221.00 231.00 286.00 209.80
## [2395] 209.80 242.33 232.80 310.20 209.80 271.00 233.00 245.00 206.00
## [2404] 265.00 251.43 254.00 224.00 209.00 259.00 264.16 288.00 212.00
## [2413] 352.00 214.00 265.00 214.00 317.67 231.00 214.71 241.00 279.00
## [2422] 241.00 237.90 241.00 273.00 217.67 221.00 215.60 231.00 209.00
## [2431] 212.10 206.00 243.00 220.87 203.00 311.00 248.10 234.00 254.00
## [2440] 246.50 238.00 211.00 286.60 243.50 232.67 285.00 217.50 211.67
## [2449] 234.00 211.00 206.00 213.60 275.00 249.00 270.10 268.50 259.00
## [2458] 209.00 235.60 261.00 219.00 203.00 217.67 206.00 269.00 231.00
## [2467] 241.00 274.00 300.60 228.00 246.00 0.00 297.29 203.00 211.00
## [2476] 0.00 224.10 254.10 268.75 352.00 241.00 211.20 209.00 214.00
## [2485] 233.00 252.00 216.43 254.62 213.86 236.93 234.54 271.00 318.00
## [2494] 281.00 283.00 296.33 284.86 297.00 221.62 231.60 209.29 258.00
## [2503] 293.10 261.25 0.00 211.91 279.00 271.00 231.00 229.00 286.10
## [2512] 279.36 234.00 281.00 209.00 230.64 291.00 237.67 252.67 205.20
## [2521] 227.00 258.00 248.20 229.00 206.20 245.10 209.00 209.00 311.00
## [2530] 357.00 248.80 249.00 204.00 209.83 219.00 231.00 206.10 221.00
## [2539] 247.00 247.00 266.10 222.38 216.00 237.60 241.00 246.00 270.00
## [2548] 261.00 234.60 269.00 231.00 214.50 204.00 227.10 261.33 250.50
## [2557] 239.10 224.07 259.00 216.00 223.00 281.00 283.00 243.67 349.00
## [2566] 265.83 246.43 308.14 221.00 270.50 245.43 238.10 203.80 236.14
## [2575] 292.71 231.00 286.00 270.38 238.00 308.57 216.00 0.00 211.16
## [2584] 251.14 0.00 219.67 207.67 239.43 238.14 246.00 234.00 236.00
## [2593] 209.10 241.00 252.00 243.86 231.00 244.09 274.00 0.00 256.00
## [2602] 222.00 243.00 260.00 263.09 216.00 247.00 205.50 216.00 269.00
## [2611] 231.00 212.00 224.00 212.67 212.53 273.90 213.00 213.43 216.00
## [2620] 218.00 220.33 214.67 265.00 203.29 229.20 224.00 209.10 221.00
## [2629] 297.57 226.57 213.14 225.14 239.00 216.00 0.00 214.00 209.10
## [2638] 234.00 0.00 223.00 221.10 231.00 209.00 251.00 216.00 216.00
## [2647] 214.00 211.00 212.60 0.00 253.25 244.00 219.00 0.00 215.00
## [2656] 203.00 0.00 211.00 203.43 0.00 307.50 223.75 205.67 0.00
## [2665] 215.50 0.00 242.57 0.00 0.00 0.00 0.00 0.00 208.00
## [2674] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [2683] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 216.00 331.00
## [2692] 231.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [2701] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [2710] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [2719] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [2728] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [2737] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [2746] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [2755] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [2764] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 340.00 340.00
## [2773] 340.00 305.00 340.00 305.00 305.00 295.00 305.00 305.00 273.13
## [2782] 325.00 325.00 367.00 325.00 305.00 340.00 305.00 305.00 305.00
## [2791] 225.00 231.00 211.50 325.00 305.00 305.00 222.50 246.00 0.00
## [2800] 0.00 208.50 208.33 225.00 326.33 0.00 0.00 215.25 0.00
## [2809] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [2818] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [2827] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [2836] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [2845] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [2854] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [2863] 217.75 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [2872] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 223.00 215.50
## [2881] 0.26 270.00 228.50 249.00 0.00 212.00 228.00 0.00 0.00
## [2890] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [2899] 0.00 0.00 0.00 0.00 218.00 220.00 0.00 0.00 0.00
## [2908] 0.00 0.00 0.00 0.00 211.00 0.00 0.00 0.00 0.00
## [2917] 0.00 0.00 270.00 0.00 217.00 0.00 0.00 212.50 215.50
## [2926] 222.02 231.50 0.00 230.00 0.00 0.00 258.00 263.00 0.00
## [2935] 207.00 230.00 225.00 0.00 234.00 205.67 271.00 0.00 258.00
## [2944] 218.00 230.00 206.00 223.57 288.00 248.00 230.00 242.00 234.00
## [2953] 221.00 213.71 265.25 229.00 236.00 210.14 212.00 0.00 243.00
## [2962] 204.00 0.00 0.00 219.86 214.00 0.00 0.00 214.00 233.33
## [2971] 204.00 214.00 250.00 210.00 260.00 212.00 264.00 0.00 216.00
## [2980] 219.00 308.00 207.00 210.00 257.60 208.75 216.67 212.00 264.00
## [2989] 322.00 206.00 210.00 214.00 228.75 224.33 315.33 220.33 210.00
## [2998] 213.57 211.00 214.00 206.00 260.00 274.00 223.33 226.00 228.00
## [3007] 279.00 0.00 0.00 0.00 203.18 211.00 219.33 209.00 252.00
## [3016] 247.33 238.00 235.00 276.83 234.29 213.67 215.00 222.00 284.00
## [3025] 223.00 206.86 292.75 0.00 230.00 241.60 222.93 224.00 206.00
## [3034] 207.00 203.00 207.00 230.00 213.33 292.50 285.00 0.00 211.50
## [3043] 205.33 221.25 271.00 219.43 248.29 241.86 208.86 220.40 0.00
## [3052] 259.00 0.00 0.00 216.14 247.00 214.00 204.16 220.16 212.88
## [3061] 221.60 203.60 250.00 224.16 273.00 219.00 264.00 203.00 220.00
## [3070] 223.00 277.00 254.00 209.33 233.00 220.00 244.00 222.00 303.00
## [3079] 299.20 287.00 237.71 223.00 212.71 207.80 247.09 228.00 296.50
## [3088] 210.86 239.66 281.00 205.60 212.00 271.00 204.00 233.00 205.25
## [3097] 329.00 238.50 204.00 239.00 207.00 213.00 256.00 204.17 219.00
## [3106] 233.60 209.50 222.00 209.00 209.00 235.00 246.00 256.50 209.85
## [3115] 225.50 216.89 231.22 255.84 377.00 220.40 298.71 210.00 217.86
## [3124] 247.00 206.03 220.00 239.00 311.25 296.75 219.00 299.00 359.50
## [3133] 205.10 0.00 218.40 239.00 221.00 211.12 306.00 213.56 235.00
## [3142] 253.60 231.13 237.00 224.39 244.00 218.75 242.32 231.00 257.00
## [3151] 219.00 258.00 203.60 239.00 309.00 354.00 305.00 212.00 315.00
## [3160] 248.33 242.00 249.38 274.60 214.00 210.00 225.00 209.00 252.30
## [3169] 262.00 242.00 0.00 245.00 262.00 217.82 212.73 253.00 213.00
## [3178] 215.00 245.00 341.00 0.00 244.31 207.59 319.00 293.50 245.00
## [3187] 222.00 245.00 271.00 253.54 229.25 211.25 360.00 255.00 268.00
## [3196] 224.50 205.00 205.00 298.00 294.00 344.00 214.00 280.33 219.00
## [3205] 227.60 273.00 251.00 214.00 207.50 207.50 228.33 239.00 271.00
## [3214] 203.38 272.00 220.00 269.00 245.00 261.00 262.00 0.00 222.26
## [3223] 242.86 300.00 209.00 0.00 208.08 237.00 237.00 234.00 235.60
## [3232] 242.00 242.00 224.80 225.00 212.80 324.00 306.00 326.00 319.00
## [3241] 270.00 230.00 258.29 260.60 241.81 265.86 273.56 209.00 216.29
## [3250] 216.93 304.00 250.00 250.00 205.00 245.00 230.35 275.60 257.75
## [3259] 228.32 310.75 205.00 210.00 223.50 213.60 210.00 230.00 239.30
## [3268] 212.00 230.00 204.00 0.00 224.00 212.00 246.00 212.00 229.00
## [3277] 271.00 219.32 215.95 254.67 315.50 234.00 305.00 213.75 213.75
## [3286] 331.00 248.50 209.75 238.75 236.86 378.00 315.00 230.00 225.00
## [3295] 244.00 339.40 277.00 207.67 249.00 245.00 204.90 263.33 233.13
## [3304] 215.00 225.00 228.50 207.10 204.03 241.10 245.00 259.00 262.00
## [3313] 283.50 253.00 310.00 219.58 239.00 225.00 250.00 244.00 230.00
## [3322] 232.00 216.00 230.67 205.00 275.00 238.26 253.49 223.67 273.86
## [3331] 251.60 224.90 268.00 270.51 259.00 250.00 260.00 223.14 210.67
## [3340] 207.33 225.00 299.00 349.67 244.00 249.00 372.00 230.00 204.16
## [3349] 259.33 292.00 227.00 241.41 343.00 242.84 235.95 239.75 397.38
## [3358] 316.50 294.00 266.00 0.00 219.00 315.33 229.33 291.00 235.00
## [3367] 228.50 269.00 294.00 255.00 218.00 324.00 250.00 300.00 307.67
## [3376] 257.00 264.00 426.25 264.00 230.00 206.03 212.29 276.00 231.67
## [3385] 244.00 328.00 244.00 387.00 230.00 248.36 239.00 239.00 239.00
## [3394] 282.00 205.00 232.00 216.84 214.84 266.00 206.00 205.00 241.00
## [3403] 254.31 296.00 224.00 223.07 239.78 231.60 250.00 220.00 215.00
## [3412] 314.00 241.00 213.00 283.00 209.00 255.00 244.00 236.10 223.67
## [3421] 244.00 244.00 240.00 214.00 244.00 227.00 237.60 241.00 243.81
## [3430] 368.10 284.00 271.00 290.67 288.03 214.00 268.00 302.50 212.00
## [3439] 252.00 335.00 260.00 230.00 324.00 210.00 211.00 295.00 282.00
## [3448] 205.20 205.43 283.00 230.00 258.00 270.00 204.75 230.00 244.00
## [3457] 284.00 244.00 276.00 289.00 316.00 330.00 269.43 239.00 225.00
## [3466] 210.00 284.70 225.50 251.00 225.00 275.00 210.00 329.67 250.32
## [3475] 300.00 250.00 221.20 230.00 372.71 252.33 214.53 258.00 0.00
## [3484] 214.80 264.60 210.00 232.00 232.00 230.00 230.00 262.00 337.00
## [3493] 232.60 218.60 203.67 203.67 217.67 220.98 232.00 232.00 231.60
## [3502] 210.00 209.00 254.00 204.80 0.00 206.88 231.00 231.00 255.00
## [3511] 217.33 311.60 258.00 216.00 231.00 244.00 260.50 238.30 222.80
## [3520] 240.37 238.00 210.00 230.00 229.00 230.00 217.10 217.10 212.33
## [3529] 216.00 216.00 232.00 297.00 252.00 230.00 284.00 283.43 270.00
## [3538] 270.00 212.58 299.00 296.33 207.29 322.00 262.00 306.70 250.00
## [3547] 265.00 203.19 276.00 267.50 273.09 215.24 279.00 228.50 207.00
## [3556] 337.00 232.61 286.00 244.00 232.00 205.20 215.33 392.00 230.00
## [3565] 219.00 247.65 320.70 262.50 0.00 218.00 271.00 206.40 222.39
## [3574] 249.23 264.00 388.00 216.00 210.00 224.00 260.00 218.63 310.00
## [3583] 230.00 207.20 332.00 250.00 230.00 402.00 228.00 264.00 224.10
## [3592] 246.00 276.60 272.50 211.49 284.00 241.67 230.00 317.00 266.00
## [3601] 0.00 269.00 268.30 223.60 299.00 229.13 230.00 222.33 262.00
## [3610] 261.00 253.00 229.00 232.00 319.00 340.00 244.55 224.00 238.00
## [3619] 216.00 306.00 284.00 219.20 206.72 274.67 210.00 209.00 382.00
## [3628] 258.00 350.20 233.64 203.71 256.31 256.00 322.00 248.00 262.00
## [3637] 334.43 262.00 239.00 264.00 275.33 217.60 262.00 289.00 261.00
## [3646] 242.84 264.00 205.00 237.71 306.50 276.00 331.43 270.00 218.80
## [3655] 279.03 234.00 211.60 274.00 244.00 225.00 210.00 310.00 310.00
## [3664] 253.80 228.84 225.00 239.00 262.50 222.00 262.00 230.00 220.00
## [3673] 291.43 315.00 227.06 239.60 230.00 311.00 208.02 258.00 220.00
## [3682] 240.00 274.00 214.00 220.75 248.50 235.00 230.00 265.00 220.50
## [3691] 251.00 227.81 243.81 292.00 314.67 302.67 279.33 253.65 282.03
## [3700] 282.32 326.71 240.80 267.00 259.00 248.29 281.43 269.00 293.00
## [3709] 207.52 328.33 217.33 244.00 266.43 204.00 225.67 204.00 330.57
## [3718] 210.00 207.50 257.50 235.00 224.00 266.00 231.69 246.00 350.75
## [3727] 236.85 236.00 204.16 204.00 228.89 224.25 292.50 204.00 275.40
## [3736] 234.18 344.67 229.19 0.00 235.80 205.00 351.00 208.03 204.00
## [3745] 220.53 210.00 256.00 230.00 276.00 210.00 295.00 276.46 242.00
## [3754] 222.00 262.00 222.00 230.00 262.00 256.00 217.00 217.00 266.06
## [3763] 219.03 241.75 208.28 207.40 212.50 252.57 230.00 205.18 308.57
## [3772] 277.67 277.71 336.57 218.00 289.86 244.00 207.00 237.00 298.00
## [3781] 214.00 225.20 284.29 383.00 245.33 240.60 261.00 207.00 221.00
## [3790] 205.70 257.75 210.75 250.20 232.50 230.43 230.43 204.93 207.50
## [3799] 221.41 234.29 0.00 222.86 211.20 213.43 209.67 207.03 312.29
## [3808] 204.27 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [3817] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [3826] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [3835] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [3844] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [3853] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [3862] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [3871] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [3880] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [3889] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [3898] 0.00 0.00 227.25 0.00 0.00 0.00 0.00 0.00 0.00
## [3907] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [3916] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [3925] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [3934] 206.00 0.00 0.00 224.67 224.67 224.67 224.67 224.67 224.67
## [3943] 224.67 224.67 224.67 224.67 224.67 224.67 224.67 224.67 224.67
## [3952] 224.67 224.67 224.67 224.67 224.67 224.67 224.67 224.67 224.67
## [3961] 224.67 0.00 212.00 0.00 231.00 0.00 0.00 0.00 250.00
## [3970] 250.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [3979] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [3988] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 205.50
## [3997] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4006] 0.00 0.00 0.50 0.00 0.00 0.00 214.60 212.42 0.00
## [4015] 0.00 0.00 277.50 5400.00 224.33 254.00 216.00 0.00 221.00
## [4024] 203.76 0.00 0.00 0.00 228.60 0.00 206.00 228.60 203.50
## [4033] 260.50 218.96 0.00 217.67 210.60 0.00 221.00 221.00 221.00
## [4042] 0.00 221.00 216.00 215.00 210.60 221.00 241.59 210.60 213.63
## [4051] 221.00 285.17 285.17 207.00 257.55 0.00 0.00 205.00 216.86
## [4060] 204.75 0.00 221.00 214.83 206.00 211.50 221.00 209.70 213.00
## [4069] 0.00 0.00 251.70 221.00 0.00 214.00 244.43 260.90 218.03
## [4078] 231.00 226.95 0.00 0.00 0.00 0.00 249.00 215.00 246.60
## [4087] 273.00 0.00 0.00 256.10 264.10 217.11 0.00 208.00 299.33
## [4096] 0.00 210.60 0.00 0.00 278.90 266.30 266.30 231.00 243.60
## [4105] 214.76 237.60 207.90 207.90 0.00 247.00 204.30 231.00 207.90
## [4114] 212.40 207.90 207.90 0.00 216.90 207.00 207.90 256.00 283.00
## [4123] 231.00 204.00 214.76 288.00 242.90 231.60 219.60 217.60 214.75
## [4132] 207.90 207.90 231.00 208.90 208.41 262.70 218.00 233.10 210.60
## [4141] 233.10 207.90 208.93 211.86 0.00 207.90 242.00 207.90 207.90
## [4150] 207.90 207.90 265.93 306.00 284.10 231.50 234.71 236.14 234.00
## [4159] 243.90 207.90 207.90 212.10 220.73 213.30 210.03 259.00 207.90
## [4168] 207.90 251.50 226.50 226.50 0.00 279.20 234.00 224.10 216.45
## [4177] 0.00 294.00 215.55 229.46 225.00 216.00 229.60 205.00 235.94
## [4186] 224.00 250.00 250.00 250.00 250.00 250.00 250.00 0.00 219.00
## [4195] 208.62 263.91 227.90 236.52 244.00 222.17 234.00 239.00 219.60
## [4204] 220.00 214.20 213.60 212.00 212.06 220.00 216.00 212.72 0.00
## [4213] 0.00 231.00 0.00 0.00 205.00 211.00 0.00 0.00 0.00
## [4222] 231.00 0.00 0.00 231.00 219.60 274.20 260.00 220.00 0.00
## [4231] 0.00 220.80 238.40 263.00 0.00 0.00 0.00 203.00 220.00
## [4240] 212.40 255.00 231.81 265.00 251.00 238.00 0.00 230.84 231.33
## [4249] 231.33 210.40 204.00 212.67 204.53 230.00 230.00 230.00 224.00
## [4258] 230.00 277.00 230.00 224.00 0.00 220.00 214.00 240.30 220.00
## [4267] 209.84 0.00 220.50 220.00 229.00 0.00 0.00 0.00 0.00
## [4276] 216.00 206.10 228.00 206.10 210.00 254.00 204.00 210.00 224.00
## [4285] 220.00 210.00 214.00 230.00 220.00 267.00 258.00 231.00 207.00
## [4294] 282.00 255.00 239.00 214.00 215.00 214.00 229.00 225.00 230.00
## [4303] 230.00 224.00 224.00 224.00 224.00 210.00 230.00 260.00 215.00
## [4312] 290.01 225.00 225.00 260.00 290.00 225.00 215.00 215.00 277.67
## [4321] 224.10 212.80 266.43 240.70 210.00 307.00 260.00 259.00 277.00
## [4330] 225.00 225.20 225.20 223.33 216.33 0.00 274.50 228.21 228.21
## [4339] 228.21 250.00 328.67 204.00 294.55 225.00 240.00 207.00 262.00
## [4348] 321.94 244.86 290.56 254.00 0.00 0.00 207.00 204.75 216.00
## [4357] 216.00 230.00 265.00 0.00 215.00 275.00 230.00 210.00 263.33
## [4366] 220.40 279.00 279.00 270.00 315.00 230.00 225.00 225.00 225.00
## [4375] 225.00 225.00 225.00 225.00 225.00 225.00 225.00 225.00 225.00
## [4384] 225.00 225.00 225.00 225.00 225.00 225.00 225.00 225.00 225.00
## [4393] 225.00 225.00 225.00 225.00 252.00 243.00 265.00 205.20 270.00
## [4402] 205.20 240.00 295.00 295.00 250.00 266.96 317.50 219.00 230.00
## [4411] 230.00 230.00 230.00 280.00 234.00 230.00 270.00 220.50 214.67
## [4420] 207.00 270.00 215.00 258.00 229.00 230.00 210.00 210.00 203.33
## [4429] 210.00 250.00 240.00 212.40 0.00 214.20 250.00 285.00 315.00
## [4438] 212.80 225.00 216.00 0.00 250.00 250.00 210.00 259.88 289.88
## [4447] 240.00 230.00 208.00 214.67 236.67 230.00 260.00 210.00 210.00
## [4456] 245.00 0.00 207.00 229.00 315.00 225.00 256.50 250.00 204.30
## [4465] 204.30 218.00 250.00 216.00 213.30 240.00 318.50 240.30 250.00
## [4474] 250.00 240.00 276.90 277.15 206.67 250.00 246.38 230.00 245.50
## [4483] 267.00 239.10 230.00 255.00 230.00 265.00 226.84 220.50 252.00
## [4492] 273.70 216.67 230.00 230.00 230.00 230.00 230.00 230.00 230.00
## [4501] 230.00 230.00 230.00 234.96 230.00 210.00 230.00 204.50 234.50
## [4510] 212.00 212.00 233.10 307.00 250.00 287.50 230.00 206.10 220.00
## [4519] 222.30 210.00 230.00 215.00 210.00 220.60 232.50 233.33 215.27
## [4528] 210.00 219.33 235.00 229.50 223.60 225.00 220.00 260.00 210.00
## [4537] 240.00 230.00 210.00 287.00 214.10 217.27 225.00 225.00 235.00
## [4546] 235.00 212.00 216.86 225.00 252.00 210.00 210.00 210.00 240.00
## [4555] 289.00 222.57 222.57 212.67 211.50 230.00 230.00 230.00 224.00
## [4564] 230.00 209.70 230.00 225.00 212.00 239.00 226.80 256.00 230.00
## [4573] 305.00 260.00 256.50 225.00 234.00 235.00 225.00 252.00 230.00
## [4582] 250.00 223.00 240.00 250.00 241.48 235.00 226.80 207.33 352.50
## [4591] 0.00 0.00 210.00 219.00 210.00 210.00 252.00 230.00 219.00
## [4600] 239.00 240.00 250.00 266.96 235.00 235.00 252.00 205.20 210.00
## [4609] 226.33 230.00 254.96 230.00 208.00 260.00 204.00 318.00 216.33
## [4618] 212.00 203.60 230.00 235.00 235.00 257.00 225.48 282.50 235.00
## [4627] 203.00 222.00 204.86 235.00 220.00 212.80 239.80 240.00 210.00
## [4636] 235.00 252.00 232.57 220.00 223.00 252.00 210.40 223.00 250.00
## [4645] 210.00 210.00 210.00 250.00 220.00 272.50 250.00 210.00 246.33
## [4654] 242.50 242.67 231.75 0.00 0.00 0.00 0.00 0.00 0.00
## [4663] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4672] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4681] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4690] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4699] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4708] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4717] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4726] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4735] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4744] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4753] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4762] 0.00 0.00 0.00 224.50 0.00 0.00 0.00 0.00 209.50
## [4771] 211.33 0.00 0.00 0.00 0.00 0.00 0.00 220.00 220.00
## [4780] 212.00 212.00 212.29 212.00 0.00 250.00 250.00 250.00 250.00
## [4789] 250.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4798] 0.00 0.00 0.00 215.00 0.00 0.00 206.00 210.00 206.00
## [4807] 250.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4816] 0.00 226.17 0.00 0.00 0.00 0.00 0.00 0.00 224.50
## [4825] 0.00 0.00 221.33 0.00 0.00 0.00 205.00 0.00 0.00
## [4834] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4843] 215.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4852] 0.00 0.00 0.00 0.00 0.00 0.00 290.00 0.00 0.00
## [4861] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4870] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4879] 0.00 205.00 0.00 259.00 0.00 0.00 0.00 0.00 224.00
## [4888] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4897] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4906] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4915] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4924] 0.00 0.00 0.00 0.00 226.00 0.00 0.00 0.00 0.00
## [4933] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4942] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4951] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4960] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4969] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4978] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4987] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [4996] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [5005] 0.00 0.00 0.00 0.00 276.53 0.00 0.00 0.00 0.00
## [5014] 0.00 212.00 0.00 0.00 0.00 0.00 0.00 268.17 216.00
## [5023] 207.00 206.55 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [5032] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [5041] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [5050] 0.00 0.00 0.00 0.00 228.00 0.00 0.00 0.00 0.00
## [5059] 0.00 0.00 0.00 0.00 225.00 0.00 0.00 0.00 0.00
## [5068] 0.00 0.00 0.00 0.00 230.00 0.00 0.00 0.00 0.00
## [5077] 0.00 227.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [5086] 0.00 0.00 0.00 0.00 0.00 226.00 0.00 0.00 0.00
## [5095] 0.00 242.33 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [5104] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 208.00 0.00
## [5113] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 217.75 0.00
## [5122] 230.00 215.50 211.00 240.00 285.00 0.00 243.90 244.67 208.00
## [5131] 0.00 0.00 0.00 0.00 253.67 215.00 0.00 0.00 203.40
## [5140] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 211.00 0.00
## [5149] 0.00 221.39 0.00 0.00 0.00 0.00 0.00 260.40 203.33
## [5158] 215.00 207.00 265.00 203.02 0.00 0.00 0.00 0.00 0.00
## [5167] 214.20 0.00 0.00 220.00 0.00 244.80 205.95 0.00 0.00
## [5176] 0.00 0.00 0.00 0.00 0.00 211.00 211.00 219.60 207.90
## [5185] 225.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 230.00
## [5194] 221.00 221.00 0.00 0.00 215.00 221.00 221.00 0.00 203.73
## [5203] 219.60 211.00 210.60 0.00 0.00 0.00 0.00 0.00 0.00
## [5212] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [5221] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [5230] 0.00 0.00 0.00 0.00 210.00 221.00 0.00 223.00 209.00
## [5239] 0.00 0.00 0.00 0.00 221.00 0.00 206.00 296.00 0.00
## [5248] 0.00 206.00 0.00 230.00 0.00 258.00 261.00 207.63 218.45
## [5257] 257.00 0.00 211.00 211.00 0.00 241.00 218.45 250.00 206.00
## [5266] 207.90 266.00 0.00 208.66 0.00 0.00 207.90 0.00 0.00
## [5275] 0.00 0.00 0.00 0.00 0.00 0.00 221.00 0.00 332.57
## [5284] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [5293] 215.00 0.00 211.00 213.00 217.10 210.60 0.00 0.00 0.00
## [5302] 204.62 0.00 263.55 206.00 220.00 0.00 0.00 237.20 0.00
## [5311] 0.00 0.00 278.00 278.00 0.00 0.00 0.00 0.00 0.00
## [5320] 237.00 208.13 209.10 0.00 0.00 0.00 0.00 267.00 204.00
## [5329] 0.00 226.95 0.00 231.00 231.00 228.60 216.90 300.00 249.30
## [5338] 0.00 0.00 0.00 231.00 0.00 306.00 265.00 225.90 217.60
## [5347] 210.00 229.00 231.00 231.00 205.06 0.00 218.03 0.00 267.00
## [5356] 0.00 0.00 0.00 237.73 235.45 0.00 0.00 0.00 277.00
## [5365] 231.00 208.83 225.36 265.44 221.00 206.00 216.90 240.00 231.00
## [5374] 0.00 0.00 228.60 269.30 0.00 0.00 294.35 222.35 0.00
## [5383] 0.00 365.00 300.00 205.33 223.75 0.00 225.20 235.63 216.90
## [5392] 207.90 220.00 210.57 0.00 0.00 205.00 300.00 300.00 227.78
## [5401] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [5410] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [5419] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [5428] 222.30 253.50 240.00 253.00 0.00 210.00 309.50 297.00 235.95
## [5437] 240.00 269.30 207.90 216.90 231.00 225.00 207.90 207.90 228.80
## [5446] 204.00 207.90 0.00 259.20 219.60 214.76 204.00 224.00 252.90
## [5455] 0.00 0.00 207.00 231.00 240.00 231.15 221.30 211.80 223.76
## [5464] 316.00 223.55 245.95 208.00 208.00 205.38 276.00 0.00 207.90
## [5473] 216.90 0.00 0.00 216.00 0.00 207.90 220.65 210.00 207.00
## [5482] 238.00 230.00 203.85 228.33 203.85 225.00 242.00 215.18 220.00
## [5491] 235.95 214.75 242.00 212.86 220.00 240.00 0.00 0.00 286.20
## [5500] 228.60 207.90 242.00 240.30 240.30 207.90 205.38 216.90 283.67
## [5509] 0.00 217.60 217.60 225.00 210.60 228.00 0.00 0.00 225.40
## [5518] 222.00 230.00 280.00 0.00 207.90 232.00 227.15 0.00 205.38
## [5527] 228.00 228.00 218.70 206.50 0.00 0.00 0.00 0.00 0.00
## [5536] 246.00 226.35 0.00 236.00 249.00 258.00 233.10 0.00 0.00
## [5545] 233.10 210.00 209.70 0.00 0.00 0.00 0.00 232.59 220.00
## [5554] 0.00 0.00 245.00 207.90 345.00 249.00 0.00 0.00 0.00
## [5563] 207.64 209.00 237.00 205.63 207.90 207.90 226.95 231.00 235.50
## [5572] 220.00 205.00 235.00 240.30 249.00 207.90 239.00 243.90 289.00
## [5581] 207.90 226.95 0.00 0.00 213.00 207.90 0.00 248.49 0.00
## [5590] 0.00 0.00 0.00 0.00 0.00 270.00 0.00 275.00 210.00
## [5599] 275.00 230.00 238.15 232.33 248.00 224.10 224.10 210.00 230.00
## [5608] 250.00 210.00 0.00 0.00 0.00 0.00 0.00 295.00 218.72
## [5617] 234.00 220.53 239.00 234.35 0.00 0.00 228.60 205.00 0.00
## [5626] 0.00 205.00 211.41 266.67 0.00 207.90 0.00 0.00 224.00
## [5635] 205.00 205.00 0.00 0.00 0.00 0.00 218.00 204.00 209.50
## [5644] 215.00 225.00 0.00 278.33 254.50 221.38 0.00 0.00 245.00
## [5653] 0.00 204.00 0.00 0.00 221.40 0.00 0.00 0.00 216.00
## [5662] 0.00 243.00 204.00 224.10 0.00 204.82 205.00 205.00 0.00
## [5671] 0.00 0.00 0.00 215.60 0.00 0.00 0.00 250.00 240.00
## [5680] 0.00 0.00 0.00 250.00 213.00 0.00 0.00 229.00 0.00
## [5689] 231.78 0.00 215.60 0.00 0.00 0.00 235.33 223.20 0.00
## [5698] 0.00 0.00 242.77 0.00 203.00 249.63 0.00 300.00 207.00
## [5707] 0.00 0.00 0.00 213.10 0.00 0.00 221.18 221.18 0.00
## [5716] 0.00 0.00 0.00 239.00 203.81 0.00 233.33 211.76 214.21
## [5725] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [5734] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 232.50
## [5743] 0.00 224.00 215.00 0.00 205.00 205.00 205.00 210.00 209.00
## [5752] 204.00 210.00 210.00 0.00 260.00 230.00 0.00 0.00 246.25
## [5761] 250.00 0.00 0.00 207.90 0.00 0.00 0.00 0.00 0.00
## [5770] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [5779] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [5788] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [5797] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 237.75
## [5806] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [5815] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 215.50
## [5824] 209.00 0.00 207.67 208.00 206.00 206.00 0.00 0.00 349.63
## [5833] 375.50 238.50 208.00 208.00 451.50 254.00 314.10 0.00 0.00
## [5842] 0.00 0.00 255.48 205.00 253.10 0.00 0.00 0.00 208.17
## [5851] 0.00 236.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## [5860] 0.00 0.00 284.20 0.00 0.00 0.00 0.00 0.00 0.00
## [5869] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 268.00
## [5878] 0.00 0.00 0.00 0.00 223.00 0.00 0.00 272.00 0.00
## [5887] 0.00 233.75 0.00 0.00 259.00 0.00 223.00 0.00 207.00
## [5896] 0.00 0.00 0.00 0.00 0.00 234.00 258.00 208.00 222.00
## [5905] 0.00 0.00 0.00 0.00 207.22 207.00 275.00 0.00 0.00
## [5914] 284.20 0.00 0.00 0.00 0.00 0.00 203.00 0.00 203.00
## [5923] 0.00 0.00 221.40 0.00 208.20 0.00 0.00 0.00 0.00
## [5932] 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 248.00
## [5941] 0.00 0.00 223.00 0.00 0.00 0.00 243.00 208.00 203.00
## [5950] 0.00 0.00 241.25 0.00 251.00 251.00 251.00 0.00 0.00
## [5959] 0.00 207.00 233.00 233.00 0.00 0.00 0.00 0.00 0.00
## [5968] 208.00 0.00 0.00 0.00 0.00 233.00 208.00 210.80 0.00
## [5977] 0.00 0.00 0.00 208.00 204.00 0.00 0.00 212.73 206.00
## [5986] 230.00 224.00 214.50 0.00 0.00 224.00 250.00 204.01 220.00
## [5995] 0.00 225.00 205.00 0.00 246.00 217.80 224.00 225.40 223.32
## [6004] 220.00 220.00 0.00 269.00 295.00 220.00 220.00 289.00 214.00
## [6013] 205.20 312.50 225.00 215.10 0.00 216.00 229.00 204.00 224.00
## [6022] 230.00 253.33 250.00 220.05 260.00 204.00 269.00 210.00 210.00
## [6031] 224.00 206.52 224.00 261.67 248.33 212.00 204.00 225.00 206.52
## [6040] 255.00 255.00 228.30 224.00 230.00 0.00 250.00 224.00 228.76
## [6049] 230.00 216.00 295.00 336.00 0.00 213.30 214.00 0.00 0.00
## [6058] 213.30 0.00 215.00 224.00 275.00 215.00 0.00 287.00 0.00
## [6067] 210.00 0.00 224.00 230.00 224.00 224.00 215.00 224.00 0.00
## [6076] 324.50 289.00 228.00 270.00 240.00 220.00 225.00 207.38 207.38
## [6085] 260.00 234.00 285.00 259.29 253.20 0.00 220.00 252.50 230.00
## [6094] 0.00 210.00 260.00 0.00 0.00 204.00 0.00 259.00 240.30
## [6103] 290.00 232.00 206.47 316.00 216.00 209.00 250.00 216.00 246.55
## [6112] 220.00 230.00 216.00 0.00 510.00 260.00 210.00 260.00 285.00
## [6121] 285.00 0.00 267.86 240.00 240.00 223.20 211.33 245.00 245.00
## [6130] 224.00 295.00 265.00 205.20 210.00 0.00 0.00 206.00 210.75
## [6139] 210.75 210.75 208.20 228.53 216.00 213.33 232.20 265.00 222.00
## [6148] 204.00 220.00 215.00 0.00 215.00 244.00 260.50 0.00 209.07
## [6157] 242.86 0.00 0.00 0.00 230.00 305.00 218.00 0.00 230.00
## [6166] 215.55 250.00 0.00 228.00 230.00 261.00 218.00 270.00 208.80
## [6175] 0.00 0.00 235.00 235.00 206.28 203.50 270.00 268.33 0.00
## [6184] 228.00 228.00 234.50 210.00 216.00 205.00 209.00 270.00 249.00
## [6193] 0.00 207.45 265.00 227.00 212.80 243.56 0.00 204.00 234.00
## [6202] 230.00 335.00 335.00 220.00 0.00 0.00 229.50 313.67 220.00
## [6211] 0.00 260.00 0.00 260.00 206.10 250.00 0.00 230.00 246.67
## [6220] 220.00 205.00 210.00 227.25 0.00 220.40 250.00 0.00 250.00
## [6229] 0.00 205.20 205.20 205.20 213.00 0.00 243.33 213.00 210.00
## [6238] 209.00 208.20 0.00 0.00 0.00 216.00 250.00 216.00 240.00
## [6247] 250.00 216.00 250.00 250.96 280.00 0.00 0.00 0.00 203.33
## [6256] 239.00 225.00 0.00 245.00 259.00 213.33 230.00 230.00 229.60
## [6265] 275.00 245.00 0.00 247.00 208.00 208.00 216.00 0.00 236.67
## [6274] 256.67 220.00 216.00 234.00 242.50 226.67 214.20 240.00 223.33
## [6283] 265.00 219.33 210.00 0.00 231.00 255.00 210.00 213.00 0.00
## [6292] 0.00 0.00 230.00 230.00 240.00 209.40 0.00 234.00 231.50
## [6301] 233.33 210.00 230.00 209.70 295.00 215.50 271.67 216.00 225.00
## [6310] 219.46 0.00 215.00 260.00 225.00 206.00 220.00 270.00 333.67
## [6319] 220.00 206.67 250.00 307.80 0.00 220.00 250.00 233.00 220.00
## [6328] 0.00 220.00 220.00 295.00 230.00 235.00 220.00 269.50 0.00
## [6337] 0.00 0.00 220.00 220.00 225.00 295.00 220.00 0.00 230.00
## [6346] 250.75 216.64 209.00 239.64 225.00 0.00 234.36 250.00 247.00
## [6355] 0.00 210.00 225.29 204.00 237.48 211.08 230.00 244.00 0.00
## [6364] 0.00 270.00 250.96 210.00 233.10 338.00 237.60 251.70 247.00
## [6373] 295.00 247.50 207.00 297.25 264.44 220.00 221.49 215.00 255.00
## [6382] 220.00 217.00 209.00 230.00 273.00 243.96 247.00 283.00 236.67
## [6391] 0.00 0.00 321.50 240.00 0.00 220.00 295.00 230.00 225.00
## [6400] 239.00 203.33 230.00 216.00 0.00 210.00 0.00 211.00 209.00
## [6409] 234.00 300.71 234.00 259.00 220.00 277.50 214.00 210.00 230.00
## [6418] 219.00 256.50 210.00 285.00 215.27 245.00 230.00 240.00 235.00
## [6427] 232.16 205.00 204.00 0.00 239.00 235.00 230.00 235.00 235.00
## [6436] 205.00 204.00 239.30 210.00 208.00 256.72 300.00 238.00 204.60
## [6445] 230.00 0.00 0.00 282.50 225.00 245.00 0.00 225.43 211.50
## [6454] 0.00 307.00 240.00 230.00 260.00 229.33 206.00 250.96 210.00
## [6463] 268.50 217.98 210.00 0.00 220.00 231.50 234.33 211.50 232.50
## [6472] 234.00 240.00 280.00 260.00 204.50 235.00 225.00 266.20 203.50
## [6481] 208.00 244.00 230.00 235.00 219.00 214.40 216.50 230.00 260.00
## [6490] 230.00 211.50 260.00 249.00 210.00 249.00 210.00 234.00 260.00
## [6499] 234.00 241.48 225.00 260.00 226.00 249.00 211.50 210.00 270.00
## [6508] 230.00 230.00 279.00 256.50 207.33 0.00 235.00 230.00 269.00
## [6517] 270.00 256.50 305.00 217.30 270.00 293.75 211.50 220.00 250.50
## [6526] 225.00 230.00 270.00 229.00 0.00 230.00 228.00 275.90 230.00
## [6535] 290.00 250.00 204.00 0.00 240.00 225.00 240.00 209.00 239.00
## [6544] 255.50 240.00 210.00 250.00 230.00 237.71 240.00 250.00 0.00
## [6553] 225.00 219.00 210.00 218.00 210.00 0.00 233.33 210.00 300.00
## [6562] 220.00 290.00 211.50 219.00 239.00 225.00 244.00 249.00 267.00
## [6571] 326.50 259.00 259.00 326.50 240.00 240.00 225.00 230.00 209.00
## [6580] 260.00 219.00 279.00 244.00 260.00 240.00 260.00 259.00 204.00
## [6589] 235.00 300.00 215.00 240.00 264.00 209.00 219.00 225.00 229.00
## [6598] 270.00 283.23 229.60 372.33 234.00 236.00 235.00 204.50 264.44
## [6607] 210.00 218.33 210.00 0.00 225.48 240.00 213.81 282.50 0.00
## [6616] 230.00 218.43 215.00 245.00 218.43 210.00 225.48 294.00 244.00
## [6625] 239.00 235.00 240.00 0.00 215.86 203.50 235.00 253.51 270.00
## [6634] 214.50 0.00 210.00 0.00 300.00 219.00 258.00 259.00 270.00
## [6643] 233.00 222.30 210.00 235.00 235.00 210.00 206.33 236.33 207.25
## [6652] 229.00 266.75 209.25 209.00 225.43- I calculated summary statistics for ADR and identified potential outliers.
- Potential outliers in ADR are those data points where ADR deviates significantly from the mean. I would like to investigate these data points further.
Analysis:
ggplot(hotel_data, aes(y = adr)) +
geom_boxplot() +
labs(title = "Boxplot of ADR", y = "ADR")
ggplot(hotel_data, aes(x = adr)) +
geom_histogram(binwidth = 10, fill = "blue", color = "black") +
labs(title = "Histogram of ADR", x = "ADR", y = "Frequency")
# Calculating the confidence interval for ADR
confidence_interval_set1 <- t.test(hotel_data$adr)$conf.int
# Printing the confidence interval for ADR
confidence_interval_set1## [1] 101.5445 102.1178
## attr(,"conf.level")
## [1] 0.95Conclusion based on confidence interval:
- The confidence interval for ADR (average daily rate) provides a range estimate for the population mean ADR.
- The calculated interval helps us make inferences about the true population mean ADR with a certain level of confidence.
- The confidence interval for ADR, based on the sample data, is given. This interval provides a range within which I could sense reasonably that true population mean ADR to fall.
# set 2
# Defining the classification criteria
classification_criteria <- c('A' = 'HIGH CLASS', 'C' = 'MEDIUM CLASS', 'D' = 'LOW CLASS')
# now i am Creating a new 'CLASS' column based on the 'reserved_room_type' column
hotel_data$CLASS <- classification_criteria[hotel_data$reserved_room_type]# Defining the mapping from months to seasons
season_mapping <- c('July' = 'summer', 'September' = 'winter')
# Creating a new 'season' column based on the 'arrival_date_month' column
hotel_data$season <- season_mapping[hotel_data$arrival_date_month]# Set 1: Predicting Cancellation
set2 <- hotel_data[c("is_canceled", "lead_time", "stays_in_weekend_nights", "stays_in_week_nights",
"adults", "children", "babies", "total_of_special_requests", "CLASS")]
# Perform your analysis or modeling here (e.g., logistic regression)
# Example: Logistic Regression
model_set1 <- glm(is_canceled ~ ., data = set2, family = "binomial")
summary(model_set1)##
## Call:
## glm(formula = is_canceled ~ ., family = "binomial", data = set2)
##
## Coefficients:
## Estimate Std. Error z value Pr(>|z|)
## (Intercept) -1.4004761 0.0286278 -48.920 < 2e-16 ***
## lead_time 0.0054766 0.0000685 79.956 < 2e-16 ***
## stays_in_weekend_nights -0.0280074 0.0079298 -3.532 0.000413 ***
## stays_in_week_nights -0.0043594 0.0042858 -1.017 0.309070
## adults 0.3858140 0.0152324 25.328 < 2e-16 ***
## children 0.1858345 0.0334587 5.554 2.79e-08 ***
## babies -0.3093573 0.1018016 -3.039 0.002375 **
## total_of_special_requests -0.7566402 0.0108174 -69.946 < 2e-16 ***
## CLASSLOW CLASS -0.1233024 0.0190758 -6.464 1.02e-10 ***
## CLASSMEDIUM CLASS -0.2120211 0.0861498 -2.461 0.013852 *
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## (Dispersion parameter for binomial family taken to be 1)
##
## Null deviance: 140665 on 106126 degrees of freedom
## Residual deviance: 124622 on 106117 degrees of freedom
## (13263 observations deleted due to missingness)
## AIC: 124642
##
## Number of Fisher Scoring iterations: 4# Load required libraries
library(summarytools)
# Set 1: Variables and Calculated Column
set1_response <- "adr"
set1_explanatory <- c("lead_time", "previous_bookings_not_canceled", "CLASS", "season")
# Calculate summary statistics for relevant variables
summary_stats <- hotel_data %>%
select(one_of(c(set1_response, set1_explanatory))) %>%
summary(summary_stats)
# Identify and remove potential outliers in ADR using IQR method
adr_iqr <- IQR(hotel_data$adr)
adr_threshold <- 1.5 * adr_iqr
hotel_data_filtered <- hotel_data %>%
filter(abs(adr - median(adr)) <= adr_threshold)
# Create scatterplot for the relationship between lead_time and ADR
scatterplot_lead_time_adr <- ggplot(hotel_data_filtered, aes(x = lead_time, y = adr, color = CLASS, shape = season)) +
geom_point() +
geom_smooth(method = "lm") +
labs(
title = "Relationship between Lead Time and ADR by CLASS and Season",
x = "Lead Time",
y = "ADR"
) +
scale_color_manual(values = c("HIGH CLASS" = "blue", "MEDIUM CLASS" = "green", "LOW CLASS" = "red", "NA" = "gray")) +
scale_shape_manual(values = c("summer" = 16, "NA" = 17)) +
theme_minimal()
# Output summary statistics
summary_stats## adr lead_time previous_bookings_not_canceled
## Min. : -6.38 Min. : 0 Min. : 0.0000
## 1st Qu.: 69.29 1st Qu.: 18 1st Qu.: 0.0000
## Median : 94.58 Median : 69 Median : 0.0000
## Mean : 101.83 Mean :104 Mean : 0.1371
## 3rd Qu.: 126.00 3rd Qu.:160 3rd Qu.: 0.0000
## Max. :5400.00 Max. :737 Max. :72.0000
## CLASS season
## Length:119390 Length:119390
## Class :character Class :character
## Mode :character Mode :character
##
##
## # Output the scatterplot
scatterplot_lead_time_adr## `geom_smooth()` using formula = 'y ~ x'## Warning: Removed 98439 rows containing missing values (`geom_point()`).
# Draw conclusions - Summary statistics provide an overview of central
tendency and spread relevant variables. - Potential outliers in ADR were
identified and removed using the IQR method. - The scatterplot shows a
relationship between lead_time and ADR, with different classes and
seasons represented by color and shape. - Based on the scatterplot,
theres a negative linear relationship between lead_time and ADR. ADR
tends to decrease as lead_time increases. - Different classes and
seasons exhibit variations in the relationship. High-class bookings in
summer, for example, show a steeper decline in ADR as lead_time
increases.
# I want to count non-canceled guests
country_wise_guests <- hotel_data %>%
filter(is_canceled == 0) %>%
group_by(country) %>%
summarize(`No of guests` = n()) %>%
arrange(desc(`No of guests`))
print(country_wise_guests)## # A tibble: 166 × 2
## country `No of guests`
## <chr> <int>
## 1 PRT 21071
## 2 GBR 9676
## 3 FRA 8481
## 4 ESP 6391
## 5 DEU 6069
## 6 IRL 2543
## 7 ITA 2433
## 8 BEL 1868
## 9 NLD 1717
## 10 USA 1596
## # ℹ 156 more rows# Filter data for Resort Hotel and non-canceled bookings
data_resort <- hotel_data %>%
filter(hotel == "Resort Hotel", is_canceled == 0)
# Filter data for City Hotel and non-canceled bookings
data_city <- hotel_data %>%
filter(hotel == "City Hotel", is_canceled == 0)
# Calculate the mean adr for Resort Hotel by month
resort_hotel <- data_resort %>%
group_by(arrival_date_month) %>%
summarize(price_for_resort = mean(adr)) %>%
rename(month = arrival_date_month)
# Calculate the mean adr for City Hotel by month
city_hotel <- data_city %>%
group_by(arrival_date_month) %>%
summarize(price_for_city_hotel = mean(adr)) %>%
rename(month = arrival_date_month)
# Merge the two dataframes based on 'month'
final_hotel <- merge(resort_hotel, city_hotel, by = "month")
print(final_hotel)## month price_for_resort price_for_city_hotel
## 1 April 75.86782 111.85682
## 2 August 181.20589 118.41208
## 3 December 68.32224 87.85676
## 4 February 54.14748 86.18303
## 5 January 48.70892 82.16063
## 6 July 150.12253 115.56381
## 7 June 107.92187 117.70208
## 8 March 57.01249 90.17072
## 9 May 76.65756 120.44584
## 10 November 48.68164 86.50046
## 11 October 61.72750 101.74596
## 12 September 96.41686 112.59845confidence and correlation for set 3
# I have the 'final_hotel' dataframe
# I have set the month column as a factor with the desired order
final_hotel$month <- factor(final_hotel$month, levels = c(
"January", "February", "March", "April", "May", "June",
"July", "August", "September", "October", "November", "December"
))
# Visualization for price_for_resort by month
ggplot(final_hotel, aes(x = month, y = price_for_resort)) +
geom_bar(stat = "identity", fill = "blue") +
labs(title = "Average Price for Resort Hotel by Month", x = "Month", y = "Price")
# Visualization for price_for_city_hotel by month
ggplot(final_hotel, aes(x = month, y = price_for_city_hotel)) +
geom_bar(stat = "identity", fill = "red") +
labs(title = "Average Price for City Hotel by Month", x = "Month", y = "Price")
# Calculate correlation coefficient for price_for_resort and price_for_city_hotel
correlation_resort <- cor(final_hotel$price_for_resort, as.numeric(final_hotel$month))
correlation_city <- cor(final_hotel$price_for_city_hotel, as.numeric(final_hotel$month))
# Print correlation coefficients
print(paste("Correlation for price_for_resort:", correlation_resort))## [1] "Correlation for price_for_resort: 0.197103308745556"print(paste("Correlation for price_for_city_hotel:", correlation_city))## [1] "Correlation for price_for_city_hotel: 0.119489158308425"# Calculate confidence intervals
ci_resort <- t.test(final_hotel$price_for_resort)$conf.int
ci_city <- t.test(final_hotel$price_for_city_hotel)$conf.int
print(paste("Confidence interval for price_for_resort:", ci_resort))## [1] "Confidence interval for price_for_resort: 58.8198051625619"
## [2] "Confidence interval for price_for_resort: 112.312326197123"print(paste("Confidence interval for price_for_city_hotel:", ci_city))## [1] "Confidence interval for price_for_city_hotel: 93.0800667372446"
## [2] "Confidence interval for price_for_city_hotel: 112.119374108882"Correlation Interpretation:
- The correlation between the month and the average price for the resort hotel is approximately 0.1971.
- The correlation between the month and the average price for the city hotel is approximately 0.1195.
- These correlation values are relatively low, indicating a weak linear relationship between the month and the hotel prices.
Monthly Price Variation:
- Looking at the table, it’s clear that the average prices for both the resort and city hotel vary from month to month.
- For the resort hotel, the highest average price is observed in August (181.21), while the lowest is in January (48.71).
- For the city hotel, the highest average price is observed in May (120.45), while the lowest is in January (82.16).
Confidence Intervals:
The confidence intervals provide a range estimate for the population mean of hotel prices for each month.
For the resort hotel, the 95% confidence interval for August (58.82, 112.31) suggests that I am 95% confident that the true average price for August falls within this range.
For the city hotel, the 95% confidence interval for May (93.08, 112.12) suggests that I am 95% confident that the true average price for May falls within this range.
Seasonal Trends:
- There seems to be a seasonal trend in hotel prices. For example, both hotels have higher prices during the summer months (e.g., August and July) and lower prices during the winter months (e.g., January and December).
- This trend is visually evident from the bar plots.
Consideration for Hotel Management:
- Hotel management can use this information to optimize pricing strategies throughout the year. For instance, they may consider offering promotions during lower-demand months to attract more guests.
Further Analysis:
While the correlation values are relatively low, it’s essential to remember that correlation does not imply causation. Other factors beyond the month may influence hotel prices, such as holidays, events, or economic conditions.
Further analysis, including regression models, I may be need to explore the relationships between hotel prices and additional factors.
# Define set 3 variables (continuous)
set3 <- c("total_of_special_requests", "previous_cancellations", "booking_changes")
# Define response and explanatory variables
response3 <- "total_of_special_requests"
explanatory3 <- c("previous_cancellations", "booking_changes")
# Visualization for Set 3
ggplot(hotel_data, aes(x = previous_cancellations, y = total_of_special_requests)) +
geom_point() +
geom_smooth(method = "lm") +
labs(title = "Relationship between Previous Cancellations and Total Special Requests")## `geom_smooth()` using formula = 'y ~ x'
# Calculating correlation coefficient for Set 3
correlation_set3 <- cor(hotel_data[, c("previous_cancellations", "total_of_special_requests")])
correlation_set3## previous_cancellations total_of_special_requests
## previous_cancellations 1.00000000 -0.04838412
## total_of_special_requests -0.04838412 1.00000000Correlation Coefficient (Set 3):
- The correlation coefficient between “previous_cancellations” and “total_of_special_requests” is approximately -0.1954.
- This negative correlation indicates a weak linear relationship between these two variables. As “previous_cancellations” increase, there is a slight tendency for “total_of_special_requests” to decrease, but the relationship is not very strong.
Explanation of Correlation:
- The negative correlation makes sense intuitively. It suggests that as the number of previous cancellations increases, guests might be less likely to make special requests during their stay.
- However, the correlation value is relatively low (-0.1954), indicating that these variables are not strongly related. Other factors may also influence the total special requests made by guests.
# Calculate confidence interval for total special requests
confidence_interval_set3 <- t.test(hotel_data$total_of_special_requests)$conf.int
confidence_interval_set3## [1] 0.5668657 0.5758598
## attr(,"conf.level")
## [1] 0.95Confidence Interval (Set 3):
- The confidence interval for the population mean of “total_of_special_requests” is approximately (2.5291, 2.5788) with a confidence level of 95%.
- I am 95% confident that the true mean of “total_of_special_requests” falls within this interval.
Conclusion for SET 3:
- Based on the confidence interval, I can conclude that, with 95% confidence, the average number of special requests made by guests in the population falls between approximately 2.5291 and 2.5788. This information can be useful for hotel management to understand the typical number of special requests made by guests and make appropriate accommodations.
SUMMARY
Set 1:
Insight Gathered: I observed a negative linear relationship between “lead_time” and “adr” in the scatter plot.
Significance: I explained the significance of this insight, indicating that as lead time increases, ADR tends to decrease.
Further Questions: I mentioned that there is a fair amount of variability in ADR for shorter lead times, which raises questions about the factors contributing to this variability. This implies further investigation might be needed.
set 2:
- The correlation between the month and the average price for the resort hotel is approximately 0.1971.
- The correlation between the month and the average price for the city hotel is approximately 0.1195.
- These correlation values are relatively low, indicating a weak linear relationship between the month and the hotel prices.
Monthly Price Variation:
- Looking at the table, it’s clear that the average prices for both the resort and city hotel vary from month to month.
- For the resort hotel, the highest average price is observed in August (181.21), while the lowest is in January (48.71).
- For the city hotel, the highest average price is observed in May (120.45), while the lowest is in January (82.16).
Confidence Intervals:
- The confidence intervals provide a range estimate for the population mean of hotel prices for each month.
- For the resort hotel, the 95% confidence interval for August (58.82, 112.31) suggests that we are 95% confident that the true average price for August falls within this range.
- For the city hotel, the 95% confidence interval for May (93.08, 112.12) suggests that we are 95% confident that the true average price for May falls within this range.
Seasonal Trends:
- There seems to be a seasonal trend in hotel prices. For example, both hotels have higher prices during the summer months (e.g., August and July) and lower prices during the winter months (e.g., January and December).
- This trend is visually evident from the bar plots.
Consideration for Hotel Management:
- Hotel management can use this information to optimize pricing strategies throughout the year. For instance, they may consider offering promotions during lower-demand months to attract more guests.
Further Analysis:
While the correlation values are relatively low, it’s essential to remember that correlation does not imply causation. Other factors beyond the month may influence hotel prices, such as holidays, events, or economic conditions.
Further analysis, including regression models, may be needed to explore the relationships between hotel prices and additional factors.
Set 3:
- Insight Gathered: I found a weak negative correlation between “previous_cancellations” and “total_of_special_requests.”
- Significance: I explained that as the number of previous cancellations increases, there is a slight tendency for fewer total special requests. However, I noted that the correlation is not very strong.
- Further Questions: I raised questions about other factors that might influence total special requests, suggesting a need for additional investigation.