hi guyz...
looking for a simple HELP on numerical equivalent interpretation on a result of

1.00 - 1.80
1.81 - 2.60
2.61 - 3.40
3.41 - 4.20
4.21 - 5.00
...what are the interpretation of each result??... besides the poor,fairly,good,very good,excellent OR very unaccepted,unaccepted,fairly accepted,acceptable,very acceptable.
....
..will use the interpretation of each result for the Weighted Mean Interpretation for User Acceptance Test for program design...

Thank you.....8)

What is User Acceptance Test? What is the test for? That would give us some ideas what to call those rankings.

If you want to match numeric ranges to strings then please give us the exact mapping and we can help with the code. Your question is very unclear as to what you want.

What is User Acceptance Test? What is the test for? That would give us some ideas what to call those rankings.

-what is UAT - application testing, and/or end user testing - is a phase of software development in which the software is tested in the "real world" by the intended audience.
OR evaluation for the system where the intended audience or evaluator will know what is 1.00-1.80 or 4.21-5.00 etc.. mean.

-What is the test for - User Acceptance Testing FOR Program Design, Content and Features, Usability and Acceptability.

we use weighted mean as the statistical tool in the study. the wighted mean that has a value of 3.41 and higher indicates a mean and the value 3.40 and below indicated that the system is not accepted by the user.

this is the table that i have.....

Verbal Interpretation
numerical equivalent|prog.design|content&featur|usability |acceptability
4.21-5.00 | excellent |excellent |Very Usable |veryacceptable
3.41-4.20 | very Good |very Good |Usable |Acceptable
2.61-3.40 | Good |Good |FairlyUsable|Fairly accpted
1.81-2.60 | fairly |fairly |usable |Unaccepted
1.00-1.80 | Poor |poor |Usable |veryunaccepted

am looking for a "sentence like interpretation " just like this:

Strongly Agree (5) represent the respondent’s total agreement on the indicators presented that the software application meets the requirements related to the program design, features and efficiency of the software application.
Agree (4) represent the respondent’s agreement on the indicators presented that the application software meets the requirements related to the program design, features and the efficiency of the software application

=If you want to match numeric ranges to strings then please give us the exact mapping and we can help with the code. Your question is very unclear as to what you want.?

acctually there are no codes because its just a study/research...and this part is an evaluation for the system where the intended audience or evaluator will know what is 1.00-1.80 or 4.21-5.00 etc.. mean.

.....sorry for the disturbance and thank you for your time.. 8)

Hi and thanks for posting. As per for fetching to appropriate entry within a range I would suggest storing the two numbers on each row in a seperate column which is the type double rather than a string as you have presented.After 4.21 and 5.0 are in two different columns, all you need to do is a sql query like the following:

SELECT * FROM `table` WHERE $value>=`min` AND $value<=`max`

After inserting that query and replacing $value with the intended value you are searching for you should get the resulting row you are looking for.

If there are any other questions just ask.

Thanks

cwarn23