Excel Magic Trick # 265: Mixed Cost Accounting Linear Regression

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