Chapter 8- Problem 12a
Genetic Research Thermometers
Descriptive Statistics and Frequency Chart
This spreadsheet is designed for up to 100 pieces of data Enter data ONLY in yellow-shaded cells.
Note: The data and cell boundaries below were sorted in ascending order to more accurately show the increasing values on the histogram
as contrasted with decreasing values in the even-numbered solutions in the text.
Frequency Table – Problem 8-12a
Upper Cell
Sorted Boundaries Frequencies
DATA Data Original Data
1-0.00251 Cell 1 -0.00251 1 0.000711 -0.000404 0.002456 0.00130 0.00018
2-0.00186 Cell 2 -0.00169 1 0.000246 0.002452 0.001407 0.00142 0.00015
8-0.00040
9-0.00039 Standard Statistical Measures
10 -0.00027
11 0.00015 Mean 0.000312
12 0.00018 Median 0.000246
13 0.00025 Mode #N/A
14 0.00036 Standard deviation 0.001343
15 0.00071 Variance 0.000002
16 0.00098 Max 0.002456
17 0.00118 Min -0.002514
18 0.00124 Range 0.004970
19 0.00130
20 0.00141
21 0.00142
22 0.00178
23 0.00221
24 0.00245
25 0.00246
3-0.00136 Cell 3 -0.00086 3 0.000976 -0.002514 0.001776 0.00221 -0.00129
4-0.00129 Cell 4 -0.00003 5 -0.00065 -0.000266 -0.001361 -0.00039 -0.00063
5-0.00089 Cell 5 0.00080 5 0.001241 0.00036 -0.00186 0.00118 -0.00089
6-0.00065 Cell 6 0.00163 6
Freq Distrib 8-12a
Chapter 8- Problem 12a
Genetic Research Thermometers
7
Cell 1 Cell 2 Cell 3 Cell 4 Cell 5 Cell 6 Cell 7
Data Cells
Frequency Distribution Problem 8-12a
Page 4
Chapter 8 – Problem 12b
Genetic Research Thermometers
Descriptive Statistics and Frequency Chart Data Set for Thermometers A & B
This spreadsheet is designed for up to 100 pieces of data Enter data ONLY in yellow-shaded cells.
Note: The data and cell boundaries below were sorted in ascending order to more accurately show the increasing values on the histogram
as contrasted with decreasing values in the even-numbered solutions in the text.
Original Data
0.00071 -0.00040 0.00246 0.00130 0.00018 0.00126 -0.00221 -0.00011 -0.00071 -0.00032
1-0.00221 Cell 1 -0.00221 1
2-0.00165 Cell 2 -0.00070 7
3-0.00155 Cell 3 0.00005 7
4-0.00149 Cell 4 0.00156 7
5-0.00135 Cell 5 0.00232 3
6-0.00120
7-0.00076 Standard Statistical Measures
8-0.00071
9-0.00041 Mean -0.000046
10 -0.00040 Median -0.000123
11 -0.00032 Mode #N/A
12 -0.00024 Standard deviation 0.001204
13 -0.00012 Variance 0.000001
14 -0.00011 Max 0.002316
15 -0.00001 Min -0.002209
26
27
28
29
Chapter 8 – Problem 12b
Genetic Research Thermometers
7
8
Frequency Distribution – Prob. 8–12b