Subscribe
Notify of
8 Answers
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
eterneladam
9 months ago

Pack the data into a spreadsheet (Excel, LibreCalc), draw an XY chart, highlight the points, insert a trend line and let show their equation.

Also goes directly with the functions SLIDE and AXIS SECTION without diagram.

Halbrecht
9 months ago

These formulas you need

I did this with the data of the task and the link from the answer above

Other values

because a data pair (0/0) is added to it by the software. How to get that away or what I do wrong: no idea

I can only warn in advance of the software.

(For AmA)

AusMeinemAlltag
9 months ago

Yeah.

https://de.planetcalc.com/5992/

y = 0.07511200972654176466 * x + 3.88721107536054688580

With an average relative error of 16.72%.

The topic is "linear regression".

This should be good enough to understand:

https://www.youtube.com/watch?v=zsEn-oqSVhY

Halbrecht
9 months ago

I have fed the software you have posted with the data of the question here

other numbers, BEIL nonsensical a data pair (0/0) is added

Do you have any idea how to get that away? see my answer the lower picture

AusMeinemAlltag
9 months ago
Reply to  Halbrecht

Strange, it wasn't my case. And can't go out by hand?

Did you deactivate all the selections except for linear regression?

AusMeinemAlltag
9 months ago

Okay, very bad that the website sometimes seems buggy.

Halbrecht
9 months ago

today it works, , , , , no (0/0)

only difference : have completed the data line at x with Enter

but also without enter, today

ergo: Page further usable but you should use the plot to control

Halbrecht
9 months ago

Yes, I tried

by the way: I only let your data go through with Reg there is that as Fkt 0.6233x + 129.5721

but also with all the selected I get that.