Required Information Lab Note: The tools presented in this lab periodically change. Updated instructions, If applicable, can be found in the eBook and lab walkthrough videos in Connect. Case Summary. After running dlagnostic analysis on Dillard's transactions, you have found that there is a statistically significant difference between the amount of money customers spend In online transactions versus In-person transactlons. You declde 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 varlable in Part 1, and in Part 2 you will extend your analysis to add In an additional explanatory varlable-tender type (the method of payment the customer chooses). Data: Dillard's sales data are avallable only on the University of Arkansas Remote Desktop (waltonlab.uark.edu). See your Instructor for login credentials. OQ1. Using the regression formula, what is the predicted amount a customer will spend on an online transaction? Note: Round your answer to 2 decimal places. OQ2 What is the R Square value? Note: Round your answer to 5 decimal places. OQ3. What is the p-value provided for the explanatory varlable? OQ4. If you completed the Excel track, what is the Signlficance F value? Required Information Lab Note: The tools presented in this lab periodically change. Updated instructions, If applicable, can be found in the eBook and lab walkthrough videos in Connect. Case Summary. After running dlagnostic analysis on Dillard's transactions, you have found that there is a statistically significant difference between the amount of money customers spend In online transactions versus In-person transactlons. You declde 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 varlable in Part 1, and in Part 2 you will extend your analysis to add In an additional explanatory varlable-tender type (the method of payment the customer chooses). Data: Dillard's sales data are avallable only on the University of Arkansas Remote Desktop (waltonlab.uark.edu). See your Instructor for login credentials. OQ1. Using the regression formula, what is the predicted amount a customer will spend on an online transaction? Note: Round your answer to 2 decimal places. OQ2 What is the R Square value? Note: Round your answer to 5 decimal places. OQ3. What is the p-value provided for the explanatory varlable? OQ4. If you completed the Excel track, what is the Signlficance F value