# Can I find a formula for the data in one column, using the data in the other columns

## Recommended Posts

Hello,

I would like to find a formula for the lastparameter (Abaterea medie Ra)from my table, using data in the other column.

Nr. prob

Viteza de avans

[mm/min]

Viteza de rotaie

[mm/min]

Presiunea dielectricului

[bar]

Tensiunea firului

[N]

Intensitate

[A]

Cderea de tensiune

[V]

Abaterea medie Ra

[m]

1

2.386

195

10

17

4

48

0,08

2

1.034

180

10

17

17

23

2,90

3

2.670

150

0.3

20

4

63

1,16

4

3.504

210

10

20

20

16

0,70

5

3.024

135

0.5

25

1

71

0,33

6

0.625

300

5

30

21

80

0,27

So, I want to obtain a formula like this:Ra= x*Va+y*Vr+z*Pd+xxTf+xyI+xzU , but it is not impotantwhether it is addition or subtraction, multiplication or division.

Can someone help me please This is for my diploma project at university.

Va vitez de avans [mm/min]

Vr vitez de rotaie [mm/min]

Pd presiunea dielectricului [bar]

Tf tensiunea firului [N]

I intensitatea curentului electric [A]

U tensiunea curentului electric [V]

##### Share on other sites

Using a linear regression sould solve your problem