Download
1 / 8
80 likes | 187 Views
Frosh Research: How to Analyze Your Data. 1. Show your results in a data table. LABEL your quantities with appropriate units. LABEL the independent and dependent variables. ONLY numbers go in the data cells, no letters. 2. Find the average for each group. In the YELLOW cell, put =average(.
E N D
1. Show your results in a data table. LABEL your quantities with appropriate units LABEL the independent and dependent variables ONLY numbers go in the data cells, no letters
2. Find the average for each group In the YELLOW cell, put =average( Then select the cells with all the data for that group (all of the pink cells here), then close the parentheses The yellow cell will look something like this: =average(B2:B11) ENTER Do this for each of your groups.
What do you notice about the averages? They’re different, but how different? Does the 2nd bearing really make the skateboard faster? To find out, we need to include error bars. Put this in the GREEN box: =STDEV( Then select the cells with all the data for that group (all of the pink cells here) – and CLOSE the parentheses The cell will look like this: =STDEV(B2:B11) Do this for each of your groups.
3. Make a column graph, pt. 1 • Insert, Column Graph • Set up a separate series for each group – • Right-click on the graph • “Select Data” • “Add” a series for each group • Name is the same as your first group (“1st bearing”) • Values - click on the cell that shows the average for that group (“2.567”) • Repeat for each different group in your experiments
Here’s an example of how your graph will look now (after labels and titles are added)
3. Make a column graph, pt. 2 • It looks like the 2nd bearings a slightly faster than the 1st bearings – but how can we know for sure? • Margin of error! • Add in error bars: • Select a column on the graph • Chart, Layout, Error Bars, More options . . . • Custom • Select Values . . . select the STANDARD DEVIATION cell for that group as the positive and negative values.
