GaryTurnerScience



WORKSHEET – Linearizing Data and determining relationshipsGoal: Determine the type of relationship between each set of dependent and independent variables.Open up an Excel fileEnter the dataPlot the data as a scatter plotFind the best-fit curve for the dataUse the equation of the curve to help you figure out how to straighten/linearize the dataMake a new data column with a formula to linearize the original dataPlot this new data as a scatter plot.Find the best-fit straight line for this new data.5495290542127Data Set 10Time (s)tDistance (m)d0.000.001.006.902.0023.603.0050.104.0086.405.00132.506.00188.407.00254.108.00329.609.00414.9010.00510.0000Data Set 10Time (s)tDistance (m)d0.000.001.006.902.0023.603.0050.104.0086.405.00132.506.00188.407.00254.108.00329.609.00414.9010.00510.003278977541020Data Set 9Distance (m)dForce (N)F0.5060.000.7030.610.9018.521.1012.401.308.881.506.671.705.191.904.162.103.402.302.842.502.4000Data Set 9Distance (m)dForce (N)F0.5060.000.7030.610.9018.521.1012.401.308.881.506.671.705.191.904.162.103.402.302.842.502.40HARD - Express the equation of the best-fit straight line in terms of the data, NOT in terms of "y" and "x."right4164330Data set #Type of relationshipEquation of best-fit curve7Linear (direct)F = 4m8Linear (direct)F = 1.8C + 329InverseF = 15d-210SquaredD = 4.9t2?+ 2t11Linear (direct)G = 0.4ts12InverseG = 3.8tg-1?OR G = 3.8/tg00Data set #Type of relationshipEquation of best-fit curve7Linear (direct)F = 4m8Linear (direct)F = 1.8C + 329InverseF = 15d-210SquaredD = 4.9t2?+ 2t11Linear (direct)G = 0.4ts12InverseG = 3.8tg-1?OR G = 3.8/tg1515745139700Data Set 8Temp (0C)CTemp (0F)F-25.00-13.00-20.00-4.00-15.005.00-10.0014.00-5.0023.000.0032.005.0041.0010.0050.0015.0059.0020.0068.0025.0077.0000Data Set 8Temp (0C)CTemp (0F)F-25.00-13.00-20.00-4.00-15.005.00-10.0014.00-5.0023.000.0032.005.0041.0010.0050.0015.0059.0020.0068.0025.0077.00-189393130810Data Set 7mass (kg)mForce (N )F1.004.001.506.002.008.002.5010.003.0012.003.5014.004.0016.004.5018.005.0020.005.5022.006.0024.0000Data Set 7mass (kg)mForce (N )F1.004.001.506.002.008.002.5010.003.0012.003.5014.004.0016.004.5018.005.0020.005.5022.006.0024.0021043904445Data Set 12Gaming time (hours/week)tgGPAG1.003.802.001.903.001.274.000.955.000.766.000.637.000.548.000.489.000.4210.000.3800Data Set 12Gaming time (hours/week)tgGPAG1.003.802.001.903.001.274.000.955.000.766.000.637.000.548.000.489.000.4210.000.38left4351Data Set 11Study time (hours/week)tsGPAG1.000.402.000.803.001.204.001.605.002.006.002.407.002.808.003.209.003.6010.004.0000Data Set 11Study time (hours/week)tsGPAG1.000.402.000.803.001.204.001.605.002.006.002.407.002.808.003.209.003.6010.004.00 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download