How to Derive Answers Using N Formula

  • Context: MHB 
  • Thread starter Thread starter DYLAN4321
  • Start date Start date
  • Tags Tags
    Derive
Click For Summary
SUMMARY

The discussion focuses on deriving answers using a specific formula in Excel, particularly involving the variable T2 and its relation to Newtons (N). The Newton-Raphson approximation is highlighted as a potential solution method for solving the quadratic equation presented. Participants clarify that the formula $$\frac{7134611197}{T_2^2}-T_2$$ should yield a specific numerical result for given values of T2, emphasizing the importance of accurate input and understanding of the equation. Misunderstandings regarding the presence of "N" in the equation are addressed, confirming that it refers to units of measurement.

PREREQUISITES
  • Understanding of Excel formulas and functions
  • Familiarity with quadratic equations
  • Knowledge of the Newton-Raphson method for numerical approximation
  • Basic principles of unit measurement in physics (Newtons)
NEXT STEPS
  • Research how to implement the Newton-Raphson method in Excel
  • Learn about solving quadratic equations using Excel functions
  • Explore the significance of units in scientific calculations, specifically Newtons
  • Investigate common pitfalls in formula input and error checking in Excel
USEFUL FOR

This discussion is beneficial for Excel users, students in physics or engineering, and anyone involved in numerical analysis or solving equations using spreadsheet software.

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: 135
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
 
There is no "N" in the given equation so there can be no "N" in the answer! Have you left something out?
 
  • Like
Likes   Reactions: roam
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.
 
Evgeny.Makarov said:
Mentioned where? This is a quadratic equation in $T_2$.
The OP also posted this on another site. Sorry, I should have included the link to it.

-Dan
 

Similar threads

  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 7 ·
Replies
7
Views
3K
  • · Replies 5 ·
Replies
5
Views
3K
  • · Replies 8 ·
Replies
8
Views
954
  • · Replies 3 ·
Replies
3
Views
1K
  • · Replies 15 ·
Replies
15
Views
3K
  • · Replies 4 ·
Replies
4
Views
1K
  • · Replies 1 ·
Replies
1
Views
2K
Replies
3
Views
2K
  • · Replies 6 ·
Replies
6
Views
3K