Answer to Question #27112 in Statistics and Probability for Toog

Question #27112
I have to group some variables and assign the number in () into the following: <=5(1) 6-10(2) >10(3) Unknown(9) I can get the numbers in the right category except for Unknown (9). The variable for 9 is 99 in the spreadsheet. this is the formula that I used and it generates a 3 for 99 and that is not what I need. =IF(E2<=5,1,IF(E2<=10,2,IF(E2>=11,3,IF(E2=99,9))))
0
Expert's answer

Answer in progress...

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be the first!

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS