Work on excel

Excel File Edit View Insert Format Tools Data Window Help Thu AutoSave O OFF A ? " C ... GBS 221 - Final Exam Home Insert Draw Page Layout Formulas Data Review View Developer Tell me 1 Share F14 4 X V fx A B C D E F G H K M N P Q R S T U V W You are working on scheduling your employees for the next month, and using past data to help inform your decisions. Below, you will see information about the amount of sales per hour you were able to generate, along with the number of employees working during that time. Perform regression analysis to answer the following questions. a. What is the linear regression equation? b. What is the coefficient of determination? c. What amount of sales could you expect to make if you scheduled 5 employees? d. How many employees do you need to schedule to make $400 in an hour? e. EXTRA CREDIT: How much does the company make in sales if you schedule 0 employees? Explain how this is possible. Employees Sales per hour($) 10 565 3 336 4 209 10 675 7 w 332 466 356 10 765 7 532 10 752 466 325 601 434 650 W 1 00 727 244 10 850 10 802 265 747 10 776 10 788 w 239 10 922 6 475 495 504 485 4 345 422