Accountants

Accounting Term: What Is Simple Linear Regression Analysis?

The best way for you to help your small business clients grow and strategize is to look for successful trends. It’s also equally important to be able to guess what costs or outcomes will happen in their future. In both of these situations, it’s useful to calculate simple linear regression. This analysis technique uses one variable to predict the value of another variable. The standard formula is written as y= x+b, where y is what you’re trying to find, x is the variable the outcome depends on, and b is the value if your activity is zero.

Say you want to guess what your client’s commission expense will be if its salesperson sells more goods. For each successful sale, the salesperson gets $100. Even if the salesperson fails to sell anything, your client still agrees to pay $250 per month. Your simple regression formula is y = 100m + 250. If the salesperson sells 10 units, plugging in 10 as the value for m lets you know your client will end up paying $1,250. If the salesperson sells 20 units, the pay is $2,250.

This type of analysis is fundamental to creating your client’s budget. You can only guess what the business activity will look like in the future based on cost behaviours . It’s easier to make these predictions about what will happen and use expense trends to figure out the costs. Instead of guessing that the commission expense will be $2,250, it’s easier to conceptualize a guess of the salesperson selling 20 units (which results in $2,250 of expenses).

Linear regression is also useful for analyzing your client’s marketing effectiveness. You can input what it spends (the x variable) to predict how many customers will visit its website or respond to a public advertisement. You can also guess what the revenue will be in future periods. If you know what sales prices will be, you can enter in different sales volumes to predict total revenue.

Simple linear regression is a fairly simple, yet effective, analysis tool. By using a few bits of information, you can predict what will happen to your client in the future. Although it’s not useful in all situations, you can easily leverage this tool to predict certain types of revenue, expenses, or market activities.


Related Articles

Your privacy

We collect data when you use our website to improve its performance. Doing so also helps us provide a secure, personalized experience. Select 'Accept cookies' to agree or 'Cookies settings' to choose which cookies we use. You can change your preferences anytime by clicking the 'Manage cookies' link in the footer.

Choose your cookie preferences

Some cookies are needed to make our website work and can't be turned off. But we need your consent to use others that are not essential. You can make your choices below and update them at any time using the 'Manage Cookies' link. To find out more, visit our Cookies Policy.

These cookies are necessary for the site to function. They also help us keep your data safe.
These cookies allow us to enhance your experience and remember your preferences, region or country, language, and accessibility options.
These cookies tell us how customers use our website. We study and organize this data to help us optimise our content and provide you with personalised experiences.
These cookies help us provide you with relevant communications and ads in our products and on other sites.

Looking for something else?

Get QuickBooks

Smart features made for your business. We've got you covered.

Firm of the Future

Expert advice and resources for today’s accounting professionals.

QuickBooks Support

Get help with QuickBooks. Find articles, video tutorials, and more.