Statistical smoothing a range of numbers - match average more clos
I have a range of numbers listed below. I want to smooth them out to be
closer to the average of 423,000. I would like to set a minumum of 350,000 and a maximum of 575,000 or thereabouts. Which statistical function(s) should I use? 507,946 713,695 413,505 256,822 277,154 794,495 679,093 178,376 308,652 449,225 698,341 363,686 375,933 264,610 498,582 310,760 342,731 620,156 355,224 340,426 247,197 295,597 291,706 369,606 462,799 583,680 |
Statistical smoothing a range of numbers - match average more clos
Pasko1 -
If your data are monthly time sequence observations, and if you wanted a trend line for subsequent seasonal analysis, you would use a moving average with period of 12. In Excel, you could create a Line chart and add a moving average trend line. Or, you could perform the same calculations on a worksheet using the AVERAGE worksheet function. - Mike www.mikemiddleton.com "Pasko1" wrote in message ... I have a range of numbers listed below. I want to smooth them out to be closer to the average of 423,000. I would like to set a minumum of 350,000 and a maximum of 575,000 or thereabouts. Which statistical function(s) should I use? 507,946 713,695 413,505 256,822 277,154 794,495 679,093 178,376 308,652 449,225 698,341 363,686 375,933 264,610 498,582 310,760 342,731 620,156 355,224 340,426 247,197 295,597 291,706 369,606 462,799 583,680 |
All times are GMT +1. The time now is 03:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com