How to calculate ARMA model manually without R or Python












3












$begingroup$


I kindly ask if someone at this forum knows how to manually calculate the arma model using time series data. I know how to do this using Python and R but im in need to do this manually. The data would be volatile. For example: 3.375, 3.200, 3.160, 3.110, 3.105, 3.230, 3.295, 3.375, 3.445, 3.315, 3.675. So it would both increase and decrease.



How would I, by using the example data, build an ARMA forecast model?



edit: Im new to this forum and if the question is not relevant, I apologize!
Thanks in advance!










share|cite|improve this question









New contributor




Vichtor is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.







$endgroup$








  • 3




    $begingroup$
    What counts as "manually"? On your fingers? Pencil and paper?
    $endgroup$
    – The Laconic
    6 hours ago










  • $begingroup$
    Sorry for being unclear but yeah, pretty much. It would be ''easy'' doing this in R and/or python. However, im trying to incorporate the ARMA model into a programme where I can not use any advanced functions and have to do this manually. Im asking for someone to give an example of how to practically/manually calculate the model. I've found many examples of this online but I found them too theoretical without any pracitcal examples on how to apply data to the function
    $endgroup$
    – Vichtor
    6 hours ago










  • $begingroup$
    Can you please edit that new info into the Q? Some wants to close as 7nclear, with this incorporated it can stand
    $endgroup$
    – kjetil b halvorsen
    5 hours ago










  • $begingroup$
    Which is what I tried to do here stats.stackexchange.com/questions/77663/…
    $endgroup$
    – forecaster
    5 hours ago










  • $begingroup$
    Tack Kjetil, will do!
    $endgroup$
    – Vichtor
    4 hours ago
















3












$begingroup$


I kindly ask if someone at this forum knows how to manually calculate the arma model using time series data. I know how to do this using Python and R but im in need to do this manually. The data would be volatile. For example: 3.375, 3.200, 3.160, 3.110, 3.105, 3.230, 3.295, 3.375, 3.445, 3.315, 3.675. So it would both increase and decrease.



How would I, by using the example data, build an ARMA forecast model?



edit: Im new to this forum and if the question is not relevant, I apologize!
Thanks in advance!










share|cite|improve this question









New contributor




Vichtor is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.







$endgroup$








  • 3




    $begingroup$
    What counts as "manually"? On your fingers? Pencil and paper?
    $endgroup$
    – The Laconic
    6 hours ago










  • $begingroup$
    Sorry for being unclear but yeah, pretty much. It would be ''easy'' doing this in R and/or python. However, im trying to incorporate the ARMA model into a programme where I can not use any advanced functions and have to do this manually. Im asking for someone to give an example of how to practically/manually calculate the model. I've found many examples of this online but I found them too theoretical without any pracitcal examples on how to apply data to the function
    $endgroup$
    – Vichtor
    6 hours ago










  • $begingroup$
    Can you please edit that new info into the Q? Some wants to close as 7nclear, with this incorporated it can stand
    $endgroup$
    – kjetil b halvorsen
    5 hours ago










  • $begingroup$
    Which is what I tried to do here stats.stackexchange.com/questions/77663/…
    $endgroup$
    – forecaster
    5 hours ago










  • $begingroup$
    Tack Kjetil, will do!
    $endgroup$
    – Vichtor
    4 hours ago














3












3








3





$begingroup$


I kindly ask if someone at this forum knows how to manually calculate the arma model using time series data. I know how to do this using Python and R but im in need to do this manually. The data would be volatile. For example: 3.375, 3.200, 3.160, 3.110, 3.105, 3.230, 3.295, 3.375, 3.445, 3.315, 3.675. So it would both increase and decrease.



How would I, by using the example data, build an ARMA forecast model?



edit: Im new to this forum and if the question is not relevant, I apologize!
Thanks in advance!










share|cite|improve this question









New contributor




Vichtor is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.







$endgroup$




I kindly ask if someone at this forum knows how to manually calculate the arma model using time series data. I know how to do this using Python and R but im in need to do this manually. The data would be volatile. For example: 3.375, 3.200, 3.160, 3.110, 3.105, 3.230, 3.295, 3.375, 3.445, 3.315, 3.675. So it would both increase and decrease.



How would I, by using the example data, build an ARMA forecast model?



edit: Im new to this forum and if the question is not relevant, I apologize!
Thanks in advance!







mathematical-statistics forecasting arima






share|cite|improve this question









New contributor




Vichtor is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|cite|improve this question









New contributor




Vichtor is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|cite|improve this question




share|cite|improve this question








edited 7 hours ago







Vichtor













New contributor




Vichtor is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked 7 hours ago









VichtorVichtor

162




162




New contributor




Vichtor is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





Vichtor is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






Vichtor is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.








  • 3




    $begingroup$
    What counts as "manually"? On your fingers? Pencil and paper?
    $endgroup$
    – The Laconic
    6 hours ago










  • $begingroup$
    Sorry for being unclear but yeah, pretty much. It would be ''easy'' doing this in R and/or python. However, im trying to incorporate the ARMA model into a programme where I can not use any advanced functions and have to do this manually. Im asking for someone to give an example of how to practically/manually calculate the model. I've found many examples of this online but I found them too theoretical without any pracitcal examples on how to apply data to the function
    $endgroup$
    – Vichtor
    6 hours ago










  • $begingroup$
    Can you please edit that new info into the Q? Some wants to close as 7nclear, with this incorporated it can stand
    $endgroup$
    – kjetil b halvorsen
    5 hours ago










  • $begingroup$
    Which is what I tried to do here stats.stackexchange.com/questions/77663/…
    $endgroup$
    – forecaster
    5 hours ago










  • $begingroup$
    Tack Kjetil, will do!
    $endgroup$
    – Vichtor
    4 hours ago














  • 3




    $begingroup$
    What counts as "manually"? On your fingers? Pencil and paper?
    $endgroup$
    – The Laconic
    6 hours ago










  • $begingroup$
    Sorry for being unclear but yeah, pretty much. It would be ''easy'' doing this in R and/or python. However, im trying to incorporate the ARMA model into a programme where I can not use any advanced functions and have to do this manually. Im asking for someone to give an example of how to practically/manually calculate the model. I've found many examples of this online but I found them too theoretical without any pracitcal examples on how to apply data to the function
    $endgroup$
    – Vichtor
    6 hours ago










  • $begingroup$
    Can you please edit that new info into the Q? Some wants to close as 7nclear, with this incorporated it can stand
    $endgroup$
    – kjetil b halvorsen
    5 hours ago










  • $begingroup$
    Which is what I tried to do here stats.stackexchange.com/questions/77663/…
    $endgroup$
    – forecaster
    5 hours ago










  • $begingroup$
    Tack Kjetil, will do!
    $endgroup$
    – Vichtor
    4 hours ago








3




3




$begingroup$
What counts as "manually"? On your fingers? Pencil and paper?
$endgroup$
– The Laconic
6 hours ago




$begingroup$
What counts as "manually"? On your fingers? Pencil and paper?
$endgroup$
– The Laconic
6 hours ago












$begingroup$
Sorry for being unclear but yeah, pretty much. It would be ''easy'' doing this in R and/or python. However, im trying to incorporate the ARMA model into a programme where I can not use any advanced functions and have to do this manually. Im asking for someone to give an example of how to practically/manually calculate the model. I've found many examples of this online but I found them too theoretical without any pracitcal examples on how to apply data to the function
$endgroup$
– Vichtor
6 hours ago




$begingroup$
Sorry for being unclear but yeah, pretty much. It would be ''easy'' doing this in R and/or python. However, im trying to incorporate the ARMA model into a programme where I can not use any advanced functions and have to do this manually. Im asking for someone to give an example of how to practically/manually calculate the model. I've found many examples of this online but I found them too theoretical without any pracitcal examples on how to apply data to the function
$endgroup$
– Vichtor
6 hours ago












$begingroup$
Can you please edit that new info into the Q? Some wants to close as 7nclear, with this incorporated it can stand
$endgroup$
– kjetil b halvorsen
5 hours ago




$begingroup$
Can you please edit that new info into the Q? Some wants to close as 7nclear, with this incorporated it can stand
$endgroup$
– kjetil b halvorsen
5 hours ago












$begingroup$
Which is what I tried to do here stats.stackexchange.com/questions/77663/…
$endgroup$
– forecaster
5 hours ago




$begingroup$
Which is what I tried to do here stats.stackexchange.com/questions/77663/…
$endgroup$
– forecaster
5 hours ago












$begingroup$
Tack Kjetil, will do!
$endgroup$
– Vichtor
4 hours ago




$begingroup$
Tack Kjetil, will do!
$endgroup$
– Vichtor
4 hours ago










1 Answer
1






active

oldest

votes


















2












$begingroup$

It is unclear in your question what "manual calculation" excludes, and your comment that you cannot use "advanced functions" is also not very helpful. In any case, fitting an ARMA model via maximum-likelihood estimation is an optimisation problem where you need to maximise a function over a set of parameters. For example, the log-likelihood function in a stationary Gaussian ARMA is:



$$ell_{x}(mu,boldsymbol{phi},boldsymbol{theta}) = - frac{1}{2} ln | boldsymbol{Sigma}(boldsymbol{phi},boldsymbol{theta})| + (mathbf{x} - mu boldsymbol{1})^text{T} boldsymbol{Sigma}(boldsymbol{phi},boldsymbol{theta})^{-1} (mathbf{x} - mu boldsymbol{1}),$$



where the covariance matrix $boldsymbol{Sigma}(boldsymbol{phi},boldsymbol{theta})$ depends on the parameters $boldsymbol{phi}$ and $boldsymbol{theta}$ according to the auto-covariance function for the ARMA model. This function has two terms. The second is a standard sum-of-squares term, but the first is a more complicated term involving the logarithm of the determinant of the covariance matrix.



The exact MLE method has critical point equations that cannot be put into closed form, so this would entail the use of iterative methods (e.g., Newton-Raphson iteration) to find the maximising values. If you are willing to deviate slightly from the exact MLE and use the partial likelihood function ---excluding the logarithmic term--- this gives MLEs that can be obtained as standard OLS estimates. Once you estimate the parameters in the model you can make forecasts as point-estimates by substituting the parameter estimates.



It is certainly possible to program this optimisation problem "manually", in the sense that you can directly program an iterative procedure to optimise the above function, without using pre-programmed optimisation procedures. It would be quite laborious, but it could probably done in a few hours.






share|cite|improve this answer









$endgroup$













  • $begingroup$
    Thank you Ben for taking your time replying. I will defiently try your suggested method!
    $endgroup$
    – Vichtor
    4 hours ago











Your Answer





StackExchange.ifUsing("editor", function () {
return StackExchange.using("mathjaxEditing", function () {
StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix) {
StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["$", "$"], ["\\(","\\)"]]);
});
});
}, "mathjax-editing");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "65"
};
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
});


}
});






Vichtor is a new contributor. Be nice, and check out our Code of Conduct.










draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstats.stackexchange.com%2fquestions%2f390513%2fhow-to-calculate-arma-model-manually-without-r-or-python%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









2












$begingroup$

It is unclear in your question what "manual calculation" excludes, and your comment that you cannot use "advanced functions" is also not very helpful. In any case, fitting an ARMA model via maximum-likelihood estimation is an optimisation problem where you need to maximise a function over a set of parameters. For example, the log-likelihood function in a stationary Gaussian ARMA is:



$$ell_{x}(mu,boldsymbol{phi},boldsymbol{theta}) = - frac{1}{2} ln | boldsymbol{Sigma}(boldsymbol{phi},boldsymbol{theta})| + (mathbf{x} - mu boldsymbol{1})^text{T} boldsymbol{Sigma}(boldsymbol{phi},boldsymbol{theta})^{-1} (mathbf{x} - mu boldsymbol{1}),$$



where the covariance matrix $boldsymbol{Sigma}(boldsymbol{phi},boldsymbol{theta})$ depends on the parameters $boldsymbol{phi}$ and $boldsymbol{theta}$ according to the auto-covariance function for the ARMA model. This function has two terms. The second is a standard sum-of-squares term, but the first is a more complicated term involving the logarithm of the determinant of the covariance matrix.



The exact MLE method has critical point equations that cannot be put into closed form, so this would entail the use of iterative methods (e.g., Newton-Raphson iteration) to find the maximising values. If you are willing to deviate slightly from the exact MLE and use the partial likelihood function ---excluding the logarithmic term--- this gives MLEs that can be obtained as standard OLS estimates. Once you estimate the parameters in the model you can make forecasts as point-estimates by substituting the parameter estimates.



It is certainly possible to program this optimisation problem "manually", in the sense that you can directly program an iterative procedure to optimise the above function, without using pre-programmed optimisation procedures. It would be quite laborious, but it could probably done in a few hours.






share|cite|improve this answer









$endgroup$













  • $begingroup$
    Thank you Ben for taking your time replying. I will defiently try your suggested method!
    $endgroup$
    – Vichtor
    4 hours ago
















2












$begingroup$

It is unclear in your question what "manual calculation" excludes, and your comment that you cannot use "advanced functions" is also not very helpful. In any case, fitting an ARMA model via maximum-likelihood estimation is an optimisation problem where you need to maximise a function over a set of parameters. For example, the log-likelihood function in a stationary Gaussian ARMA is:



$$ell_{x}(mu,boldsymbol{phi},boldsymbol{theta}) = - frac{1}{2} ln | boldsymbol{Sigma}(boldsymbol{phi},boldsymbol{theta})| + (mathbf{x} - mu boldsymbol{1})^text{T} boldsymbol{Sigma}(boldsymbol{phi},boldsymbol{theta})^{-1} (mathbf{x} - mu boldsymbol{1}),$$



where the covariance matrix $boldsymbol{Sigma}(boldsymbol{phi},boldsymbol{theta})$ depends on the parameters $boldsymbol{phi}$ and $boldsymbol{theta}$ according to the auto-covariance function for the ARMA model. This function has two terms. The second is a standard sum-of-squares term, but the first is a more complicated term involving the logarithm of the determinant of the covariance matrix.



The exact MLE method has critical point equations that cannot be put into closed form, so this would entail the use of iterative methods (e.g., Newton-Raphson iteration) to find the maximising values. If you are willing to deviate slightly from the exact MLE and use the partial likelihood function ---excluding the logarithmic term--- this gives MLEs that can be obtained as standard OLS estimates. Once you estimate the parameters in the model you can make forecasts as point-estimates by substituting the parameter estimates.



It is certainly possible to program this optimisation problem "manually", in the sense that you can directly program an iterative procedure to optimise the above function, without using pre-programmed optimisation procedures. It would be quite laborious, but it could probably done in a few hours.






share|cite|improve this answer









$endgroup$













  • $begingroup$
    Thank you Ben for taking your time replying. I will defiently try your suggested method!
    $endgroup$
    – Vichtor
    4 hours ago














2












2








2





$begingroup$

It is unclear in your question what "manual calculation" excludes, and your comment that you cannot use "advanced functions" is also not very helpful. In any case, fitting an ARMA model via maximum-likelihood estimation is an optimisation problem where you need to maximise a function over a set of parameters. For example, the log-likelihood function in a stationary Gaussian ARMA is:



$$ell_{x}(mu,boldsymbol{phi},boldsymbol{theta}) = - frac{1}{2} ln | boldsymbol{Sigma}(boldsymbol{phi},boldsymbol{theta})| + (mathbf{x} - mu boldsymbol{1})^text{T} boldsymbol{Sigma}(boldsymbol{phi},boldsymbol{theta})^{-1} (mathbf{x} - mu boldsymbol{1}),$$



where the covariance matrix $boldsymbol{Sigma}(boldsymbol{phi},boldsymbol{theta})$ depends on the parameters $boldsymbol{phi}$ and $boldsymbol{theta}$ according to the auto-covariance function for the ARMA model. This function has two terms. The second is a standard sum-of-squares term, but the first is a more complicated term involving the logarithm of the determinant of the covariance matrix.



The exact MLE method has critical point equations that cannot be put into closed form, so this would entail the use of iterative methods (e.g., Newton-Raphson iteration) to find the maximising values. If you are willing to deviate slightly from the exact MLE and use the partial likelihood function ---excluding the logarithmic term--- this gives MLEs that can be obtained as standard OLS estimates. Once you estimate the parameters in the model you can make forecasts as point-estimates by substituting the parameter estimates.



It is certainly possible to program this optimisation problem "manually", in the sense that you can directly program an iterative procedure to optimise the above function, without using pre-programmed optimisation procedures. It would be quite laborious, but it could probably done in a few hours.






share|cite|improve this answer









$endgroup$



It is unclear in your question what "manual calculation" excludes, and your comment that you cannot use "advanced functions" is also not very helpful. In any case, fitting an ARMA model via maximum-likelihood estimation is an optimisation problem where you need to maximise a function over a set of parameters. For example, the log-likelihood function in a stationary Gaussian ARMA is:



$$ell_{x}(mu,boldsymbol{phi},boldsymbol{theta}) = - frac{1}{2} ln | boldsymbol{Sigma}(boldsymbol{phi},boldsymbol{theta})| + (mathbf{x} - mu boldsymbol{1})^text{T} boldsymbol{Sigma}(boldsymbol{phi},boldsymbol{theta})^{-1} (mathbf{x} - mu boldsymbol{1}),$$



where the covariance matrix $boldsymbol{Sigma}(boldsymbol{phi},boldsymbol{theta})$ depends on the parameters $boldsymbol{phi}$ and $boldsymbol{theta}$ according to the auto-covariance function for the ARMA model. This function has two terms. The second is a standard sum-of-squares term, but the first is a more complicated term involving the logarithm of the determinant of the covariance matrix.



The exact MLE method has critical point equations that cannot be put into closed form, so this would entail the use of iterative methods (e.g., Newton-Raphson iteration) to find the maximising values. If you are willing to deviate slightly from the exact MLE and use the partial likelihood function ---excluding the logarithmic term--- this gives MLEs that can be obtained as standard OLS estimates. Once you estimate the parameters in the model you can make forecasts as point-estimates by substituting the parameter estimates.



It is certainly possible to program this optimisation problem "manually", in the sense that you can directly program an iterative procedure to optimise the above function, without using pre-programmed optimisation procedures. It would be quite laborious, but it could probably done in a few hours.







share|cite|improve this answer












share|cite|improve this answer



share|cite|improve this answer










answered 5 hours ago









BenBen

23.8k224113




23.8k224113












  • $begingroup$
    Thank you Ben for taking your time replying. I will defiently try your suggested method!
    $endgroup$
    – Vichtor
    4 hours ago


















  • $begingroup$
    Thank you Ben for taking your time replying. I will defiently try your suggested method!
    $endgroup$
    – Vichtor
    4 hours ago
















$begingroup$
Thank you Ben for taking your time replying. I will defiently try your suggested method!
$endgroup$
– Vichtor
4 hours ago




$begingroup$
Thank you Ben for taking your time replying. I will defiently try your suggested method!
$endgroup$
– Vichtor
4 hours ago










Vichtor is a new contributor. Be nice, and check out our Code of Conduct.










draft saved

draft discarded


















Vichtor is a new contributor. Be nice, and check out our Code of Conduct.













Vichtor is a new contributor. Be nice, and check out our Code of Conduct.












Vichtor is a new contributor. Be nice, and check out our Code of Conduct.
















Thanks for contributing an answer to Cross Validated!


  • 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.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstats.stackexchange.com%2fquestions%2f390513%2fhow-to-calculate-arma-model-manually-without-r-or-python%23new-answer', 'question_page');
}
);

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







Popular posts from this blog

SQL Server 17 - Attemping to backup to remote NAS but Access is denied

Always On Availability groups resolving state after failover - Remote harden of transaction...

Restoring from pg_dump with foreign key constraints