Excluding data for a linear regression in OpenOffice

AI Thread Summary
In the discussion, the focus is on calculating the change in temperature for a calorimetry experiment by using a line of best fit from a specific point in the data set. The user has collected temperature data over time and aims to exclude initial data points before 25 seconds, where the peak temperature occurs, to create a more accurate line of best fit. The goal is to plot this line alongside the original data on the same graph. The user seeks guidance on how to exclude earlier data points when calculating the line of best fit while still displaying both data series together on the graph. This approach aims to enhance the clarity and relevance of the analysis in the context of the experiment.
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.
 
In my discussions elsewhere, I've noticed a lot of disagreement regarding AI. A question that comes up is, "Is AI hype?" Unfortunately, when this question is asked, the one asking, as far as I can tell, may mean one of three things which can lead to lots of confusion. I'll list them out now for clarity. 1. Can AI do everything a human can do and how close are we to that? 2. Are corporations and governments using the promise of AI to gain more power for themselves? 3. Are AI and transhumans...
Thread 'ChatGPT Examples, Good and Bad'
I've been experimenting with ChatGPT. Some results are good, some very very bad. I think examples can help expose the properties of this AI. Maybe you can post some of your favorite examples and tell us what they reveal about the properties of this AI. (I had problems with copy/paste of text and formatting, so I'm posting my examples as screen shots. That is a promising start. :smile: But then I provided values V=1, R1=1, R2=2, R3=3 and asked for the value of I. At first, it said...

Similar threads

Back
Top