Rearranging Equations to y= mx + b

  • Thread starter Thread starter Ranjan1995
  • Start date Start date
Click For Summary
SUMMARY

The discussion focuses on rearranging the equation T=2π√(lcosα/g) to achieve a linear relationship suitable for graphing in Excel. The user attempts to eliminate the square root by squaring the period T, resulting in T² = 4π²cosα/g. However, confusion arises regarding the identification of independent (x) and dependent (T) variables, as well as the feasibility of fitting a linear equation to the derived equation. The consensus indicates that a linear fit may not be possible for the given equation without further adjustments.

PREREQUISITES
  • Understanding of basic trigonometry and cosine functions
  • Familiarity with the concept of linear relationships in graphing
  • Knowledge of Excel for data plotting and graphing
  • Ability to manipulate algebraic equations and variables
NEXT STEPS
  • Learn how to derive linear relationships from quadratic equations
  • Research methods for fitting linear models to non-linear data
  • Explore the use of Excel for creating scatter plots and trendlines
  • Study the implications of independent and dependent variables in physics equations
USEFUL FOR

Students in physics or mathematics, educators teaching algebraic manipulation, and anyone interested in data visualization using Excel.

Ranjan1995
Messages
6
Reaction score
0

Homework Statement


Graph the following charts on excel so you have a linear relationship.
Determine your x and y variables before graphing, you may have to rearrange and even recalculate some of the variables.

Angle Period (s)
0 0.95
10 0.94
20 0.97
30 1.00
40 1.03
50 1.09
60 1.14
NOTE: TEACHER SAID THAT SHE GAVE THE WRONG NUMBERS, THESE WONT WORK, JUST GIVING THEM INCASE ANYONE ASKS.

Homework Equations



T=2π√(lcosα/g)
Fixed l of 1.0 m
What is g?

The Attempt at a Solution



Firstly, I have to get rid of the square root

T^2 = 4π^2cosx/g
I removed the l since it is equal to 1 and is a constant

The problem is here already. What can I do to make it a linear function. The moment i squared the T it became a quadratic/ arc.

I KNOW it isn't much, but i am struggling for so long and can't seem to get anywhere. Sorry about that guys.
 
Last edited:
Physics news on Phys.org
Ranjan1995 said:

Homework Statement


Graph the following charts on excel so you have a linear relationship.
Determine your x and y variables before graphing, you may have to rearrange and even recalculate some of the variables.

Angle Period (s)
0 0.95
10 0.94
20 0.97
30 1.00
40 1.03
50 1.09
60 1.14
NOTE: TEACHER SAID THAT SHE GAVE THE WRONG NUMBERS, THESE WONT WORK, JUST GIVING THEM INCASE ANYONE ASKS.

Homework Equations



T=2π√(lcosα/g)
Fixed l of 1.0 m
What is g?



The Attempt at a Solution



Firstly, I have to get rid of the square root

T^2 = 4πcosx/g
I removed the l since it is equal to 1 and is a constant

The problem is here already. What can I do to make it a linear function. The moment i squared the T it became a quadratic/ arc.

I KNOW it isn't much, but i am struggling for so long and can't seem to get anywhere. Sorry about that guys.

In the beginning of your problem statement, you mention x and y. But then in the equation there is no "y". Is x the independent variable in the equation? If so, what is the dependent variable?
 
T is the dependent variable
 
So you mean x and T rather than x and y?
 
Yes, sorry.
 
Well I could be wrong, but I don't think you can fit a linear equation to the T = SQRT(cos(x)) equation that you are given. Are you maybe supposed to find the best linear fit across some small interval of x?
 

Similar threads

  • · Replies 15 ·
Replies
15
Views
5K
  • · Replies 3 ·
Replies
3
Views
2K
  • · Replies 16 ·
Replies
16
Views
4K
  • · Replies 2 ·
Replies
2
Views
6K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 1 ·
Replies
1
Views
11K
  • · Replies 5 ·
Replies
5
Views
2K
  • · Replies 5 ·
Replies
5
Views
11K
Replies
3
Views
22K