automatic averaging

blueberry · Apr 3rd, 2002, 02:26 PM

I've got thousands of water level readings I'd like to average based on varying time periods. Is there a way that I can average the data automatically for, let's say, 1 week for the entire dataset. Can someone tell me if I can also get a max and min?

Much appreciated!

lenze · Apr 3rd, 2002, 03:01 PM

You could use a Pivot Table and group by date. You can select average (or Min, Max)for the Data Field option. Your data will have to be arranged in a table format with one column for dates, the other for readings. Then create the Pivot Table. Use Dates for the row field, Readings for the Data Field. You can group the date field by weeks, months, quarters, etc.

Dave Hawley · Apr 3rd, 2002, 08:24 PM

Hi blueberry

A pivot Table would also be my first choice, but also look under Data>Subtotals

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 3rd, 2002, 02:26 PM	#1
blueberry New Member Join Date: Apr 2002 Posts: 4	I've got thousands of water level readings I'd like to average based on varying time periods. Is there a way that I can average the data automatically for, let's say, 1 week for the entire dataset. Can someone tell me if I can also get a max and min? Much appreciated!

Apr 3rd, 2002, 03:01 PM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	You could use a Pivot Table and group by date. You can select average (or Min, Max)for the Data Field option. Your data will have to be arranged in a table format with one column for dates, the other for readings. Then create the Pivot Table. Use Dates for the row field, Readings for the Data Field. You can group the date field by weeks, months, quarters, etc.

Apr 3rd, 2002, 08:24 PM	#3
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi blueberry A pivot Table would also be my first choice, but also look under Data>Subtotals