FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Statistical functions are used when a mathematical process is required for a range of cells, such as summing the values in several cell locations. For these computations, functions are preferable to formulas because adding many cell locations one at a time to a formula can be very time-consuming.

Detailed explanation-2: -The most common statistical functions used by data analysts and professionals in this field are the MODE, MEDIAN, STANDARD DEVIATION, VARIANCE, AVERAGE, QUARTILES, CORRELATION, etc.

Detailed explanation-3: -Descriptive statistics are used to describe the basic features of the data in a study. They provide simple summaries about the sample and the measures.

Detailed explanation-4: -Following are the functions of Statistics : (i) Statistics presents complex facts into simple and definite form. (ii) Statistics helps in condensing vast statistical information into a few significant figures. (iii) Statistics facilitates comparisons among similar data. Suggest Corrections.