lkplet.blogg.se

Teknomo, Kardi (2015) Regression Model using Microsoft Excel. Preferable reference for this tutorial is We get the same results as the manual computation that the slope is 0.136, intercept is -267.2 and the prediction of population for the year 2005 is 5.48 (times hundred thousand people). To predict the population (Y value) for the year 2005, we can name the slope, intercept and next year cells (using insert name defined as in step 1) and then compute the prediction = next_year * slope + intercept. To determine the intercept of the linear regression line, type = Intercept (Population, Year) as shown in the figure belowĤ. To compute the slope of linear regression line using MS excel function, type =Slope(Population, Year) as shown in the figure belowģ. For example, the name is Year and PopulationĢ. For each column, we put name of the array using MS excel menu Insert-Name-Define. We put the data in two columns table in the spreadsheet as shown in the figure below. Suppose we have the following 5 data points and we want to predict the population data for the year 2005 using linear regression model.ġ. Microsoft Excel has built in function SLOPE and INTERCEPT to calculate linear regression slope and intercept. Regression analysis describes the relationships between a set of independent variables and the dependent variable.