FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Average This 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.

Detailed explanation-2: -To calculate the mean of grouped data, the first step is to determine the midpoint (also called a class mark) of each interval, or class. These midpoints must then be multiplied by the frequencies of the corresponding classes. The sum of the products divided by the total number of values will be the value of the mean.

Detailed explanation-3: -AutoSum lets you find the average in a column or row of numbers where there are no blank cells. Click a cell below the column or to the right of the row of the numbers for which you want to find the average. On the HOME tab, click the arrow next to AutoSum > Average, and then press Enter.

Detailed explanation-4: -It’s obtained by simply dividing the sum of all values in a data set by the number of values. The calculation can be done from raw data or for data aggregated in a frequency table.

Detailed explanation-5: -The average is the sum of all values divided by the number of values. It is also sometimes referred to as mean. In statistics, the mean is the average of the given sample or data set. It is equal to the total of observations divided by the number of observations.