How to Derive Answers Using N Formula

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

Discussion Overview

The discussion revolves around the derivation and application of a specific formula involving a variable denoted as "N" (Newtons) and a variable "T2." Participants seek clarity on how to implement the formula in an Excel spreadsheet, with some expressing confusion over the equation's components and the derivation process.

Discussion Character

  • Homework-related
  • Technical explanation
  • Debate/contested

Main Points Raised

  • One participant requests a step-by-step explanation of how to derive answers using the provided formula for use in Excel.
  • Another participant suggests considering the Newton-Raphson approximation as a potential solution method but notes that Excel will not solve it automatically.
  • A participant points out that there is no "N" in the given equation, questioning the relevance of "N" in the context of the formula.
  • Concerns are raised about the clarity of what the Excel formula is intended to compute, specifically regarding the equation $$\frac{7134611197}{T_2^2}-T_2$$ and its expected output for a given value of $T_2$.
  • It is noted that for $T_2=956$, the computed value is approximately 6850, which differs from another stated value of 6863.
  • There is a clarification that "N" refers to the units in which $T_2$ is measured, not a component of the equation itself.
  • One participant mentions that the original poster (OP) has also posted the question on another site, indicating a search for broader input.

Areas of Agreement / Disagreement

Participants express differing views on the presence and relevance of "N" in the equation, as well as the interpretation of the formula's intended computation. The discussion remains unresolved regarding the correct application and derivation of the formula.

Contextual Notes

There are limitations in the clarity of the equation's components and the assumptions regarding the intended calculations in Excel. The discussion also highlights potential discrepancies in computed values based on the provided formula.

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: 137
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
1K
  • · 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