In Excel 2003, point to Column on the Format menu, and then click AutoFit Selection.In Microsoft Office Excel 2007, click the Home tab, click Format in the Cells group, and then click AutoFit Column Widths.With the pasted range still selected, use one of the following procedures, as appropriate for the version of Excel that you are running: =AVERAGE(A2:A7) - 0.775280899*AVERAGE(B2:B7)Īfter you paste this table into your new Excel worksheet, click the Paste Options button, and then click Match Destination Formatting. To illustrate the INTERCEPT function, create a blank Excel worksheet, copy the following table, select cell A1 in your blank Excel worksheet, and then paste the entries so that the following table fills cells A1:D13 in your worksheet. Frequently, INTERCEPT includes 2 ranges of cells containing the data, such as INTERCEPT(A1:A100, B1:B100). The arguments, known_y's and known_x's, must be arrays or cell ranges that contain equal numbers of numeric data values. The INTERCEPT( known_y's, known_x's) function returns the INTERCEPT of the linear regression line that is used to predict y values from x values.
#STATISTICAL ANALYSIS MICROSOFT EXCEL 2013 HOW TO#
This article discusses the INTERCEPT function in Microsoft Excel, illustrates how to use the function, and compares its results for Excel 2003 and for later versions of Excel with its results in earlier versions of Excel. For more information about this change, read this blog post. Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise.