A temperature sensor probably has picked up noise. This result is put in Calc. Red curve. A screendump of a part of the curve is made.
I have drawn manually a "ideal" blue line over the red curve, of which I think it should have been the result without noise.
Does Calc has a function that can also approximately eliminate or reduce the noise from the data?
See attachement.
[Solved] Noisy data
[Solved] Noisy data
- Attachments
-
Last edited by Kees1 on Mon Sep 27, 2021 9:50 pm, edited 1 time in total.
Open Office 4.1.7
Windows 10 64-bits
Windows 10 64-bits
Re: Noisy data
You can plot two series, one with all of the points and one that averages over N points. I picked N = 5 in the attached file.
- Attachments
-
- SmoothLine.ods
- (22.74 KiB) Downloaded 155 times
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Noisy data
Using a running average smooths a line too. Here you average the five (or different number) preceding values and plot their values.
The SLOPE function fits a straight line to data using linear regression and returns its slope.
You could do your own least squares analysis and find the curve which minimises the sum of the differences.
removing noise from plotted data spreadsheet gets lots of hits including Smoothing
The SLOPE function fits a straight line to data using linear regression and returns its slope.
You could do your own least squares analysis and find the curve which minimises the sum of the differences.
removing noise from plotted data spreadsheet gets lots of hits including Smoothing
- Attachments
-
- Running average.ods
- (35.96 KiB) Downloaded 138 times
LO 6.4.4.2, Windows 10 Home 64 bit
See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.
Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.
Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
Re: Noisy data
Thank you.
Exactly what I wished.
However after I had created a column with more than 3000 meanvalues I had to empty every 2nd, 3rd, 4th and 5th cell between two wanted mean values.
May be a macro can make the trick?
Exactly what I wished.
However after I had created a column with more than 3000 meanvalues I had to empty every 2nd, 3rd, 4th and 5th cell between two wanted mean values.
May be a macro can make the trick?
Open Office 4.1.7
Windows 10 64-bits
Windows 10 64-bits
Re: Noisy data
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Noisy data
1. Select a group of 5 cells. one with the formula, the others emptyKees1 wrote:I had to empty every 2nd, 3rd, 4th and 5th cell between two wanted mean values.
2. Copy
3. Highlight the 3,000 cells. l-click in A10, scroll to A3,010, Shift+l-click in A3,010 selects A10 to A3,010
4. Paste
LO 6.4.4.2, Windows 10 Home 64 bit
See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.
Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.
Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
Re: Noisy data
Thank you. That helped.John_Ha wrote:1. Select a group of 5 cells. one with the formula, the others empty
2. Copy
3. Highlight the 3,000 cells. l-click in A10, scroll to A3,010, Shift+l-click in A3,010 selects A10 to A3,010
4. Paste
Open Office 4.1.7
Windows 10 64-bits
Windows 10 64-bits