Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Smoothing Data in Columsns in Excel 2012
I am trying to smooth data in a work sheet. What I am trying to do is, I have 35 years of temperature data for my location. In teh colums AVG High, AVG LOW and AVG Temp is the average for each day. As you can see that teh data is "noisy". I want to smooth the data.
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Smoothing Data in Columsns in Excel 2012
"munleyj" wrote
I am trying to smooth data in a work sheet. What I am trying to do is, I have 35 years of temperature data for my location. In teh colums AVG High, AVG LOW and AVG Temp is the average for each day. As you can see that teh data is "noisy". I want to smooth the data. [....] |Download: http://www.excelbanter.com/attachment.php?attachmentid=715| There are many ways to "smooth data". It is unclear what method you want to use. And it is unclear how you want to present the "smoothed" data. You might consider the Moving Average option of the Data Analysis feature. Click on Tools, Data Analysis. Or you might consider creating an XY Scatter chart of the data, then selecting the Moving Average trendline. For your example, a moving average of 7 periods might provide the "smoothing" that you are looking for. (There are many other types of moving averages. You might want to take a look at http://en.wikipedia.org/wiki/Moving_average.) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2012 Excel Modeling World Championships (New York) | Excel Programming | |||
inserting columsns variable range | Excel Programming | |||
smoothing integer data | New Users to Excel | |||
smoothing data | Excel Discussion (Misc queries) | |||
double exponential smoothing in MS Excel? | Excel Discussion (Misc queries) |