Прочетете за отчитане Основи, Счетоводни системи, Финансово-счетоводен, Бизнес Счетоводство, Бизнес счетоводен софтуер
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 Счетоводство Linear Regression (Excel Magic Trick #265) This video is for a Highline Community College Cost Счетоводство 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 …
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=?