Part 1: Your task is to create the best model you can for predicting the gross drug costs. Use data3.xlsx. That is, you will use the model you developed for the six months' worth of data provided and predict the gross drug costs for the next month using your model coefficients. Instructions for creating the model are provided in the Regression directions document. This is meant as an open-ended assignment that requires you to use your analytics mindset to develop your own regression model. There is no ultimate right solution for this part of the case. The factors that do not matter should not be used in your model. and additional factors can be explored to try and fit a better model. Much of statistics is an interactive process of learning and building better models by adding and taking away variables. Required 0 Create your best regression model based on the data to predict the future gross drug costs. The Regression Analysis using Excel document provides instructions for regression analysis using EXCEL. See the Regression Example file regarding how to interpret regression output. Use the data file named "Analytics Mindset Case Part 1". You will turn in your EXCEL file to SAKAI and bring a print out to class. 0 Submit a memo that contains the standard regression output (coefficients, T- stats, P-values, adjusted R-squared, etc.). - Explain to senior management what you learned from your model that will be valuable in operating the PBM business. - Also include any cautions that senior management should understand about using this model