Graphing Using Excel Exercise
Mr. Francis J. DeHoratius


You are to graph each of the following problems as you did in the sample problem.
You should plot the independent variable along the X axis and the dependent variable along the Y axis. e.g. in problem number 1, the number of tickets is the independent variable and the amount of money is the dependent variable i.e. the more tickets that are sold the more money is raised. Be sure to follow this pattern when graphing each of the following problems.

1. Your school is putting on a play. To raise money for the event, tickets for the play are being sold for $3.00 each. Construct a graph of the following data using Excel.



2. You collected data on the amount of rain that fell over a period of time. Your data is recorded on the table below. Construct a graph of the following data using Excel.



3. A student collects data in an experiment involving acids and bases. The student is adding base to an acid and noting the pH. Construct a graph of the following data using Excel.



4. You collected the following data for the volume of a gas at different pressures. Construct a graph of the following data using Excel.



5. A student carried out an experiment to determine the solubility of an unknown substance over a range of temperatures. Construct a graph of the following data using Excel.



6. A student performs an experiment to determine the meltingtemperatures of a solid. The energy supplied to the system from the heating element remained constant throughout the experiment. Construct a graph of the following data using Excel.