Using Regression for a ‘recipe’

Hello,

I have been tasked with trying to create a spreadsheet that will allow me to ‘calculate’ a recipe for a process at work.

Essentially, i have roughly 4-5 different variable categories, which each having around 10 or so subsections that should be used as a formula to calculate a final value (a prediction to be used in production).

I have tralled the web trying to find a solution for this but have not been able to come up with anything.

Please could someone tell me if this is even possible!

 

Thanks

By: Craig Dawson

Leave a Reply

Your email address will not be published. Required fields are marked *