How do you work with statistics in Microsoft Excel?

Microsoft Excel makes it ridiculously easy to work with statistics. Excel has a number of built-in functions that you can use relatively easily. These are backed up with enough documentation to use the functions.

These four steps show how:

Access Add a function using fx:

Insert function window opens as shown.

In the Insert Function window scroll down the drop-down list and choose 'Statistical'. This has a long list of functions available.

Let us take an example of the function 'Trend'

Scroll down the available function list till you get to 'Trend' as shown.

Click  the 'Help on this function' link. The web page (https://tinyurl.com/y5r94tp5) for this function opens. A part of this page's image is shown here:

If the tiny URL does not work, try this ugly link:

https://support.microsoft.com/en-us/office/trend-function-e2f135f0-8827-4096-9873-9a7cf7b51ef1?ns=excel&version=90&syslcid=1033&uilcid=1033&appver=zxl900&helpid=xlmain11.chm60098&ui=en-us&rs=en-us&ad=us