Excel Forum

Excel Magic Trick # 265: Mixed Cost Accounting Linear Regression - Ron's Class

See how to do Linear Regression 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.
Excel Magic Trick # 265: Cost Accounting Linear Regression (Excel Magic Trick #265)
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
To see how to use the Excel Add-in Data Analysis feature, see this video:
Stats 08: Install Excel 2007 Data Analysis Add-in
Ron Sabado Accounting Class

Got a Question? Ask it Here in the Forum.