| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
1 | LEGO City Set | Pieces | Price ($) | Source | |||||
2 | LEGO City Advent Calendar | 278 | 29.99 | shop.lego.com | |||||
3 | Deep Sea Scuba Scooter | 42 | 6.99 | ||||||
4 | Deep Sea Starter Set | 90 | 9.99 | Pieces | (How it's calculated -- add an "=" before the following command) | ||||
5 | Deep Sea Submarine | 274 | 39.99 | min | 38 | min(B:B) | |||
6 | Deep Sea Helicopter | 388 | 49.99 | Q1 | 172.25 | QUARTILE(B:B,1) | |||
7 | Deep Sea Exploration Vessel | 717 | 119.99 | median | 276 | median(B:B) | |||
8 | Deep Sea Operation Base | 907 | 99.99 | Q3 | 486.75 | quartile(B:B,3) | |||
9 | Space Starter Set | 107 | 9.99 | max | 1,683 | max(B:B) | |||
10 | Utility Shuttle | 155 | 24.99 | IQR | 314.5 | E8-E6 | |||
11 | Training Jet Transporter | 448 | 49.99 | 1.5xIQR | 471.75 | 1.5*E10 | |||
12 | Spaceport | 586 | 119.99 | lower outlier limit | -299.5 | ||||
13 | High Speed Chase | 284 | 29.99 | upper outlier limit | 958.5 | ||||
14 | Crook Pursuit | 38 | 6.99 | mean | 374 | average(B:B) | |||
15 | High Speed Police Chase | 110 | 19.99 | standard dev. | 310.8237129 | STDEV(B:B) | |||
16 | Prisoner Transporter | 196 | 24.99 | ||||||
17 | Mobile Police Unit | 375 | 44.99 | ||||||
18 | Helicopter Surveillance | 528 | 74.99 | Price | |||||
19 | Police Station | 854 | 99.99 | min | 6.99 | ||||
20 | Police Dog Unit | 249 | 29.99 | Q1 | 19.99 | ||||
21 | Helicopter Transporter | 382 | 44.99 | median | 29.99 | ||||
22 | Race Car | 100 | 9.99 | Q3 | 71.24 | ||||
23 | Monster Truck | 78 | 9.99 | max | 199.99 | ||||
24 | Campter Van | 195 | 19.99 | IQR | 51.25 | ||||
25 | Auto Transporter | 349 | 29.99 | 1.5xIQR | 76.875 | ||||
26 | ATV Patrol | 59 | 6.99 | lower outlier limit | -56.885 | ||||
27 | Swamp Police Starter Set | 78 | 9.99 | upper outlier limit | 148.115 | ||||
28 | Helicopter Pursuit | 253 | 39.99 | mean | 52.19 | ||||
29 | Crooks' Hideout | 473 | 69.99 | standard dev. | 49.60770455 | ||||
30 | Swamp Police Station | 707 | 89.99 | ||||||
31 | Water Plane Chase | 263 | 29.99 | ||||||
32 | Hovercraft Arrest | 331 | 44.99 | ||||||
33 | Demolition Starter Set | 85 | 9.99 | ||||||
34 | Service Truck | 233 | 24.99 | ||||||
35 | Bulldozer | 384 | 39.99 | ||||||
36 | Excavator and Truck | 311 | 49.99 | ||||||
37 | Demolition Site | 776 | 89.99 | ||||||
38 | Pickup Tow Truck | 209 | 19.99 | ||||||
39 | Dune Buggy Trailer | 222 | 19.99 | ||||||
40 | Snowplow Truck | 196 | 19.99 | ||||||
41 | Racing Bike Transporter | 178 | 19.99 | ||||||
42 | 4x4 with Powerboat | 301 | 29.99 | ||||||
43 | LEGO City Starter Set | 242 | 29.99 | ||||||
44 | Fire Starter Set | 92 | 9.99 | ||||||
45 | Fire Truck | 209 | 19.99 | ||||||
46 | Fire Station | 753 | 99.99 | ||||||
47 | City Square | 1,683 | 189.99 | ||||||
48 | Arctic Snowmobile | 44 | 6.99 | ||||||
49 | Arctic Ice Crawler | 113 | 14.99 | ||||||
50 | Arctic Helicrane | 262 | 39.99 | ||||||
51 | Arctic Outpost | 374 | 49.99 | ||||||
52 | Arctic Base Camp | 735 | 89.99 | ||||||
53 | Arctic Ice Breaker | 717 | 129.99 | ||||||
54 | Train Station | 423 | 64.99 | ||||||
55 | High-speed Passenger Train | 610 | 149.99 | ||||||
56 | Cargo Train | 888 | 199.99 | ||||||
57 | Heavy Haul Train | 984 | 199.99 | ||||||
58 | |||||||||
59 | |||||||||
60 | |||||||||
61 | |||||||||
62 | |||||||||
63 | |||||||||
64 | |||||||||
65 | |||||||||
66 | |||||||||
67 | |||||||||
68 | |||||||||
69 | |||||||||
70 | |||||||||
71 | |||||||||
72 | |||||||||
73 | |||||||||
74 | |||||||||
75 | |||||||||
76 | |||||||||
77 | |||||||||
78 | |||||||||
79 | |||||||||
80 | |||||||||
81 | |||||||||
82 | |||||||||
83 | |||||||||
84 | |||||||||
85 | |||||||||
86 | |||||||||
87 | |||||||||
88 | |||||||||
89 | |||||||||
90 | |||||||||
91 | |||||||||
92 | |||||||||
93 | |||||||||
94 | |||||||||
95 | |||||||||
96 | |||||||||
97 | |||||||||
98 | |||||||||
99 | |||||||||
100 |