moving avergage data analysis

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Moving Avergage in Data Analysis

Moving Avergage in Data Analysis

resolvedResolved · Low Priority · Version 2007

Rees has attended:
Excel Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course

Moving Avergage in Data Analysis

What is the significance of the "Interval" selection when producing the Moving Average chart through the Data Analysis Function.

Thanks

RE: Moving Avergage in Data Analysis

Hello Rees

Thank you for your question and welcome to the forum.

The following article on the Microsoft web site discussed the Moving Average analysis tool, although the article mentions Excel 2003 I'm assuming the functionality of this is the same in 2007.

Kind regards
Amanda

RE: Moving Avergage in Data Analysis

Hello Rees

Sorry, I forgot to add the link to the article in my last post:
http://office.microsoft.com/en-gb/excel/HA010864801033.aspx

Kind regards
Amanda

Mon 6 Jul 2009: Automatically marked as resolved.


 

Excel tip:

Status Bar Functions

When using the SUM, MIN, MAX, AVERAGE and COUNT functions, the result of such calculations are displayed in the worksheet.

However, if a range of cells, containing numbers, is highlighted, and then a right-mouse click is performed at the bottom right side of the status bar, then the result of those functions will be displayed.

View all Excel hints and tips


Server loaded in 0.09 secs.