This text provides a straightforward guide to using these functions of Microsoft Excel, guiding the reader from basic principles through to more complicated areas such as formulae, charts, curve-fitting, equation solving, integration, ...

... line of best fit in the least-squares model. For a simple problem like this we have the choice of using the CurveFit or the Statistics package. [LinearRegr1.mw] This worksheet ... worksheet vectors are used to hold the data, but one may use ...

... simultaneous OEDs by simple substitution. For example, to solve y′′ = ay′ + by + c, we make the substitution y′ = u. The introduction of the auxiliary variable u allows us to write the second-order equations as two simultaneous equations ...

... substitution that gives a pair of simultaneous first-order ODEs. For example, to solve y' =y' + y = sin(x) subject to y(0) = 0 and y(0) = 0, one can make the substitution y' = u, to get a pair of equations y' = u with initial value y(0) ...

... calculation, places the result on a worksheet. For the demonstration it is ... Worksheets(“MolSpeed”).Activate Range(“B4:D4”).ClearContents Range(“B7:D7”).ClearContents Gas = InputBox(prompt:=“Give ... mole)”) Range(“C4”). A simple subroutine.

... VLOOKUP In this exercise we use the VLOOKUP function . The scenario is : you ... TOTAL 12450 940 5000 500 Figure 5.7 ( a ) In Sheet4 of CHAP5.XLS enter the ... SUM formulas in E7 and F7 . Save the workbook . Now we will make the bonus ...

... 1-627-05419-5ch10 10-1 © Morgan & Claypool Publishers 2014 Figure 10.1. Coulomb's law experiment setup. 10.2 Electrostatic potential (Worksheet: IOP. Concise. Physics. bk978-1-627-05419-5ch10 Chapter 10 Electrostatics 10.1 Coulomb's law.