Task: we want to find the coefficients for the linear regression equation y = b*x + a to forecast sales using the LINEST function. Then it returns an array that describes that straight line. The LINEST function in Excel uses the least-squares regression method to analyze a dataset and calculates a best-fit straight line. Apply Formulas to Forecast Sales by Using Regression Analysis in Excel 2.1 Use of LINEST Function Read More: How to Forecast Sales in ExcelĢ. Now, with the regression equation, we can predict sales for a given no of ads. Step 3: Build the Linear Regression Equation with the Coefficientsįrom the analysis result, use the coefficients Intercept and No of Ads to write the Linear regression equation as. (iv) click on the New Worksheet Ply option. (ii) choose the No of Adds column as the Input X Range. (i) choose the Sales column as the Input Y Range.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |