Monday, December 27, 2010
Graphing & Extrapolating: How Many Licks Does it Take?
Since we weren't able to complete enough licks to get our answer, we need to graph the data and then extrapolate to find the answer. You can do this by hand or using Excel.
Here are the instructions for creating the graph on Excel*
Open a new excel worksheet
Label column A "Number of Licks"
Label column B "Mass"
Fill in number of licks, continuing by 10s until you reach 200 (yes, go to 200 even if you didn't get anywhere near that many licks done).
Go to Insert, then Chart
Click on XY Scatter, then click Next
Enter a chart title (name of lab), the x-axis label (Number of Licks), and the y-axis label (Mass (g))
Select the option to place the chart as a new sheet
Click on one of the points on the graph - all the points should be highlighted
Go to Chart, then Add trendline
Click on the legend and delete it
Double click on the numbers on the y-axis.
Click on Scale
Change Minimum to 0
Double click on the background of the graph
Set area to none
Print the graph
Draw a horizontal line at the value you had for the stick and wrapper
At the point where the line you drew hits the line on the graph, draw a vertical line to the x-axis.
Estimate the value for where the line hits the axis - that is the number of licks it would take to get to the center of a Tootsie Roll Pop
*I wrote these instructions using an older version of Excel, which is still what I have access to. If you use a newer version and find that some of the terminology needs to be changed, please let me know. Also, please let me know if something is unclear or you just aren't sure about something and I'll do my best to help.