Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Find a formula that take three input and it gives a result as a percentage as the following: Input activeUnits=1 Sequence= XXXXXXXXXX% totallUnits=500 activeUnits=3 Sequence= 100 89% totallUnits=500...

2 answer below »
Find a formula that take three input and it gives a result as a percentage as the following:
Input
activeUnits=1
Sequence= XXXXXXXXXX%
totallUnits=500
activeUnits=3
Sequence= 100 89%
totallUnits=500
In another explanation, I want a formula that find the values in this table with ±5 e
or rate
In this table sequence variable is always 100
Active units 500U 1000U 2000U 4000U 8000U 16000U 32000U 64000U
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX100 100
XXXXXXXXXX 99 100
XXXXXXXXXX 98 100
XXXXXXXXXX 97 100
XXXXXXXXXX 94 99
And the same formula if we change the sequence variable it can calculate the following table
Here always activeUnits is 2
Sequence size 100U 500U 1000U 2000U 4000U 8000U 16000U 32000U 64000U
XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX91 0.96
Results note: When the variable activeUnits, the result is 100%
Results
When activeUnits increase, the accuracy decrease. And
when totallUnits variable increase the accuracy increase
see the table below.
When activeUnits> 1 the results not necessary should to
e same like here 89% it can be ±5 and if it exactly same
would be bette
totallUnits
totallUnits
XXXXXXXXXX XXXXXXXXXX84 0.92
Answered Same Day Aug 27, 2021

Solution

Yogesh answered on Aug 30 2021
148 Votes
Formula for the second table where the value of active unit is always 2 can be given as -
• [ Total units ÷ (Active units × Sequence)] + 0.11 = Result
This formula gives almost all the solutions of the values as Table 2 but not for all, i think there may be e
ors in the table.
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here