Question: C. Using MS Excel for Least-Squares Fitting Exercise #5: Fitting a line to a data set using the LINEST function 1. Attach the plot that

C. Using MS Excel for Least-Squares Fitting Exercise #5: Fitting a line to a data set using the LINEST function 1. Attach the plot that you constructed in this section (screen shot is best to preserve formatting of the GRAPHICAL PLOT only - keep all tabular values in your MS Excel file attachment). Make sure to put the correct axis labels (with units) on the plot, and make sure that your axis labels and numbers are large enough to be read when grading. (20 pts total = 10 pts data set, 10 points plot) 2. What is the equation of your fitted line (include uncertainties in the slope and intercept). Also, what is the R2 value of your model fit? ( 10 pts)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock