Excel 2008: Analysis Add-in?

In article <#QAwy09iIHA.5820@TK2MSFTNGP04.phx.gbl>,
"Mike Middleton" <mike.DeleteThis@mikemiddleton.com> wrote:

> Ryan -
>
> The array-entered worksheet function LINEST has been included in all
> versions of Excel (at least since Excel 4).
>
> LINEST can be used for multiple regression with up to sixteen explanatory
> variables.
>
> LINEST does not depend on the availability of the Analysis ToolPak add-in.
>
> (The Regression tool wizard of the Analysis ToolPak used Excel's built-in
> LINEST function for its computations.)
>
> - Mike Middleton
> <http://www.DecisionToolworks.com>
> Decision Analysis Add-ins for Excel

Just to add to that: with a little judicious setting up, you can use
LOGEST to fit certain combinations of exponential and linear functions
as well.

I even made LINEST fit a sine, by fitting to both sin(X) and cos(X),
and extracting the frequency and phase, but that falls in the realm of
software wanking :-)


Far better just to get a real tool: Regress+, or ProFit, or R, or
FreeMat, or Octave, etc etc.

--
Team EM to the rescue! http://www.team-em.com
 >> Stay informed about: Excel 2008: Analysis Add-in? 

Anyway to have it handy in Excel is actually the best thing. That's what we've paid for.

I'm doing High School Quantitative Methods right now and I always have to reboot to Windows and use Excel 2007 to create histograms all the time.

:(
 >> Stay informed about: Excel 2008: Analysis Add-in? 

In article <ee88d6d.39.DeleteThis@webcrossing.caR9absDaxw>,
infernalman7.DeleteThis@officeformac.com wrote:

> I'm doing High School Quantitative Methods right now and I always have to
> reboot to Windows and use Excel 2007 to create histograms all the time.

The workbook found here

http://www.coventry.ac.uk/ec/~nhunt/oatbran/

should be much faster than rebooting and using XL07.
 >> Stay informed about: Excel 2008: Analysis Add-in? 

In article <jemcgimpsey-01D350.09372227032008.RemoveThis@news.microsoft.com>,
JE McGimpsey <jemcgimpsey.RemoveThis@mvps.org> wrote:

> In article <ee88d6d.39.RemoveThis@webcrossing.caR9absDaxw>,
> infernalman7.RemoveThis@officeformac.com wrote:
>
> > I'm doing High School Quantitative Methods right now and I always have to
> > reboot to Windows and use Excel 2007 to create histograms all the time.
>
> The workbook found here
>
> http://www.coventry.ac.uk/ec/~nhunt/oatbran/
>
> should be much faster than rebooting and using XL07.

One more thing :-)

There's a Q&D toy for free at

http://www.blackcatsystems.com/GM/download.html

No instructions, but I figured it out :-)
You load a text-only file consisting of one entry per line.
The program displays a nice histogram and a bunch of related data like
mean and median, but unfortunately you can't save the image (except via
screen grabs). The program does save the binned data as CSV with bin
and quantity as ordered pairs, but there's no way to specify the number
of bins or any of that stuff.

--
Team EM to the rescue! http://www.team-em.com
 >> Stay informed about: Excel 2008: Analysis Add-in? 

Buy the way there is packages for Excel more powerful than Analysis
Toolpak, for example StatPlus:mac.
But it's price is higher than the Excel's one :)
 >> Stay informed about: Excel 2008: Analysis Add-in? 

After I installed Office for Mac, I had icons on the right hand side of my screen. Over the next few days they started to disappear and the system became unstable in the Administrative account. However the entries still show up in "Desktop" if I enter through "Finder". Outside the user in which I installed the software the system is stable. In the original Administrator account I can no longer up-date software, though I can in another account with administrative privileges. Apple's Genius Bar says this is all the result of Office changing my "permissions" when it was installed, and I should reformat my hard drive and completely reinstall all software from the ground up - a concept the leaves me cold. Has anyone else heard of anything like this?
 >> Stay informed about: Excel 2008: Analysis Add-in?