How to Solve System of Equations

  • Thread starter Thread starter RichC
  • Start date Start date
R

RichC

I have a series of data that I need to develop a linear relationshi
for.

A1*X+B1*Y=C1
A2*X+B2*Y=C2
A3*X+B3*Y=C3
....
....
....
AN*X+B3*Y=CN

AN, BN and CN are all known. However, there does not exist an exac
solution for X and Y (this is from statistical data).

I'm just looking for an approximation for X and Y. The data is ver
rough, and a linear relationship probably isn't the best fit (r-square
values of 0.226). However, I need to figure out a way to force a fi
in there, regardless of how mess it is
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

solving of linear equation 5
How to separate x y data in 1 column to 2 colums of x and y data? 6
Moving rows to columns 5
Excel Excel 2003 Trend Equation Error 1
How to use solver to solve for 2 unknown in a linear equation? 9
Trendline Function Extraction 6
Equation of a straight line on excel 1
How to fit an equation 1

Back
Top