This post shows how to use the TRUNC function in Excel. Use it to remove or truncate decimals, time from date-time format, etc. It is the opposite of Round.

Calculating the Pearson correlation coefficient can be complicated but software makes it much easier. You can use several methods to calculate correlation in Excel.