Two columns or rows of data in Microsoft Excel may contain useful information, but you'll just have a set of numbers. You can give spreadsheet viewers a graphical representation of those numbers by ...

A scatterplot chart graphs two related data values as a single dot by plotting one value on the horizontal X axis and the other value on the vertical Y axis. For example, you could plot an employee's ...

So, you want to know how to create a scatter plot in Excel. Chances are, you probably already know what the term means, but given Microsoft Excel’s arsenal of options packed into each tab, getting ...

If you understand the definition of a mathematical function, a good way to judge it is that any line drawn parallel to the y-axis intersects with the values in the function’s curve only once. The same ...

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 ...

In today’s fast-paced business world, the ability to create visually compelling and informative Excel charts is a crucial skill for semi-technical professionals. Whether you’re presenting data to ...

Despite the chant that correlation is not causation, some researchers believe the design of scatter plots nudges us to the wrong conclusions. Can a change in their design lessen that risk? Analyzing ...