Jtucker10278
Board Regular
- Joined
- May 14, 2017
- Messages
- 65
- Office Version
- 365
- Platform
- Windows
I guess I'm looking for a place that can help me with general maths/conceptual help.
I don't know if there is a place here to post/discuss this type of stuff or if anyone can recommend another forum
Example 1.
Weighted Averages -
Movie and TV ratings on IMDB are rated 0.0 through 10.
however something that has an average rating of 7 that has been rated by 50,000+ people is probably better than something that has an average rating of 8.5 but only rated by 650 people.
So I understand the concept of weighted averages and how to do it in excel but I am clueless about how much "weight" to give in this instance.
Example 2.
Employee Productivity Charts -
I have employees who build different kinds of widgets,
Sarah Builds Widget Type A faster than she builds Type B or C
Tom Builds Widget Type A just as fast as Sarah But he also builds Type C faster than anyone.
How do I Show this on a Graph or Chart?
Again I understand how to make charts in excel I just don't know the best way to represent this data
thanks for any thoughts
I don't know if there is a place here to post/discuss this type of stuff or if anyone can recommend another forum
Example 1.
Weighted Averages -
Movie and TV ratings on IMDB are rated 0.0 through 10.
however something that has an average rating of 7 that has been rated by 50,000+ people is probably better than something that has an average rating of 8.5 but only rated by 650 people.
So I understand the concept of weighted averages and how to do it in excel but I am clueless about how much "weight" to give in this instance.
Example 2.
Employee Productivity Charts -
I have employees who build different kinds of widgets,
Sarah Builds Widget Type A faster than she builds Type B or C
Tom Builds Widget Type A just as fast as Sarah But he also builds Type C faster than anyone.
How do I Show this on a Graph or Chart?
Again I understand how to make charts in excel I just don't know the best way to represent this data
thanks for any thoughts