Finding X and Y with respect to third variable if having two sets of X and Y

  • Context: Undergrad 
  • Thread starter Thread starter kunju
  • Start date Start date
  • Tags Tags
    Sets Variable
Click For Summary
SUMMARY

The discussion focuses on finding Y values at a new temperature of 9.6 degrees based on existing data for temperatures of 5 and 7 degrees. Users suggest using polynomial equations to model the relationship between temperature and Y values, emphasizing the need for curve fitting techniques. Specifically, they recommend deriving functions Y(T) and X(T) to establish a clearer relationship. Excel is identified as the tool for performing these polynomial calculations and curve fittings.

PREREQUISITES
  • Understanding of polynomial equations and curve fitting techniques
  • Proficiency in using Excel for data analysis and modeling
  • Knowledge of independent and dependent variables in mathematical modeling
  • Familiarity with temperature as a variable in scientific data analysis
NEXT STEPS
  • Learn how to perform polynomial regression in Excel
  • Explore curve fitting techniques for multivariable data analysis
  • Study the concept of independent and dependent variables in mathematical functions
  • Investigate the use of Excel's data analysis toolpak for statistical modeling
USEFUL FOR

Data analysts, scientists, and engineers who need to model relationships between variables and perform temperature-based data analysis using Excel.

kunju
Messages
1
Reaction score
0
My problem

At temperature 5 degrees the Y=1.00228594 for X=435 and Y=1.000986038 for X=449 and Y=0.999760292 for X=463

At temperature 7 degrees the Y=1.002094781 for X=435 and Y=1.00079709 for X=449 and Y=0.999573015 for X =463

For a new temperature of 9.6 degrees how to find the Y values for different X values

I find a polynomial eqn for the first set of X and Y values , then I find a polynomial eqn for the second set of X and Y values in excel. How can i find a polynomial for a different temp in excel

help me out

Thanks
 
Mathematics news on Phys.org
I am not sure I follow when you say you find a polynomial for the first set...

What's Y? What's X? Are they independent from each other? Is temperature the only independent variable?

I think all you need to do is find a curve fit for Y alone based on T, and then you find a curve fit for X based on T; then, you will have two curves, functions Y(T) and X(T).

So, just because you name Y Y and X X does not mean they should be your X,Y coordinates.

So, maybe you need to think of your Y as Y1 and your X as Y2 and your T as X and so you will have Y1(X) and Y2(X)

does this help?
 

Similar threads

Undergrad Finding multinomial coefficients by evaluation?
  • · Replies 13 ·
Replies
13
Views
2K
MHB Rearranging Formula, making x the subject from y=5(x+3)
  • · Replies 12 ·
Replies
12
Views
3K
Undergrad Gradient descent algorithm and optimizers
  • · Replies 5 ·
Replies
5
Views
2K
MHB Finding X & Y Components of Vectors
  • · Replies 1 ·
Replies
1
Views
2K
Graduate Can you use Taylor Series with mathematical objects other than points?
  • · Replies 4 ·
Replies
4
Views
2K
Undergrad Find f(z) given f(x, y) = u(x, y) + iv(x,y)
  • · Replies 8 ·
Replies
8
Views
1K
Undergrad Statistical modeling and relationship between random variables
  • · Replies 7 ·
Replies
7
Views
2K
Undergrad The covariance of a sum of two random variables X and Y
  • · Replies 10 ·
Replies
10
Views
3K
High School Ax+b=0 is one-variable linear equation
  • · Replies 8 ·
Replies
8
Views
3K
Undergrad Can Angular Velocity Accurately Control Ragdoll Limbs in Game Physics?
  • · Replies 6 ·
Replies
6
Views
4K