Question 16A 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. RUN A REGRESSION IN EXCEL, INCLUDING DUMMYVARIABLES for the qualitative information provided. Use the Weekday as the 0-0. Answer the following question: What is the value of the Guard Hours B1 variable?Lost Sales Total Security TimeRevenue Guard Hours Occurred16001.4630WeekdayWeeknight1.91000Weekday21200Weeknight1.8950 Weekday2.11300Weekend2.31350WeekendOA. 277619OB..097706OC.-.01937D. .001511OE-586853 Student questionstVARIABLES for the qualitative infoAnswer the following question: What is the value of the CTime Revenue Guard Hours Occurred \table[[1, 600, Wee], [2,1200, Weeknight], [1.8,950, Weekday], [2.1, 1300, WeeC. .01937 D. 001511 E. .586853Question 161.82.12.3OA, .277619OB..097706OC.-.01937D. .001511E. .586853

Here the dependent variable (y) is Lost sales revenue.There are two independent variables are given…

A large department store has collected the fo VARIABLES for the qualitative information Lost Sales Total Security Time Revenue Guard Hours Occurred 1 600 Weekday 1.4 630 Weeknight 1.9 1000 Weekday 2 1200 Weeknight 1.8 950 Weekday 2.1 1300 Weekend 1350 Weekend 2.3 OA-277619 OB..097706 OC.-.01937 D. .001511 OE586853