eurostat pt. 5

8/14/2019 eurostat pt. 5

1/46

11/4/2013 EUROSTAT 5 1


2/46

11/4/2013 EUROSTAT 5 2


3/46

11/4/2013 EUROSTAT 5 3


4/46

11/4/2013 EUROSTAT 5 4


5/46

11/4/2013 EUROSTAT 5 5


6/46

11/4/2013 EUROSTAT 5 6


7/46


8/46

11/4/2013 EUROSTAT 5 8

MAX functionReturns the largest value in a set of values.

Syntax

MAX(number1,number2,...)

Number1, number2, ... are 1 to 255 numbers for which you want to find the maximum value.

Remarks

Arguments can either be numbers or names, arrays, or references that contain numbers.

Logical values and text representations of numbers that you type directly into the list of

arguments are counted.

If an argument is an array or reference, only numbers in that array or reference are used.

Empty cells, logical values, or text in the array or reference are ignored.If the arguments contain no numbers, MAX returns 0 (zero).

Arguments that are error values or text that cannot be translated into numbers cause errors.

If you want to include logical values and text representations of numbers in a reference as part

of the calculation, use the MAXA function.


9/46

11/4/2013 EUROSTAT 5 9

=AVERAGE(number1, [number2],...)DescriptionReturns the average (arithmetic mean) of the arguments. For example, if the range

A1:A20 contains numbers, the formula =AVERAGE(A1:A20)returns the average of those numbers.

SyntaxAVERAGE(number1, [number2],...)The AVERAGEfunction syntax has the following

arguments: number1 Required. The first number, cell reference, or range for which you want theaverage. number2, ... Optional. Additional numbers, cell references or ranges for which you want the

average, up to a maximum of 255.

Remarks

Arguments can either be numbers or names, ranges, or cell references that contain numbers.

Logical values and text representations of numbers that you type directly into the list of arguments

are counted.

If a range or cell reference argument contains text, logical values, or empty cells, those values are

ignored; however, cells with the value zero are included.

Arguments that are error values or text that cannot be translated into numbers cause errors.

If you want to include logical values and text representations of numbers in a reference as part of the

calculation, use the AVERAGEAfunction.

If you want to calculate the average of only the values that meet certain criteria, use the

AVERAGEIFfunction or the AVERAGEIFSfunction.NOTE The AVERAGEfunction measures central tendency, which is the location of the center of

a group of numbers in a statistical distribution. The three most common measures of central tendency are:

Average, which is the arithmetic mean, and is calculated by adding a group of numbers and then

dividing by the count of those numbers. For example, the average of 2, 3, 3, 5, 7, and 10 is 30 divided by

6, which is 5.


10/46

11/4/2013 EUROSTAT 5 10

Grafic

in plan

Grafic in

plan

sume

cumulate

Grafic in

planponderi

Grafic

spatiu

Grafic in

spatiuponderi

Grafic in

spatiu

sume

cumulate


11/46

11/4/2013 EUROSTAT 5 11


12/46

11/4/2013 EUROSTAT 5 12


13/46

11/4/2013 EUROSTAT 5 13

0,0000

0,2000

0,4000

0,6000

0,8000

1,0000

1,2000

1,4000

1,6000

2000 2001 2002 2003 2004 2005

Total

General public services

Defence

Public order and safety

Economic affairs

Environment protection

Housing and community

amenities

Health


14/46

11/4/2013 EUROSTAT 5 14


15/46

11/4/2013 EUROSTAT 5 15


16/46

11/4/2013 EUROSTAT 5 16


17/46

11/4/2013 EUROSTAT 5 17

indice baza lant

0,7800

0,8800

0,9800

1,0800

1,1800

1,2800

1,3800

1,4800

2000 2001 2002 2003 2004 2005 2006

total Total

gf01 General public services

gf02 Defence

gf03 Public order and safety

gf04 Economic affairs

gf05 Environment protection

gf06 Housing and community amenities

gf07 Health


18/46

11/4/2013 EUROSTAT 5 18

indice baza lant

1,0000

1,0100

1,0200

1,0300

1,0400

1,0500

2000 2001 2002 2003 2004 2005 2006

total Total


19/46

11/4/2013 EUROSTAT 5 19

indice baza lant

0,9800

1,0000

1,0200

1,0400

1,0600

1,0800

1,1000

1,1200

1,1400

2000 2001 2002 2003 2004 2005 2006

gf01 General public services

gf02 Defence

gf03 Public order and safety


20/46

11/4/2013 EUROSTAT 5 20

indice baza lant

0,7800

0,8800

0,9800

1,0800

1,1800

1,2800

1,3800

1,4800

2000 2001 2002 2003 2004 2005 2006

gf04 Economic affairsgf05 Environment protection

gf06 Housing and community amenities

gf07 Health


21/46

11/4/2013 EUROSTAT 5 21


22/46

11/4/2013 EUROSTAT 5 22


23/46

11/4/2013 EUROSTAT 5 23


24/46

11/4/2013 EUROSTAT 5 24


25/46

11/4/2013 EUROSTAT 5 25


26/46

11/4/2013 EUROSTAT 5 26


27/46

11/4/2013 EUROSTAT 5 27


28/46

11/4/2013 EUROSTAT 5 28


29/46

11/4/2013 EUROSTAT 5 29


30/46

11/4/2013 EUROSTAT 5 30


31/46

11/4/2013 EUROSTAT 5 31


32/46

11/4/2013 EUROSTAT 5 32


33/46

11/4/2013 EUROSTAT 5 33


34/46

11/4/2013 EUROSTAT 5 34


35/46

11/4/2013 EUROSTAT 5 35


36/46

11/4/2013 EUROSTAT 5 36


37/46

11/4/2013 EUROSTAT 5 37


38/46

11/4/2013 EUROSTAT 5 38


39/46

11/4/2013 EUROSTAT 5 39


40/46

11/4/2013 EUROSTAT 5 40


41/46

11/4/2013 EUROSTAT 5 41


42/46

11/4/2013 EUROSTAT 5 42


43/46

11/4/2013 EUROSTAT 5 43


44/46

11/4/2013 EUROSTAT 5 44


45/46

11/4/2013 EUROSTAT 5 45


46/46

11/4/2013 EUROSTAT 5 46

eurostat pt. 5

Documents

Transcript of eurostat pt. 5