| A | B | C | D | |
| 1 | function | formula | example | result |
| 2 | lowest price | a | $ 100 | $ 100 |
| 3 | highest price | b | $ 1000 | $ 1000 |
| 4 | b/a | =B3/B2 | 1000/100 | 10 |
| 5 | Ln(b/a) | =Ln(B4) | Ln10 | 2,30 |
| 6 | (Ln(b/a))/6 | =B5/6 | (Ln10)/6 | 0,38 |
| 7 | Exp(Ln(b/a))/6 | =Exp(B6) | Exp(Ln10)/6 | 1,47 |
| 8 | factor q | =B7 | q | 1,47 |
| 9 | lowest price | a.q0 | a.1 | 1,47 |
| 10 | centre of low price sector | a.q | a.1,47 | $ 100 |
| 11 | limit of low price sector | a.q2 | a.1,472 | $ 147 |
| 12 | centre of CENTER price sector | a.q3 | a.1,473 | $ 215 |
| 13 | limit of CENTER price sector | a.q4 | a.1,474 | $ 316 |
| 14 | centre of high price sector | a.q5 | a.1,475 | $ 681 |
| 15 | highest price | a.q6 | a.1,476 | $ 1000 |
| 5)
7)
8)
9 till 15) 11 and 13)
10, 12 and 14) |
introduces the logarithmic function
7) returns from logarithms to normal numbers and
8) a geometric series has the following formula a.q0, a.q1, a.q2...a.qn we can now calculate the complete series. calculate the limits of the three sectors. The results in our example are: the low price sector from
$ 100 to $ 215
calculate the geometric 'centres' or characteristic prices for each
sector.
typical low price $ 147 or ca. $ 150
|
| back to theory pages |
| alla pagina sul marketing (in Italian) |
|
|
|
|
|
|