How to Derive Answers Using N Formula

  • Context:
  • Thread starter Thread starter DYLAN4321
  • Start date Start date
  • Tags Tags
    Derive
Join the discussion
Registration is free. Ask a follow-up in this thread, or start your own.
4 replies · 2K views
DYLAN4321
Messages
4
Reaction score
0
Hi,

I have been given the attachment formula and asked to enter this into an excel spreadsheet. Although I am not entirely sure how the answer was derived. Is anyone able to explain step by step as I want to try and enter this into an excel spreadsheet. For reference N = Newtons
 

Attachments

  • equation.png
    equation.png
    5.7 KB · Views: 159
Mathematics news on Phys.org
DYLAN4321 said:
Hi,

I have been given the attachment formula and asked to enter this into an excel spreadsheet. Although I am not entirely sure how the answer was derived. Is anyone able to explain step by step as I want to try and enter this into an excel spreadsheet. For reference N = Newtons
I believe you were suggested to look up a solution method, the Newton-Raphson approximation being one method mentioned. Do you have a solution method you would like to use? Excel will not simply solve it for you.

-Dan
 
DYLAN4321 said:
I have been given the attachment formula and asked to enter this into an excel spreadsheet.
It is not clear what your Excel formula is supposed to compute: $$\frac{7134611197}{T_2^2}-T_2$$ for the given value of $T_2$, the value of $T_2$ for the given left-hand side of this equation or something else. Also, for $T_2=956$ we have $$\frac{7134611197}{T_2^2}-T_2\approx6850$$ and not $6863$.

topsquark said:
I believe you were suggested to look up a solution method, the Newton-Raphson approximation being one method mentioned.
Mentioned where? This is a quadratic equation in $T_2$.

HallsofIvy said:
There is no "N" in the given equation
N is the units in which $T_2$ is measured.