View as Microsoft Word* | View as PDF
Data Analysis Worksheet
Use your spreadsheet to calculate your sum totals or averages:
- Click in the cell below your seventh day (probably the cells in the tenth row).
- On the Insert menu, choose Function, a function pop-up window will appear.
- Choose your function (Sum or Average).
- Click OK.
- In Number 1, enter the cells you want the sum total or average, such as B3:B6.
- Click OK.
- Your calculation should now show up in the cell.
Answer the following questions as you interpret your data:
- Are some categories more numerous? Why do you think this is so?
- Do some categories have higher averages? Why do you think this occurs?
- Were your predictions accurate? What did you learn from your predictions?
- Do you think that you would get the same data should you continue your observational study for seven more days? Why or why not?
Creating a Graph
Use the chart wizard to produce at least two different charts representing your data. Think about which type of chart best represents your data and explain why you have chosen the charts you have. Import the charts into your worksheet:
<
Return to Insects