how to plot a graph in excel and get a funtion

Chris Gayle - Rohit Sharma - Dhoni - Virat Kohli

Having said that, the batting scores mean and variance/standard deviation also comes into the picture in taking the final decision on who to put larger money on. What's the main reason we want to understand the trend line? The primary goal is to assess who could the larger money be put in order to acquire him for the team? The batsman who has the largest upward trend line with the highest slope is the one I would like to put my money on. In this post, we will consider an example of IPL average batting scores of Virat Kohli, Chris Gayle, MS Dhoni, and Rohit Sharma of the last 10 years and assess the trend related to their overall performance using trend lines. As a data scientist, it proves to be helpful to learn the concepts and related Python code, which can be used to draw or add the trend line to the line charts as it helps understand the trend and make decisions. It is best used for continuous data.In this article, you will learn how to add a trend line to the line chart/line graph using Python Matplotlib.

Line charts do not display discrete data very efficiently.

These are better suited to dealing with whole numbers.

You can also not use line charts to represent percentages.

With increasing data sets, the readability of your line chart will be compromised.

Line graphs are not very efficient in representing large data sets that go over multiple rows.

how the answers from a survey is divided between age groups.

Line graphs are not good at visualizing the proportions of a whole.

A few cases are such that line graphs simply can’t handle the data.

There are only so many instances where you cannot and must not use a line graph. You want users to decipher the data (or a trend) in a simple, easy, and fast manner.You want to show the increase or decrease of a trend over time.You want to display data from multiple sets at one time.

A line graph is very effective in representing small sets of periodic data.

How to plot a graph in excel and get a funtion