use excel for data a graph and word to answer question

1 answer below »
use excel for data a graph and word to answer question
Answered Same DayMay 12, 2022

Answer To: use excel for data a graph and word to answer question

Sultana answered on May 13 2022
98 Votes
Problem 2-28A Estimating fixed and variable cost using the regression method
a)
By using the scatt
er 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...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here