I am looking to set up a spreadsheet that has the option to select multiple variables, and show the impact they will have on the Y variables. For example using historical prices for Petrol price to show the impact on stock prices.
I have sent LINSET equations in excel can run this for mutiple X variables on multiple Y values. Whilst i have seen it done using this method, i am open to methodologies.
I am aiming to be able to use a cell to change a value in X to predict the value of Y.
Attached is an example. Ideally this will be macro or formula.
[login to view URL]
Hi, I can do the task in excel. So this is basically linear regression and I can do this with LINEST in excel. I can do it with a function and if you prefer a macro, I can do that. Let me know. Thank you
29 фрілансерів(-и) готові виконати цю роботу у середньому за $124
Dear customer, i confidently express my desire to work on this paper as I am committed to provide you with the best possible services including plagiarism free work, timely delivery and of course, excellent quality.