(formula)
Linear dependent variable and logged independent variable
(formula)
(formulas)
Chart Showing formulas for figures
| Formulas for 1st five points | |||
| Linear | logearn | quadratic + log | |
| 1 | 9902.1+169.73*A3 | EXP(9.0+0.014*A3) | EXP(8.55+0.076*A3-0.001*A3*A3) |
| 2 | 9902.1+169.73*A4 | EXP(9.0+0.014*A4) | EXP(8.55+0.076*a4-0.001*a4*a4) |
| 3 | 9902.1+169.73*A5 | EXP(9.0+0.014*A5) | EXP(8.55+0.076*a5-0.001*a5*a5) |
| 4 | 9902.1+169.73*A6 | EXP(9.0+0.014*A6) | EXP(8.55+0.076*a6-0.001*a6*a6) |
| 5 | 9902.1+169.73*A7 | EXP(9.0+0.014*A7) | EXP(8.55+0.076*a7-0.001*a7*a7) |
| quadratic | logexp | log-log | |
| 1 | 5605.2+762.5*A3-13.16*A3*A3 | 4961.2+3113.57*LN(A3) | EXP(8.511476+0.291746*LN(A3)) |
| 2 | 5605.2+762.5*a4-13.16*a4*a4 | 4961.2+3113.57*LN(A4) | EXP(8.511476+0.291746*LN(A4)) |
| 3 | 5605.2+762.5*a5-13.16*a5*a5 | 4961.2+3113.57*LN(A5) | EXP(8.511476+0.291746*LN(A5)) |
| 4 | 5605.2+762.5*a6-13.16*a6*a6 | 4961.2+3113.57*LN(A6) | EXP(8.511476+0.291746*LN(A6)) |
| 5 | 5605.2+762.5*a7-13.16*a7*a7 | 4961.2+3113.57*LN(A7) | EXP(8.511476+0.291746*LN(A7)) |
| Values for 1st five points | |||
| Linear | logearn | quadratic + log | |
| +log | |||
| 1 | 10071.8391 | 8245.476286 | 5589.544064 |
| 2 | 10241.56947 | 8364.417704 | 6007.974806 |
| 3 | 10411.29983 | 8485.074858 | 6439.981845 |
| 4 | 10581.03019 | 8607.472497 | 6884.081525 |
| 5 | 10750.76056 | 8731.635729 | 7338.582624 |
| quadratic | logexp | log-log | |
| 1 | 6354.557668 | 4961.153882 | 4971.495603 |
| 2 | 7077.598766 | 7119.318254 | 6085.711451 |
| 3 | 7774.32009 | 8381.763482 | 6849.916496 |
| 4 | 8444.72164 | 9277.482626 | 7449.646307 |
| 5 | 9088.803416 | 9972.256371 | 7950.762168 |