Read For Accounting Basics, Accounting Systems, Financial Accounting, Business Accounting, Business Accounting Software
- Subscribe to this RSS feed
- Receive updates as soon as they are posted.
- Subscribe to this RSS feed
- Receive updates as soon as they are posted.
Excel Magic Trick # 265: Mixed Cost Accounting Linear Regression
June
18 ,
2009 Posted by
Vaccountancy In:
General Accounting ,Financial , Business
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 …
Related posts:
- Excel Magic Trick #132: Borders For an Accounting Template
- Accounting From Community College Is Different From Accounting At A 4 Yr School?
- Accounting From Community College Is Different From Accounting At A 4 Yr School?
- Learning Accounting for Your Business
- Accounting for community college is different from the school of accountancy in 4 years?
You can follow any responses to this entry through the
RSS 2.0 feed.
You can leave a response, or trackback from your own site.
6 Responses to “Excel Magic Trick # 265: Mixed Cost Accounting Linear Regression”
Leave a reply
Categories
Office Products
Translation
by 
ExcelIsFun
June 18th, 2009 at 5:44 pm
Dear y0ung01,
One way is to use the RSQ function:
=RSQ(y-values,x-values)
–excelisfun
y0ung01
June 18th, 2009 at 5:44 pm
How do you find the r squared?
ExcelIsFun
June 18th, 2009 at 5:44 pm
Dear andrewbottom1,
If the Excel is hard, try this video and the others in is this series:
Excel Basics #1: What Is Excel?
–excelisfun
andrewbottom1
June 18th, 2009 at 5:44 pm
Interesting kinda hard though for me.
ExcelIsFun
June 18th, 2009 at 5:44 pm
Dear TiffanySouthall ,
independent = predictor = x
dependent = predicted = y = f(x)
–excelisfun
TiffanySouthall
June 18th, 2009 at 5:44 pm
can you clarify which is the independent and dependent varable. If y=predictor then what is x=?