Directions:

For questions 6-7, download the Excel file, "Data: Heritability," containing the parent phenotypes and offspring phenotypes for metal tolerance. Use Excel for calculations, modeling, and graphing. Note that the percentages have been converted to numbers between 0 and 100. Round all calculated values to the nearest hundredth of a decimal place. For example, if you calculate the value as 3.8218, round to 3.82.

Note:

We have also provided links to Excel tutorials and transcripts below, to help you answer these questions.

6.

Make a plot of a linear relationship between parental phenotypes and offspring phenotypes for metal tolerance. This plot should follow the formatting guidelines listed below.

Formatting Instructions

General

Chart type: X Y (Scatter)

Quick layout: Layout 1 - Scatter (you can delete the key/legend on the right and the chart title if preferred)

Y-axes title: "Metal tolerance of sunstalk offspring (%)"; Font size = 18

Y-axis numbers: Font size = 14

X-axis title: "Metal tolerance of sunstalk parents (%)"; Font size 18

X-axis numbers: Font size = 14

Y-axis

Bounds: minimum at 0, maximum at 100

X-axis

Bounds: minimum at 0, maximum at 100

Trendline (linear model)

Line: Solid line

Metal tolerance of parents (%)	Metal tolerance of offspring (%)
76.57	68.07
49.50	62.69
50.83	59.01
65.59	61.61
82.94	76.55
50.37	62.44
77.75	66.66
64.58	73.36
69.67	62.31
57.74	64.40
25.54	38.52
80.17	72.10
58.38	64.37
38.57	57.39
29.68	52.97
73.95	75.62
63.62	69.68
25.93	55.22
40.91	54.06
27.04	42.05
25.53	48.23
24.67	42.28
67.45	62.68
46.21	61.19
77.39	62.10
70.93	70.27
16.43	45.26
89.41	78.85
72.44	62.43
17.38	43.63
31.73	53.54
83.73	74.42
16.33	42.87
46.05	66.89
15.14	45.18
36.95	56.06
68.80	62.86
46.41	55.14
50.98	56.83
62.91	66.38
23.65	57.39
38.30	55.37
80.44	68.71
91.19	77.02
84.69	79.66
46.26	56.44
14.18	45.04
73.72	75.49
53.03	53.27
74.57	69.02
77.61	72.37
26.99	46.58
68.58	65.73
86.70	79.02
17.13	49.05
84.12	73.85
92.10	73.75
38.05	48.15
34.39	56.52
91.05	81.82
57.34	58.83
70.24	66.80
34.31	51.44
88.12	69.30
63.42	68.42
27.81	54.09
29.59	48.62
42.10	48.41
59.64	58.87
55.42	58.96
66.56	61.54
32.50	52.68
71.09	69.25
37.32	61.51
80.74	78.37
57.19	63.19
43.54	64.07
67.17	59.88
67.04	65.85
68.86	59.40
82.85	71.72
28.12	44.75
62.69	61.09
74.27	71.55
71.90	69.62
46.45	55.11
84.49	74.20
91.55	77.52
45.51	48.93
55.17	65.86
38.15	53.84
33.54	57.03
40.78	60.09
75.84	80.32
42.28	52.39
70.92	66.84
60.18	71.55
17.82	52.98
82.23	68.92
16.67	45.69
89.05	75.12
59.92	54.24
47.32	66.40
75.48	64.81
36.38	63.88
15.32	48.70
52.11	53.97
29.58	55.93
67.58	66.17
37.02	57.22
19.55	46.78
18.72	49.85
42.51	53.59
66.36	61.00
36.70	52.96
51.46	66.76
38.46	58.32
67.29	61.68
58.34	57.63
65.40	67.24
75.22	70.62
32.56	50.29
50.78	58.66
92.00	89.25
30.46	54.43
86.03	80.24
35.14	57.44
49.63	54.91
60.91	65.30
66.65	70.59
56.77	63.61
60.99	65.86
84.15	79.25
81.64	82.08
62.61	67.70
91.28	71.18
81.63	81.89
26.20	53.22
42.61	58.47
63.24	61.40
16.74	44.17
55.90	68.80
81.06	67.52
58.19	53.09
88.57	81.21
49.21	51.62
49.71	58.68
26.04	45.93
60.29	59.93
48.27	60.21
19.14	44.14
22.78	50.83
90.12	71.09
91.87	80.64
29.57	51.94
65.34	66.30
67.35	67.87
75.25	68.40
66.22	63.17
27.25	54.80
73.24	76.06
47.41	56.97
92.65	72.03
85.28	71.10
72.56	72.26
16.28	49.17
58.16	60.25
46.19	58.38
49.31	59.03
32.11	60.05
48.62	61.46
69.64	65.55
77.32	71.53
30.20	50.79
57.07	47.88
82.64	73.96
75.56	64.96
63.99	67.36
62.71	58.42
71.99	62.09
30.40	52.90
30.85	54.68
33.71	58.04
37.14	46.06
44.43	47.55
38.51	52.14
42.00	62.35
39.18	51.80
62.72	64.63
44.75	55.35
44.08	57.37
63.67	65.15
45.92	48.81
82.01	75.49
69.27	56.77
51.26	55.02
92.06	72.91
50.55	61.85
38.83	58.47
25.93	49.80
40.04	53.07
30.86	50.42
72.67	66.50
48.06	64.60
91.21	78.13
60.92	54.45
81.63	69.11
54.74	61.53
67.51	62.27
48.24	65.88
87.53	76.18
58.25	65.28
63.25	62.66
42.74	60.42
52.97	56.12
20.53	47.37