using basic stats

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Using basic stats

Using basic stats

resolvedResolved · Low Priority · Version 2003

Veena has attended:
Excel Intermediate course

Using basic stats

where can I find summary of functions available in excel and information on how to use excel to do basic stats?

RE: using basic stats

Hello Veena

Thank you for your question and welcome to the forum.

If you search for functions in Excel help, there should be a Help topic List of worksheet functions (by category) that comes up in the list of results. From here you can view all the functions within the various categories.

There is also a tutorial available on the Microsoft web site regarding statistical functions - some of it might be a bit basic but there are parts that might be useful:
http://office.microsoft.com/training/training.aspx?AssetID=RC010919231033

The following article might also be useful:
http://office.microsoft.com/en-us/excel/HA011266271033.aspx?pid=CL100570551033

I hope this helps, bearing in mind that I'm not a statistician!

Kind regards
Amanda

Tue 25 Aug 2009: Automatically marked as resolved.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Naming and Using Constants

Constants make calculations easier so worksheets are more easily understood. Constant values also need to be given relevant and memorably names. It is also easier to change the value of a constant.

For example:
Instead of entering 17.5% in each cell when you generate a VAT amount you could name a Constant "VAT" and assigning a "0.175" value to it. To do this:

From the 'Insert' menu select 'Name', then select 'Define'.

Enter the constant

View all Excel hints and tips


Server loaded in 0.08 secs.