Big Chemical Encyclopedia

Chemical substances, components, reactions, process design ...

Articles Figures Tables About

Linear regression using LINEST

We have encountered Excel s LINEST as a tool for linear regression. Unfortunately, LINEST cannot be generalised from vectors to matrices. To deal with matrices, we do not have an option but to use equations (4.59) and (4.61). It is possible to do so, but not as convenient as in Matlab. [Pg.146]

At this point, a considerable amount of theory on Hansch analysis has been presented with almost no examples of practice. The next three Case Studies will hopefully solidify ideas on Hansch analysis that have already been discussed. Each Case Study introduces a different idea. The first is an example of a very simple Hansch equation with a small data set. The second demonstrates the use of squared parameters in Hansch equations. The third and final Case Study shows how indicator variables are used in QSAR studies. If you are unfamiliar with performing linear regressions, be sure to read Appendix B on performing a regression analysis with the LINEST function in almost any common spreadsheet software. A section in the appendix describes in great detail how to derive Equations 12.20 through 12.22 in the first Case Study. [Pg.307]

Oxygen.xls illustrates the use of the LINEST function to perform multiple linear regression. [Pg.465]

Use of modem spreadsheets such as Excel facilitates the solution of problems of this type, preparation of appropriate plots of the data for visualization, and regression analyses to generate model parameters and the nncertainties associated therewith. The parameter (Cgo - iCpj )k was obtained using the linear trendline and Linest capabilities of Excel. [Pg.42]

A statistical function of considerable use for chemists is LINEST linear esfimation). It returns the least-squares regression parameters of the linear function that best describes a data set. LINEST is discussed in detail in Chapter 11. [Pg.73]

Compare the standard deviations using the forgoing procedure (cells L24 and M24 in Figure 12-9) with those obtained from LI NEST, which are shown in row 32 of Figure 12-10. Once again, it should be made clear that a linear problem was chosen to permit comparison between the standard deviations of the regression coefficients and those from LINEST,... [Pg.234]

The chart (Figure 22-5) is used only to verify that the transformed data fit a linear relationship. LINEST was used to obtain the constants from the slope and intercept of the regression line. [Pg.356]

A regression analysis was carried out using the plotting wizard and the Linest function associated with an Excel spreadsheet (see Figure 13.2). The linearity of the plot indicates that the data are consistent with the assumed rate expression and that... [Pg.42]


See other pages where Linear regression using LINEST is mentioned: [Pg.209]    [Pg.209]    [Pg.499]    [Pg.209]    [Pg.209]    [Pg.499]    [Pg.303]    [Pg.149]    [Pg.51]   
See also in sourсe #XX -- [ Pg.209 ]




SEARCH



Linear regression

Regression Using LINEST

© 2024 chempedia.info