Linear Programming

Hi everyone!

I am trying to create a linear programming model for a marketing problem I have been set for my class. The only problem I am having is turning a non-linear data set into a linear function so that it will be recognised by solver.

Currently the data is plotted as a s curve. I think I need to create a line of best fit, so that the incremental changes in my data are linear and can therefore be used by solver.

If anyone has any idea on how I can create a linear function for my non-linear data I would be extremely appreciative.

Kind regards,

Obbor

Thank you very much mahju.