Comparison between two itemsRelationship between VC dimension and degrees of freedomResearch in high-dimensional statistics vs. machine learning?How do I find the correct decay rate when the data are not helping?What is the difference between statistical learning and predictive analytics?statistical significance test between binary label featuresHow to find relation between N components and predict the value of any one component using the predicted relation?Calculate Q parameter for Deep Q-Learning applied to videogamesClassifying Car Data By YearComparative Analysis of two sets of dataWhat's the difference between ELM and NNAR?
Apparently, my CLR assembly function is causing deadlocks?
Why does nature favour the Laplacian?
How do I reattach a shelf to the wall when it ripped out of the wall?
Re-entry to Germany after vacation using blue card
What does the integral of a function times a function of a random variable represent, conceptually?
What is the most expensive material in the world that could be used to create Pun-Pun's lute?
Why must Chinese maps be obfuscated?
How to pronounce 'c++' in Spanish
Can't get 5V 3A DC constant
Two field separators (colon and space) in awk
What causes platform events to fail to be published and should I cater for failed platform event creations?
On The Origin of Dissonant Chords
a sore throat vs a strep throat vs strep throat
Why didn't the Space Shuttle bounce back into space as many times as possible so as to lose a lot of kinetic energy up there?
"The cow" OR "a cow" OR "cows" in this context
Was there a Viking Exchange as well as a Columbian one?
Do I have an "anti-research" personality?
Could the terminal length of components like resistors be reduced?
Retract an already submitted recommendation letter (written for an undergrad student)
How to have a sharp product image?
Mistake in years of experience in resume?
Why was the Spitfire's elliptical wing almost uncopied by other aircraft of World War 2?
If a planet has 3 moons, is it possible to have triple Full/New Moons at once?
How do I deal with a coworker that keeps asking to make small superficial changes to a report, and it is seriously triggering my anxiety?
Comparison between two items
Relationship between VC dimension and degrees of freedomResearch in high-dimensional statistics vs. machine learning?How do I find the correct decay rate when the data are not helping?What is the difference between statistical learning and predictive analytics?statistical significance test between binary label featuresHow to find relation between N components and predict the value of any one component using the predicted relation?Calculate Q parameter for Deep Q-Learning applied to videogamesClassifying Car Data By YearComparative Analysis of two sets of dataWhat's the difference between ELM and NNAR?
$begingroup$
I have table like:
Sales
2010 2011 2012 2013
State X Y X Y X Y X Y
1
2
3
4
5
6
7
Which statistical and/or machine learning approach can be used to compute the relation between sales of X and Y.
machine-learning data-mining statistics
edited Apr 10 at 10:16
Harikrishnamv
31
asked Apr 10 at 9:36
Darpan DahalDarpan Dahal
11
$endgroup$
add a comment |
$begingroup$
I have table like:
Sales
2010 2011 2012 2013
State X Y X Y X Y X Y
1
2
3
4
5
6
7
Which statistical and/or machine learning approach can be used to compute the relation between sales of X and Y.
machine-learning data-mining statistics
edited Apr 10 at 10:16
Harikrishnamv
31
asked Apr 10 at 9:36
Darpan DahalDarpan Dahal
11
$endgroup$
$begingroup$
what? your code is a mess
$endgroup$
– lsmor
Apr 10 at 9:45
$begingroup$
It is for sample table in HTML code. I don't know how to add table.
$endgroup$
– Darpan Dahal
Apr 10 at 9:46
add a comment |
$begingroup$
I have table like:
Sales
2010 2011 2012 2013
State X Y X Y X Y X Y
1
2
3
4
5
6
7
Which statistical and/or machine learning approach can be used to compute the relation between sales of X and Y.
machine-learning data-mining statistics
edited Apr 10 at 10:16
Harikrishnamv
31
asked Apr 10 at 9:36
Darpan DahalDarpan Dahal
11
$endgroup$
I have table like:
Sales
2010 2011 2012 2013
State X Y X Y X Y X Y
1
2
3
4
5
6
7
Which statistical and/or machine learning approach can be used to compute the relation between sales of X and Y.
machine-learning data-mining statistics
machine-learning data-mining statistics
edited Apr 10 at 10:16
Harikrishnamv
31
asked Apr 10 at 9:36
Darpan DahalDarpan Dahal
11
edited Apr 10 at 10:16
Harikrishnamv
31
asked Apr 10 at 9:36
Darpan DahalDarpan Dahal
11
edited Apr 10 at 10:16
Harikrishnamv
31
edited Apr 10 at 10:16
Harikrishnamv
31
edited Apr 10 at 10:16
Harikrishnamv
31
31
asked Apr 10 at 9:36
Darpan DahalDarpan Dahal
11
asked Apr 10 at 9:36
Darpan DahalDarpan Dahal
11
asked Apr 10 at 9:36
Darpan DahalDarpan Dahal
11
11
$begingroup$
what? your code is a mess
$endgroup$
– lsmor
Apr 10 at 9:45
$begingroup$
It is for sample table in HTML code. I don't know how to add table.
$endgroup$
– Darpan Dahal
Apr 10 at 9:46
add a comment |
$begingroup$
what? your code is a mess
$endgroup$
– lsmor
Apr 10 at 9:45
$begingroup$
It is for sample table in HTML code. I don't know how to add table.
$endgroup$
– Darpan Dahal
Apr 10 at 9:46
$begingroup$
what? your code is a mess
$endgroup$
– lsmor
Apr 10 at 9:45
$begingroup$
what? your code is a mess
$endgroup$
– lsmor
Apr 10 at 9:45
$begingroup$
It is for sample table in HTML code. I don't know how to add table.
$endgroup$
– Darpan Dahal
Apr 10 at 9:46
$begingroup$
It is for sample table in HTML code. I don't know how to add table.
$endgroup$
– Darpan Dahal
Apr 10 at 9:46
add a comment |
1 Answer
1
active
oldest
votes
$begingroup$
Basically you should consider regression methods. But first you should examine the scatter plot of X with respect to Y. If (from the scatter plot) there seems to be a linear relationship between X and Y, you can try linear regression models like linear regression. You can also check the linear dependency of your variables by computing the correlation coefficient between them. If their correlation coefficient is near to 1 or -1, they can be related by linear models. If their correlation coefficient is near 0, they can not be related by linear regression models so you should try non-linear regression models like neural networks. You can even try time-series models like sequence to sequence modeling using LSTM.
answered Apr 10 at 13:44
pythinkerpythinker
8641314
$endgroup$
$begingroup$
Thank you pythinker, can you say should I first calculate average sales of all years or calculate separately?
$endgroup$
– Darpan Dahal
Apr 11 at 1:44
$begingroup$
This is a part of data I am going to use in my research.
$endgroup$
– Darpan Dahal
Apr 11 at 1:46
$begingroup$
First I should know how many years and how many states you have.
$endgroup$
– pythinker
Apr 11 at 5:43
$begingroup$
Same as above I mentioned.
$endgroup$
– Darpan Dahal
Apr 11 at 9:46
$begingroup$
@DarpanDahal I thought this is just a sample from your dataset. If the size of your dataset is this small, I’m sorry you can not expect any complex machine learning method to work for you. So, simply use linear regression to fit a line in XY space.
$endgroup$
– pythinker
Apr 11 at 10:53
|
show 2 more comments
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "557"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
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%2fdatascience.stackexchange.com%2fquestions%2f49031%2fcomparison-between-two-items%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
$begingroup$
Basically you should consider regression methods. But first you should examine the scatter plot of X with respect to Y. If (from the scatter plot) there seems to be a linear relationship between X and Y, you can try linear regression models like linear regression. You can also check the linear dependency of your variables by computing the correlation coefficient between them. If their correlation coefficient is near to 1 or -1, they can be related by linear models. If their correlation coefficient is near 0, they can not be related by linear regression models so you should try non-linear regression models like neural networks. You can even try time-series models like sequence to sequence modeling using LSTM.
answered Apr 10 at 13:44
pythinkerpythinker
8641314
$endgroup$
$begingroup$
Thank you pythinker, can you say should I first calculate average sales of all years or calculate separately?
$endgroup$
– Darpan Dahal
Apr 11 at 1:44
$begingroup$
This is a part of data I am going to use in my research.
$endgroup$
– Darpan Dahal
Apr 11 at 1:46
$begingroup$
First I should know how many years and how many states you have.
$endgroup$
– pythinker
Apr 11 at 5:43
$begingroup$
Same as above I mentioned.
$endgroup$
– Darpan Dahal
Apr 11 at 9:46
$begingroup$
@DarpanDahal I thought this is just a sample from your dataset. If the size of your dataset is this small, I’m sorry you can not expect any complex machine learning method to work for you. So, simply use linear regression to fit a line in XY space.
$endgroup$
– pythinker
Apr 11 at 10:53
|
show 2 more comments
$begingroup$
Basically you should consider regression methods. But first you should examine the scatter plot of X with respect to Y. If (from the scatter plot) there seems to be a linear relationship between X and Y, you can try linear regression models like linear regression. You can also check the linear dependency of your variables by computing the correlation coefficient between them. If their correlation coefficient is near to 1 or -1, they can be related by linear models. If their correlation coefficient is near 0, they can not be related by linear regression models so you should try non-linear regression models like neural networks. You can even try time-series models like sequence to sequence modeling using LSTM.
answered Apr 10 at 13:44
pythinkerpythinker
8641314
$endgroup$
$begingroup$
Thank you pythinker, can you say should I first calculate average sales of all years or calculate separately?
$endgroup$
– Darpan Dahal
Apr 11 at 1:44
$begingroup$
This is a part of data I am going to use in my research.
$endgroup$
– Darpan Dahal
Apr 11 at 1:46
$begingroup$
First I should know how many years and how many states you have.
$endgroup$
– pythinker
Apr 11 at 5:43
$begingroup$
Same as above I mentioned.
$endgroup$
– Darpan Dahal
Apr 11 at 9:46
$begingroup$
@DarpanDahal I thought this is just a sample from your dataset. If the size of your dataset is this small, I’m sorry you can not expect any complex machine learning method to work for you. So, simply use linear regression to fit a line in XY space.
$endgroup$
– pythinker
Apr 11 at 10:53
|
show 2 more comments
$begingroup$
Basically you should consider regression methods. But first you should examine the scatter plot of X with respect to Y. If (from the scatter plot) there seems to be a linear relationship between X and Y, you can try linear regression models like linear regression. You can also check the linear dependency of your variables by computing the correlation coefficient between them. If their correlation coefficient is near to 1 or -1, they can be related by linear models. If their correlation coefficient is near 0, they can not be related by linear regression models so you should try non-linear regression models like neural networks. You can even try time-series models like sequence to sequence modeling using LSTM.
answered Apr 10 at 13:44
pythinkerpythinker
8641314
$endgroup$
Basically you should consider regression methods. But first you should examine the scatter plot of X with respect to Y. If (from the scatter plot) there seems to be a linear relationship between X and Y, you can try linear regression models like linear regression. You can also check the linear dependency of your variables by computing the correlation coefficient between them. If their correlation coefficient is near to 1 or -1, they can be related by linear models. If their correlation coefficient is near 0, they can not be related by linear regression models so you should try non-linear regression models like neural networks. You can even try time-series models like sequence to sequence modeling using LSTM.
answered Apr 10 at 13:44
pythinkerpythinker
8641314
answered Apr 10 at 13:44
pythinkerpythinker
8641314
answered Apr 10 at 13:44
pythinkerpythinker
8641314
answered Apr 10 at 13:44
pythinkerpythinker
8641314
8641314
$begingroup$
Thank you pythinker, can you say should I first calculate average sales of all years or calculate separately?
$endgroup$
– Darpan Dahal
Apr 11 at 1:44
$begingroup$
This is a part of data I am going to use in my research.
$endgroup$
– Darpan Dahal
Apr 11 at 1:46
$begingroup$
First I should know how many years and how many states you have.
$endgroup$
– pythinker
Apr 11 at 5:43
$begingroup$
Same as above I mentioned.
$endgroup$
– Darpan Dahal
Apr 11 at 9:46
$begingroup$
@DarpanDahal I thought this is just a sample from your dataset. If the size of your dataset is this small, I’m sorry you can not expect any complex machine learning method to work for you. So, simply use linear regression to fit a line in XY space.
$endgroup$
– pythinker
Apr 11 at 10:53
|
show 2 more comments
$begingroup$
Thank you pythinker, can you say should I first calculate average sales of all years or calculate separately?
$endgroup$
– Darpan Dahal
Apr 11 at 1:44
$begingroup$
This is a part of data I am going to use in my research.
$endgroup$
– Darpan Dahal
Apr 11 at 1:46
$begingroup$
First I should know how many years and how many states you have.
$endgroup$
– pythinker
Apr 11 at 5:43
$begingroup$
Same as above I mentioned.
$endgroup$
– Darpan Dahal
Apr 11 at 9:46
$begingroup$
@DarpanDahal I thought this is just a sample from your dataset. If the size of your dataset is this small, I’m sorry you can not expect any complex machine learning method to work for you. So, simply use linear regression to fit a line in XY space.
$endgroup$
– pythinker
Apr 11 at 10:53
$begingroup$
Thank you pythinker, can you say should I first calculate average sales of all years or calculate separately?
$endgroup$
– Darpan Dahal
Apr 11 at 1:44
$begingroup$
Thank you pythinker, can you say should I first calculate average sales of all years or calculate separately?
$endgroup$
– Darpan Dahal
Apr 11 at 1:44
$begingroup$
This is a part of data I am going to use in my research.
$endgroup$
– Darpan Dahal
Apr 11 at 1:46
$begingroup$
This is a part of data I am going to use in my research.
$endgroup$
– Darpan Dahal
Apr 11 at 1:46
$begingroup$
First I should know how many years and how many states you have.
$endgroup$
– pythinker
Apr 11 at 5:43
$begingroup$
First I should know how many years and how many states you have.
$endgroup$
– pythinker
Apr 11 at 5:43
$begingroup$
Same as above I mentioned.
$endgroup$
– Darpan Dahal
Apr 11 at 9:46
$begingroup$
Same as above I mentioned.
$endgroup$
– Darpan Dahal
Apr 11 at 9:46
$begingroup$
@DarpanDahal I thought this is just a sample from your dataset. If the size of your dataset is this small, I’m sorry you can not expect any complex machine learning method to work for you. So, simply use linear regression to fit a line in XY space.
$endgroup$
– pythinker
Apr 11 at 10:53
$begingroup$
@DarpanDahal I thought this is just a sample from your dataset. If the size of your dataset is this small, I’m sorry you can not expect any complex machine learning method to work for you. So, simply use linear regression to fit a line in XY space.
$endgroup$
– pythinker
Apr 11 at 10:53
|
show 2 more comments
Thanks for contributing an answer to Data Science Stack Exchange!
- 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.
Use MathJax to format equations. MathJax reference.
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%2fdatascience.stackexchange.com%2fquestions%2f49031%2fcomparison-between-two-items%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
$begingroup$
what? your code is a mess
$endgroup$
– lsmor
Apr 10 at 9:45
$begingroup$
It is for sample table in HTML code. I don't know how to add table.
$endgroup$
– Darpan Dahal
Apr 10 at 9:46