Hi Neville and Assumers,

it is good to see the list still exists.
Excel 2007 is really a mixed blessing. The fact that Excel now has
 > 10^6 rows and > 1.6*10^4 columns is really a major change for 
statistical work, and it is extremely useful for quick and dirty data 
maintenance for larger data sets.

COUNTIFS might be useful but it always was possible (albeit possibly 
somewhat more esoteric) to do any complicated COUNT queries using array 
functions.

Graphics really was downgraded in my opinion. What Neville describes is 
just one of the niceties the MSofties removed. Rotating 3D-charts 
mousewise is another one of the lost treasures.

In case some readers of the list don't know: there is a blog of the 
Excel developer team at
http://blogs.msdn.com/excel/

I also have a question:
SPSS now has an Excel addin (works with XL2007 only).
SPSS Advantage™ for Excel® 2007
Does anybody on the list have any experiences with it?

Some more hints:
Changes from 2003 to 2007 are documented at
http://technet.microsoft.com/en-us/library/cc179167.aspx


http://blogs.msdn.com/excel/archive/2006/08/24/718786.aspx
has the list of all the goodies which went into the bitbucket

http://www.microsoft.com/downloads/details.aspx?FamilyID=89718abd-2758-47b3-9f90-93788112b985&DisplayLang=en
is an application showing where you find things you know how to do in 
Excel 20043 and cannot find in Excel 2007.


One more thing:
Excel 2008 on Macs does not have VBA anymore. This is really very 
aggressive: Addin-developers have lost the means of developing software 
for 2 platforms from a commons source base.











Neville Hunt wrote:
> Dear Assumers
> 
> This list has been rather quiet of late.  I have just taken delivery of
> Excel 2007 and would be interested to know what you think of the new
> version insofar as it affects Statistics.
> 
> I see there is a new COUNTIFS functions that allows multiple conditions
> for the "if".  That might be useful for calculating grouped frequency
> distributions - as an alternative to using the FREQUENCY array function,
> or calculating the cumulative distribution first.  Are there any new
> statistical functions?  None is mentioned in the Help under What's New.
> 
> It seems that the four-step Chart Wizard has vanished.  It is certainly
> going to take me a while to get used to the new chart drawing interface!
> I don't seem to be able to select a single data point on a chart now.  I
> used to have a really neat exercise for students where they could
> manually move a point on a scatter plot and see the effect it had on the
> correlation.  That does not now appear to be possible.
> 
> Anyone else got any thoughts?
> 
> Neville
> 
> Dr Neville Hunt
> Department of Mathematical Sciences
> Coventry University
> Priory Street
> COVENTRY
> CV1 5FB
> Tel: 02476-888978
>  
>  
> --------------------------------------------------------
> 
> NOTICE
> 
> This message and any files transmitted with it is intended for the addressee only and may contain information that is confidential or privileged. Unauthorised use is strictly prohibited. If you are not the addressee, you should not read, copy, disclose or otherwise use this message, except for the purpose of delivery to the addressee. 
> 
> Any views or opinions expressed within this e-mail are those of the author and do not necessarily represent those of Coventry University.
> 
> 

-- 
Erich Neuwirth, University of Vienna
Faculty of Computer Science
Computer Supported Didactics Working Group
Visit our SunSITE at http://sunsite.univie.ac.at
Phone: +43-1-4277-39464 Fax: +43-1-4277-39459