Least Squares Fit (Computer Spread Sheet)

Objective

The purpose of this activity is to familiarize yourself with the built-in functions in Excel. You will learn how to calculate a large amount of data and how the least squares fit works mathematically.

Least Squares Fit (Computer Spread Sheet) by Hiro's physics

Preparation & Warning

  • Please bring an external drive to save your data.
  • Print out this handout for understanding the math of least fits.

    • Mathematics for Least Squares Fit




    Go back to the Hiro's Physics Main