Question

How do I answer the following question on excel?

Bus and subway ridership during the Summer is believed to be heavily tied to the number of tourists. During the past five years, the following data have been obtain

Year​​Tourists​​Riders

​​(in millions)​​(100,000s)

2015​​3.5​​​ 8

2016​​3.8​​​ 9

2017​​4.0​​​9.5

2018​​4.3​​​11

2019​​4.5​​​13

What is the forecasted number of riders for the Summer of 2021 (forget 2020 as not typical) if 5.0 million tourists are expected during that period?

Answer 1

x = Tourist

y = riders

Using Excel

data -> data analysis -> regression

y^ = -16.9637 + 6.6178 *x

when x= 5

y^ = 16.1254

Please round to whatever decimal you need

Please give me a thumbs-up if this helps you out. Thank you! :)