http://www.talkstats.com/ Linear regression, linear models, nonlinear regression en Wed, 22 May 2013 21:52:22 GMT vBulletin 60 http://www.talkstats.com/images/misc/rss.png http://www.talkstats.com/ http://www.talkstats.com/showthread.php/43798-Help-understanding-Microsoft-Excel-ANOVA-output-(Significance-F-)?goto=newpost Wed, 22 May 2013 13:29:40 GMT Hi, So I created my own very simple excel table, with a set of X and Y values, and then I told Excel to run a regression analysis. ... Hi,

So I created my own very simple excel table, with a set of X and Y values, and then I told Excel to run a regression analysis.

http://s22.postimg.org/41djtsab3/stats.png

I have been going through every piece of info provided by the Excel output table, attempting to understand what it all means and how each piece of info is calculated.

Sadly I am struggling to understand "Significance F".
I am really rusty with statistics and I believe I might need to look this up in a table... but I did google for "F distribution tables" and I cannot see any figures anywhere even close to 0.124027063 ...

Can someone please help me understand this?

Thanks a lot in advance. ]]> Regression Analysis spearchew http://www.talkstats.com/showthread.php/43798-Help-understanding-Microsoft-Excel-ANOVA-output-(Significance-F-) http://www.talkstats.com/showthread.php/43788-Asasociation-between-two-series-of-measurements?goto=newpost Wed, 22 May 2013 09:36:22 GMT I have series of (metric) lab variables measured in a group of patients, with once daily measurements over 20 days, and I would like to investigate... I have series of (metric) lab variables measured in a group of patients, with once daily measurements over 20 days, and I would like to investigate the association between the time courses of two of these variables. What is the preferred statistical procedure for analyzing such associations? ]]> Regression Analysis AVoelp http://www.talkstats.com/showthread.php/43788-Asasociation-between-two-series-of-measurements http://www.talkstats.com/showthread.php/43773-RMA-regression?goto=newpost Tue, 21 May 2013 20:18:33 GMT Hello!

I'm trying to fit regression as a modeling approach between predictor variables (radiation, temperature, relative humidity, etc.) and response variables (physiological parameters).
Since the predictor variables influence each other I cannot use a multiple regression due to collinarity. So, I had to use simple linear regression for each predictor variable. Since both types of variables are random (not controlled by me) I have to use a Model II regression, and specifically the reduced or range major axis (RMA) regression.
What about if I divide the the range of these predictor variable into three levels, i.e. high radiation or temperature, medium, and low with the respective values of the response variable. Should I still use RMA regression as the measurements are prone to error or since I have categorised them it can be considered as a "controlled" and use OLS regression instead?
Quick advice is highly appreciated!
Thank you in advance,
Endrit ]]> Regression Analysis ekullaj http://www.talkstats.com/showthread.php/43773-RMA-regression