When provided data in an Excel format, regression analysis:
A) Will provide total fixed costs as the Coefficient/Intercept and total variable costs as Coefficient/# of members.
B) Will provide total fixed costs as the Coefficient/Intercept and unit variable costs as Coefficient/# of members.
C) Will provide individual member fixed costs as the Coefficient/Intercept and individual variable costs as Coefficient/# of members.
D) Will provide total fixed costs as the Coefficient/Intercept and unit variable costs as p-value/# of members.

Question

Quizplus · Accepted Answer

In regression analysis of Excel data, the intercept or coefficient represents the total fixed cost while the slope or coefficient/# of members represents the unit variable cost. Therefore, option B stating that regression analysis provides total fixed costs as the Coefficient/Intercept and unit variable costs as Coefficient/# of members is the correct choice.

When Provided Data in an Excel Format, Regression Analysis