Results 1 to 2 of 2
Thread: Averaging an Average (97)
2001-11-14, 17:45 #1
- Join Date
- Jan 2001
- Thanked 0 Times in 0 Posts
Averaging an Average (97)
Here's the scenario: I have several sections within a survey, we'll call them Section A B and C. Within Section A there are 10 questions (A1-A10), the answers were entered as numbers 1 through 5. I've already gotten an average for each question. Now I also want to come up with an average for the entire section (questions A1-A10) and I'm having a mind-block on how to do it! I just can't seem to come up with the right formula or syntax to find that average. Any assistance would be most appreciated!
2001-11-14, 22:00 #2kevrizzGuest
Re: Averaging an Average (97)
If I read this right I think you need to do some sort of grouping by Section so that you view the data by Section rather than individual questions.