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

Thread starter marvolo1300
Start date Feb 27, 2012
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.

Feb 27, 2012

marvolo1300

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

Feb 27, 2012

gneill

Mentor

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

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

Thread 'I've come across another fluid pressure problem I don't understand'

Neglect gravity other than that of water; neglect friction. F1=ρgsh=1000*10*1*(1+4)=50000 N; F1=ρgsh=1000*10*0.1*4=4000 N; F3=50000-4000=46000 N?

View full post »

Thread 'Variable mass system : water sprayed into a moving container'

Starting with the mass considerations #m(t)# is mass of water #M_{c}# mass of container and #M(t)# mass of total system $$M(t) = M_{C} + m(t)$$ $$\Rightarrow \frac{dM(t)}{dt} = \frac{dm(t)}{dt}$$ $$P_i = Mv + u \, dm$$ $$P_f = (M + dm)(v + dv)$$ $$\Delta P = M \, dv + (v - u) \, dm$$ $$F = \frac{dP}{dt} = M \frac{dv}{dt} + (v - u) \frac{dm}{dt}$$ $$F = u \frac{dm}{dt} = \rho A u^2$$ from conservation of momentum , the cannon recoils with the same force which it applies. $$\quad \frac{dm}{dt}...

View full post »

Thread 'Understanding Forces and their Vector Components'

I was told forces are vectors so they can be divided into x and y components, but what about the normal force or the force of static friction? do you divide those into x and y components if say you had a block that was lying on an angled surface?

View full post »