O'Reilly logo

Top Market Strategy by Elizabeth Rush Kruger

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

A3.5 Calculate Averages for Metric Items

Our next step was to average metric responses by designating the range of cells to be averaged. To average the metric responses in column S, we formated an empty cell with one decimal place and entered “=AVERAGE(S2:S151).” We revised this formula to average all metric responses (items S-2, S-3, and 4.1–11.5 in columns C, D, and S–BF).

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required