Home Insert Draw Page Layout Formulas Data Review View Automate P Tell m Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? 1. Customer call minutes 2. Customer complaints 3. Average workers 4. Company sales Required: 1. Using regression analysis and choosing from several potentlai cost ditvers, derive the cost driv predictors of overall overhead costs and can be used to help allocate overhead. Set alpha to 5 2. Derlve the formula for allocating overhead (the regression line equation). 3. Compare estimated overhead per delivery to actual overhead per delivery using a scatterpiot. Data: Alt Lab 3.5 Data xisx Specify the Question: How can we use regression analysis to find cost drivers and derive a formy overhead? Obtain the Data: This lab uses the data in Alt Lab 3.5 Dataxisx. This dataset contains information drivers. Analyze the Data: Refer to lab 3.5 in your text for additional instructions and steps. Lab 3.5 Alternate: Assessment Questions Answer the following questions based on the details computed. Home Insert Draw Page Layout Formulas Data Review View Automate P Tell m Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? 1. Customer call minutes 2. Customer complaints 3. Average workers 4. Company sales Required: 1. Using regression analysis and choosing from several potentlai cost ditvers, derive the cost driv predictors of overall overhead costs and can be used to help allocate overhead. Set alpha to 5 2. Derlve the formula for allocating overhead (the regression line equation). 3. Compare estimated overhead per delivery to actual overhead per delivery using a scatterpiot. Data: Alt Lab 3.5 Data xisx Specify the Question: How can we use regression analysis to find cost drivers and derive a formy overhead? Obtain the Data: This lab uses the data in Alt Lab 3.5 Dataxisx. This dataset contains information drivers. Analyze the Data: Refer to lab 3.5 in your text for additional instructions and steps. Lab 3.5 Alternate: Assessment Questions Answer the following questions based on the details computed