Box & Whisker vs. Histogram Demo

Loading the math board and drawing, please wait…

2019-06-12 02:31

This example demonstrates the differences between box plots and histograms in visualizing data distributions. It involves core mathematical concepts like mean, median, mode, min, Q1, Q3, max, confidence interval, and distributions. The construction uses GeoGebra commands: mean, Median, Mode, Min, Q1, Q3, Max, If, Sum, Histogram, BoxPlot, Polygon, Vector, Segment. Suitable for high school and above students learning data visualization techniques.

GeoGebra Commands & Parameters

mean(B3:B5) → C5
Median(B3:B5) → D5
Mode(B3:B5) → E5
Min(B3:B5) → F5
Q1(B3:B5) → G5
Q3(B3:B5) → I5
Max(B3:B5) → J5
mean(B3:B6) → C6
mean(B3:B7) → C7
mean(B3:B8) → C8
mean(B3:B9) → C9
mean(B3:B10) → C10
mean(B3:B11) → C11
mean(B3:B12) → C12
mean(B3:B13) → C13
mean(B3:B14) → C14
mean(B3:B15) → C15
mean(B3:B16) → C16
mean(B3:B17) → C17
mean(B3:B18) → C18
mean(B3:B19) → C19
mean(B3:B20) → C20
mean(B3:B21) → C21
mean(B3:B22) → C22
mean(B3:B23) → C23
Median(B3:B6) → D6
Median(B3:B7) → D7
Median(B3:B8) → D8
Median(B3:B9) → D9
Median(B3:B10) → D10
Median(B3:B11) → D11
Median(B3:B12) → D12
Median(B3:B13) → D13
Median(B3:B14) → D14
Median(B3:B15) → D15
Median(B3:B16) → D16
Median(B3:B17) → D17
Median(B3:B18) → D18
Median(B3:B19) → D19
Median(B3:B20) → D20
Median(B3:B21) → D21
Median(B3:B22) → D22
Median(B3:B23) → D23
Mode(B3:B6) → E6
Mode(B3:B7) → E7
Mode(B3:B8) → E8
Mode(B3:B9) → E9
Mode(B3:B10) → E10
Mode(B3:B11) → E11
Mode(B3:B12) → E12
Mode(B3:B13) → E13
Mode(B3:B14) → E14
Mode(B3:B15) → E15
Mode(B3:B16) → E16
Mode(B3:B17) → E17
Mode(B3:B18) → E18
Mode(B3:B19) → E19
Mode(B3:B20) → E20
Mode(B3:B21) → E21
Mode(B3:B22) → E22
Mode(B3:B23) → E23
Min(B3:B6) → F6
Min(B3:B7) → F7
Min(B3:B8) → F8
Min(B3:B9) → F9
Min(B3:B10) → F10
Min(B3:B11) → F11
Min(B3:B12) → F12
Min(B3:B13) → F13
Min(B3:B14) → F14
Min(B3:B15) → F15
Min(B3:B16) → F16
Min(B3:B17) → F17
Min(B3:B18) → F18
Min(B3:B19) → F19
Min(B3:B20) → F20
Min(B3:B21) → F21
Min(B3:B22) → F22
Min(B3:B23) → F23
Q1(B3:B6) → G6
Q1(B3:B7) → G7
Q1(B3:B8) → G8
Q1(B3:B9) → G9
Q1(B3:B10) → G10
Q1(B3:B11) → G11
Q1(B3:B12) → G12
Q1(B3:B13) → G13
Q1(B3:B14) → G14
Q1(B3:B15) → G15
Q1(B3:B16) → G16
Q1(B3:B17) → G17
Q1(B3:B18) → G18
Q1(B3:B19) → G19
Q1(B3:B20) → G20
Q1(B3:B21) → G21
Q1(B3:B22) → G22
Q1(B3:B23) → G23
Q3(B3:B6) → I6
Q3(B3:B7) → I7
Q3(B3:B8) → I8
Q3(B3:B9) → I9
Q3(B3:B10) → I10
Q3(B3:B11) → I11
Q3(B3:B12) → I12
Q3(B3:B13) → I13
Q3(B3:B14) → I14
Q3(B3:B15) → I15
Q3(B3:B16) → I16
Q3(B3:B17) → I17
Q3(B3:B18) → I18
Q3(B3:B19) → I19
Q3(B3:B20) → I20
Q3(B3:B21) → I21
Q3(B3:B22) → I22
Q3(B3:B23) → I23
Max(B3:B22) → J22
Max(B3:B23) → J23
Max(B3:B6) → J6
Max(B3:B7) → J7
Max(B3:B8) → J8
Max(B3:B9) → J9
Max(B3:B10) → J10
Max(B3:B11) → J11
Max(B3:B12) → J12
Max(B3:B13) → J13
Max(B3:B14) → J14
Max(B3:B15) → J15
Max(B3:B16) → J16
Max(B3:B17) → J17
Max(B3:B18) → J18
Max(B3:B19) → J19
Max(B3:B20) → J20
Max(B3:B21) → J21
mean(B29:B32) → C32
mean(B29:B33) → C33
mean(B29:B34) → C34
mean(B29:B35) → C35
mean(B29:B36) → C36
mean(B29:B37) → C37
mean(B29:B38) → C38
mean(B29:B39) → C39
mean(B29:B40) → C40
mean(B29:B41) → C41
mean(B29:B42) → C42
mean(B29:B43) → C43
mean(B29:B44) → C44
mean(B29:B45) → C45
mean(B29:B46) → C46
mean(B29:B47) → C47
mean(B29:B48) → C48
mean(B29:B49) → C49
Median(B29:B32) → D32
Median(B29:B33) → D33
Median(B29:B34) → D34
Median(B29:B35) → D35
Median(B29:B36) → D36
Median(B29:B37) → D37
Median(B29:B38) → D38
Median(B29:B39) → D39
Median(B29:B40) → D40
Median(B29:B41) → D41
Median(B29:B42) → D42
Median(B29:B43) → D43
Median(B29:B44) → D44
Median(B29:B45) → D45
Median(B29:B46) → D46
Median(B29:B47) → D47
Median(B29:B48) → D48
Median(B29:B49) → D49
Mode(B29:B32) → E32
Mode(B29:B33) → E33
Mode(B29:B34) → E34
Mode(B29:B35) → E35
Mode(B29:B36) → E36
Mode(B29:B37) → E37
Mode(B29:B38) → E38
Mode(B29:B39) → E39
Mode(B29:B40) → E40
Mode(B29:B41) → E41
Mode(B29:B42) → E42
Mode(B29:B43) → E43
Mode(B29:B44) → E44
Mode(B29:B45) → E45
Mode(B29:B46) → E46
Mode(B29:B47) → E47
Mode(B29:B48) → E48
Mode(B29:B49) → E49
Min(B29:B32) → F32
Min(B29:B33) → F33
Min(B29:B34) → F34
Min(B29:B35) → F35
Min(B29:B36) → F36
Min(B29:B37) → F37
Min(B29:B38) → F38
Min(B29:B39) → F39
Min(B29:B40) → F40
Min(B29:B41) → F41
Min(B29:B42) → F42
Min(B29:B43) → F43
Min(B29:B44) → F44
Min(B29:B45) → F45
Min(B29:B46) → F46
Min(B29:B47) → F47
Min(B29:B48) → F48
Min(B29:B49) → F49
Q1(B29:B32) → G32
Q1(B29:B33) → G33
Q1(B29:B34) → G34
Q1(B29:B35) → G35
Q1(B29:B36) → G36
Q1(B29:B37) → G37
Q1(B29:B38) → G38
Q1(B29:B39) → G39
Q1(B29:B40) → G40
Q1(B29:B41) → G41
Q1(B29:B42) → G42
Q1(B29:B43) → G43
Q1(B29:B44) → G44
Q1(B29:B45) → G45
Q1(B29:B46) → G46
Q1(B29:B47) → G47
Q1(B29:B48) → G48
Q1(B29:B49) → G49
Q3(B29:B32) → I32
Q3(B29:B33) → I33
Q3(B29:B34) → I34
Q3(B29:B35) → I35
Q3(B29:B36) → I36
Q3(B29:B37) → I37
Q3(B29:B38) → I38
Q3(B29:B39) → I39
Q3(B29:B40) → I40
Q3(B29:B41) → I41
Q3(B29:B42) → I42
Q3(B29:B43) → I43
Q3(B29:B44) → I44
Q3(B29:B45) → I45
Q3(B29:B46) → I46
Q3(B29:B47) → I47
Q3(B29:B48) → I48
Q3(B29:B49) → I49
Max(B29:B32) → J32
Max(B29:B33) → J33
Max(B29:B34) → J34
Max(B29:B35) → J35
Max(B29:B36) → J36
Max(B29:B37) → J37
Max(B29:B38) → J38
Max(B29:B39) → J39
Max(B29:B40) → J40
Max(B29:B41) → J41
Max(B29:B42) → J42
Max(B29:B43) → J43
Max(B29:B44) → J44
Max(B29:B45) → J45
Max(B29:B46) → J46
Max(B29:B47) → J47
If(n ≟ 3, C5, If[n ≟ 4, C6, If[n ≟ 5, C7, If[n ≟ 6, C8, If[n ≟ 7, C9, If[n ≟ 8, C10, If[n ≟ 9, C11, If[n ≟ 10, C12, If[n ≟ 11, C13, If[n ≟ 12, C14, If[n ≟ 13, C15, If[n ≟ 14, C16, If[n ≟ 15, C17, If[n ≟ 16, C18, If[n ≟ 17, C19, If[n ≟ 18, C20, If[n ≟ 19, C21, If[n ≟ 20, C22, C23]]]]]]]]]]]]]]]]]) → C24
If(n ≟ 3, D5, If[n ≟ 4, D6, If[n ≟ 5, D7, If[n ≟ 6, D8, If[n ≟ 7, D9, If[n ≟ 8, D10, If[n ≟ 9, D11, If[n ≟ 10, D12, If[n ≟ 11, D13, If[n ≟ 12, D14, If[n ≟ 13, D15, If[n ≟ 14, D16, If[n ≟ 15, D17, If[n ≟ 16, D18, If[n ≟ 17, D19, If[n ≟ 18, D20, If[n ≟ 19, D21, If[n ≟ 20, D22, D23]]]]]]]]]]]]]]]]]) → D24
If(n ≟ 3, E5, If[n ≟ 4, E6, If[n ≟ 5, E7, If[n ≟ 6, E8, If[n ≟ 7, E9, If[n ≟ 8, E10, If[n ≟ 9, E11, If[n ≟ 10, E12, If[n ≟ 11, E13, If[n ≟ 12, E14, If[n ≟ 13, E15, If[n ≟ 14, E16, If[n ≟ 15, E17, If[n ≟ 16, E18, If[n ≟ 17, E19, If[n ≟ 18, E20, If[n ≟ 19, E21, If[n ≟ 20, E22, E23]]]]]]]]]]]]]]]]]) → E24
If(n ≟ 3, F5, If[n ≟ 4, F6, If[n ≟ 5, F7, If[n ≟ 6, F8, If[n ≟ 7, F9, If[n ≟ 8, F10, If[n ≟ 9, F11, If[n ≟ 10, F12, If[n ≟ 11, F13, If[n ≟ 12, F14, If[n ≟ 13, F15, If[n ≟ 14, F16, If[n ≟ 15, F17, If[n ≟ 16, F18, If[n ≟ 17, F19, If[n ≟ 18, F20, If[n ≟ 19, F21, If[n ≟ 20, F22, F23]]]]]]]]]]]]]]]]]) → F24
If(n ≟ 3, G5, If[n ≟ 4, G6, If[n ≟ 5, G7, If[n ≟ 6, G8, If[n ≟ 7, G9, If[n ≟ 8, G10, If[n ≟ 9, G11, If[n ≟ 10, G12, If[n ≟ 11, G13, If[n ≟ 12, G14, If[n ≟ 13, G15, If[n ≟ 14, G16, If[n ≟ 15, G17, If[n ≟ 16, G18, If[n ≟ 17, G19, If[n ≟ 18, G20, If[n ≟ 19, G21, If[n ≟ 20, G22, G23]]]]]]]]]]]]]]]]]) → G24
If(n ≟ 3, H5, If[n ≟ 4, H6, If[n ≟ 5, H7, If[n ≟ 6, H8, If[n ≟ 7, H9, If[n ≟ 8, H10, If[n ≟ 9, H11, If[n ≟ 10, H12, If[n ≟ 11, H13, If[n ≟ 12, H14, If[n ≟ 13, H15, If[n ≟ 14, H16, If[n ≟ 15, H17, If[n ≟ 16, H18, If[n ≟ 17, H19, If[n ≟ 18, H20, If[n ≟ 19, H21, If[n ≟ 20, H22, H23]]]]]]]]]]]]]]]]]) → H24
If(n ≟ 3, I5, If[n ≟ 4, I6, If[n ≟ 5, I7, If[n ≟ 6, I8, If[n ≟ 7, I9, If[n ≟ 8, I10, If[n ≟ 9, I11, If[n ≟ 10, I12, If[n ≟ 11, I13, If[n ≟ 12, I14, If[n ≟ 13, I15, If[n ≟ 14, I16, If[n ≟ 15, I17, If[n ≟ 16, I18, If[n ≟ 17, I19, If[n ≟ 18, I20, If[n ≟ 19, I21, If[n ≟ 20, I22, I23]]]]]]]]]]]]]]]]]) → I24
If(n ≟ 3, J5, If[n ≟ 4, J6, If[n ≟ 5, J7, If[n ≟ 6, J8, If[n ≟ 7, J9, If[n ≟ 8, J10, If[n ≟ 9, J11, If[n ≟ 10, J12, If[n ≟ 11, J13, If[n ≟ 12, J14, If[n ≟ 13, J15, If[n ≟ 14, J16, If[n ≟ 15, J17, If[n ≟ 16, J18, If[n ≟ 17, J19, If[n ≟ 18, J20, If[n ≟ 19, J21, If[n ≟ 20, J22, J23]]]]]]]]]]]]]]]]]) → J24
Median(B29:B50) → D50
mean(B29:B50) → C50
Mode(B29:B50) → E50
Min(B29:B50) → F50
Q1(B29:B50) → G50
Q3(B29:B50) → I50
Max(B29:B50) → J50
Max(B29:B48) → J48
Max(B29:B49) → J49
If(n ≟ 3, C32, If[n ≟ 4, C33, If[n ≟ 5, C34, If[n ≟ 6, C35, If[n ≟ 7, C36, If[n ≟ 8, C37, If[n ≟ 9, C38, If[n ≟ 10, C39, If[n ≟ 11, C40, If[n ≟ 12, C41, If[n ≟ 13, C42, If[n ≟ 14, C43, If[n ≟ 15, C44, If[n ≟ 16, C45, If[n ≟ 17, C46, If[n ≟ 18, C47, If[n ≟ 19, C48, If[n ≟ 20, C49, C50]]]]]]]]]]]]]]]]]) → C51
If(n ≟ 3, D32, If[n ≟ 4, D33, If[n ≟ 5, D34, If[n ≟ 6, D35, If[n ≟ 7, D36, If[n ≟ 8, D37, If[n ≟ 9, D38, If[n ≟ 10, D39, If[n ≟ 11, D40, If[n ≟ 12, D41, If[n ≟ 13, D42, If[n ≟ 14, D43, If[n ≟ 15, D44, If[n ≟ 16, D45, If[n ≟ 17, D46, If[n ≟ 18, D47, If[n ≟ 19, D48, If[n ≟ 20, D49, D50]]]]]]]]]]]]]]]]]) → D51
If(n ≟ 3, E32, If[n ≟ 4, E33, If[n ≟ 5, E34, If[n ≟ 6, E35, If[n ≟ 7, E36, If[n ≟ 8, E37, If[n ≟ 9, E38, If[n ≟ 10, E39, If[n ≟ 11, E40, If[n ≟ 12, E41, If[n ≟ 13, E42, If[n ≟ 14, E43, If[n ≟ 15, E44, If[n ≟ 16, E45, If[n ≟ 17, E46, If[n ≟ 18, E47, If[n ≟ 19, E48, If[n ≟ 20, E49, E50]]]]]]]]]]]]]]]]]) → E51
If(n ≟ 3, F32, If[n ≟ 4, F33, If[n ≟ 5, F34, If[n ≟ 6, F35, If[n ≟ 7, F36, If[n ≟ 8, F37, If[n ≟ 9, F38, If[n ≟ 10, F39, If[n ≟ 11, F40, If[n ≟ 12, F41, If[n ≟ 13, F42, If[n ≟ 14, F43, If[n ≟ 15, F44, If[n ≟ 16, F45, If[n ≟ 17, F46, If[n ≟ 18, F47, If[n ≟ 19, F48, If[n ≟ 20, F49, F50]]]]]]]]]]]]]]]]]) → F51
If(n ≟ 3, G32, If[n ≟ 4, G33, If[n ≟ 5, G34, If[n ≟ 6, G35, If[n ≟ 7, G36, If[n ≟ 8, G37, If[n ≟ 9, G38, If[n ≟ 10, G39, If[n ≟ 11, G40, If[n ≟ 12, G41, If[n ≟ 13, G42, If[n ≟ 14, G43, If[n ≟ 15, G44, If[n ≟ 16, G45, If[n ≟ 17, G46, If[n ≟ 18, G47, If[n ≟ 19, G48, If[n ≟ 20, G49, G50]]]]]]]]]]]]]]]]]) → G51
If(n ≟ 3, H32, If[n ≟ 4, H33, If[n ≟ 5, H34, If[n ≟ 6, H35, If[n ≟ 7, H36, If[n ≟ 8, H37, If[n ≟ 9, H38, If[n ≟ 10, H39, If[n ≟ 11, H40, If[n ≟ 12, H41, If[n ≟ 13, H42, If[n ≟ 14, H43, If[n ≟ 15, H44, If[n ≟ 16, H45, If[n ≟ 17, H46, If[n ≟ 18, H47, If[n ≟ 19, H48, If[n ≟ 20, H49, H50]]]]]]]]]]]]]]]]]) → H51
If(n ≟ 3, I32, If[n ≟ 4, I33, If[n ≟ 5, I34, If[n ≟ 6, I35, If[n ≟ 7, I36, If[n ≟ 8, I37, If[n ≟ 9, I38, If[n ≟ 10, I39, If[n ≟ 11, I40, If[n ≟ 12, I41, If[n ≟ 13, I42, If[n ≟ 14, I43, If[n ≟ 15, I44, If[n ≟ 16, I45, If[n ≟ 17, I46, If[n ≟ 18, I47, If[n ≟ 19, I48, If[n ≟ 20, I49, I50]]]]]]]]]]]]]]]]]) → I51
If(n ≟ 3, J32, If[n ≟ 4, J33, If[n ≟ 5, J34, If[n ≟ 6, J35, If[n ≟ 7, J36, If[n ≟ 8, J37, If[n ≟ 9, J38, If[n ≟ 10, J39, If[n ≟ 11, J40, If[n ≟ 12, J41, If[n ≟ 13, J42, If[n ≟ 14, J43, If[n ≟ 15, J44, If[n ≟ 16, J45, If[n ≟ 17, J46, If[n ≟ 18, J47, If[n ≟ 19, J48, If[n ≟ 20, J49, J50]]]]]]]]]]]]]]]]]) → J51
If($B3 ≥ L$2 ∧ $B3 ≤ M$2 ∧ n ≥ $A3, 1, 0) → M3
If($B3 > M$2 ∧ $B3 ≤ N$2 ∧ n ≥ $A3, 1, 0) → N3
If($B3 > N$2 ∧ $B3 ≤ O$2 ∧ n ≥ $A3, 1, 0) → O3
If($B3 > O$2 ∧ $B3 ≤ P$2 ∧ n ≥ $A3, 1, 0) → P3
If($B3 > P$2 ∧ $B3 ≤ Q$2 ∧ n ≥ $A3, 1, 0) → Q3
If($B3 > Q$2 ∧ $B3 ≤ R$2 ∧ n ≥ $A3, 1, 0) → R3
If($B3 > R$2 ∧ $B3 ≤ S$2 ∧ n ≥ $A3, 1, 0) → S3
If($B3 > S$2 ∧ $B3 ≤ T$2 ∧ n ≥ $A3, 1, 0) → T3
If($B4 ≥ L$2 ∧ $B4 ≤ M$2 ∧ n ≥ $A4, 1, 0) → M4
If($B4 > M$2 ∧ $B4 ≤ N$2 ∧ n ≥ $A4, 1, 0) → N4
If($B4 > N$2 ∧ $B4 ≤ O$2 ∧ n ≥ $A4, 1, 0) → O4
If($B4 > O$2 ∧ $B4 ≤ P$2 ∧ n ≥ $A4, 1, 0) → P4
If($B4 > P$2 ∧ $B4 ≤ Q$2 ∧ n ≥ $A4, 1, 0) → Q4
If($B4 > Q$2 ∧ $B4 ≤ R$2 ∧ n ≥ $A4, 1, 0) → R4
If($B4 > R$2 ∧ $B4 ≤ S$2 ∧ n ≥ $A4, 1, 0) → S4
If($B4 > S$2 ∧ $B4 ≤ T$2 ∧ n ≥ $A4, 1, 0) → T4
If($B5 ≥ L$2 ∧ $B5 ≤ M$2 ∧ n ≥ $A5, 1, 0) → M5
If($B5 > M$2 ∧ $B5 ≤ N$2 ∧ n ≥ $A5, 1, 0) → N5
If($B5 > N$2 ∧ $B5 ≤ O$2 ∧ n ≥ $A5, 1, 0) → O5
If($B5 > O$2 ∧ $B5 ≤ P$2 ∧ n ≥ $A5, 1, 0) → P5
If($B5 > P$2 ∧ $B5 ≤ Q$2 ∧ n ≥ $A5, 1, 0) → Q5
If($B5 > Q$2 ∧ $B5 ≤ R$2 ∧ n ≥ $A5, 1, 0) → R5
If($B5 > R$2 ∧ $B5 ≤ S$2 ∧ n ≥ $A5, 1, 0) → S5
If($B5 > S$2 ∧ $B5 ≤ T$2 ∧ n ≥ $A5, 1, 0) → T5
If($B6 ≥ L$2 ∧ $B6 ≤ M$2 ∧ n ≥ $A6, 1, 0) → M6
If($B6 > M$2 ∧ $B6 ≤ N$2 ∧ n ≥ $A6, 1, 0) → N6
If($B6 > N$2 ∧ $B6 ≤ O$2 ∧ n ≥ $A6, 1, 0) → O6
If($B6 > O$2 ∧ $B6 ≤ P$2 ∧ n ≥ $A6, 1, 0) → P6
If($B6 > P$2 ∧ $B6 ≤ Q$2 ∧ n ≥ $A6, 1, 0) → Q6
If($B6 > Q$2 ∧ $B6 ≤ R$2 ∧ n ≥ $A6, 1, 0) → R6
If($B6 > R$2 ∧ $B6 ≤ S$2 ∧ n ≥ $A6, 1, 0) → S6
If($B6 > S$2 ∧ $B6 ≤ T$2 ∧ n ≥ $A6, 1, 0) → T6
If($B7 ≥ L$2 ∧ $B7 ≤ M$2 ∧ n ≥ $A7, 1, 0) → M7
If($B7 > M$2 ∧ $B7 ≤ N$2 ∧ n ≥ $A7, 1, 0) → N7
If($B7 > N$2 ∧ $B7 ≤ O$2 ∧ n ≥ $A7, 1, 0) → O7
If($B7 > O$2 ∧ $B7 ≤ P$2 ∧ n ≥ $A7, 1, 0) → P7
If($B7 > P$2 ∧ $B7 ≤ Q$2 ∧ n ≥ $A7, 1, 0) → Q7
If($B7 > Q$2 ∧ $B7 ≤ R$2 ∧ n ≥ $A7, 1, 0) → R7
If($B7 > R$2 ∧ $B7 ≤ S$2 ∧ n ≥ $A7, 1, 0) → S7
If($B7 > S$2 ∧ $B7 ≤ T$2 ∧ n ≥ $A7, 1, 0) → T7
If($B8 ≥ L$2 ∧ $B8 ≤ M$2 ∧ n ≥ $A8, 1, 0) → M8
If($B8 > M$2 ∧ $B8 ≤ N$2 ∧ n ≥ $A8, 1, 0) → N8
If($B8 > N$2 ∧ $B8 ≤ O$2 ∧ n ≥ $A8, 1, 0) → O8
If($B8 > O$2 ∧ $B8 ≤ P$2 ∧ n ≥ $A8, 1, 0) → P8
If($B8 > P$2 ∧ $B8 ≤ Q$2 ∧ n ≥ $A8, 1, 0) → Q8
If($B8 > Q$2 ∧ $B8 ≤ R$2 ∧ n ≥ $A8, 1, 0) → R8
If($B8 > R$2 ∧ $B8 ≤ S$2 ∧ n ≥ $A8, 1, 0) → S8
If($B8 > S$2 ∧ $B8 ≤ T$2 ∧ n ≥ $A8, 1, 0) → T8
If($B9 ≥ L$2 ∧ $B9 ≤ M$2 ∧ n ≥ $A9, 1, 0) → M9
If($B9 > M$2 ∧ $B9 ≤ N$2 ∧ n ≥ $A9, 1, 0) → N9
If($B9 > N$2 ∧ $B9 ≤ O$2 ∧ n ≥ $A9, 1, 0) → O9
If($B9 > O$2 ∧ $B9 ≤ P$2 ∧ n ≥ $A9, 1, 0) → P9
If($B9 > P$2 ∧ $B9 ≤ Q$2 ∧ n ≥ $A9, 1, 0) → Q9
If($B9 > Q$2 ∧ $B9 ≤ R$2 ∧ n ≥ $A9, 1, 0) → R9
If($B9 > R$2 ∧ $B9 ≤ S$2 ∧ n ≥ $A9, 1, 0) → S9
If($B9 > S$2 ∧ $B9 ≤ T$2 ∧ n ≥ $A9, 1, 0) → T9
If($B10 ≥ L$2 ∧ $B10 ≤ M$2 ∧ n ≥ $A10, 1, 0) → M10
If($B10 > M$2 ∧ $B10 ≤ N$2 ∧ n ≥ $A10, 1, 0) → N10
If($B10 > N$2 ∧ $B10 ≤ O$2 ∧ n ≥ $A10, 1, 0) → O10
If($B10 > O$2 ∧ $B10 ≤ P$2 ∧ n ≥ $A10, 1, 0) → P10
If($B10 > P$2 ∧ $B10 ≤ Q$2 ∧ n ≥ $A10, 1, 0) → Q10
If($B10 > Q$2 ∧ $B10 ≤ R$2 ∧ n ≥ $A10, 1, 0) → R10
If($B10 > R$2 ∧ $B10 ≤ S$2 ∧ n ≥ $A10, 1, 0) → S10
If($B10 > S$2 ∧ $B10 ≤ T$2 ∧ n ≥ $A10, 1, 0) → T10
If($B11 ≥ L$2 ∧ $B11 ≤ M$2 ∧ n ≥ $A11, 1, 0) → M11
If($B11 > M$2 ∧ $B11 ≤ N$2 ∧ n ≥ $A11, 1, 0) → N11
If($B11 > N$2 ∧ $B11 ≤ O$2 ∧ n ≥ $A11, 1, 0) → O11
If($B11 > O$2 ∧ $B11 ≤ P$2 ∧ n ≥ $A11, 1, 0) → P11
If($B11 > P$2 ∧ $B11 ≤ Q$2 ∧ n ≥ $A11, 1, 0) → Q11
If($B11 > Q$2 ∧ $B11 ≤ R$2 ∧ n ≥ $A11, 1, 0) → R11
If($B11 > R$2 ∧ $B11 ≤ S$2 ∧ n ≥ $A11, 1, 0) → S11
If($B11 > S$2 ∧ $B11 ≤ T$2 ∧ n ≥ $A11, 1, 0) → T11
If($B12 ≥ L$2 ∧ $B12 ≤ M$2 ∧ n ≥ $A12, 1, 0) → M12
If($B12 > M$2 ∧ $B12 ≤ N$2 ∧ n ≥ $A12, 1, 0) → N12
If($B12 > N$2 ∧ $B12 ≤ O$2 ∧ n ≥ $A12, 1, 0) → O12
If($B12 > O$2 ∧ $B12 ≤ P$2 ∧ n ≥ $A12, 1, 0) → P12
If($B12 > P$2 ∧ $B12 ≤ Q$2 ∧ n ≥ $A12, 1, 0) → Q12
If($B12 > Q$2 ∧ $B12 ≤ R$2 ∧ n ≥ $A12, 1, 0) → R12
If($B12 > R$2 ∧ $B12 ≤ S$2 ∧ n ≥ $A12, 1, 0) → S12
If($B12 > S$2 ∧ $B12 ≤ T$2 ∧ n ≥ $A12, 1, 0) → T12
If($B13 ≥ L$2 ∧ $B13 ≤ M$2 ∧ n ≥ $A13, 1, 0) → M13
If($B13 > M$2 ∧ $B13 ≤ N$2 ∧ n ≥ $A13, 1, 0) → N13
If($B13 > N$2 ∧ $B13 ≤ O$2 ∧ n ≥ $A13, 1, 0) → O13
If($B13 > O$2 ∧ $B13 ≤ P$2 ∧ n ≥ $A13, 1, 0) → P13
If($B13 > P$2 ∧ $B13 ≤ Q$2 ∧ n ≥ $A13, 1, 0) → Q13
If($B13 > Q$2 ∧ $B13 ≤ R$2 ∧ n ≥ $A13, 1, 0) → R13
If($B13 > R$2 ∧ $B13 ≤ S$2 ∧ n ≥ $A13, 1, 0) → S13
If($B13 > S$2 ∧ $B13 ≤ T$2 ∧ n ≥ $A13, 1, 0) → T13
If($B14 ≥ L$2 ∧ $B14 ≤ M$2 ∧ n ≥ $A14, 1, 0) → M14
If($B14 > M$2 ∧ $B14 ≤ N$2 ∧ n ≥ $A14, 1, 0) → N14
If($B14 > N$2 ∧ $B14 ≤ O$2 ∧ n ≥ $A14, 1, 0) → O14
If($B14 > O$2 ∧ $B14 ≤ P$2 ∧ n ≥ $A14, 1, 0) → P14
If($B14 > P$2 ∧ $B14 ≤ Q$2 ∧ n ≥ $A14, 1, 0) → Q14
If($B14 > Q$2 ∧ $B14 ≤ R$2 ∧ n ≥ $A14, 1, 0) → R14
If($B14 > R$2 ∧ $B14 ≤ S$2 ∧ n ≥ $A14, 1, 0) → S14
If($B14 > S$2 ∧ $B14 ≤ T$2 ∧ n ≥ $A14, 1, 0) → T14
If($B15 ≥ L$2 ∧ $B15 ≤ M$2 ∧ n ≥ $A15, 1, 0) → M15
If($B15 > M$2 ∧ $B15 ≤ N$2 ∧ n ≥ $A15, 1, 0) → N15
If($B15 > N$2 ∧ $B15 ≤ O$2 ∧ n ≥ $A15, 1, 0) → O15
If($B15 > O$2 ∧ $B15 ≤ P$2 ∧ n ≥ $A15, 1, 0) → P15
If($B15 > P$2 ∧ $B15 ≤ Q$2 ∧ n ≥ $A15, 1, 0) → Q15
If($B15 > Q$2 ∧ $B15 ≤ R$2 ∧ n ≥ $A15, 1, 0) → R15
If($B15 > R$2 ∧ $B15 ≤ S$2 ∧ n ≥ $A15, 1, 0) → S15
If($B15 > S$2 ∧ $B15 ≤ T$2 ∧ n ≥ $A15, 1, 0) → T15
If($B16 ≥ L$2 ∧ $B16 ≤ M$2 ∧ n ≥ $A16, 1, 0) → M16
If($B16 > M$2 ∧ $B16 ≤ N$2 ∧ n ≥ $A16, 1, 0) → N16
If($B16 > N$2 ∧ $B16 ≤ O$2 ∧ n ≥ $A16, 1, 0) → O16
If($B16 > O$2 ∧ $B16 ≤ P$2 ∧ n ≥ $A16, 1, 0) → P16
If($B16 > P$2 ∧ $B16 ≤ Q$2 ∧ n ≥ $A16, 1, 0) → Q16
If($B16 > Q$2 ∧ $B16 ≤ R$2 ∧ n ≥ $A16, 1, 0) → R16
If($B16 > R$2 ∧ $B16 ≤ S$2 ∧ n ≥ $A16, 1, 0) → S16
If($B16 > S$2 ∧ $B16 ≤ T$2 ∧ n ≥ $A16, 1, 0) → T16
If($B17 ≥ L$2 ∧ $B17 ≤ M$2 ∧ n ≥ $A17, 1, 0) → M17
If($B17 > M$2 ∧ $B17 ≤ N$2 ∧ n ≥ $A17, 1, 0) → N17
If($B17 > N$2 ∧ $B17 ≤ O$2 ∧ n ≥ $A17, 1, 0) → O17
If($B17 > O$2 ∧ $B17 ≤ P$2 ∧ n ≥ $A17, 1, 0) → P17
If($B17 > P$2 ∧ $B17 ≤ Q$2 ∧ n ≥ $A17, 1, 0) → Q17
If($B17 > Q$2 ∧ $B17 ≤ R$2 ∧ n ≥ $A17, 1, 0) → R17
If($B17 > R$2 ∧ $B17 ≤ S$2 ∧ n ≥ $A17, 1, 0) → S17
If($B17 > S$2 ∧ $B17 ≤ T$2 ∧ n ≥ $A17, 1, 0) → T17
If($B18 ≥ L$2 ∧ $B18 ≤ M$2 ∧ n ≥ $A18, 1, 0) → M18
If($B18 > M$2 ∧ $B18 ≤ N$2 ∧ n ≥ $A18, 1, 0) → N18
If($B18 > N$2 ∧ $B18 ≤ O$2 ∧ n ≥ $A18, 1, 0) → O18
If($B18 > O$2 ∧ $B18 ≤ P$2 ∧ n ≥ $A18, 1, 0) → P18
If($B18 > P$2 ∧ $B18 ≤ Q$2 ∧ n ≥ $A18, 1, 0) → Q18
If($B18 > Q$2 ∧ $B18 ≤ R$2 ∧ n ≥ $A18, 1, 0) → R18
If($B18 > R$2 ∧ $B18 ≤ S$2 ∧ n ≥ $A18, 1, 0) → S18
If($B18 > S$2 ∧ $B18 ≤ T$2 ∧ n ≥ $A18, 1, 0) → T18
If($B19 ≥ L$2 ∧ $B19 ≤ M$2 ∧ n ≥ $A19, 1, 0) → M19
If($B19 > M$2 ∧ $B19 ≤ N$2 ∧ n ≥ $A19, 1, 0) → N19
If($B19 > N$2 ∧ $B19 ≤ O$2 ∧ n ≥ $A19, 1, 0) → O19
If($B19 > O$2 ∧ $B19 ≤ P$2 ∧ n ≥ $A19, 1, 0) → P19
If($B19 > P$2 ∧ $B19 ≤ Q$2 ∧ n ≥ $A19, 1, 0) → Q19
If($B19 > Q$2 ∧ $B19 ≤ R$2 ∧ n ≥ $A19, 1, 0) → R19
If($B19 > R$2 ∧ $B19 ≤ S$2 ∧ n ≥ $A19, 1, 0) → S19
If($B19 > S$2 ∧ $B19 ≤ T$2 ∧ n ≥ $A19, 1, 0) → T19
If($B20 ≥ L$2 ∧ $B20 ≤ M$2 ∧ n ≥ $A20, 1, 0) → M20
If($B20 > M$2 ∧ $B20 ≤ N$2 ∧ n ≥ $A20, 1, 0) → N20
If($B20 > N$2 ∧ $B20 ≤ O$2 ∧ n ≥ $A20, 1, 0) → O20
If($B20 > O$2 ∧ $B20 ≤ P$2 ∧ n ≥ $A20, 1, 0) → P20
If($B20 > P$2 ∧ $B20 ≤ Q$2 ∧ n ≥ $A20, 1, 0) → Q20
If($B20 > Q$2 ∧ $B20 ≤ R$2 ∧ n ≥ $A20, 1, 0) → R20
If($B20 > R$2 ∧ $B20 ≤ S$2 ∧ n ≥ $A20, 1, 0) → S20
If($B20 > S$2 ∧ $B20 ≤ T$2 ∧ n ≥ $A20, 1, 0) → T20
If($B21 ≥ L$2 ∧ $B21 ≤ M$2 ∧ n ≥ $A21, 1, 0) → M21
If($B21 > M$2 ∧ $B21 ≤ N$2 ∧ n ≥ $A21, 1, 0) → N21
If($B21 > N$2 ∧ $B21 ≤ O$2 ∧ n ≥ $A21, 1, 0) → O21
If($B21 > O$2 ∧ $B21 ≤ P$2 ∧ n ≥ $A21, 1, 0) → P21
If($B21 > P$2 ∧ $B21 ≤ Q$2 ∧ n ≥ $A21, 1, 0) → Q21
If($B21 > Q$2 ∧ $B21 ≤ R$2 ∧ n ≥ $A21, 1, 0) → R21
If($B21 > R$2 ∧ $B21 ≤ S$2 ∧ n ≥ $A21, 1, 0) → S21
If($B21 > S$2 ∧ $B21 ≤ T$2 ∧ n ≥ $A21, 1, 0) → T21
If($B22 ≥ L$2 ∧ $B22 ≤ M$2 ∧ n ≥ $A22, 1, 0) → M22
If($B22 > M$2 ∧ $B22 ≤ N$2 ∧ n ≥ $A22, 1, 0) → N22
If($B22 > N$2 ∧ $B22 ≤ O$2 ∧ n ≥ $A22, 1, 0) → O22
If($B22 > O$2 ∧ $B22 ≤ P$2 ∧ n ≥ $A22, 1, 0) → P22
If($B22 > P$2 ∧ $B22 ≤ Q$2 ∧ n ≥ $A22, 1, 0) → Q22
If($B22 > Q$2 ∧ $B22 ≤ R$2 ∧ n ≥ $A22, 1, 0) → R22
If($B22 > R$2 ∧ $B22 ≤ S$2 ∧ n ≥ $A22, 1, 0) → S22
If($B22 > S$2 ∧ $B22 ≤ T$2 ∧ n ≥ $A22, 1, 0) → T22
If($B23 ≥ L$2 ∧ $B23 ≤ M$2 ∧ n ≥ $A23, 1, 0) → M23
If($B23 > M$2 ∧ $B23 ≤ N$2 ∧ n ≥ $A23, 1, 0) → N23
If($B23 > N$2 ∧ $B23 ≤ O$2 ∧ n ≥ $A23, 1, 0) → O23
If($B23 > O$2 ∧ $B23 ≤ P$2 ∧ n ≥ $A23, 1, 0) → P23
If($B23 > P$2 ∧ $B23 ≤ Q$2 ∧ n ≥ $A23, 1, 0) → Q23
If($B23 > Q$2 ∧ $B23 ≤ R$2 ∧ n ≥ $A23, 1, 0) → R23
If($B23 > R$2 ∧ $B23 ≤ S$2 ∧ n ≥ $A23, 1, 0) → S23
If($B23 > S$2 ∧ $B23 ≤ T$2 ∧ n ≥ $A23, 1, 0) → T23
Sum(M3:M23) → M24
Sum(N3:N23) → N24
Sum(O3:O23) → O24
Sum(P3:P23) → P24
Sum(Q3:Q23) → Q24
Sum(R3:R23) → R24
Sum(S3:S23) → S24
Sum(T3:T23) → T24
Max(M24:T24) → V24
Histogram({L2, M2, N2, O2, P2, Q2, R2, S2, T2}, {M24, N24, O24, P24, Q24, R24, S24, T24}) → hist
BoxPlot(W1, W2, {F24, G24, (G24 + H24) / 2, H24, (H24 + I24) / 2, I24, J24}) → box1
If($B29 ≥ L$2 ∧ $B29 ≤ M$2, 1, 0) → M26
If($B29 ≥ L$2 ∧ $B29 ≤ M$2, 1, 0) → If[$B29 ≥ L$2 ∧ $B29 < M$2, 1, 0]
If($B29 > M$2 ∧ $B29 ≤ N$2, 1, 0) → N26
If($B29 > M$2 ∧ $B29 ≤ N$2, 1, 0) → If[$B29 ≥ M$2 ∧ $B29 < N$2, 1, 0]
If($B29 > N$2 ∧ $B29 ≤ O$2, 1, 0) → O26
If($B29 > O$2 ∧ $B29 ≤ P$2, 1, 0) → P26
If($B29 > P$2 ∧ $B29 ≤ Q$2, 1, 0) → Q26
If($B29 > Q$2 ∧ $B29 ≤ R$2, 1, 0) → R26
If($B29 > R$2 ∧ $B29 ≤ S$2, 1, 0) → S26
If($B29 > S$2 ∧ $B29 ≤ T$2, 1, 0) → T26
Histogram({L2, M2, N2, O2, P2, Q2, R2, S2, T2}, {M27, N27, O27, P27, Q27, R27, S27, T27}) → hist2
Polygon(A, B, C, D) → poly1, a, b, c, d
Vector(MEANTOP, MEANBOT) → Mean
Vector(MEDIANTOP, MEDIANBOT) → Median
Vector(MEDIAN2TOP, G) → NewMedian
Vector(MEAN2TOP, MEAN2BOT) → NewMean
BoxPlot(W1 - 2, W2, {F51, G51, (G51 + H51) / 2, H51, (H51 + I51) / 2, I51, J51}) → box2
Segment(RANGEA, RANGEB) → rangea
Segment(RANGEB, RANGEC) → rangeb
Segment(RANGEC, RANGED) → rangec
Segment(IQRA, IQRB) → iqra
Segment(IQRB, IQRC) → iqrb
Segment(IQRC, IQRD) → iqrc
Segment(IQR2A, IQR2B) → iqr2a
Segment(IQR2B, IQR2C) → iqr2b
Segment(IQR2C, IQR2D) → iqr2c
Segment(RANGE2A, RANGE2B) → range2a
Segment(RANGE2B, RANGE2C) → range2b
Segment(RANGE2C, RANGE2D) → range2c