MHB Calculate Data Points to Match Given Totals

  • Thread starter Thread starter micromichele
  • Start date Start date
  • Tags Tags
    Data Match Points
micromichele
Messages
2
Reaction score
0
Hello! I have a super tricky problem for everyone I truly hope there is an answer to this.

I have different data sets all of which are a different amount of number per set (total points per set)
Each number is multiplied by 4.86 then rounded down. Then the total is added

Alternatively the sum of the data points is multiplied by 4.86 then rounded down.

Just to add another note in case it was confusing so first set
189 needs to be 184
second set
2906 needs to be 2903
third
1219 needs to be 1215
fourth
102 needs to be 101

I need these two numbers to match and I can not figure out how I have attached a photo to help with this.
math problem.png
 
Mathematics news on Phys.org
Let's denote the result of rounding down $x$ by $\lfloor x\rfloor$. This operation and addition do not commute, which means that in general $\lfloor x_1+x_2\rfloor\ne\lfloor x_1\rfloor+\lfloor x_2\rfloor$. One can only guarantee that $\lfloor x_1+x_2\rfloor\ge\lfloor x_1\rfloor+\lfloor x_2\rfloor$. The same holds for more than two numbers. Here $x_i$ denote the numbers from you datasets multiplied by 4.86. Therefore your mismatches are expected (provided the computations are correct), and you cannot make the results to coincide any more than you can make 2 + 2 equal 5.
 
A possible solution is to not round down.
It is good practice to never round intermediate results. And final results are usually rounded to appropriate precision only for display.
In Excel you can format fields to show data with a desired precision while the calculations still work with unrounded numbers.
 
Thank you for you replies and help :)
 
Insights auto threads is broken atm, so I'm manually creating these for new Insight articles. In Dirac’s Principles of Quantum Mechanics published in 1930 he introduced a “convenient notation” he referred to as a “delta function” which he treated as a continuum analog to the discrete Kronecker delta. The Kronecker delta is simply the indexed components of the identity operator in matrix algebra Source: https://www.physicsforums.com/insights/what-exactly-is-diracs-delta-function/ by...
Fermat's Last Theorem has long been one of the most famous mathematical problems, and is now one of the most famous theorems. It simply states that the equation $$ a^n+b^n=c^n $$ has no solutions with positive integers if ##n>2.## It was named after Pierre de Fermat (1607-1665). The problem itself stems from the book Arithmetica by Diophantus of Alexandria. It gained popularity because Fermat noted in his copy "Cubum autem in duos cubos, aut quadratoquadratum in duos quadratoquadratos, et...
I'm interested to know whether the equation $$1 = 2 - \frac{1}{2 - \frac{1}{2 - \cdots}}$$ is true or not. It can be shown easily that if the continued fraction converges, it cannot converge to anything else than 1. It seems that if the continued fraction converges, the convergence is very slow. The apparent slowness of the convergence makes it difficult to estimate the presence of true convergence numerically. At the moment I don't know whether this converges or not.
Back
Top