Required: Using regression analysis and choosing from several potential cost drivers, derive the cost drivers that are significant predictors of overall overhead costs and can be used to help allocate overhead. Set alpha to 5%, or 0.05. Derive the formula for allocating overhead (the regression line equation). Compare estimated overhead per delivery to actual overhead per delivery using a scatterplot. Data: Lab 3.5 Data.xlsx Specify the Question: How can we use regression analysis to find cost drivers and derive a formula for allocating overhead? Obtain the Data: Bob's Delivery does an intense analysis of overhead costs. Once the managers identify the drivers of overhead costs, they develop a formula to allocate the overhead based on those cost drivers. The analysis calculates total overhead costs over 122 delivery days and considers three potential cost drivers that the company believes may be associated with the overhead costs. These potential cost drivers are the number of miles driven, the total delivery time, and the weight. This lab uses the data in Lab 3.5 Data.xlsx. This dataset contains information for the potential cost drivers. Analyze the Data: Refer to lab 3.5 in your text for additional instructions and steps