I am averaging columns with varying numbers (1-5). There are no blanks and no
zeros. When I average some columns, the correct answer comes out with five
decimal places. When I try to average other rows I get a number without
decimal places (such as 4 or 5), but when I do the math physcially, I get the
answer 4.01818 or 4.75... instead of 4 or 5. Why am I getting the wrong
averages on some columns, I am using the same function (the Average function
under the Sum button on the toolbar)?
Please help me as there are many many numbers to average.
Thank you,
Lana