Overview
A big part of experimental psychology is organizing and analyzing data and then showcasing the data using graphs. In this experimental lab, you will use a provided data sheet and how-to videos to create some of the most common graphs: line graphs, bar graphs, and scatter plots. You will then copy and paste the graphs you create into a worksheet and answer a few questions about what they represent. Creating graphs from data collected in experiments can help to showcase results.
In this activity, you will be watching three ‘how-to’ videos with instructions on how to create line graphs, bar graphs, and scatter plots using Microsoft Excel.
After learning how to make graphs from the videos, you can download a spreadsheet with three folders containing descriptions of an experiment and data.
You will make three types of graphs and then copy and paste your graphs into a worksheet.
Instructions
- Download the datasheet.
- Download the worksheet.
- The data sheet has three sheets of data, which can be found as tabs on the bottom of the: line graph, bar graph, and scatter plot.
- For each sheet, read the experimental design and then watch the how-to video below that goes with each sheet and follow the directions. You may need to watch the videos more than once.
- When you’ve created your graphs, copy them, and paste them into the worksheet.
- Answer the questions on the worksheet.
Files
This is the spreadsheet with the data needed to make the graphs (see videos below for instructions
This is the worksheet where you will answer questions and upload your graphs.
Videos
These are the links to the three videos showing how to create a bar graph, line graph, and scatterplot using the Excel spreadsheet provided. Click on the link to take you to the video.
Psychology Labs and Hub 