What kind of trend, and relationship is this graph? [closed]
I need some help with labeling the trend of this graph, and also deciding what the relationship is between the two variables (X,Y).
Here is a picture of it:
The Excel document can be downloaded here:
http://tempsend.com/5079DC65F4
Using Excels trend-line option it seems to fit either a exponential or moving average trend-line, and also to me seems like it has a horizontal asymptote. Can anyone help me with this? I am also looking at figuring out the relationship between the two variables, seeing i'm only familiar with linear relationship i have no clue.
graphing-functions
asked Sep 9 '14 at 7:59
Hatmix5
528
closed as unclear what you're asking by Yves Daoust, KReiser, Alexander Gruber♦ Nov 30 at 3:07
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
|
show 17 more comments
I need some help with labeling the trend of this graph, and also deciding what the relationship is between the two variables (X,Y).
Here is a picture of it:
The Excel document can be downloaded here:
http://tempsend.com/5079DC65F4
Using Excels trend-line option it seems to fit either a exponential or moving average trend-line, and also to me seems like it has a horizontal asymptote. Can anyone help me with this? I am also looking at figuring out the relationship between the two variables, seeing i'm only familiar with linear relationship i have no clue.
graphing-functions
asked Sep 9 '14 at 7:59
Hatmix5
528
closed as unclear what you're asking by Yves Daoust, KReiser, Alexander Gruber♦ Nov 30 at 3:07
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
If you need any pictures of the trend-lines excel gives me or the graph equation, just tell me if it helps with answering the question. Thanks.
– Hatmix5
Sep 9 '14 at 8:00
1
This looks exponential, the vertical axis quantity roughly halves every increase of two units along the horizontal axis.
– Travis
Sep 9 '14 at 8:04
Note that a "moving average" isn't a type of function exactly, rather it just refers to a function $hat{f(t)}$ given by averaging another function $f(t)$ over some interval in $t$, sometimes with some kind of weighting.
– Travis
Sep 9 '14 at 8:05
Could you post the points ?
– Claude Leibovici
Sep 9 '14 at 8:05
Points have been added.
– Hatmix5
Sep 9 '14 at 8:08
|
show 17 more comments
I need some help with labeling the trend of this graph, and also deciding what the relationship is between the two variables (X,Y).
Here is a picture of it:
The Excel document can be downloaded here:
http://tempsend.com/5079DC65F4
Using Excels trend-line option it seems to fit either a exponential or moving average trend-line, and also to me seems like it has a horizontal asymptote. Can anyone help me with this? I am also looking at figuring out the relationship between the two variables, seeing i'm only familiar with linear relationship i have no clue.
graphing-functions
asked Sep 9 '14 at 7:59
Hatmix5
528
I need some help with labeling the trend of this graph, and also deciding what the relationship is between the two variables (X,Y).
Here is a picture of it:
The Excel document can be downloaded here:
http://tempsend.com/5079DC65F4
Using Excels trend-line option it seems to fit either a exponential or moving average trend-line, and also to me seems like it has a horizontal asymptote. Can anyone help me with this? I am also looking at figuring out the relationship between the two variables, seeing i'm only familiar with linear relationship i have no clue.
graphing-functions
graphing-functions
asked Sep 9 '14 at 7:59
Hatmix5
528
asked Sep 9 '14 at 7:59
Hatmix5
528
edited Sep 9 '14 at 9:59
asked Sep 9 '14 at 7:59
Hatmix5
528
asked Sep 9 '14 at 7:59
Hatmix5
528
asked Sep 9 '14 at 7:59
Hatmix5
528
528
closed as unclear what you're asking by Yves Daoust, KReiser, Alexander Gruber♦ Nov 30 at 3:07
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
closed as unclear what you're asking by Yves Daoust, KReiser, Alexander Gruber♦ Nov 30 at 3:07
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
If you need any pictures of the trend-lines excel gives me or the graph equation, just tell me if it helps with answering the question. Thanks.
– Hatmix5
Sep 9 '14 at 8:00
1
This looks exponential, the vertical axis quantity roughly halves every increase of two units along the horizontal axis.
– Travis
Sep 9 '14 at 8:04
Note that a "moving average" isn't a type of function exactly, rather it just refers to a function $hat{f(t)}$ given by averaging another function $f(t)$ over some interval in $t$, sometimes with some kind of weighting.
– Travis
Sep 9 '14 at 8:05
Could you post the points ?
– Claude Leibovici
Sep 9 '14 at 8:05
Points have been added.
– Hatmix5
Sep 9 '14 at 8:08
|
show 17 more comments
If you need any pictures of the trend-lines excel gives me or the graph equation, just tell me if it helps with answering the question. Thanks.
– Hatmix5
Sep 9 '14 at 8:00
1
This looks exponential, the vertical axis quantity roughly halves every increase of two units along the horizontal axis.
– Travis
Sep 9 '14 at 8:04
Note that a "moving average" isn't a type of function exactly, rather it just refers to a function $hat{f(t)}$ given by averaging another function $f(t)$ over some interval in $t$, sometimes with some kind of weighting.
– Travis
Sep 9 '14 at 8:05
Could you post the points ?
– Claude Leibovici
Sep 9 '14 at 8:05
Points have been added.
– Hatmix5
Sep 9 '14 at 8:08
If you need any pictures of the trend-lines excel gives me or the graph equation, just tell me if it helps with answering the question. Thanks.
– Hatmix5
Sep 9 '14 at 8:00
If you need any pictures of the trend-lines excel gives me or the graph equation, just tell me if it helps with answering the question. Thanks.
– Hatmix5
Sep 9 '14 at 8:00
1
1
This looks exponential, the vertical axis quantity roughly halves every increase of two units along the horizontal axis.
– Travis
Sep 9 '14 at 8:04
This looks exponential, the vertical axis quantity roughly halves every increase of two units along the horizontal axis.
– Travis
Sep 9 '14 at 8:04
Note that a "moving average" isn't a type of function exactly, rather it just refers to a function $hat{f(t)}$ given by averaging another function $f(t)$ over some interval in $t$, sometimes with some kind of weighting.
– Travis
Sep 9 '14 at 8:05
Note that a "moving average" isn't a type of function exactly, rather it just refers to a function $hat{f(t)}$ given by averaging another function $f(t)$ over some interval in $t$, sometimes with some kind of weighting.
– Travis
Sep 9 '14 at 8:05
Could you post the points ?
– Claude Leibovici
Sep 9 '14 at 8:05
Could you post the points ?
– Claude Leibovici
Sep 9 '14 at 8:05
Points have been added.
– Hatmix5
Sep 9 '14 at 8:08
Points have been added.
– Hatmix5
Sep 9 '14 at 8:08
|
show 17 more comments
1 Answer
1
active
oldest
votes
Desmos confirms the result that you and Claude reached; your set of data is almost perfectly modeled by the function $$y=1081.6x^2$$ I tried a few other kinds of fits (exponential, higher-order polynomial, etc.), and none worked as well as the above equation, so I think that one should work pretty well for you.
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Desmos confirms the result that you and Claude reached; your set of data is almost perfectly modeled by the function $$y=1081.6x^2$$ I tried a few other kinds of fits (exponential, higher-order polynomial, etc.), and none worked as well as the above equation, so I think that one should work pretty well for you.
add a comment |
Desmos confirms the result that you and Claude reached; your set of data is almost perfectly modeled by the function $$y=1081.6x^2$$ I tried a few other kinds of fits (exponential, higher-order polynomial, etc.), and none worked as well as the above equation, so I think that one should work pretty well for you.
add a comment |
Desmos confirms the result that you and Claude reached; your set of data is almost perfectly modeled by the function $$y=1081.6x^2$$ I tried a few other kinds of fits (exponential, higher-order polynomial, etc.), and none worked as well as the above equation, so I think that one should work pretty well for you.
Desmos confirms the result that you and Claude reached; your set of data is almost perfectly modeled by the function $$y=1081.6x^2$$ I tried a few other kinds of fits (exponential, higher-order polynomial, etc.), and none worked as well as the above equation, so I think that one should work pretty well for you.
answered Nov 29 at 21:00
community wiki
Robert Howard
add a comment |
add a comment |
If you need any pictures of the trend-lines excel gives me or the graph equation, just tell me if it helps with answering the question. Thanks.
– Hatmix5
Sep 9 '14 at 8:00
1
This looks exponential, the vertical axis quantity roughly halves every increase of two units along the horizontal axis.
– Travis
Sep 9 '14 at 8:04
Note that a "moving average" isn't a type of function exactly, rather it just refers to a function $hat{f(t)}$ given by averaging another function $f(t)$ over some interval in $t$, sometimes with some kind of weighting.
– Travis
Sep 9 '14 at 8:05
Could you post the points ?
– Claude Leibovici
Sep 9 '14 at 8:05
Points have been added.
– Hatmix5
Sep 9 '14 at 8:08