You are here:

Advanced Math/averages chart

Advertisement


Question
chart
chart  
I don't know if you can answer this question about a chart of calling times which I have attached. The decimals represent time, e.g. 5.5 = 5.30am, etc. In the boxes at bottom I have inserted the formula for "average" and it works as far as the bottoms of columns A-D. Column E, bottom, is the average for columns A-D, and Column E, next to bottom is the average for column E. But here's the problem: when I insert a number into column E, it doesn't affect the bottom right (bolded) column. How do I get it so that all the bottom boxes each reflect the average for that column, and to make a separate box somehow that reflects the average for all columns. So for instance if I insert a number into the "Friday" column, the average in the E bottom box will reflect it? Thanks!

Answer
The bolded cell calculates the average of the bottom-row figures from columns A through D, but omits the average from Column E. That is why it does not update when you enter data in column E. You can change the formula to include E, but I question whether that is the result you want.

By averaging the bottom-row figures, you are taking the average of averages, which is not an accurate picture of the data. It gives Wednesday, which has only 3 data points, the same weight as Friday, which has 12 data points.

If you wish to calculate the average over all the data, the formula will look something like this:
 =AVERAGE(A2:E19)
and the cell must be sited outside the data area.

For style and consistency, the average for column E should appear on the same row as the other column averages.

Example:
http://www.flickr.com/photos/dwread/8531535255/

Advanced Math

All Answers


Answers by Expert:


Ask Experts

Volunteer


Janet Yang

Expertise

I can answer questions in Algebra, Basic Math, Calculus, Differential Equations, Geometry, Number Theory, and Word Problems. I would not feel comfortable answering questions in Probability and Statistics or Topology because I have not studied these in depth.

Experience

I tutor students (fifth through twelfth grades) and am a Top Contributor on Yahoo!Answers with over 24,000 math solutions.

Publications
Co-author of An Outline of Scientific Writing: For Researchers With English as a Foreign Language

Education/Credentials
I have a Bachelor's degree in Applied Mathematics from the University of California at Berkeley.

Past/Present Clients
George White Elementary School. Homework Help program at the Ridgewood Public Library, Ridgewood, NJ. Individual students.

©2016 About.com. All rights reserved.