. Develop a scatter diagram. b. Developer a regression model using Excel Data Analysis for Regression c. What is the regression equation? d. What is r2 and what does it mean for this data? e. What is the Significance F Value and what does is mean? f. What is the P-Value for Total Security Guard Hours and what does it mean? g. If the Security Guard Hours is 800, what is the estimated lost sales in revenue? 5. A large department store has collected the following monthly data on lost sales revenue