Ok so at my job we score an employee on a scale of 1-5 for 4 questions, so the values can range between 1 and 5. I have a table of 17 rows (17 employees) and 10 columns (up to 10 scores in a month). The goal for my team is to get a 4.86 average out of all 17 employees and up to 10 scores per employee.
Right now, for example, I have 36 scores with an average of 4.75. What I need is a formula or a way to automatically calculate how many perfect 5 scores I need to reach my 4.86 goal. (4.86 can be rounded up from 4.855 or higher).
Thanks in advance for the help.
P.S. I am doing this manually right now with a column of 40 perfect 5 scores in which I delete or add 5's until an average with my scores equals up to 4.86 but that is a hassle.
Bookmarks