INTERCEPT

For a given series we can add a trend line which, by applying the selected mathematical function, approximates and shows the trend of data, which was discussed in one of the earlier posts. By displaying the value of R2 we can see how well we chose the function that approximates the data. How else can you improve the trend line appearance?

Cell attributes

Each cell in the worksheet can be blank or have some content (text, number). It can also have its own formatting elements. The CELL function allows you to read the attributes of a cell, however it is not nearly as powerful as the old GET.CELL macro function. In the following text, you will learn how to read cell attributes.

FREQUENCY function

The FREQUENCY function is used to calculate how often certain values ​​in a given range are repeated. This is an array function, and we can use it to calculate a distribution by which we can see how many points students have scored on a test and for other similar statistical analyzes. To help you understand how the function works will also illustrate this with a simple chart …

“D” functions

The “D” functions are used for multiple data aggregation in the given table. In essence, they do the same thing as “IFS” functions in a slightly more elegant way, and whether this way is better – you estimate yourself! By the way, I am an adversary when the “experts” describe tables as databases. Sometimes the database actually makes one table, but this is very rare. Now, at least you know what letter “D” in ther prefix stands for!

Trigonometric functions

If you are someone who likes mathematics it will be useful for you to know that Excel has a lot of trigonometric functions, and we can use them whenever is necessary to plot your sinusoids. These are the functions of SIN (sine), COS (cosine), TAN (tangent), COT (cotangent), and there are many others as well. If you are curious you can easily find them in the Excel function library. How to draw a sinusoid?