5:14 LTE 30 Assignment Details 202304E OL BAN317 AO Data Analytics and Business Forecasti... In this assignment, you are to act as the manager of the Mid-Valley Travel Agency (MVTA), which has offices in 12 cities. The company believes that its monthly airline bookings are related to the mean income in those cities and has collected the following data: (c4p 10) A template with this data on it is provided for you here: Week 2 Application Assignment Template Location Bookings Income Location Bookings Income 1,098 43,299 855 27,482 1,131 45,021 8 1,054 33,025 1,120 40,290 9 1,081 34,687 aUAWNH 1,142 41,893 10 982 28,725 971 30,620 11 1,098 37,892 1,403 48,105 12 1,387 46,198 1. Develop a linear regression model of monthly airline bookings as a function of income. (Use the Tool Pack) 2. Develop a scatter plot of the data and trend line. (Use the Chart Feature in Excel) 3. Use the process described above to evaluate your results. (You need to evaluate the regression results and the scatter chart results) 4. How would you state your findings to upper management? Submit Assignment Previous Next 000 0= 2 0= Dashboard Calendar To Do Notifications Inbox