Warning

 

Close

Confirm Action

Are you sure you wish to do this?

Confirm Cancel
BCM
User Panel

Posted: 1/18/2024 10:30:19 PM EDT
Looking for a formula to figure the impact on an average with additional inputs.

lets use individual input scores of 1 thru 5.
lets say that there  275 inputs are ready and the current average is 4.7

Is there a formula to easily calculate what impact an additional input of a value would have on the overall average?

Keeping in mind that each additional input value decreases the weighting of all current inputs.

additionally how can you determine the number of top score (5) inputs it would require to raise the overall average from the current 4.7 to 4.8 and to 4.9? Rounding is done at 2 decimal points.

thanks.
Link Posted: 1/18/2024 10:43:15 PM EDT
[Last Edit: intheburbs] [#1]
Link Posted: 1/18/2024 10:54:35 PM EDT
[#2]
Discussion ForumsJump to Quoted PostQuote History
Originally Posted By intheburbs:
It would take 135 more 5s to raise it to 4.8
X=additional 5s needed

4.8(275+x)=5x+275*4.7
1320+4.8x=5x+1293
27=.2x
135=x

Change it to 4.9 and x=550
View Quote
Amazing. Thank you.

if I may ask 1 question:

let say in the process of gathering the 135 additional 5 scores hoping to get to 4.8, a score of 1 was given. How far back would it alone set the process? How many more 5 score would it then take to recover from the low score and get to a 4.8 ?
to my unmathematical mind, because there is much more room between 4.7 and 1 than there is between 4.7 and 5, a low score would have a more significant impact on the average than a high score would. Is this a truth?
Link Posted: 1/18/2024 11:21:24 PM EDT
[#3]
Link Posted: 1/18/2024 11:38:27 PM EDT
[#4]
Discussion ForumsJump to Quoted PostQuote History
Originally Posted By intheburbs:


Yes, one bad score crushes it.  A single "1"  requires an additional 20 5s to offset it and raise to 4.8.

The starting equation would change to...

4.8(276+x)=5x+1294

And solving for x gives 155 now to raise to 4.8.

A single "1" would require 30 more 5s to raise to 4.9.
View Quote
That's what I thought.

As the number of input values increases, the impact (good or bad) decreases, correct? If you had 550 input scores, double the original number,  to begin with would it then require double the amount of 5 scores to move up to 4.8 and 4.9? 270 and 1100 respectively? There comes a point where it almost impossible in a practical sense to increase the average but still exists a comparatively easy way for the average to drop.
Close Join Our Mail List to Stay Up To Date! Win a FREE Membership!

Sign up for the ARFCOM weekly newsletter and be entered to win a free ARFCOM membership. One new winner* is announced every week!

You will receive an email every Friday morning featuring the latest chatter from the hottest topics, breaking news surrounding legislation, as well as exclusive deals only available to ARFCOM email subscribers.


By signing up you agree to our User Agreement. *Must have a registered ARFCOM account to win.
Top Top