Hi all,
I work in a contact center that evaluates calls on a scale from 0 - 4, 2 and above meeting expectations. We are trying to figure out a way to map out goal growth for ourselves over a period of time (how many associates to move from not meeting expectations, to meets.
I got the bright idea to ball park the numbers, graph them on a line chart in excel, and then have excel give me the formula to a trend line that I can then turn into the formula to give me the goal growth given some historic value. (EG if 36% of your team fell in the 2s, 3s, & 4s category last time how many should fall into it this time for you to be effective at growth? How many for high? How many for outstanding?).
Problem is it seems like excel is horrible at figuring out the formula to a best fit line. I am using a power 6 polynomial, because it plots to the ballpark figures pretty well, but the y= formula that excell gives me comes nowhere close to matching the best fit line.
Is this a known problem? Is there anything I can do to fix it? The excel gurus on this site have helped me before, I am sure you can help me again.
Here is a screenshot of the data table and line chart I have...
As you can see the "Best Fit Value" collumn should come close to the value in the "Increase Goal" collumn, but it is nowhere near.
Thoughts?
Thanks!
I work in a contact center that evaluates calls on a scale from 0 - 4, 2 and above meeting expectations. We are trying to figure out a way to map out goal growth for ourselves over a period of time (how many associates to move from not meeting expectations, to meets.
I got the bright idea to ball park the numbers, graph them on a line chart in excel, and then have excel give me the formula to a trend line that I can then turn into the formula to give me the goal growth given some historic value. (EG if 36% of your team fell in the 2s, 3s, & 4s category last time how many should fall into it this time for you to be effective at growth? How many for high? How many for outstanding?).
Problem is it seems like excel is horrible at figuring out the formula to a best fit line. I am using a power 6 polynomial, because it plots to the ballpark figures pretty well, but the y= formula that excell gives me comes nowhere close to matching the best fit line.
Is this a known problem? Is there anything I can do to fix it? The excel gurus on this site have helped me before, I am sure you can help me again.
Here is a screenshot of the data table and line chart I have...

As you can see the "Best Fit Value" collumn should come close to the value in the "Increase Goal" collumn, but it is nowhere near.
Thoughts?
Thanks!