how to decompose the data in excel ?

[David Biddulph]

You'll have to be clearer as to what you mean by your question.

(... and please ask the question in the body of the message, not in the
subject line.)

 

[Mike Middleton]

Jitin -

There is an example file, LinearTrendSeasonalForecast.xls, for one approach
at http://www.mikemiddleton.com

There are three methods described in Chapter 20, "Time Series Seasonality,"
of my book, Data Analysis Using Microsoft Excel: Updated for Office XP.

- Mike

 

[Decomposing the data]

Thanks mike,

Appreciate the reply.

Jitin

Jitin -

There is an example file, LinearTrendSeasonalForecast.xls, for one approach
at http://www.mikemiddleton.com

There are three methods described in Chapter 20, "Time Series Seasonality,"
of my book, Data Analysis Using Microsoft Excel: Updated for Office XP.

- Mike