Formula for Reverse Average

[melvinwaaa]

Hi, I tried the search bar for my question but all posts give more questions.
So basically is there a formula for when I need to have 4 rows of random numbers between 75 and 99 that results in a certain average number?
Thanks a lot!

Example:

Average	80
Score 1
Score 2
Score 3
Score 4

 

[footoo]

Can you use a VBA solution?

 

[hagia_sofia]

Hello, not sure how it will perform if it would be applied to generate a larger sample but here is a recursive LAMBDA to be tested (to be inserted within Name Manager and named REVERSE_AVERAGE):

=LAMBDA(n,a,l,u, LET( r, RANDARRAY(n,,l,u), s, r/SUM(r)*n*a, t, AND((s>=l)*(s<=u)), IF(t,s,REVERSE_AVERAGE(n,a,l,u))))

where based on your example n = 4, a = 80, l = 75, and u = 99.