Using Excel For Calculations and Graphing

1
Using Excel For Calculations and Graphing

• Put subjects in the first column with the title
  subjects in the first cell.
• Put the data in columns by trials with the titles
  Trial 1, Trial 2, etc. in the first cells.

2
Using Excel For Calculations and Graphing

• Choose the open cell at the bottom of the trial
  column by clicking it.
• Click the button to choose or edit a
  formula.

3
Using Excel For Calculations and Graphing

• After clicking the button, click on the
  triangle to open a drop-down menu of functions.
• Next choose Average from the list.

4
Using Excel For Calculations and Graphing

• A formula box will open that shows you what
  specific cells will be averaged.
• Click OK which makes the bottom cell a location
  to hold the averaged values of the cells in the
  column.

5
Using Excel For Calculations and Graphing

• The formula bar near the top tells you that the
  bottom cell now equals the average of cell B2
  down to B7.
• The result is shown in the bottom cell.

6
Using Excel For Calculations and Graphing

• Click on the bottom cell and then click on the
  copy icon to copy the formula associated with
  that cell.
• Click on the next cell over and then click the
  paste icon to paste the formula.

7
Using Excel For Calculations and Graphing

• You have now made a new average for the second
  cell.
• The program automatically includes the correct
  cells for that column.
• Average(C2C7). The values are the same in
  both columns, so the average is the same.

8
Using Excel For Calculations and Graphing

• Repeat for each bottom cell to create an average
  of the values in each column.
• Since you copied the first, you only have to
  paste into the others. The correct cells will be
  included in the calculations.

9
Using Excel For Calculations and Graphing

• You can create as many groupings as you like on
  one spread sheet or you can create a new spread
  sheet for each grouping.
• Just remember to create new calculations if the
  number of subjects changes.

10
Using Excel For Calculations and Graphing

• In order to graph your results, you must enter
  the calculations in a new location and put them
  in columns from first to last. Title the
  column(s) in the first cell.
• Next, highlight the column(s).

11
Using Excel For Calculations and Graphing

• With the columns highlighted, click on the chart
  wizard icon to begin the graphing process.

12
Using Excel For Calculations and Graphing

• Choose line graph for all graphs in PEAK 300.
• Click next to move on from Step 1 of 4 to
  Step 2 of 4.
• Click next to move from Step 2 of 4 to Step
  3 of 4.

13
Using Excel For Calculations and Graphing

• At Step 3 of 4 you can add titles and edit most
  of your graph by choosing the tabs.
• When done, click next.

14
Using Excel For Calculations and Graphing

• At 4 of 4 you can name and save the chart
  (graph) you just made. I recommend saving it as
  a new sheet.
• Click finish to view your graph.

15
Using Excel For Calculations and Graphing

• You can always re-click the chart wizard to go
  back through all the steps to make changes.
• No information is lost when you do this if you
  have saved the graph.

16

• You can also edit straight from the completed
  graph.
• Double click on just about any part of the graph
  to make changes from scaling to line width to
  legends to font style.

17

• When you double click on a portion of the graph
  to make a change, a dialogue box will open.
• Choose your changes from each of the tabs and
  then click OK to view the results.

18
Using Excel For Calculations and Graphing

• Be sure to title your graph, title the x axis and
  y axis (if necessary).
• Make all titles clear, but not redundant. Anyone
  should be able to understand the relationships by
  the graph and the titles.

19
Using Excel For Calculations and Graphing

• Save your work and print out as part of your lab
  report.

20
Using Excel For Calculations and Graphing

• Create new tables and graphs for each lab
  experiment.
• Be sure that the data you compare have similar
  scales so that the visual comparison is easy to
  make.

21
Using Excel For Calculations and Graphing

• Try a practice graph with the following data and
  see if you can create a replica of the sample
  graph.

22
Using Excel For Calculations and Graphing

• Sample Graph.
• Notice the color changes and absence of legend
  box.

23
(No Transcript)
24
(No Transcript)