How Do You Create a Line of Worst Fit in Excel?

  • Thread starter Thread starter marvolo1300
  • Start date Start date
  • Tags Tags
    Excel Fit Line
marvolo1300
Messages
15
Reaction score
0
How would I go about creating a line of worst fit in excel? Would I create a different row for the uncertainties?
 
marvolo1300 said:
How would I go about creating a line of worst fit in excel? Would I create a different row for the uncertainties?

Line of worst fit :confused:

Perhaps you are looking to plot error bars for your data points? Do a web search on "plotting error bars in excel".
 

Similar threads

Least Square Method to fit a line to a set of datapoints
  • · Replies 11 ·
Replies
11
Views
1K
Finding Absolute Zero Values from Best Fit Lines with & w/o Uncertainty
  • · Replies 2 ·
Replies
2
Views
2K
How to Combine Gradient Uncertainty with other Uncertainty?
  • · Replies 3 ·
Replies
3
Views
2K
Should Excel macros self-adjust when you delete lines above the affected cells?
  • · Replies 27 ·
Replies
27
Views
5K
Error in Y-intercept, Least-square+Excel=True?
  • · Replies 2 ·
Replies
2
Views
2K
Uncertainty in the intersection of two lines with error bars
  • · Replies 16 ·
Replies
16
Views
6K
Curving of gravitational field lines
  • · Replies 9 ·
Replies
9
Views
2K
How do I find the uncertainty in this specific scenario?
  • · Replies 1 ·
Replies
1
Views
1K
Basic doubts about measurements and fitting
  • · Replies 7 ·
Replies
7
Views
2K
Undergrad What Are the Advantages of Linearizing Cubic Data for Analysis?
  • · Replies 11 ·
Replies
11
Views
3K