Forecasting in Excel

[aftershokk]

Hello, what are users using as an add-in to excel for forecasting, regression analysis and analyzing trends for a catalog company?

Thanks!

 

[Ian Mac]

On 2002-10-04 09:26, aftershokk wrote:
Hello, what are users using as an add-in to excel for forecasting, regression analysis and analyzing trends for a catalog company?

Thanks!

You need to be a bit more specific as to your requirements, Excel has lots of built in Statistical Functions:

Here's the list:

About statistical functions

Statistical worksheet functions perform statistical analysis on ranges of data. For example, a statistical worksheet function can provide statistical information about a straight line plotted through a group of values, such as the slope of the line and the y-intercept, or about the actual points that make up the straight line.

Which function do you want to read about?

AVEDEV worksheet function
AVERAGE worksheet function
AVERAGEA worksheet function
BETADIST worksheet function
BETAINV worksheet function
BINOMDIST worksheet function
CHIDIST worksheet function
CHIINV worksheet function
CHITEST worksheet function
CONFIDENCE worksheet function
CORREL worksheet function
COUNT worksheet function
COUNTA worksheet function
COVAR worksheet function
CRITBINOM worksheet function
DEVSQ worksheet function
EXPONDIST worksheet function
FDIST worksheet function
FINV worksheet function
FISHER worksheet function
FISHERINV worksheet function
FORECAST worksheet function
FREQUENCY worksheet function
FTEST worksheet function
GAMMADIST worksheet function
GAMMAINV worksheet function
GAMMALN worksheet function
GEOMEAN worksheet function
GROWTH worksheet function
HARMEAN worksheet function
HYPGEOMDIST worksheet function
INTERCEPT worksheet function
KURT worksheet function
LARGE worksheet function
LINEST worksheet function
LOGEST worksheet function
LOGINV worksheet function
LOGNORMDIST worksheet function
MAX worksheet function
MAXA worksheet function
MEDIAN worksheet function
MIN worksheet function
MINA worksheet function
MODE worksheet function
NEGBINOMDIST worksheet function
NORMDIST worksheet function
NORMINV worksheet function
NORMSDIST worksheet function
NORMSINV worksheet function
PEARSON worksheet function
PERCENTILE worksheet function
PERCENTRANK worksheet function
PERMUT worksheet function
POISSON worksheet function
PROB worksheet function
QUARTILE worksheet function
RANK worksheet function
RSQ worksheet function
SKEW worksheet function
SLOPE worksheet function
SMALL worksheet function
STANDARDIZE worksheet function
STDEV worksheet function
STDEVA worksheet function
STDEVP worksheet function
STDEVPA worksheet function
STEYX worksheet function
TDIST worksheet function
TINV worksheet function
TREND worksheet function
TRIMMEAN worksheet function
TTEST worksheet function
VAR worksheet function
VARA worksheet function
VARP worksheet function
VARPA worksheet function
WEIBULL worksheet function
ZTEST worksheet function

 

[aftershokk]

Weekly forecasting among 4 divisions of the company including regression and trend analysis.

 

[Ekim]

Hi,

Look at Excel functions: FORECAST, TREND, GROWTH AND CORREL (for correlation).

Search this site and Google for posts on these functions.

If you REALLY get stuck, I could email you an Excel workbook with some dummy data that illustrates the above functions. Contact me via a Private Message. This offer is made to you only.

Regards,

Mike