Big Chemical Encyclopedia

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

Articles Figures Tables About

Inverses in Excel

The spreadsheet in Figure 4-62 is heavily matrix based (see Chapter 2, for an introduction to basic matrix functions in Excel). It is the only way to keep the structure reasonably simple. The matrix C in cells A21 C31 is computed in the usual way, see equation (4.63) the parameters required to compute the concentration matrix are in cells Q4 S4, they include the initial concentration for species A and the two rate constants that are to be fitted. In cells E 16 018 the computation of the best absorptivity matrix A for any given concentration matrix C, is done as a matrix equation, as demonstrated in The Pseudo-Inverse in Excel (p.146). Similarly the matrix Ycaic in cells E21 031 is written as the matrix product CA. Even the calculation of the square sum of the residuals in cell R7 is written in a compact way, using the Excel function SUMXMY2, especially designed for this purpose. We refer to... [Pg.210]


See other pages where Inverses in Excel is mentioned: [Pg.25]    [Pg.146]   
See also in sourсe #XX -- [ Pg.431 , Pg.432 ]




SEARCH



Excel

Excellence

The Pseudo-Inverse in Excel

© 2024 chempedia.info