Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

temperature weighted average

Comment:

hello, i have the aggregrate temperature average for a country by month for years 1978 - 2007. How do i calculate this results to yearly temperatur average. thanks

Name: Jennifer SUMN
Date: July 5, 2009 at 10:03:21 Pacific

Reply:

http://www.computing.net/answers/of... LIR

0

Name: DerbyDad03
Date: July 5, 2009 at 20:52:33 Pacific

Reply:

If you are trying to get the average temperature for each year, try this... Example: Your dates are in A1:A10 Your temps are in B1:B10 You have a list of years in C1:C4 Put this array-entered formula in D1 and drag it down to the bottom of your list of years: =SUMPRODUCT((YEAR($A$1:$A$10)=C1)*($B$1:$B$10))/SUM(1*(YEAR($A$1:$A$10)=C1)) Array entered means the formula is entered using Ctrl-Shift-Enter to put {} around the formula.

0

Keeping number of rows in...

strange font problem

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Hello, I think what I am trying to do is called weighted average in Excel, but I can not figure it out. I have a temperature reading at random times. I would like to calculate the average temperatur...

Summary: Hi I wish to average a set of cells, but not include cells with #N/A or any other error in them (and therefore not skewing my average) Is there any way of doing this? Thanks ...

Summary: Hi, I am using a report in Microsoft Access to try and display the most occuring customer number in a table, i have looked in the expression builder and there does not appear to be a mode average func...