70.2K

Verified Solution

Link Copied!

As the new manager of a local fitness club, Fitness $-$for $-$ All, you have been studying the club's financial data. You would like to determine how the club's costs behave in order to make accurateRequirement $6.$ Perform regression analysis using Excel. What is the monthly operating cost equation? What is the R$-$squared value? Why is the cost equation different from that in Requirement $2?$What is the monthly operating cost equation? $($Enter the variable cost per unit to the nearest cent and the total fixed costs to the nearest dollar.$)$ y$=$ $ $13\mathrm{.}03$ x$+$ $ $4,509$What is the R$-$squared value? $($Round the R$-$squared value to $4$ decimal places, XXXXX$.)$The R$-$squared value is$0\mathrm{.}7491$Why is the cost equation different from that in Requirement $2?$O A$.$ The regression analysis cost equation uses all of the data points, not just the data from November and July. Therefore, it better represents all of the data.O B$.$ The regression analysis cost equation uses all of the data points, except the data from November and July. Therefore, it better represents all of the data.OC$.$ The regression analysis cost equation uses just the data from November and July, but Excel is more accurate than the calculations you performed in Requirement $2.$O D$.$ The regression analysis cost equation uses all of the data points, except the data from November and July. Therefore, it does not represent the data as well as in Requirement $2.$

Answer & Explanation Solved by verified expert

See Answer