can tou help me answer please
Qs are in one picture
the rest of the picture are the options for the questions
Required information Excel Analytics 5-69: Estimation Methods - Simple Regression, Data Analysis and Visualization: Visualization [The following information applies to the questions dispiayed belaw] Bradford Fabric Shops is a chain of retall stores offering fabrics, accessories, and machines for sewing, knitting, and so on The company's 13 retail stores are managed by employees, most of whom started working on the sales floor and rose through the ranks. The chief financial officer (CFO) would like to understand how the operating costs of the stores inot including the cost of the goods sold) vary across stores. While there are differences among the stores in terms of location, size, and clientele, these differences are not thought to be too great. The CFO has asked you to prepare an analysis of store operating cost and, after ciscussion with the CFO and the store managers, the financial staff have provided information on store operating costs and customer visits for each of the stores for the past year. (All online sales are the responsiblity of a different unit and not any of the stores.) The information collected follows: Questions 1. Why was it appropriate to exclude Store \#11 from the regression analysis? 2. What impact would the data from Store \#11 have had if the high-low method were used instead of a simple regression? 3.Withintheresultsoftheregressionanalysis,whichelementisequaltothefixedcost? 4. Based on the results of the regression analysis, what are the variable costs per visit? Answers \#11 from the regression 711 have had if the high-low ession? isis, which element is equal to The variable cost per visit would have been too high, but the fixed cost (although different from the regression results) would not have been affected. The fixed cost would have been too high, but the varlable cost per unit (although different from the regression results) would not have been affected. Neither the variable cost per visit nor the fixed cost would have been affected. Both the variable cost per unit and the fixed cost would have been too high. Questions exclude Store \#11 from the regression ta from Store $11 have had if the high-low a simple regression? gression analysis, which element is equal to regression analysis, what are the variable ph we can quickly see that which of the Store operating costs exceeded $200,000 for every store. Store operating costs were less than $250,000 for every store. Store Visits exceeded 29,000 for every store. Store Visits were less than 39,000 for every store. Required information Excel Analytics 5-69: Estimation Methods - Simple Regression, Data Analysis and Visualization: Visualization [The following information applies to the questions dispiayed belaw] Bradford Fabric Shops is a chain of retall stores offering fabrics, accessories, and machines for sewing, knitting, and so on The company's 13 retail stores are managed by employees, most of whom started working on the sales floor and rose through the ranks. The chief financial officer (CFO) would like to understand how the operating costs of the stores inot including the cost of the goods sold) vary across stores. While there are differences among the stores in terms of location, size, and clientele, these differences are not thought to be too great. The CFO has asked you to prepare an analysis of store operating cost and, after ciscussion with the CFO and the store managers, the financial staff have provided information on store operating costs and customer visits for each of the stores for the past year. (All online sales are the responsiblity of a different unit and not any of the stores.) The information collected follows: Questions 1. Why was it appropriate to exclude Store \#11 from the regression analysis? 2. What impact would the data from Store \#11 have had if the high-low method were used instead of a simple regression? 3.Withintheresultsoftheregressionanalysis,whichelementisequaltothefixedcost? 4. Based on the results of the regression analysis, what are the variable costs per visit? Answers \#11 from the regression 711 have had if the high-low ession? isis, which element is equal to The variable cost per visit would have been too high, but the fixed cost (although different from the regression results) would not have been affected. The fixed cost would have been too high, but the varlable cost per unit (although different from the regression results) would not have been affected. Neither the variable cost per visit nor the fixed cost would have been affected. Both the variable cost per unit and the fixed cost would have been too high. Questions exclude Store \#11 from the regression ta from Store $11 have had if the high-low a simple regression? gression analysis, which element is equal to regression analysis, what are the variable ph we can quickly see that which of the Store operating costs exceeded $200,000 for every store. Store operating costs were less than $250,000 for every store. Store Visits exceeded 29,000 for every store. Store Visits were less than 39,000 for every store
