How to Make a Graph in Excel With Word and Number Variables. Microsoft Excel can perform numerous statistical functions, as well as create charts from statistical data. Statistical data includes ...

. A line graph should be used when the independent and dependent variables are continuous . A bar chart should be used if the independent variable is categoric close ...

Learn how to graph linear regression in Excel. Use these steps to analyze the linear relationship between an independent and a dependent variable.

The line of best fit is used to show a trend or correlation between the dependent variable and independent variable (s). It can be depicted visually, or as a mathematical expression.