ABSTRACT
This chapter discusses numerical integration, use of the logical IF function, histograms, normal error distributions, calculation of uncertainty propagation in experiments, multivariable linear and exponential regression analysis with LINEST and LOGEST worksheet functions, and provides the examples of regression methods. Numerical evaluation of integrals may be performed in Excel by using either the trapezoidal rule or Simpson's rule. The IF statement will place a value in the cell it occupies based on a true or false result of a logical test. Histograms are, very simply, a way of compartmentalizing various sets of data. A histogram for a digital camera provides a visual display that shows the distribution of light across the visual spectrum. Linear regression analysis with a single independent variable may be performed using a graphical display and the trendline and R2 features. Excel may be used to perform a least-squares regression calculation for a linear function with multiple independent variables.
