Macro Batch + Linear Regression (error)

barbarasuppa

Hello, 

Can anyone help me? I download a batch macro that allows me to run a linear regression for a lot of itens groups.

I have a sale's quantities sold, the price and I would like to see how related the price and quantity are.

When I run the batch macro the first time it works quite well buy I needed to "change" my quantity because of the sazonality. So what I did was multiply my quantity times my sazonality index. After that when I try to run the flow again a error message appears.

This are the kind of informations that I have when everything works just fine:

What I did next was multiply the qtd x sazonality index:

fmvizcaino

Hi @barbarasuppa ,

From the link below, it seems like a hardware limitation to process your data, maybe related to the quantity of decimal places in your [Preço] column, I suggest you to try using fixed decimal only to check if that is the case and take it from there.

https://stat.ethz.ch/R-manual/R-devel/library/base/html/Memory-limits.html#:~:text=Error%20messages%20beginning%20cannot%20allocate,unable%20to%20provide%20the%20memory.&text=There%20are%20also%20limits%20on%20individual%20objects.

https://stackoverflow.com/questions/5171593/r-memory-management-cannot-allocate-vector-of-size-n-mb#:~:text=Error%20messages%20beginning%20cannot%20allocate,unable%20to%20provide%20the%20memory.

If rounding is not the issue nor a valid solution for your problem, please share the macro you are using and a sample dataset (if you can) where the error is happening and I can try to help you debug.

Best,

Fernando Vizcaino