Firstly I am far from an expert in data analysis or the understanding of quadratic equations, but I successfully use Linest for a single polynomial regression curve to generate the values to be used in an Excel VBA formula. Where I am completely stumped is whether this method can be used to...
I have some experimental data that needs polynomial regression, and would like to use the coding method described here. However, coding only changes the intercept, and the regression model does not fully describe the behaviour. Could I also use coding to apply to both the intercept and to ...
LINESTworks just as in the simple linear regression case, except that instead of using a 5 × 2 region for the output a 5 ×kregion is required wherek= the number of independent variables + 1. Thus for a model with 3 independent variables you need to highlight an empty 5 × 4 regio...
Describes how to perform power regression in Excel using Excel's regression data analysis tool after a log-log transformation.