Leslie Kramer is a writer for Institutional Investor, correspondent for CNBC, journalist for Investopedia, and managing editor for Markets Group. Correlation measures the linear relationship between ...

A mathematical function is a formula that takes an input, x, applies a set of calculations to it, and produces an output called y. By calculating a function at a large number of set intervals, it is ...

Almost every day you can find in media commentary that XYZ is causing stocks to fall (or rise). Such definitive statements are common—but what’s almost always missing is statistical proof. And if you ...

Microsoft has recently added a new feature to excel in the form of the extremely useful Scan Function. This guide aims to provide a quick overview of how you can get the most from this new function ...

Microsoft Office's Excel application allows users to store, model and manipulate data sets. Excel spreadsheets organize this data into worksheets, each with a number of rows and columns. Each row or ...

When you dive into the world of Microsoft Excel spreadsheets, you quickly realize how powerful its functions can be. One such function that you will find incredibly useful is the RANK function. This ...

Excel's PIVOTBY function and PivotTables both summarize and reorganize data, allowing for detailed analysis by grouping and aggregating your figures. However, despite their similar names, the methods ...

Suzanne is a content marketer, writer, and fact-checker. She holds a Bachelor of Science in Finance degree from Bridgewater State University and helps develop content strategies. Learn about our ...

Excel's AGGREGATE function lets you perform calculations whilst ignoring hidden rows, errors, or other functions that appear in the data. It's similar to the SUBTOTAL function but provides more ...