Creating Graphs and Linearizing Data

docx

School

Salt Lake Community College *

*We aren’t endorsed by this school

Course

2010

Subject

Physics

Date

Dec 6, 2023

Type

docx

Pages

4

Uploaded by miniespindola

Report
Lab 1: GRAPHING AND INTERPRETING DATA LAB Introduction Displaying data graphically is often a valuable tool used to interpret laboratory results. Creating a graph by hand can be tedious and time consuming. Luckily, there are numerous software packages available that aid in plotting graphs. This lab contains two parts that allow for practice of graphing data using Microsoft Excel. Microsoft Excel, is available to you at no cost, through Broward College One Access, Office 365 Portal. The graphs you will create for this activity are called scatter plots. This type of graphing method is used when the data collected does not all lie in a perfectly straight line. Scatter plots allow you to find lines of best fit or smooth curves that fit the data. If you are not familiar with plotting graphs in Microsoft Excel, see the following video: Creating scatter plots in Excel Guidelines for Making Graphs Your graph should have a descriptive title that tells the reader exactly what is graphed. You should have axes that are labeled with the variable and its units. Remove stray lines, legends, points, and any other unintended additions by the computer that does not add to your graph. Adjust the scale so that the data is spread out to cover most of the graph area. The origin ( 0,0 ) does not always need to be included. Any added trendline equation should be changed to match the variables being plot. Figure 1a: Taken from University of Pennsylvania, Department of Physics and Astronomy, this is an example of a bad graph. The missing elements are highlighted in red font.
Figure 1b: An example of a good graph taken from University of Pennsylvania, Department of Physics and Astronomy. The improvements are shown in green. Linearizing data A linear relationship between y and x variables has the form y = mx + b , where m is the slope of the graph and b is the y -intercept. This is useful for showing direct relationships such as F = ma and V = IR . Plotting a graph of voltage, V vs. current, I (i.e. voltage on the y -axis and current on the x -axis) would give a straight line graph with a slope that is equal to the value for resistance, R . What about equations which are non‐linear? How could a best fit straight-line help with that? The trick is to linearize your data and then apply a linear trendline fit. Consider the two graphs below, which both deal with the equation y = ax 2 . The left graph y vs. x is plotted directly, which yields a parabola or second order polynomial fit. In the graph on the right we have linearized the function and plotted y vs x 2 . By doing this, we obtain a straight-line graph with slope equal to a , the co-efficient of x 2 . The difference between the two graphs is that in graph A, x is treated as the independent variable and in graph B x 2 is treated as the independent variable. We will practice linearizing your data but first we have an example, Example 1, to show you the process. Figure 2: Another diagram taken from University of Pennsylvania, Department of Physics and Astronomy showing how to change the parabolic relationship between y and x to obtain a linear graph.
Example 1 : The period of a pendulum is given by T = 2 π L g . In lab students perform an experiment in which they measure the period, T, and the length of the pendulum, L. From the equation, which shows the relationship between the T and L, we see that they are not directly related to each other. So, a graph of T vs L would not be linear. 1. What can the students plot to obtain a linear graph? Answer 1a: They can plot T vs L and in this case the slope = 2 π g . 2. What are the units of the slope? Unit of slope = (units of y -axis) = units of T = seconds (units of x -axis) units of L meters 3. What does the slope represent? Or what is the physical significance of the slope? It is understood that the slope represents how T changes with L so that is not what is being asked. The slope represents the coefficient of the variable on the x-axis. So, in this case the slope is the coefficient of L. Rewrite the equation, So now you can clearly see that the coefficient of L is 2 π g . So the slope = 2 π g Alternative solution : Alternatively, students can square both sides of the equation to obtain T 2 = 4 π 2 L g . 1. What can the students plot to obtain a linear graph? The students can plot T 2 vs L to obtain a linear graph. 2. What are the units of the slope? The units of the slope will be units of T 2 = (seconds) 2 units of L = meter 3. What does the slope represent? Or what is the physical significance of the slope? The slope will now be the coefficient of L. Therefore, the slope ¿ 4 π 2 g .
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Example 2 : Torricelli’s law says that for a tall column of liquid in a container with a small hole at the bottom, the water will flow out of the hole with a velocity v = 2 gh . In lab, students measure v , the velocity of the water, and h , the height of the liquid column. If they graph v vs. √ h , the graph will be linear with a slope ¿ 2 g and an intercept of zero. 1. Use the following data table to plot a linear graph and use the slope to calculate an experimental value for g . Determine the percent error using g theor = 9.81 m/s 2 . Data Table 1: The table shows the height, h , measured from the small hole to the top of the water column, and the measured speed, v , of the water flowing out of the small hole near the bottom of the column. Height, h ± 1 (cm) Speed v ±0.2 (m/s) 100 4.2 120 5.0 140 5.2 160 5.6 180 6.0 200 6.4 220 6.8 240 7.0 Slope: _______________________ g experimental : ____________________ Percent error: ____________________ ** see the document “Experimental Uncertainty and Error in Lab” to calculate the percent error