ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Formulas (https://www.excelbanter.com/new-users-excel/146891-formulas.html)

Newby07

Formulas
 
I need the average for a set of survey questions and I cannot figure out how
to get the answers I need and write the formulas. I have 11 survey
questions, 5 choices for each question(1 is bad--5 is best), a combined # of
students(30) for 3 classes...1st class=11 students, 2nd class=9 students, 3rd
class=10 students. My boss says he wants the averages to be in the 4%-5%
range, but my calculations came up with ranges more like 10%, 11%, etc. And
I am no mathemetician or a "formula girl", so any help would be greatly
appreciated. Thanks!

confused

Formulas
 


"Newby07" wrote:

I need the average for a set of survey questions and I cannot figure out how
to get the answers I need and write the formulas. I have 11 survey
questions, 5 choices for each question(1 is bad--5 is best), a combined # of
students(30) for 3 classes...1st class=11 students, 2nd class=9 students, 3rd
class=10 students. My boss says he wants the averages to be in the 4%-5%
range, but my calculations came up with ranges more like 10%, 11%, etc. And
I am no mathemetician or a "formula girl", so any help would be greatly
appreciated. Thanks!


Sandy Mann

Formulas
 
I don't understand what you mean:
class=10 students. My boss says he wants the averages to be in the 4%-5%
range


4% - 5% of what?

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Newby07" wrote in message
...
I need the average for a set of survey questions and I cannot figure out
how
to get the answers I need and write the formulas. I have 11 survey
questions, 5 choices for each question(1 is bad--5 is best), a combined #
of
students(30) for 3 classes...1st class=11 students, 2nd class=9 students,
3rd
class=10 students. My boss says he wants the averages to be in the 4%-5%
range, but my calculations came up with ranges more like 10%, 11%, etc.
And
I am no mathemetician or a "formula girl", so any help would be greatly
appreciated. Thanks!





All times are GMT +1. The time now is 02:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com