1 / 8

Frosh Research: How to Analyze Your Data

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(.

shima
Download Presentation

Frosh Research: How to Analyze Your Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Frosh Research: How to Analyze Your Data

  2. 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

  3. 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.

  4. 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.

  5. 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

  6. Here’s an example of how your graph will look now (after labels and titles are added)

  7. 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.

  8. Here’s how this graph would look now

More Related