Exemplo

Obs 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Média Mediana Var D. Pad Coef_Var MAD Mínimo Quartil 1 Quartil 2 Quartil 3 Máximo Amplitude AIQ

Vendas 9645 8850 15023 12983 8244 7285 12747 11139 7477 6116 13604 10828 6836 5979 14005 11855

16000 14000 12000 10000

Vendas

8000 6000 4000 0

2.5

5

7.5

10

12.5

15

17.5

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

A Obs 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

B Vendas 5979 6116 6836 7285 7477 8244 8850 9645 10828 11139 11855 12747 12983 13604 14005 15023

C

D Média Mediana

E

F G Fórmulas: 10163.5 =MÉDIA(B$2:B$17) 10236.5 =MED(B$2:B$17)

H

I

J

Var 9015566 =VAR(B$2:B$17) D. Pad 3002.6 =DESVPAD(B$2:B$17) Coef_Var 29.54% =E6/E2 MAD 2609.5 =DESV.MÉDIO(B$2:B$17) Mínimo Quartil 1 Quartil 2 Quartil 3 Máximo

5979.0 7429.0 10236.5 12806.0 15023.0

=MÍNIMO(B$2:B$17) ou QUARTIL(B$2:B$17,0) =QUARTIL(B$2:B$17,1) =QUARTIL(B$2:B$17,2) =QUARTIL(B$2:B$17,3) =MÁXIMO(B$2:B$17) ou QUARTIL(B$2:B$17,4)

Amplitude AIQ

9044.0 5377.0

=E14-E10 =E13-E11

Obs 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Média Mediana Var D. Pad Coef_Var MAD Mínimo Quartil 1 Quartil 2 Quartil 3 Máximo Amplitude AIQ

Preço $26,000 $31,000 $37,400 $34,800 $39,200 $38,000 $39,600 $31,200 $37,200 $38,400 $43,600 $44,800 $40,600 $41,800 $45,200

$50,000 $40,000 $30,000 $20,000

Preço

$10,000 $R R RR R RR R R RR R R RR o o o o o o o o o o o o o o o w w ww w ww w w ww w w ww

Obs 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

Preço $26,000 $31,000 $31,200 $34,800 $37,200 $37,400 $38,000 $38,400 $39,200 $39,600 $40,600 $41,800 $43,600 $44,800 $45,200

Média Mediana

$37,920 =MÉDIA(B$2:B$16) $38,400 =MED(B$2:B$16)

Var 28941714 =VAR(B$2:B$16) D. Pad 5379.8 =DESVPAD(B$2:B$16) Coef_Var 14.19% =E5/E1 MAD 3989.3 =DESV.MÉDIO(B$2:B$16) Mínimo Quartil 1 Quartil 2 Quartil 3 Máximo

26000.0 36000.0 38400.0 41200.0 45200.0

=MÍNIMO(B$2:B$16) =QUARTIL(B$2:B$16,1) =QUARTIL(B$2:B$16,2) =QUARTIL(B$2:B$16,3) =MÁXIMO(B$2:B$16)

Amplitude 19200.0 =E13-E9 AIQ 5200.0 =E12-E10

Cliente 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50

Despesa 2.32 6.61 6.90 8.04 9.45 10.26 11.34 11.63 12.66 12.95 13.67 13.72 14.35 14.52 14.55 15.01 15.33 16.55 17.15 18.22 18.30 18.71 19.54 19.55 20.58 20.89 20.91 21.13 23.85 26.04 27.07 28.76 29.15 30.54 31.99 32.82 33.26 33.80 34.76 36.22 37.52 39.28 40.80 43.97 45.58 52.36 61.57 63.85 64.30 69.49

Média Mediana

25.84 20.74

Var D. Pad Coef_Var MAD

260.93 16.15 62.52% 12.82

Mínimo Quartil 1 Quartil 2 Quartil 3 Máximo

2.32 14.39 20.74 33.67 69.49

Amplitude AIQ

67.17 19.27