Forecasting in Excel

aftershokk

New Member
Joined
May 13, 2002
Messages
37
Hello, what are users using as an add-in to excel for forecasting, regression analysis and analyzing trends for a catalog company?

Thanks!
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Ian Mac

MrExcel MVP
Joined
Feb 20, 2002
Messages
1,174
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

New Member
Joined
May 13, 2002
Messages
37
Weekly forecasting among 4 divisions of the company including regression and trend analysis.
 

Ekim

Well-known Member
Joined
Jun 30, 2002
Messages
1,416
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
 

Forum statistics

Threads
1,144,151
Messages
5,722,801
Members
422,459
Latest member
Chriselff

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top