Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Excluding data for a linear regression in OpenOffice

  1. Nov 20, 2007 #1
    For my chemistry lab, in order to computer change in temperature for a calorimetry experiment we're suggested to take the line of best fit from the peak temperature onwards (excluding the initial data) and extrapolate to y = 0. For example, here's some of the data I gathered:

    A, Trial 2
    Time (s) Temp (°C)
    5 29.0
    10 31.0
    15 33.0
    20 33.5
    25 34.0
    30 34.0
    40 33.5
    50 33.5
    60 33.5
    70 33.0
    80 33.0
    90 33.0
    120 32.5
    150 32.5
    180 32.5
    210 32.0
    240 32.0
    270 32.0

    Basically, I want to take the line of best fit from 25 seconds on (as this is the peak of the temperature), excluding everything else. I want to put this line on the same graph as the data itself. Is there any way to exclude data when calculating the line of best fit?
     
  2. jcsd
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Can you help with the solution or looking for help too?
Draft saved Draft deleted



Similar Discussions: Excluding data for a linear regression in OpenOffice
  1. Data organization (Replies: 6)

  2. Copying data (Replies: 6)

Loading...