A small regional airline wishes to predict sales for its business class between two cities for the year 2019. The airline has recorded the following data for its past ten years; tickets sold and the number of businesses within its market area.

(chart in photo file)

Using Microsoft Excel or a similar app, determine following:

1. Plot the annual sales data (PAX) against the number of businesses (BUS) in the market area and draw in the "line of best fit" that seems to be visually appropriate.
2. Measure the intercept and slope of the above line of best fit, state the approximate function relationship between the two variables.
3. Suppose the number of businesses is projected as increasing to 16,500 in 2019. Use the above function relationship to forecast the demand.
4. Comment on the probable accuracy of your forecast.

A small regional airline wishes to predict sales for its business class between two cities for the year 2019. The airline has recorded the following data for its past ten years: tickets sold and the number of businesses within its market area. Year Tickets Sold Number of Businesses 2009 70,000 3,500 2010 76,500 4,620 2011 71,500 5,480 2012 83,000 6,100 2013 80,000 6,940 2014 92,000 8,300 2015 90,500 9,850 2016 101,000 10,800 2017 103,000 12,100 2018 106,000 13,300 Using Microsoft Excel or a similar app, create and upload a le illustrating the following: 1. Plot the annual sales data (FAX) against the number of businesses (BUS) in the market area and draw in the "line of best t" that seems to be visually appropriate. 2. Measure the intercept and slope of the above line of best t, state the approximate function relationship between the two variables. 3. Suppose the number of businesses is projected as increasing to 16,500 in 2019. Use the above function relationship to forecast the demand. 4. Comment on the probable accuracy of your forecast. Upload Choose a File EEO-DUOIIiig