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
AI Thread Summary
To create a line of worst fit in Excel, users are advised to consider plotting error bars for their data points. This involves analyzing uncertainties and potentially creating a separate row for them. The discussion highlights the need for clarity on how to visually represent data uncertainties. Additionally, a web search on "plotting error bars in Excel" is suggested for further guidance. Understanding these concepts can enhance data visualization in Excel.
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?
 
Physics news on Phys.org
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".
 
Thread 'Collision of a bullet on a rod-string system: query'

Thread 'Collision of a bullet on a rod-string system: query'

In this question, I have a question. I am NOT trying to solve it, but it is just a conceptual question. Consider the point on the rod, which connects the string and the rod. My question: just before and after the collision, is ANGULAR momentum CONSERVED about this point? Lets call the point which connects the string and rod as P. Why am I asking this? : it is clear from the scenario that the point of concern, which connects the string and the rod, moves in a circular path due to the string...
View full post »
Thread 'A cylinder connected to a hanging mass'

Thread 'A cylinder connected to a hanging mass'

Let's declare that for the cylinder, mass = M = 10 kg Radius = R = 4 m For the wall and the floor, Friction coeff = ##\mu## = 0.5 For the hanging mass, mass = m = 11 kg First, we divide the force according to their respective plane (x and y thing, correct me if I'm wrong) and according to which, cylinder or the hanging mass, they're working on. Force on the hanging mass $$mg - T = ma$$ Force(Cylinder) on y $$N_f + f_w - Mg = 0$$ Force(Cylinder) on x $$T + f_f - N_w = Ma$$ There's also...
View full post »

Similar threads

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

Hot Threads

Recent Insights

Back
Top