I am surveying 5,000 people. I have 8 questions using a 5 point Likert scale response (Strongly agree to Strongly disagree).

I want the end of the survey to dynamically score people based on their answers and serve 3 outcomes (eg. happy, ok, sad)

I have applied weights to each question. Eg. Question 1 = weight 7 and I've scored the answers 1 - 5. Therefore, if I strongly disagree my score is 35.

Is there a technique that I can use in Excel to work out what the breaks are in the scores. Eg. 175+ = high, 100-175 = medium, <100 = low. Basically, I need to more scientifically calculate the breaks. I need to set these breaks before I survey people (i.e. I'm working with the survey design rather than response data).

thanks