Advanced Chart Problems

this page is under construction

1) Soil Composition at Different Depths. The table below has different soil types (rows) measured at specific depths (columns). Plot the following data of soil properties versus depth on a graph. Clarity of results is of essence here.

	Depth (in yards)						
	    0	0.2	0.4	0.6	0.8	1	1.2
Poor clay  28	36	35	43	48	51	57
Clay	   10	8	7	8	8	8	6
Fine	   18	19	19	19	15	13	11
Medium	   25	20	20	19	20	21	21
Coarse	   19	17	19	11	9	7	5

(2) Primary inland energy sources (in %). Plot the following energy percentages versus time. Fit a trend line to each energy source. Which energy type has grown the most in the time period of this data set?

Energy Source	1970	1973	1979	1980	1985	1986	1987	1988	1989	1990
Petroleum	43.8	46.8	43.5	40.4	34	35.3	34.6	34.8	33.5	35.4
Bituminous coal	24.3	19.3	16	16.6	16.7	16.3	15.8	15.5	15.4	15.6
Brown coal	24.7	22.1	21.5	22.6	24.5	24	23.3	23.2	23.5	21.7
Natural gas	4.4	8.8	14.1	14.6	13.9	14	14.9	14.6	15.3	15.6
Nuclear energy	0.5	0.8	3.3	3.8	9	8.3	8.9	9.8	10.4	9.8
Hydroelectric	1.9	1.8	1.2	1.6	1.2	1.4	1.7	1.3	1.1	1.1
Other type	0.4	0.4	0.4	0.4	0.7	0.7	0.8	0.8	0.8	0.8