Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
David J. Braden
 
Posts: n/a
Default

Jerry---
You allude to "several commercial add-ins to do more complicated analysis in
Excel "; I assume you aren't referring to Matlab or Mathematica interfaces.
What exactly do you have in mind? Rather, what would *you* recommend, and
why?

TIA
Dave B

"Jerry W. Lewis" wrote in message
...
Mike wrote:

...

I think my question has been answered. Excel does not have any functions
that allow you to forecast or trend beyond a linear trend or forecast
(Which I am very surprised).



That depends on how you are defining "linear". As noted in my first post
in this thread, TREND can do polynomial, multiple regression, etc.
forcasting. Models that are linear in the unknown coefficients are a far
richer set than just straight lines.

Also, with Solver or VBA, it is possible to fit any model that you wish,
you just have to work a bit harder. Also there are several commercial
add-ins to do more complicated analysis in Excel (try a Google search). Or
you can use Excel as a convenient interface into the widely used
statistics package R
www.r-project.org

Jerry



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trend Forecast Help MIVELD Excel Worksheet Functions 3 June 23rd 05 11:23 AM
PASTE DOWN FUNCTIONS jackle Excel Worksheet Functions 0 May 25th 05 02:10 PM
3 questions about automated c++ com add-in worksheet functions gert Excel Worksheet Functions 0 March 10th 05 09:57 AM
Statistical functions David Excel Worksheet Functions 9 January 13th 05 01:57 PM
Trend Lines (or Linest?) Martinaire Excel Worksheet Functions 2 November 26th 04 06:08 PM


All times are GMT +1. The time now is 11:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"