how to compute least squares regression line excel for a mac

You can use Excels Regression tool provided by the Data Analysis add-in.

For example, say that you used the scatter plotting technique, to begin looking at a simple data set.

And, after that initial examination, suppose that you want to look more closely at the data by using full blown, take-no-prisoners, regression.

Then use the Input X Range text box to identify the worksheet range reference holding your independent variables.

If your input ranges include a label, select the Labels check box.

To place the regression results into a range in the existing worksheet, for example, select the Output Range radio button and then identify the range address in the Output Range text box.

To place the regression results someplace else, select one of the other option radio buttons.

Below that information, the Regression tool supplies analysis of variance (or ANOVA) data, including information about the degrees of freedom, sum-of-squares value, mean square value, the f-value, and the significance of F.

Excel also plots out some of the regression data using simple scatter charts.

He is the author of more than 100 books, including QuickBooks For Dummies and Quicken For Dummies.

How To Compute Least Squares Regression Line Excel For A Mac