SPREADSHEET FOR CALCULATION OF MEASUREMENT ERROR
This spreadsheet calculates the Technical Error of Measurement (TEM) and the Intraclass Correlation Coefficient
(ICC) from a one-way ANOVA. For additional information on the statistical calculations, refer to Norton & Olds
(1996) or other statistics textbooks.
The calculations are for two (2) measures on twenty (20) subjects.
The target %TEMs for inter and intra testers for obtaining ISAK accreditation are shown in the table bellow.
Level 1 Level 2 & 3
post-course post-profiles post-course post-profiles
inter skinfolds 12.5 10.0 10.0 7.5
other 2.5 2.0 2.0 1.5
intra skinfolds 10.0 7.5 7.5 5.0
other 2.0 1.5 1.5 1.0
Number of subjects: 20
Measures per subject: 2
Spreadsheet programmed based on information from Anthropometrica: A textbook of body measurement
for sports and health courses (Norton & Olds, eds., UNSW, 1996) for the ISAK's Accreditation in
Anthropometry.
Marta I.R. Pereira, 2000
unoconv_2660877527.xlsx
,ISAK FULL PROFORMA
Name 1
Name 2
Country
Ethnicity
Sex (male=1, female=2)
Sport
Date of Measurement
Date of Birth 3rd Mean or
Measure 1 2 3 Measure? Median
Body mass 74.0 74.0 0.0 0.0% No 74.0
Stretch stature 188.0 188.0 0.0 0.0% No 188.0
Triceps sf mm 7.0 7.0 0.0 0.0% No 7.0
Subscapular sf mm 5.0 5.0 0.0 0.0% No 5.0
Biceps sf mm 3.0 3.0 0.0 0.0% No 3.0
Iliac Crest sf mm 6.0 6.0 0.0 0.0% No 6.0
Supraspinale sf mm 5.0 5.0 0.0 0.0% No 5.0
Abdominal sf mm 6.0 6.0 0.0 0.0% No 6.0
Front Thigh sf mm 8.0 8.0 0.0 0.0% No 8.0
Medial Calf sf mm 4.0 4.0 0.0 0.0% No 4.0
Arm girth relaxed cm 27.0 27.0 0.0 0.0% No 27.0
Arm girth flexed and tensed cm 32.0 32.0 0.0 0.0% No 32.0
Waist girth (min.) cm 75.0 75.0 0.0 0.0% No 75.0
Gluteal girth (max.) cm 77.0 77.0 0.0 0.0% No 77.0
Calf girth (max.) cm 35.0 35.0 0.0 0.0% No 35.0
Humerus breadth (biepicondylar cm 7.2 7.2 0.0 0.0% No 7.2
Femur breadth (biepicondylar) cm 8.4 8.4 0.0 0.0% No 8.4
,ISAK FULL PROFORMA Printout
Name 1 0
Name 2 0
Country 0
Ethnicity 0
Sex (male=1, female=2) 0
Sport 0
Date of Measurement
Date of Birth
Value Phantom Z-value
Body mass 74 kg -1.13
Stretch stature 188 cm
Triceps sf 7.0 mm -2.03
Subscapular sf 5.0 mm -2.50
Biceps sf 3.0 mm -2.64
Iliac Crest sf 6.0 mm -2.50
Supraspinale sf 5.0 mm -2.43
Abdominal sf 6.0 mm -2.57
Front Thigh sf 8.0 mm -2.37
Medial Calf sf 4.0 mm -2.65
Arm girth relaxed 27.0 cm -1.05
Corrected arm girth 26.3 cm 0.92
Arm girth flexed and tensed 32.0 cm -0.19
Waist girth (min.) 75.0 cm -0.90
Gluteal girth (max.) 77.0 cm -4.47
Calf girth (max.) 35.0 cm -1.55
Corrected calf girth (max.) 34.6 cm 0.56
Humerus breadth (biepicondylar) 7.2 cm 0.16
Femur breadth (biepicondylar) 8.4 cm -3.94
Somatotype
(Heath-Carter) Endomorphy 1.4
Mesomorphy 2.6
Ectomorphy 4.2
(0.5 to 2.5 - low; 2.6 to 5.4 - moderate, 5.5 to 7 - high; 7 plus: extremely high)
Body Mass Index (BMI) 20.9
(LINZ females, 15-19 mn 22.4 sd 2.9; 20-29 mn 23.7 sd 4.8; 30-39 mn 24.2 sd 4.7)
Waist/Hip Ratio (WHR) 0.97
(LINZ females, 15-19 mn 0.73 sd 0.05; 20-29 mn 0.75 sd 0.07; 30-39 mn 0.75 sd 0.06)
Sum of 6 skinfolds 35.0 mm
(Excl. Biceps & Iliac Crest) 9.0 %fat (Yuhasz)
(LINZ females, 15-19 mn 114.2 sd 35.4; 20-29 mn 112.5 sd 45.2; 30-39 mn 120.5 sd 47.8)
Sum of 8 skinfolds 44.0 mm
Measured by:
, ISAK FULL PROFORMA
Name 1
Name 2
Country
Ethnicity
Sex (male=1, female=2)
Sport
Date of Measurement
Date of Birth 3rd Mean or
Measure 1 2 3 Measure? Median
Body mass 0.0 0.0 0.0 ### ### 0.0
Stretch stature 0.0 0.0 0.0 ### ### 0.0
Triceps sf 0.0 0.0 0.0 ### ### 0.0
Subscapular sf 0.0 0.0 0.0 ### ### 0.0
Biceps sf 0.0 0.0 0.0 ### ### 0.0
Iliac Crest sf 0.0 0.0 0.0 ### ### 0.0
Supraspinale sf 0.0 0.0 0.0 ### ### 0.0
Abdominal sf 0.0 0.0 0.0 ### ### 0.0
Front Thigh sf 0.0 0.0 0.0 ### ### 0.0
Medial Calf sf 0.0 0.0 0.0 ### ### 0.0
Arm girth relaxed 0.0 0.0 0.0 ### ### 0.0
Arm girth flexed and tensed 0.0 0.0 0.0 ### ### 0.0
Waist girth (min.) 0.0 0.0 0.0 ### ### 0.0
Gluteal girth (max.) 0.0 0.0 0.0 ### ### 0.0
Calf girth (max.) 0.0 0.0 0.0 ### ### 0.0
Humerus breadth (biepicondylar) 0.0 0.0 0.0 ### ### 0.0
Femur breadth (biepicondylar) 0.0 0.0 0.0 ### ### 0.0
This spreadsheet calculates the Technical Error of Measurement (TEM) and the Intraclass Correlation Coefficient
(ICC) from a one-way ANOVA. For additional information on the statistical calculations, refer to Norton & Olds
(1996) or other statistics textbooks.
The calculations are for two (2) measures on twenty (20) subjects.
The target %TEMs for inter and intra testers for obtaining ISAK accreditation are shown in the table bellow.
Level 1 Level 2 & 3
post-course post-profiles post-course post-profiles
inter skinfolds 12.5 10.0 10.0 7.5
other 2.5 2.0 2.0 1.5
intra skinfolds 10.0 7.5 7.5 5.0
other 2.0 1.5 1.5 1.0
Number of subjects: 20
Measures per subject: 2
Spreadsheet programmed based on information from Anthropometrica: A textbook of body measurement
for sports and health courses (Norton & Olds, eds., UNSW, 1996) for the ISAK's Accreditation in
Anthropometry.
Marta I.R. Pereira, 2000
unoconv_2660877527.xlsx
,ISAK FULL PROFORMA
Name 1
Name 2
Country
Ethnicity
Sex (male=1, female=2)
Sport
Date of Measurement
Date of Birth 3rd Mean or
Measure 1 2 3 Measure? Median
Body mass 74.0 74.0 0.0 0.0% No 74.0
Stretch stature 188.0 188.0 0.0 0.0% No 188.0
Triceps sf mm 7.0 7.0 0.0 0.0% No 7.0
Subscapular sf mm 5.0 5.0 0.0 0.0% No 5.0
Biceps sf mm 3.0 3.0 0.0 0.0% No 3.0
Iliac Crest sf mm 6.0 6.0 0.0 0.0% No 6.0
Supraspinale sf mm 5.0 5.0 0.0 0.0% No 5.0
Abdominal sf mm 6.0 6.0 0.0 0.0% No 6.0
Front Thigh sf mm 8.0 8.0 0.0 0.0% No 8.0
Medial Calf sf mm 4.0 4.0 0.0 0.0% No 4.0
Arm girth relaxed cm 27.0 27.0 0.0 0.0% No 27.0
Arm girth flexed and tensed cm 32.0 32.0 0.0 0.0% No 32.0
Waist girth (min.) cm 75.0 75.0 0.0 0.0% No 75.0
Gluteal girth (max.) cm 77.0 77.0 0.0 0.0% No 77.0
Calf girth (max.) cm 35.0 35.0 0.0 0.0% No 35.0
Humerus breadth (biepicondylar cm 7.2 7.2 0.0 0.0% No 7.2
Femur breadth (biepicondylar) cm 8.4 8.4 0.0 0.0% No 8.4
,ISAK FULL PROFORMA Printout
Name 1 0
Name 2 0
Country 0
Ethnicity 0
Sex (male=1, female=2) 0
Sport 0
Date of Measurement
Date of Birth
Value Phantom Z-value
Body mass 74 kg -1.13
Stretch stature 188 cm
Triceps sf 7.0 mm -2.03
Subscapular sf 5.0 mm -2.50
Biceps sf 3.0 mm -2.64
Iliac Crest sf 6.0 mm -2.50
Supraspinale sf 5.0 mm -2.43
Abdominal sf 6.0 mm -2.57
Front Thigh sf 8.0 mm -2.37
Medial Calf sf 4.0 mm -2.65
Arm girth relaxed 27.0 cm -1.05
Corrected arm girth 26.3 cm 0.92
Arm girth flexed and tensed 32.0 cm -0.19
Waist girth (min.) 75.0 cm -0.90
Gluteal girth (max.) 77.0 cm -4.47
Calf girth (max.) 35.0 cm -1.55
Corrected calf girth (max.) 34.6 cm 0.56
Humerus breadth (biepicondylar) 7.2 cm 0.16
Femur breadth (biepicondylar) 8.4 cm -3.94
Somatotype
(Heath-Carter) Endomorphy 1.4
Mesomorphy 2.6
Ectomorphy 4.2
(0.5 to 2.5 - low; 2.6 to 5.4 - moderate, 5.5 to 7 - high; 7 plus: extremely high)
Body Mass Index (BMI) 20.9
(LINZ females, 15-19 mn 22.4 sd 2.9; 20-29 mn 23.7 sd 4.8; 30-39 mn 24.2 sd 4.7)
Waist/Hip Ratio (WHR) 0.97
(LINZ females, 15-19 mn 0.73 sd 0.05; 20-29 mn 0.75 sd 0.07; 30-39 mn 0.75 sd 0.06)
Sum of 6 skinfolds 35.0 mm
(Excl. Biceps & Iliac Crest) 9.0 %fat (Yuhasz)
(LINZ females, 15-19 mn 114.2 sd 35.4; 20-29 mn 112.5 sd 45.2; 30-39 mn 120.5 sd 47.8)
Sum of 8 skinfolds 44.0 mm
Measured by:
, ISAK FULL PROFORMA
Name 1
Name 2
Country
Ethnicity
Sex (male=1, female=2)
Sport
Date of Measurement
Date of Birth 3rd Mean or
Measure 1 2 3 Measure? Median
Body mass 0.0 0.0 0.0 ### ### 0.0
Stretch stature 0.0 0.0 0.0 ### ### 0.0
Triceps sf 0.0 0.0 0.0 ### ### 0.0
Subscapular sf 0.0 0.0 0.0 ### ### 0.0
Biceps sf 0.0 0.0 0.0 ### ### 0.0
Iliac Crest sf 0.0 0.0 0.0 ### ### 0.0
Supraspinale sf 0.0 0.0 0.0 ### ### 0.0
Abdominal sf 0.0 0.0 0.0 ### ### 0.0
Front Thigh sf 0.0 0.0 0.0 ### ### 0.0
Medial Calf sf 0.0 0.0 0.0 ### ### 0.0
Arm girth relaxed 0.0 0.0 0.0 ### ### 0.0
Arm girth flexed and tensed 0.0 0.0 0.0 ### ### 0.0
Waist girth (min.) 0.0 0.0 0.0 ### ### 0.0
Gluteal girth (max.) 0.0 0.0 0.0 ### ### 0.0
Calf girth (max.) 0.0 0.0 0.0 ### ### 0.0
Humerus breadth (biepicondylar) 0.0 0.0 0.0 ### ### 0.0
Femur breadth (biepicondylar) 0.0 0.0 0.0 ### ### 0.0
