The data in this midterm is adapted from tables contained in the Documentation of the Traditional Food System of Pohnpei (DOTFSP), a project of the Island Food Community of Pohnpei and the Centre for Indigenous People's Nutrition and Environment. Due to the particular needs of a statistics examination, the data has been adapted for the examination. The data, while based in actual data from a single village on Pohnpei, should be considered in the same vein as those "based on actual events" made-for-television movies. Please refer to the Island Food Community of Pohnpei web site for substantive and accurate information! My thanks to the Island Food Community of Pohnpei for helping provide data relevant to our students here at the college.
Drinking water study on fecal contamination July 2005
mg/dl |
---|
86 |
89 |
94 |
100 |
100 |
106 |
110 |
131 |
158 |
196 |
The following section is based on data from page 49 of the DOTFSP. The data used the mean fasting blood sugar in mg/dl for females age 20 to 29 years old. The ten data points in the table on the right represent ten fictitious females. Although the sample is fictitious, the minimum, maximum, range, mean, and standard deviation match that found in the DOTFSP for this age cohort.
Bins (x) | Frequency (f) | Rel. Freq. p(x) |
---|---|---|
_______ | _______ | _______ |
_______ | _______ | _______ |
_______ | _______ | _______ |
_______ | _______ | _______ |
_______ | _______ | _______ |
Sum: | _______ | _______ |
The mean body mass was determined for 167 men and women of all ages. Use the following table to estimate the population mean body mass. [Note: this data was artificially derived from mean blood sugar cohort data binned by age on page 49 and thus the result does not represent the true population mean.]
BMI bin (x) | Freq | RF or p(x) | x*p(x) |
---|---|---|---|
27 | 11 | 0.07 | 1.8 |
29 | 62 | 0.37 | 10.8 |
31 | 49 | 0.29 | 9.1 |
33 | 20 | 0.12 | 4.0 |
35 | 25 | 0.15 | 5.2 |
Sums: | 167 | 1.00 | 30.9 |
The following data uses the mean Body Mass Index (mean BMI) data for 85 women. The first column is the mid-interval age in years for a cohort of women. The second column is the mean body mass index for that age group. This data derives from page 47 of the DOTFSP.
Age cohort (x) | mean BMI (y) |
---|---|
17 | 28.5 |
27 | 30.5 |
37 | 33.1 |
47 | 33.8 |
57 | 31.3 |
67 | 35.9 |
Although this midterm utilizes data from one particular village on Pohnpei, other data from other villages on Pohnpei suggest that the overall health situation is probably not significantly different.
Statistic or Parameter | Symbol | Equations | Excel |
---|---|---|---|
Square root | =SQRT(number) | ||
Sample mean | x | Σx/n | =AVERAGE(data) |
Sample standard deviation | sx | =STDEV(data) | |
Sample Coefficient of Variation | CV | sx/x | =STDEV(data)/AVERAGE(data) |
Calculate a z value from an x | z | ^{=} | =STANDARDIZE(x, ”, σ) |
Slope | b | =SLOPE(y data, x data) | |
Intercept | a | =INTERCEPT(y data, x data) | |
Correlation | r | =CORREL(y data, x data) | |
Coefficient of Determination | rČ | =(CORREL(y data, x data))^2 |