Hello, thanks the video is really easy to understand. I'll like to know if we can apply regression function on data values created with formulas which contains non numeric values(ex:sales using SUMIFS function) ?
Hi there. Yes, since the results of the function is numeric you should be able to apply regression analysis unless you end up in a circular loop where you intend to use the regression results in the function which you then use in the regression. Give it a try and see what you get!
I don’t have one right now but you should be able to easily duplicate it by calculating the absolute deviation for each forecast |actual - forecast| and then averaging them all to get the MAD. Do the same for the absolute percentage error |(actual - forecast)/actual| and averages them all for MAPE Hope this helps
Simple yet so clearly explained. Thank you sir
great content
Thanks!
Please provide the link to the Excel file data in the description, so that we can work along with this video. Thanks.
Hi there. Sorry I’m unable to provide tue file. The data is simple enough for you to duplicate in a blank worksheet, however.
Hello, thanks the video is really easy to understand. I'll like to know if we can apply regression function on data values created with formulas which contains non numeric values(ex:sales using SUMIFS function) ?
Hi there. Yes, since the results of the function is numeric you should be able to apply regression analysis unless you end up in a circular loop where you intend to use the regression results in the function which you then use in the regression.
Give it a try and see what you get!
Thank you
You’re welcome!
Do you have the same example but also with MAD and MAPE?
I don’t have one right now but you should be able to easily duplicate it by calculating the absolute deviation for each forecast |actual - forecast| and then averaging them all to get the MAD. Do the same for the absolute percentage error |(actual - forecast)/actual| and averages them all for MAPE
Hope this helps