CORREL function - Microsoft Support
As much as the correlation coefficient is closer to +1 or -1, it indicates positive (+1) or negative (-1) correlation between the arrays. Positive correlation means that if the values in one array are increasing, the values in the other array increase as well.
Create a waterfall chart - Microsoft Support
Use the waterfall chart to quickly see positive and negative values impacting a subtotal or total value. Waterfall charts are often used to visualize financial statements, and are sometimes called bridge charts.
Add, change, or remove error bars in a chart - Microsoft Support
For example, you can show a 10 percent positive and negative error amount in the results of a scientific experiment like this: You can use error bars in 2-D area, bar, column, line, xy (scatter), and bubble charts.
SKEW function - Microsoft Support
Returns the skewness of a distribution. Skewness characterizes the degree of asymmetry of a distribution around its mean. Positive skewness indicates a distribution with an asymmetric tail extending toward more positive values. Negative skewness indicates a distribution with an asymmetric tail extending toward more negative values. Syntax
TREND function - Microsoft Support
It fits a straight line (using the method of least squares) to the array's known_y's and known_x's. TREND returns the y-values along that line for the array of new_x's that you specify.
Use conditional formatting to highlight information in Excel
The example shown here uses data bars to highlight dramatic positive and negative values. You can format data bars so that the data bar starts in the middle of the cell, and stretches to the left for negative values.
Trendline options in Office - Microsoft Support
A logarithmic trendline can use negative and positive values. A logarithmic trendline uses this equation to calculate the least squares fit through points: where c and b are constants and ln is the natural logarithm function.
Create conditional formulas - Microsoft Support
Testing whether conditions are true or false and making logical comparisons between expressions are common to many tasks. You can use the AND, OR, NOT, and IF functions to create conditional formulas. For example, the IF function uses the following arguments. Formula that uses the IF function. logical_test: The condition that you want to check.
Available chart types in Office - Microsoft Support
A waterfall chart shows a running total of your financial data as values are added or subtracted. It's useful for understanding how an initial value is affected by a series of positive and negative values. The columns are color coded so you can quickly tell positive from negative numbers.
Excel functions (alphabetical) - Microsoft Support
Financial: Returns the internal rate of return where positive and negative cash flows are financed at different rates. MMULT function. Math and trigonometry: Returns the matrix product of two arrays. MOD function. Math and trigonometry: Returns the …
Using IF with AND, OR, and NOT functions in Excel
In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False.