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

.
.
Name

false
ltr
item
Accounting Education: Calculate Cost Accounting Linear Regression in MS Excel
Calculate Cost Accounting Linear Regression in MS Excel
http://1.bp.blogspot.com/_DJEIRrK4tl4/TFcFZdzWAGI/AAAAAAAAFyc/OIqhD80Ns-E/s640/excel+cost+accounting.PNG
http://1.bp.blogspot.com/_DJEIRrK4tl4/TFcFZdzWAGI/AAAAAAAAFyc/OIqhD80Ns-E/s72-c/excel+cost+accounting.PNG
Accounting Education
http://www.svtuition.org/2010/08/calculate-cost-accounting-linear.html
http://www.svtuition.org/
http://www.svtuition.org/
http://www.svtuition.org/2010/08/calculate-cost-accounting-linear.html
true
2410664366776677676
UTF-8