Required informationLab 3-6(Static) Comprehensive Case: Create a Data Abstract and Perform Regression AnalysisDillards (LO 3-4)Skip to questionCase Summary: After running a diagnostic analysis on Dillards transactions, you have found that there is a statistically significant difference between the amount of money customers spend in online transactions versus in-person transactions. You decide to take this a step further and design a predictive model to help determine how much a customer will spend based on the transaction type (online or in-person). You will run a simple regression to create a predictive model using one explanatory variable in Part 1, and in Part 2 you will extend your analysis to add in an additional explanatory variabletender type (the method of payment the customer chooses).Data: Dillards sales data are available only on the University of Arkansas Remote Desktop (waltonlab.uark.edu). Use your assigned login credentials.Lab 3-6 Part 2(Static): Objective Questions (LO 3-4)OQ1. What is the coefficient for the BANK-Dummy variable?Note: Round your answer to 4 decimal places.OQ2. What is the coefficient for the Online-Dummy variable? (Carefulit is not the same as it was in the simple regression output!)Note: Round your answer to 4 decimal places.OQ3. What is the expected transaction amount for a customer who uses their credit card for an online purchase?Note: Round your answer to 2 decimal places.