Issue with Average() function or is there something wrong with my math?
Trying to figure something out for work - calculating/simulating trending concentrations and dilutions for a solution. The leftmost column is the concentration of the solution in mg/uL, the next is the dilution factor (effectively 1/column A but is actually being calculated based on values not seen). The table towards the top of the page is just Min(), Average(), Max(), and Median() of column B. So far so good. At the bottom table is two columns - the bordered column is the values at the top calculated to the target unit (by calculating 1000/value), but the column next to it contains the functions listed above([column A]*1000)... which should be the same. But why are these values all the same except the Average? I even did the math by hand and the average of that column is indeed .285758, so the calculation its doing isn't wrong, but checking my math against the average at the top by doing 1000/value should get me back to 4.529, and it doesn't, I get 3.499. Even google AI says converting 4.53 uL/mg to mg/mL is 220.75. What am I doing wrong?
[link] [comments]
Want to read more?
Check out the full article on the original site