Two quick comments:
How does the student insert the uncertainty value of the ith point if each point is raw data and has no uncertainty?
The spreadsheet wont open and provides a warning notice. Thi k this has been mentioned in the past.
Have a good one.
Paul.
............
Paste
However, we're in luck, because it is ridiculously
easy to trick the linest() function into performing a
weighted fit. At the ith point, just multiply the
observed data Y(i) and each of the basis functions F(i)
by a factor of 1/σ(i). For details, see https://www.av8n.com/physics/linear-least-squares.htm#sec-weighting