## You are learning Data Analysis and Visualization in MS Excel

What are common data analysis functions in Excel (SUM, AVERAGE, COUNTIF, etc.)?

You're right! SUM, AVERAGE, and COUNTIF are definitely some of the most common data analysis functions in Excel. Here's a breakdown of these and other frequently used functions for data analysis:

Basic Functions:

* SUM: Calculates the total of a range of numbers. (e.g., `=SUM(A1:A10)`)

* AVERAGE: Calculates the average of a range of numbers. (e.g., `=AVERAGE(B2:B15)`)

* COUNT: Counts the number of cells containing numbers or text in a range. (e.g., `=COUNT(C1:C20)`)

* COUNTIF: Counts the number of cells within a range that meet a single criterion. (e.g., `=COUNTIF(D3:D25, ">50")`)

Statistical Functions:

* MIN: Returns the smallest value in a range. (e.g., `=MIN(E4:E32)`)

* MAX: Returns the largest value in a range. (e.g., `=MAX(F1:F18)`)

* MEDIAN: Calculates the middle value in a sorted range of numbers. (e.g., `=MEDIAN(G5:G13)`)

* STDEV: Calculates the standard deviation of a range of numbers. (e.g., `=STDEV(H2:H29)`)

* VAR: Calculates the variance of a range of numbers. (e.g., `=VAR(I7:I22)`)

Logical Functions:

* IF: Checks a logical condition and returns a value based on whether the condition is TRUE or FALSE. (e.g., `=IF(J3>100, "Pass", "Fail")`)

* AND: Returns TRUE if all conditions specified are TRUE, otherwise FALSE. (e.g., `=AND(K1>0, K1<5)`)

* OR: Returns TRUE if any of the conditions specified are TRUE, otherwise FALSE. (e.g., `=OR(L8="Apple", L8="Orange")`)

Lookup and Reference Functions:

* VLOOKUP: Searches for a specific value in the leftmost column of a table and returns a corresponding value from a different column in the same row. (e.g., `=VLOOKUP(A1, B1:E10, 3, FALSE)`)

* HLOOKUP: Similar to VLOOKUP, but searches for a value in the top row of a table and returns a corresponding value from a different row in the same column.

* INDEX & MATCH: A powerful combination for flexible lookups within a table.

* XLOOKUP: A newer function offering a more versatile way to search for and return data from a table.

Other Useful Functions:

* CONCATENATE: Combines text from multiple cells into a single cell. (e.g., `=CONCATENATE(A2, " ", B2)`)

* LEFT/RIGHT: Extracts a specific number of characters from the left or right side of a text string.

* TRIM: Removes extra spaces from a text string.

* LEN: Returns the number of characters in a text string.

* SUMIFS/AVERAGEIFS/COUNTIFS: Similar to SUM/AVERAGE/COUNT, but allow applying multiple criteria simultaneously.

This is just a selection of some of the most common data analysis functions in Excel. By mastering these and exploring others, you can unlock the power of Excel for analyzing and summarizing your data.