Calculate Cost Accounting Linear Regression in MS Excel

>> August 2, 2010


The following video screencasts describes how you can easily do linear regression  in ms excel  for determining what part of a mixed cost is a Fixed Cost and what part is a Variable Cost. Also See how to create a Scatter Diagram and add Trend Line.



This video is for a Highline Community College Cost Accounting Class.

The SLOPE (m) function calculates the slope of the linear equation y = m*x + b

The INTERCEPT (b) function calculates the intercept of the linear equation y = m*x + b

The RSQ (r^2) function calculates the Coefficient Of Determination (how much influence x has on y)

The symbol carrot ^ (Shift + 6) is used for exponents

The ROUND function must be used when:
1) multiplying decimals;
 2) you are required to round (money requires that you round because the smallest unit is a penny); 3) you will use your formula results in subsequent formulas.

How to Calculate Cost Accounting Regression in MS Excel






You might like:


Follow Us


0 comments:

Post a Comment

About Accounting Education


An educational site with 2500+ articles, solutions, video-guides and tutorials on all topics related to accounting and finance.

Get Update on Mobile


Type svtuition.org in your mobile phone web browser for free access anytime, from any place.The content is designed specifically for cell phones and mobile devices.

Contact Us


Contact us Send an Email Phone number and vCard LinkedIn profile Follow us on twitter