Excel 1

HWCH7ExcelTemplate.xlsx

XY Graph

				The data describe a sequence of chemical reactions. The concentrations of A, B, and C in moles per liter are given.
				Plot all three concentrations as a function of times on the same graph. Show the individual data points with different data markers.
Time (sec)	Conc A	Conc B	Conc C
0	5	0	0
1	4.5	0.46	0.02
2	4.1	0.84	0.06
3	3.7	1.2	0.13
4	3.4	1.4	0.22
5	3	1.6	0.33
6	2.7	1.8	0.45
7	2.5	1.9	0.58
8	2.3	2	0.72
9	2	2.1	0.87
10	1.8	2.2	1
12	1.5	2.2	1.3
14	1.2	2.2	1.6
16	1	2.1	1.9
18	0.83	2	2.2
20	0.68	1.85	2.5
25	0.41	1.5	3.1
30	0.25	1.2	3.5
35	0.15	0.93	3.9
40	0.09	0.71	4.2

	Using the equation plot V versus t as both an XY chart and a semi-log graph.
	What is the relationship between the 2 graphs?

	Given the data below. It is the quantity of water discharged from a tank as a function of time.
	Plot the data using semi-log coordinates. Then plot the data using log-log coordinates.
	Show individual data points in both graphs.
	Which is a better representation? Why?
	What type of equation might best represent the data? Why?
Time	Volume
0	0
5	17.2
10	27.8
15	38.4
20	46.5
25	54.3
30	62.5
35	70.2
40	77.2
45	83.7
50	89.9
55	96.9
60	103.4

The exams are worth 60% of the course, the Final Exam is worth 40% of the course.
Find the Overall Score. Then calculate the average of each column.
Construct a bar graph of the overall scores for the individual students.
Do not include the overall class average on the graph.
Construct the graph in such a manner that the individual vertical bars touch each other.
Add in a title and a title for each axes.
Create a bar graph using the same data with appropriate titles.
Which is better and why?
Student	Exam 1	Exam 2	Final Exam	Overall Score
Davis	82	77	94
Graham	66	80	75
Jones	95	100	97
Meyers	47	62	78
Richardson	80	58	73
Thomas	74	81	85
Williams	57	62	67
AVERAGE:

Using the data from "Bar Graph", assign a letter grade to each student for their Overall Score [use IF stmts].

Create a pie chart showing the grade distribution.

Label each segment of the pie chart with the appropriate letter grade.

Select attractive sizes and locations for the circle, the labels, and the title.

Complete problem 2 from the textbook.

Complete problem 5 from the textbook.