Issues with linear regression and more

Question

Level 1

8 points

Issues with linear regression and more

I am using Numbers for an assignment and I am having trouble getting it to do what I need and can't find documentation on these issues/features.

Question #1

Why is this graph not having the correct linear regression that I would expect given the data I have provide

Question #2

I know it is possible to create the line of best fit (Kind of like above) but is it possible to find the worst fit line given the error bars.

Question #3

Kind of with the last question I know you can have vertical error bars but can you have horizontal error bars as well.

MacBook Pro TouchBar and Touch ID, macOS Mojave (10.14)

Posted on Oct 5, 2018 9:01 PM

Reply

Answer 1

Oct 6, 2018 7:53 AM in response to nfusselman1

1) Please show your data otherwise it is not possible to reproduce your situation (post the actual data by selecting your data, copy, then paste directly here)

2) you can show error bars in both the x and y axis when you plot using an "x-y scatter" chart (the bottom right chart in the following image

Reply

Answer 2

nfusselman1 Author

Level 1

8 points

Oct 6, 2018 7:54 AM in response to Wayne Contello

Perfect I was able to change it to a scatter plot and it fixed the linear regressing issue.

The only problem is Question #2, Just need to make a worst fit line.

Reply

Answer 3

Yellowbox

Level 7

21,939 points

Oct 6, 2018 8:37 AM in response to nfusselman1

Hi nfusselman1

The only problem is Question #2, Just need to make a worst fit line.

Do you want to show a 95% confidence envelope? 99% confidence envelope?

Please show your data. Hide all personal or sensitive information.

Regards,

Ian.

Reply