use excel for data a graph and word to answer question

Question

Sultana · Accepted Answer

Problem 2-28A Estimating fixed and variable cost using the regression method
a)
By using the scatter plot, using Excel, we have
So, it can clearly be written on the basis of above scatter plot that for describing the how total office support costs can be estimated:
b)
By using Excel, the regression summary output is given below:
	SUMMARY OUTPUT
	
	
	
	
	
	
	
	
	
	
	
	
	
	Regression Statistics
	
	
	
	
	
	Multiple R
	0.91155
	
	
	
	
	
	R Square
	0.830923
	
	
	
	
	
	Adjusted R Square
	0.825093
	
	
	
	
	
	Standard Error
	726.

use excel for data a graph and word to answer question

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment