Advice 1: How to calculate the average age of employees

In order to determine the prospects of development of the company for several years, is to determine the average age of employees. It is important to know in order to correctly build the personnel policy. If the average age corresponds to the pre-retirement, management should be alert and to think about the training of new employees. In addition, the average age of the staff may need in order to beautifully represent the firm in the competition or to create a presentation video. The average age of the employees can do a lot to tell customers or prospective partners about the company, about how successfully it combines experience and youth.
How to calculate the average age of employees
You will need
  • - data on the number of employees;
  • - dates of birth of all employees.
Calculate the total age of the employees. Data about how old we are, we can take in HR, in accounting or record Keeper, depending on the size of the enterprise. If the firm is small, it is possible the age of each employee to calculate separately, and then all the data are folded using a calculator or even in a column on a piece of paper.
If the company is large and employees a lot, break team into groups according to age. Most likely, in the personnel Department or in accounting there is a complete list of employees with years of birth. Copy the table, put it into Excel and sort by age. Calculate the total age of each group by multiplying the age of the participants at their number. Calculate the total age of the whole team, to put the results of all groups.
Divide total age by number of employees. Don't be surprised if will be not an integer and a fraction. As it should be. Age can be approximated. If you are preparing a presentation or something like a "passport" you can say something like: "the Average age of employees of our company — 29 years."
In exactly the same way we can calculate the average age of the villagers and even small towns. The necessary statistical data can be taken from the results of the last census.
Useful advice
To calculate months and days is not necessary. Take only the number of complete years;

If you need statistical data in the personnel Department did not show up, survey the employees. It can be anonymous, since you only need the number of years and number of employees.

Advice 2: How to determine the average age of employees

The average age of employees is determined by calculating the arithmetic mean ageov all employees of the office. Accordingly, to determine the average age for employees in positions of the same level, it is necessary to compute such arithmetic mean.
How to determine the average age of employees
The average age of employees of the company has implications for policy: a system of evaluation and promotion for the "young" and more "the age ofgovernmental" offices varies. Therefore, the HR Manager sometimes it is necessary to calculate the average age of employees.
To calculate the average age of employees of the company, you need to calculate the arithmetic average ageof ov employees of the company. It is calculated as follows: age of all employees is formed and divided by their number. As a rule, is taken to count the actual number of years an employee at a given date (i.e., if in November this year he will be 40 years old, and now until April, you must take 39 years).
Example determine the average ageand employees of the company.
In the company N. 10 employees. One of them is 18, two is 20, three in 35, four 40. You must combine the age of all employees:
18 + 20X2 + 35х3 + 40х4 = 323
This number is divided by 10 (number of employees). The result is 32.3. This is the average age of employees of the company N.
Sometimes managers calculate the average age of employees of the company in the same position. This is useful for understanding what kind of people should be hired for these positions further, because employees (particularly at not very high positions) is more comfortable to work with peers or those slightly older than them. For example, if the average age of paralegals N. company equal to approximately 24 years, for this position it is better to hire people for about 22-26 years old.

Advice 3: How in Excel to calculate the age

Software packages Microsoft Office Excel, Gnumeric and Calc can not only create and edit spreadsheets, but also to carry out calculations. You can, for example, to enter birth years are listed in the list of people and automatically calculate their age.
How in Excel to calculate the age
Take in table one cell for the number of the current year. Type the appropriate number (always four-digit and two-digit abbreviated). In all the following examples it will be assumed that the number of the current year entered in cell A1.
You can also do to the current year was set automatically. Then the value of the corresponding cell can not modify manually every year, but it is correct computations will be implemented only if the computer is properly set the clock and calendar. Use the following formula: =year(today()) in the Russian version or =year(today ()) in English. In the program Gnumeric here and further use the operators in English, even if the program interface is in English.
In the cell where you want to be a person's age, enter the following expression: =A1-Xn, where Xn is the cell where is the number of the year of birth of the same person. For example, if it is located in cell B4, the formula will be: =A1-B4.
This method is inconvenient that the date of birth for all listed in the table of people accepted for the first of January, and the age is calculated without taking into account the factor that birthdays can have on the middle or the end of the year. To calculate the age more accurately, put into cell A1 the current date in the format configured for the used office package (these settings can be changed). For example, if the date format is DD/mm/yyyy and today 6 April 2012, enter into this cell 06/04/2012. Note that in this case, to change the contents of the cell will have to manually every day. To avoid this, enter the expression: =today() or =today(). In this case, as in the previous case, make sure that you correctly set the clock and calendar.
Instead of the year of birth of the person specify in the corresponding cell and his date of birth in the format in which configured office Suite. And in the cell that must be specified is automatically calculated age, enter the following expression: =datedif(A1;Xn;"y") or =Rashat(A1;Xn;"y"). For example: =datedif(A1;B4;"y"). The letter y is in both cases Latin.

Advice 4: How to round all numbers in Excel

Automatic implementation of arithmetic operations in Excel is certainly a convenient feature that considerably facilitates work with large data sets. However, as a result, for example, division can get a number with lots of decimal places. In this situation it is necessary to do the rounding.
How to round all numbers in Excel
The operation of rounding numbers in Excel are fairly simple, so it will not cause special difficulties even for the beginner. At the same time, like most other operations, it can be applied to individual numbers or to the whole array of the desired numbers.

The choice of array for rounding

In order to give the program to understand what part of the database should extend the operation of rounding, it is necessary to allocate a portion of the array, subject to its implementation. This can be done by clicking the left mouse button on the desired cell and stretching the field highlight to the desired number of cells. However, in the process you may find that the array to be rounded is discrete, i.e., discontinuous. One of the most obvious but also the most time consuming of the options in this case will alternate rounding in each part of the array. You can do it simpler: when implementing the selection, press and hold the Ctrl key. This will allow you to select with the mouse the intermittent data sets, against which you can later implement a common operation. Finally, the third way is to set the data array to be rounded up with a formula.

The operation of rounding fractions

In order to produce the rounding of allocated numbers, should click on one of the cells in the region subjected to selection with the left mouse button. This will bring up a menu, one of which is "Format cells" - it should select. In the menu in turn, you will see several tabs: the settings you want are located under the tab "Number." This section allows you to select the type of numbers that is in the selected cells. In order to carry out the operation of rounding, it is necessary from the offered list to choose the format labeled "Numeric". Selecting this format will bring up a menu with additional settings. One of the items on this menu is the number of decimal places, which you can choose on your own. In this case the number written in each of the rounded cells, will not change as a result of this operation, since only changes the format of his images. Thus, you can likewise go back to the original format or select another type of rounding.

Rounding integers

In order to carry out the rounding of integers, use the round function. In parentheses after the symbol add function the first argument is the name of the cell or specify the dataset to which to apply the operation, and the second argument is the number of significant digits to be used when rounding. The same method can be used for rounding off fractions. So, bit 0 will cause the rounding of a number to an integer value. The discharge equal to 1, rounded to 1 digit after the decimal point. Category -1 - rounding up to the first ten. Suppose you want to round the number 1003, located in cell A2 to the nearest thousand. In this case, the function will look like this: =round(A2,-3). The result in the specified cell will display the number 1000.
Is the advice useful?