correct answer for a thumps up !!

6. [20 points) Crossroad Inn is a small bed-and-breakfast inn. Following table shows number of guests and number of room service orders for the last year. Month 1 2 3 4 5 6 7 8 9 10 11 12 Guests 1400 1100 1500 1600 2400 2800 2200 2100 2600 4300 3400 3900 Room service orders 329 373 403 377 654 934 645 553 767 1455 1150 1217 a) Is there relationship between the number of guests and number of room service orders? Provide reasoning for your answer. (Hint: Use regression correlation analysis or a scatter plot to visualize the data Show screen captures or scanned images to show work). b) Develop a simple linear regression model that relates number of guests to number of room service orders. (Hint: Use Excel formulas or Excel regression analysis tools. Show screen captures to show work) c) The manager expects 1500 and 1250 guests for in for next two months. Use linear regression model and forecast the room service orders for next two months