Although Excel is capable of calculating a number of descriptive and inferential statistics for you, it is often better to show a visual representation of data when presenting information to a group. Using Excel’s built in trendline function, you can add a linear regression trendline to any Excel scatter plot. Inserting a Scatter Diagram into Excel Suppose you have two columns of data in Excel and you want to insert a scatter plot to examine the relationship between the two variables

View post:
Add a Linear Regression Trendline to an Excel Scatter Plot

One of the limitations of subtracting dates in Excel is that the application can only give you either the number of days, the number of months within a single year, or the number of years without regard for the days and months between the two dates. Luckily, Microsoft included a built in Excel function to give you precise differences between two dates in a worksheet

View post:
How to Use the YEARFRAC Function in Excel

Placing date and time stamps into Excel is easy enough but sometimes you need to know the number of days, months, or years between two different dates. Researchers often do this to figure out how old a research subject was at a given point in time and financial calculations often involve analyzing money from different points in time.

More here:
How to Subtract Dates in Excel