keyongtech


  keyongtech > excel.* > excel.worksheet.functions > 10/2003

 #1  
10-21-03, 03:39 AM
Steph
I need to know how in the world you are supposed to find
these two things. I have a table that I had to recreate
and then decide which or both of the two independent
variables are related to the dependent. I have the
formulas, but I don't know how to use these....please help!
 #2  
10-21-03, 01:27 PM
Bernard V Liengme
Read a stats book then look in Excel Help under LINEST, trendline and
Regression Analysis
Bernard

"Steph" <anonymous> wrote in message
news:280a
[..]
Similar Threads
Coefficients from trendline

Dear Excel Gurus, I am wondering if I can somehow pull the coefficients from the trendline equation and display them in cells separately, e.g if the equation is y =...

Trendline Coefficients

I have a function that reads the coefficients of a trendline by searching the datalabel.text It is by no means sophisticated, but it works well. It is designed only for...

Trendline Coefficients

Does anyone know if there are functions available in or for Excel that return the coefficents of logarithmic and polynomial trendlines, analogous to Slope(...) and...

VBA coefficients of an equation

I am trying to write a VBA code to figure out the coefficients of an equation. Y = A + B*X1 + C*X2 + D*X3 So if I have an equation of this form Y = 2 + 3*X1 + 4*X2 +...

Correlation Coefficients for 2nd & 3rd Order Curves

I am doing a comparison of COD results in mg/L vs. Absorbance readings. I have plotted the values for a linear curve and 2nd and 3rd order curves. I have been able to...


All times are GMT. The time now is 03:22 AM. | Privacy Policy