Push the button «FILE»-«Options»-«Add-Ins».But faster it will make the add-on «analysis package». In Excel, there are built-in features with which you can calculate the parameters of the linear regression model. In our example as Y serves the indicator of employees who retired.

Where a – are the regression coefficients, x – the influencing variables, k – the number of factors. The linear regression model is as follows: It is necessary to determine the dependence of the number of employees who retired from the average salary.

On 6 enterprises was analyzed the average monthly salary and the number of employees who retired. And based on the main factors you may to predict, to plan the development of priorities areas, to make to the management decisions.Ĭonsider the example to the construction of a regression model in Excel and the interpretation of the results. The analysis result allows you to prioritize. Or: how to influence foreign investment, energy prices, etc. For example, it depends on the number of economically active population from the number of enterprises, the value of wages and other parameters. See their site for resources they have developed for teaching data analytics in introductory accounting.It shows the influence of some values (independent, substantive ones) on the dependent variable. Ohio Jennifer Cainas, CPA, DBA, is a clinical professor at the University of South Florida in Tampa and Tracie Miller-Nobles, CPA, is an associate professor of accounting at Austin Community College in Austin, Texas. Wendy Tietz, CPA, CGMA, Ph.D., is a professor of accounting at Kent State University in Kent. The next time you teach cost behavior, consider expanding your students' Excel skills by teaching them how to perform a simple linear regression, one of the many options within the Data Analysis function. Now that you have the regression results, you can discuss with the students the key pieces of information being displayed, including the coefficients (the intercept representing the fixed costs, and the X variable 1 representing the variable costs) and how to interpret the R square and adjusted R square values.

Mac excel linear regression