[ 3 / biz / cgl / ck / diy / fa / ic / jp / lit / sci / vr / vt ] [ index / top / reports ] [ become a patron ] [ status ]
2023-11: Warosu is now out of extended maintenance.

/sci/ - Science & Math

Search:


View post   

>> No.4700248 [View]
File: 133 KB, 892x686, excel.png [View same] [iqdb] [saucenao] [google]
4700248

d= 6.09725
it is not the mean (the mean is 6.097479)

>sum of absolute errors between the
diameters of all ball-bearings and d is minimized.
How to determine d?
I can do better, i can make it zero (or wrong in one part in a million).


check the attached picture. Using excel, list out the information. the question is equivalent to asking to find d where the sum of the errors is minimised.
for example: let a,b,c...f be the errors

|a+b+c|-|d+e+f| is the same as a+b+c-d-e-f if {a,b...f}>0

so in difference, put the number multiplied by d-X (where x is the diameter).

sum it up, and use solver. changing the d term to make the sum zer.

Navigation
View posts[+24][+48][+96]