5. A large department store has collected the following monthly data on lost sales revenue due...

Transcribed Image Text:

5. A large department store has collected the following monthly data on lost sales revenue due to theft and the number of security guard hours on duty: Lost Sales Revenue Total Security (S000s) Guard hours 1.0 600 1.4 630 1.8 950 1.9 1000 2.0 1200 2.1 1300 2.3 1350 a. Develop a scatter diagram. b. Developer a regression model using Excel Data Analysis for Regression c. What is the regression equation? d. What is r 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 due to theft and the number of security guard hours on duty: Lost Sales Revenue Total Security (S000s) Guard hours 1.0 600 1.4 630 1.8 950 1.9 1000 2.0 1200 2.1 1300 2.3 1350 a. Develop a scatter diagram. b. Developer a regression model using Excel Data Analysis for Regression c. What is the regression equation? d. What is r 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?