You are here:

Advanced Math/averages 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!

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:
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.


Advanced Math

All Answers

Answers by Expert:

Ask Experts


Janet Yang


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.


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

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

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.

©2017 All rights reserved.