You will need the attached file when we go to the library to learn about using Excel to crunch data for your project.
We’ll spend the next two lessons in the library learning how to use Excel. Download the instructions using the link below. If you have your own LO3 data, feel free to work with those values 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
Here is the file you will need for the graphing activity in today’s lesson.
This tutorial will help you with adding a line of best fit to your LO3 graph. If you use the linest function, you can extract useful information on gradient and intercept of the line. There are also screenshots to show how error bars can be added to individual points.
I have added a download link to a short pdf on the use of linest.