Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
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
25 0.00246
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
Chapter 8 - Problem 12b
Genetic Research Thermometers
7
8
Frequency Distribution - Prob. 8-12b
