Summary  
Built-in statistical functions perform descriptive analyses—such as computing average, maximum, minimum, and median—on numerical data by accepting numbers, ranges, or references as arguments.  

General domain of usage  
Academic performance evaluation (e.g., analyzing students’ grades)

We will consider the most well-known **statistical functions** and their use.
**Arguments** for these functions can be numbers, names, ranges, or references to cells **containing numbers**.

Download the file containing information about students' grades in the Statistics course on a 100-point scale. Find the average value, maximum, minimum grade, and median.

Unlock the power of Excel for data analysis! In this course, you will acquire the essential skills and knowledge needed to harness Excel's full potential as a data analysis tool. From mastering formulas and functions to visualizing data with charts and graphs, you'll gain the expertise to confidently navigate Excel's features. Whether you're a beginner or looking to enhance your existing Excel skills, this course will equip you with the tools to excel in data analysis. Join us and take your data manipulation and interpretation abilities to the next level.

Begin your Excel journey by learning essential basics: navigating the interface, entering data, and understanding Excel's basics.

Master the art of formulas in Excel, from simple calculations to advanced data manipulation techniques for efficient analysis.

Explore Excel's powerful functions! Learn Logical, Mathematical, and Statistical functions to boost your data analysis skills.

Learn to transform data into insightful visuals. Explore chart creation and formatting to effectively communicate your findings and enhance data-driven decision-making.

Efficiently manage and organize data within Excel. Discover techniques for data sorting, filtering, and handling large datasets with ease.

Dive deep into Excel's advanced capabilities. Explore topics such as pivot tables, macros, and data analysis tools to elevate your Excel proficiency.

Statistical Functions

1. What is the average grade?

2. What is the maximum grade?

3. What is the minimum grade in the course?

4. What is the median?