Scatter Plot Excel 2016 How To Put It

Writer Bio First published in 1998, Richard Gaughan has contributed to publications such as Photonics Spectra, The Scientist and other magazines.

Save 90 Local Sports Things to Do Business Travel Politics Opinions Homes Subscribe Archives Nation Jobs More Cars Video Apartments Shopping Classifieds Insider azcentral tickets Lottery Obituaries E-Newspaper Investigations Comics Buy Photos Apps Giving Back New Home Central Monsoons Business Directory Member Guide Traffic Moonlighting Advertise with Us USA TODAY NETWORK Public Notices Subscribe Home Local Sports Things to Do Nation Now Business Travel Explore Politics Opinion Investigations Marketplace Insider Advertise with Us Obituaries Archives Weather Subscribe How to Consolidate Duplicates in Excel How to Find the Tangent on a Graph in Excel How to Find the Y-Intercept of a Line of a Graph in Excel on a Mac by Richard Gaughan Related Articles How to Consolidate Duplicates in Excel How to Find the Tangent on a Graph in Excel How to Change the Intervals on an X-Axis in Excel How to Graph Simultaneous Differentials in Excel How to Make a Percentile Graph in Excel How to Create a Pie Chart With Google Spreadsheet Share on Facebook Linear relationships abound.

Ten customers in your store will buy roughly twice as much as five customers.

A service call five miles away will take about five times as much gasoline as a call one mile away.

All of those relationships can be described with linear equations.

Scatter Plot Excel 2016 How To Put It

If youve got data, but arent sure how to put it in that linear form, Excel for the Mac can help.

Analytical Solution Step 1 Open a new spreadsheet and type X into cell A1 and Y into cell A2.

Step 2 Enter your x values into column A starting in cell A2.

Enter the corresponding y values into column B, starting in cell B2.

Remember that each x value will have a corresponding y value matched to just that value.

Step 3 Select all the x-values, from cell A2 down the column to the end of the x values youve just entered in.

The dialogue box will come up with X, which you had entered above the data.

Accept that name by clicking OK, which will let you refer to all your x values using just the name X.

Step 4 Repeat Step 3 for the y values in column B, except the B column dialogue box will offer you the name Y, which you should accept.

Now X and Y refer to the data youve entered for x and y values.

Step 5 Click in cell D2 and type Intercept(Y,X) without quotes.

Graphical Solution Step 1 Select the cells containing the x and y values.

Step 2 Select the Charts toolbar, select the Scatter option and then select the Marked Scatter option.

Step 3 On the toolbar for Excel for Mac, select Layout 9 from the Quick Chart Layouts option.

Step 4 Extract the y-intercept value from the equation displayed on the graph.

The equation will be in the form y mx b where m is a number corresponding to the slope and b is a number corresponding to the y-intercept.

References Clemson University: Linear Regression and Excel Microsoft Office Support: Intercept Function Resources NC State University: Linear Regression in Excel Tips Remember, you type an equals sign as the first character in a cell where you want to enter a formula.

You can also have Excel compute the slope analytically as well; just type slope(Y,X) in whichever cell youd like to have display the slope of the line that best fits your data.

Scatter Plot Excel 2016 For Mac