18 - Excel Functions#

This lecture treats determining relationships between variables using Excel. We will cover the following topics:

  • Trendlines

  • Example applications with Bacteria, Kinetics, and Vapor Pressure

  • Minimizing the sum of squared errors

  • Calculating the correlation coefficient, R^2

  • Calculating the MAPE value (percent error)

  • Calculating the 95% confidence on a regression with example sheet on tipice.byu.edu

See the Excel file (excelfunctions.xlsx) in Canvas.