Excluding data for a linear regression in OpenOffice

Click For Summary
SUMMARY

The discussion focuses on how to exclude initial data points when calculating the line of best fit for a linear regression in OpenOffice, specifically for a calorimetry experiment. The user aims to analyze temperature data starting from 25 seconds, where the peak temperature occurs, and plot this alongside the initial data points. The solution involves using OpenOffice's charting features to create two separate data series: one for the data from 25 seconds onward and another for the data prior to that time. This method allows for a clear visual representation of the temperature change over time while excluding irrelevant data.

PREREQUISITES
  • Familiarity with OpenOffice Calc for data manipulation
  • Understanding of linear regression concepts
  • Basic knowledge of graphing techniques in spreadsheet software
  • Ability to interpret temperature data in a scientific context
NEXT STEPS
  • Learn how to create and customize charts in OpenOffice Calc
  • Research methods for calculating linear regression in spreadsheet software
  • Explore data filtering techniques in OpenOffice Calc
  • Investigate best practices for presenting scientific data visually
USEFUL FOR

Students conducting scientific experiments, educators teaching data analysis, and researchers needing to visualize temperature data effectively.

xAXISx
Messages
10
Reaction score
0
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?
 
Computer science news on Phys.org
I would plot the data from 25 seconds onward as one data series, fit them, then add the data points from < 25s as a second data series onto the same graph.
 

Similar threads

  • · Replies 30 ·
2
Replies
30
Views
5K
  • · Replies 16 ·
Replies
16
Views
5K
  • · Replies 2 ·
Replies
2
Views
5K
  • · Replies 6 ·
Replies
6
Views
7K
  • · Replies 1 ·
Replies
1
Views
3K
  • · Replies 2 ·
Replies
2
Views
4K
  • · Replies 1 ·
Replies
1
Views
4K
  • · Replies 1 ·
Replies
1
Views
5K
  • · Replies 6 ·
Replies
6
Views
7K
  • · Replies 2 ·
Replies
2
Views
2K