Why trending line of scatter plot doesn't match given equation?
up vote
1
down vote
favorite
I have some sample data, I draw a trending line which gives me equation as well. But I found that the trending line sometimes isn't trustworthy at all.
The trending line graph doesn't match the equation!
I think that's unacceptable and totally out of my expectation. Why is it?
Sample data:
count(x) runtime(y)
1000 0.1
2000 0.8
4000 6.4
8000 51.1
How to reproduce it: Draw a scatter plot, add a trending line, choose Exponential. Then try to calculate by the given equation, when x
= 4000
, 7000
, 8000
. And you can see y
doesn't match the graph at all.
fileLink: https://anonfile.com/A4m0F7lbb3/sheet1_-_copy_xlsx
Screenshot:
microsoft-excel
add a comment |
up vote
1
down vote
favorite
I have some sample data, I draw a trending line which gives me equation as well. But I found that the trending line sometimes isn't trustworthy at all.
The trending line graph doesn't match the equation!
I think that's unacceptable and totally out of my expectation. Why is it?
Sample data:
count(x) runtime(y)
1000 0.1
2000 0.8
4000 6.4
8000 51.1
How to reproduce it: Draw a scatter plot, add a trending line, choose Exponential. Then try to calculate by the given equation, when x
= 4000
, 7000
, 8000
. And you can see y
doesn't match the graph at all.
fileLink: https://anonfile.com/A4m0F7lbb3/sheet1_-_copy_xlsx
Screenshot:
microsoft-excel
@cybernetic.nomad Got same result, my friend. They're the same equation I think.
– Rick
Nov 21 at 16:16
You are correct. I can't explain it either
– cybernetic.nomad
Nov 21 at 16:31
add a comment |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
I have some sample data, I draw a trending line which gives me equation as well. But I found that the trending line sometimes isn't trustworthy at all.
The trending line graph doesn't match the equation!
I think that's unacceptable and totally out of my expectation. Why is it?
Sample data:
count(x) runtime(y)
1000 0.1
2000 0.8
4000 6.4
8000 51.1
How to reproduce it: Draw a scatter plot, add a trending line, choose Exponential. Then try to calculate by the given equation, when x
= 4000
, 7000
, 8000
. And you can see y
doesn't match the graph at all.
fileLink: https://anonfile.com/A4m0F7lbb3/sheet1_-_copy_xlsx
Screenshot:
microsoft-excel
I have some sample data, I draw a trending line which gives me equation as well. But I found that the trending line sometimes isn't trustworthy at all.
The trending line graph doesn't match the equation!
I think that's unacceptable and totally out of my expectation. Why is it?
Sample data:
count(x) runtime(y)
1000 0.1
2000 0.8
4000 6.4
8000 51.1
How to reproduce it: Draw a scatter plot, add a trending line, choose Exponential. Then try to calculate by the given equation, when x
= 4000
, 7000
, 8000
. And you can see y
doesn't match the graph at all.
fileLink: https://anonfile.com/A4m0F7lbb3/sheet1_-_copy_xlsx
Screenshot:
microsoft-excel
microsoft-excel
edited Nov 21 at 15:57
asked Nov 21 at 15:51
Rick
1085
1085
@cybernetic.nomad Got same result, my friend. They're the same equation I think.
– Rick
Nov 21 at 16:16
You are correct. I can't explain it either
– cybernetic.nomad
Nov 21 at 16:31
add a comment |
@cybernetic.nomad Got same result, my friend. They're the same equation I think.
– Rick
Nov 21 at 16:16
You are correct. I can't explain it either
– cybernetic.nomad
Nov 21 at 16:31
@cybernetic.nomad Got same result, my friend. They're the same equation I think.
– Rick
Nov 21 at 16:16
@cybernetic.nomad Got same result, my friend. They're the same equation I think.
– Rick
Nov 21 at 16:16
You are correct. I can't explain it either
– cybernetic.nomad
Nov 21 at 16:31
You are correct. I can't explain it either
– cybernetic.nomad
Nov 21 at 16:31
add a comment |
1 Answer
1
active
oldest
votes
up vote
1
down vote
accepted
Found it:
The problem is the equation has some rounding in it. If you right-click on it and select Format trendline label
:
You can add decimal places:
and get a more precise result:
You are a genius!
– Rick
Nov 22 at 1:22
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
1
down vote
accepted
Found it:
The problem is the equation has some rounding in it. If you right-click on it and select Format trendline label
:
You can add decimal places:
and get a more precise result:
You are a genius!
– Rick
Nov 22 at 1:22
add a comment |
up vote
1
down vote
accepted
Found it:
The problem is the equation has some rounding in it. If you right-click on it and select Format trendline label
:
You can add decimal places:
and get a more precise result:
You are a genius!
– Rick
Nov 22 at 1:22
add a comment |
up vote
1
down vote
accepted
up vote
1
down vote
accepted
Found it:
The problem is the equation has some rounding in it. If you right-click on it and select Format trendline label
:
You can add decimal places:
and get a more precise result:
Found it:
The problem is the equation has some rounding in it. If you right-click on it and select Format trendline label
:
You can add decimal places:
and get a more precise result:
answered Nov 21 at 16:58
cybernetic.nomad
1,134111
1,134111
You are a genius!
– Rick
Nov 22 at 1:22
add a comment |
You are a genius!
– Rick
Nov 22 at 1:22
You are a genius!
– Rick
Nov 22 at 1:22
You are a genius!
– Rick
Nov 22 at 1:22
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1377329%2fwhy-trending-line-of-scatter-plot-doesnt-match-given-equation%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
@cybernetic.nomad Got same result, my friend. They're the same equation I think.
– Rick
Nov 21 at 16:16
You are correct. I can't explain it either
– cybernetic.nomad
Nov 21 at 16:31