Using Excel to crunch numbers

We’re going to the library for the next few periods. Download the instructions using the link below. Use your own LO3 data instead of the numbers I have provided.

By the end of this activity you will be able to;

  • manipulate raw data using formulae in cells
  • plot a graph of your results
  • add error bars to your graph
  • add a line of best fit
  • calculate the gradient and y-axis intercept of your line

Leave a Comment