I have a set of hand generated data that follows somewhat closely to an exponential curve:
I can come up with an exponential equation to the line that gives the values on the 3rd row, and Someone else here helped me come up with the 4th row which is an even better estimate. What could I do to improve the accuracy of this curve? Specifically because I'm losing a ton of profit at quantity 24 and charging too much at 36-144
Equation 1:
$P(Q)=7.527(Q)^{-.361}$
Equation 2:
$P(Q)=\frac{1+0.02481\;(\log_{10}(Q))^2}{0.03156+0.20417\;(\log_{10}(Q))^2}$