Course Outline
Join PRO

What is simple linear regression analysis?

Author:
Harold Averkamp, CPA, MBA

What is Simple Linear Regression Analysis

Simple linear regression analysis is a statistical tool for quantifying the relationship between one independent variable (hence “simple”) and one dependent variable based on past experience (observations).

Based on entering a reasonable number of observations of the independent and dependent variables, regression software will compute the best fitting straight line (hence “linear”) that expresses the average relationship between the dependent and independent variable.

Simple linear regression analysis is helpful in determining the two components of a mixed cost (also known as semivariable cost):

  • The amount that is fixed or constant
  • The variable rate (the rate by which the total cost changes when there is one additional unit of the independent variable)

Example of Simple Linear Regression Analysis

Assume that a manufacturer wants to know the amount of its monthly electricity bill that is a fixed amount and how much the electricity bill changes when the number of production machine hours change. The manufacturer will look at the amount of each month’s electricity bill (the dependent variable) and then determine the number of production machine hours (the independent variable) that occurred between the meter reading dates indicated on the bill.

The amount of each bill and the related production machine hours for the bill are entered into the regression software. The software determines the best fitting line based on the amounts entered. The line is expressed as y = a + bx, where:

  • y is the estimated monthly electricity cost (the dependent variable)
  • a is the average fixed amount of a monthly electricity bill
  • b is the rate per machine hour that causes a change in the monthly electricity bill
  • x is the number of production machine hours (the independent variable) for the period of the electricity bill

The software will also provide statistics for the following: correlation, confidence, dispersion around the line, and more.

In all likelihood there will be more than one independent variable that causes the change in the amount of the dependent variable. The multiple independent variables along with the dependent variable for each observation can be entered into multiple regression software.

It’s always wise to review a graph of the past observations. You may be able to see a pattern of the points as well as any outlier(s). Also keep in mind that correlation does not guarantee there is a cause and effect relationship.

Join PRO to Track Progress

Advance Your Accounting and Bookkeeping Career

Must Watch image

  • Perform better at your job
  • Get hired for a new position
  • Understand your small business
  • Pass your accounting class
Watch the Video
Certificates of Achievement

Earn Our Certificates of Achievement

Certificates of Achievement
  • Debits and Credits
  • Adjusting Entries
  • Financial Statements
  • Balance Sheet
  • Income Statement
  • Cash Flow Statement
  • Working Capital and Liquidity
  • Financial Ratios
  • Bank Reconciliation
  • Accounts Receivable and Bad Debts Expense
  • Inventory and Cost of Goods Sold
  • Depreciation
  • Payroll Accounting
View PRO Plus Features

Join PRO or PRO Plus and Get Lifetime Access to Our Premium Materials

Read all 2,866 reviews

Features

PRO

PRO Plus

Features
Lifetime Access (One-Time Fee)
Explanations
Quizzes
Q&A
Word Scrambles
Crosswords
Bookkeeping Video Training
Financial Statements Video Training
Flashcards
Visual Tutorials
Quick Tests
Quick Tests with Coaching
Cheat Sheets
Bookkeeping Study Guide
Managerial Study Guide
Business Forms
All PDF Files
Progress Tracking
Earn Badges and Points
Certificate - Debits and Credits
Certificate - Adjusting Entries
Certificate - Financial Statements
Certificate - Balance Sheet
Certificate - Income Statement
Certificate - Cash Flow Statement
Certificate - Working Capital
Certificate - Financial Ratios
Certificate - Bank Reconciliation
Certificate - Accounts Receivable and Bad Debts Expense
Certificate - Inventory and Cost of Goods Sold
Certificate - Depreciation
Certificate - Payroll Accounting
Motivational Badges
Motivational Points
Medal Rankings
Activity Streaks
Custom Public Profile Page of Achievements

About the Author

Harold Averkamp

For the past 52 years, Harold Averkamp (CPA, MBA) has
worked as an accounting supervisor, manager, consultant, university instructor, and innovator in teaching accounting online. He is the sole author of all the materials on AccountingCoach.com.

Learn More About Harold

Read 2,866 Testimonials

Take the Tour Join Pro Upgrade to Pro Plus