Overview

analysis
data


Sheet 1: analysis


Data x Sample means xbar


count 568 19


min 0.8 2.9


max 6.1 4.44


bin min 0.8



bin max 6.1



range 5.3 1.54


bins 15



width 0.35



mode 4 #VALUE!


median 3.9 3.84


mean xbar 3.76 3.76


(mean) stdev 0.62 0.41


sx/√30 0.11



skew -0.78 -0.35


kurtosis 0.91 -0.3








Data measurements x

Sample means (using same bins)

Bins (x) Freq f of x RF or P(x) Freq f of xbar RF or P(x) xbar
1.15 2 0 0 0
1.51 5 0.01 0 0
1.86 5 0.01 0 0
2.21 16 0.03 0 0
2.57 22 0.04 0 0
2.92 24 0.04 1 0.05
3.27 44 0.08 2 0.11
3.63 101 0.18 3 0.16
3.98 70 0.12 8 0.42
4.33 152 0.27 4 0.21
4.69 81 0.14 1 0.05
5.04 40 0.07 0 0
5.39 2 0 0 0
5.75 3 0.01 0 0
6.1 1 0 0 0
6.45 0 0 0 0
6.81 0 0 0 0
7.16 0 0 0 0
7.51 0 0 0 0
7.87 0 0 0 0
8.22 0 0 0 0

568 1 19 1















Sheet 2: data


Edleen Melinda Jimmy Agnes Kimberley C. Lorrie Andereas Lolina Jonathan Kimberley G. Sylvia Gina Simpson Florian Annie Antonio Alpino Cindy Elterina





m Hainrick Scottkey Patrick Sophia Josephine Marlinda Luanne Victor Jordan Scarlet Tyrone Kiumy Tanya Jenny Mad Rowino Grace Lil






1 4.5 5 3.2 3.5 4.4 3.5 4.1 2.2 3.9 3.5 4 4.5 4.5 4.4 3.9 3.7 4 3.5 4





2 4.8 4.5 4.4 2.6 4.9 3.6 4.4 2.3 4 3.3 3.5 3.5 4 3.8 3.4 3.2 3.9 3 4





3 5 4.1 3.4 3.5 4.6 3.6 3.7 2.9 3 2.2 4.5 4 4 4.1 3 3.6 4 3.5 4





4 4.4 6.1 3.2 3.5 4.5 3.6 4.2 2.9 2.8 4 3 3.5 3.5 3.6 3.5 3.9 3.3 2.6 3.5





5 4.3 3.6 3.3 4 4.6 3.6 4 3.7 4.5 3 4.8 3.5 4.25 2.9 4 4.1 4.3 3.4 3.5





6 4.1 4.7 3.8 4 4.5 3.7 3.9 3.7 2.5 3.6 4.9 4 4.5 2.8 4.1 3.6 4.3 4 3.5





7 4 4.2 5 3.9 4.9 3.7 3.4 4.5 4.1 4 4.4 3.9 3.5 3.8 5 3.4 4.2 4 4





8 4.7 4.5 4.6 4 4.5 3.7 3.7 4.6 3.8 2.8 4.6 4 3 2.7 3.7 3.7 3.8 2.5 4.5





9 5 3.9 3.2 4 3.9 3.7 3.9 3.5 4.4 3.9 4.4 5 2.8 2.5 4.2 3.4 3.8 4.2 4.5





10 4.2 4.4 4.2 4.5 4.5 3.8 4.1 3.6 3.4 3.7 4.5 4.9 2.8 1.9 4.5 4.1 4.5 4.4 4





11 4.4 3.9 3.9 4.3 4.5 3.8 4.1 3.7 2.7 4 4.5 4.6 3 4.4 4 3.5 4.8 3.2 4





12 5.4 2.9 4.4 3 4.6 3.8 4.2 3.9 4.8 2 4.9 4.7 3 4.1 3.1 4 4.5 4 3.6





13 5.5 4.1 4.3 4 4.3 3.8 3.8 4.4 3 3 4.9 4.8 4.2 3.1 3 4.4 4.1 1 4





14 5 4.5 3.3 4 4.2 3.8 3.6 4.2 2 2.6 4.5 5 3.8 1.7 3.5 3 3.5 1.5 3.5





15 5.1 2.7 3.8 4.5 4.6 3.9 3 3.8 3.6 4.1 3.9 5 4 2.2 3.5 3.5 3.4 2.5 3.5





16 4 4.2 4.6 4.5 4.5 4 2.2 3.6 4.2 3.5 4 5 5 1.7 4.7 3.7 3.3 2.3 3.5





17 3.7 2.3 4.8 4 4.3 4 2 1.4 3.8 3 4.2 3.8 5.2 1.9 5 3.4 3.3 1.5 3.5





18 3 4 4.5 4.3 4.4 4 2.5 0.8 3.7 3.4 5 4 4.6 1.3 4.8 3.2 3.5 2.3 3.5





19 3.3 3.6 4.4 4.1 4.8 4 3 2 4.4 3.1 4.8 3.7 4.7 3 3.7 3.5 3.4 3 3.5





20 3.1 4.2 4.5 4.2 4.2 4 2.2 2.2 3.6 3.2 5.4 4.4 4.7 3.5 4.9 3.6 3.4 3.5 4





21 3.5 2.7 3.6 3.5 4.3 4 2 3 2.3 2.4 3.1 4.9 3.9 3.9 4 4.1 3.4 3.6 4





22 4 3 4 4 4 4.1 3.7 4.3 3.1 2.3 4 4.5 2.4 4 4.5 3.4 3.8 2.3 4





23 4.1 3.8 3.4 3.5 4.2 4.1 2.5 4.1 2.8 2.6 4 3.5 1.8 3.7 4 3.5 3.1 3 4





24 4.6 3.9 4.2 3.5 4.6 4.1 3.4 4 2.4 2.7 4.2 3.2 3.4 2.1 4.3 3.5 4 1.6 4.5





25 3.2 4 4.5 4.4 4.6 4.1 3.8 3.3 4.2 3.4 4.4 4.2 4 1.5 4.6 3.7 3.5 4.5 4





26 3.5 2.5 4.1 3.5 4.6 4.1 3.9 4.7 4.5 4 4.5 5 4 2.8 4.2 4.1 3 4.3 4





27 3.7 4.1 3.6 3.8 4.2 4.2 4.5 4 2 3.4 4.6 4.5 3.9 1.7 4.5 3.7 3 3.5 3.6





28 4 2.6 4.3 3.9 4.3 4.2 3.7 3.3 4.3 2.8 2.5 4.3 3.6 3.4 4 3.9 3.1 2.5 4





29 4.1 3.1 4.5 4 4.4 4.2 4.6 3.8 4 4.1 5 4 3.7 2.3 2.5 4.1 2.8 4 3.6





30 4.2 4 3.6 3.3 4.3
4.7 3.2 2.5 3.4 4.5 4.3 4 2.2 3.2 3.6 2.9 4.5
































means 4.21 3.84 4.02 3.86 4.44 3.89 3.56 3.39 3.48 3.23 4.32 4.27 3.79 2.9 3.98 3.67 3.66 3.12 3.86





sample stdev sx 0.67 0.83 0.53 0.45 0.23 0.21 0.79 0.96 0.82 0.61 0.64 0.55 0.78 0.95 0.65 0.32 0.53 0.97 0.32