Mathematics desk | ||
---|---|---|
< October 8 | << Sep | October | Nov >> | Current desk > |
Welcome to the Wikipedia Mathematics Reference Desk Archives |
---|
The page you are currently viewing is a transcluded archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages. |
I am trying to resolve an (apparent) discrepancy. Any help is appreciated. Thanks in advance.
Here is a website: [1].
About half-way down that page, there is a (somewhat) complicated formula:
Volume (L,R,h) = L[R^2cos^(-1)((R-h)/R)-(R-h)sqrt(2Rh-h^2)]
In that formula, we can replace the variable "L" (Length) with the known value of 192.
In that formula, we can also replace the variable "R" (Radius) with the known value of 48.
Now, we move on to a completely different website: [2].
In this second website, someone has converted the above mathematical formula into an Excel formula.
The variable "h" (Height) is replaced with the Excel Cell Number labeled K2.
Towards the very bottom of the page, on the second website, the proposed "Excel" translation formula for the above mathematical formula is given as:
Volume = 192*(48^2*ACOS((48-K2)/48)-(48-K2)*PIERWIASTEK(2*48*K2-K2^2))/231.
That person states to replace the gibberish phrase of "PIERWIASTEK" with whatever the correct Excel formula is for Square Root (which is "SQRT").
In summary:
To me, everything seems to "line up" pretty much perfectly.
I just can't seem to figure out why the Excel formula has that "extra" calculation added in at the very end ... namely, to divide by 231.
As all of the elements between both formulas seem (to me) to line up and match, pretty exactly ... why is the person throwing in that extra "divide by 231" at the end?
Thanks! 32.209.55.38 ( talk) 05:30, 9 October 2022 (UTC)
Mathematics desk | ||
---|---|---|
< October 8 | << Sep | October | Nov >> | Current desk > |
Welcome to the Wikipedia Mathematics Reference Desk Archives |
---|
The page you are currently viewing is a transcluded archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages. |
I am trying to resolve an (apparent) discrepancy. Any help is appreciated. Thanks in advance.
Here is a website: [1].
About half-way down that page, there is a (somewhat) complicated formula:
Volume (L,R,h) = L[R^2cos^(-1)((R-h)/R)-(R-h)sqrt(2Rh-h^2)]
In that formula, we can replace the variable "L" (Length) with the known value of 192.
In that formula, we can also replace the variable "R" (Radius) with the known value of 48.
Now, we move on to a completely different website: [2].
In this second website, someone has converted the above mathematical formula into an Excel formula.
The variable "h" (Height) is replaced with the Excel Cell Number labeled K2.
Towards the very bottom of the page, on the second website, the proposed "Excel" translation formula for the above mathematical formula is given as:
Volume = 192*(48^2*ACOS((48-K2)/48)-(48-K2)*PIERWIASTEK(2*48*K2-K2^2))/231.
That person states to replace the gibberish phrase of "PIERWIASTEK" with whatever the correct Excel formula is for Square Root (which is "SQRT").
In summary:
To me, everything seems to "line up" pretty much perfectly.
I just can't seem to figure out why the Excel formula has that "extra" calculation added in at the very end ... namely, to divide by 231.
As all of the elements between both formulas seem (to me) to line up and match, pretty exactly ... why is the person throwing in that extra "divide by 231" at the end?
Thanks! 32.209.55.38 ( talk) 05:30, 9 October 2022 (UTC)