The manager of a commuter transit wants to determine which factors have a significant impact on the demand for rides in the large city served by the transit system. The manager collected data on variables thought to be possibly related to the number of weekly riders on the transit system.

Hover over the column headers to see the definitions of the variables. Note Weekly Riders and Populations are in thousands, i$.$e$.,1200$ means $1,200,000.$ As you answer the questions, leave the units as thousands.

$($a$)$ Estimate a multiple regression equation using the given data.

Let y $=$ Weekly Riders, x $=$ the remaining four variables $($all except Year$)$

In the Regression dialog box, what did you enter as Input Y Range?

What did you enter as Input X Range? Give the cell addresses $($e$.$g$.,$ D$2$:E$10).$

$($b$)$ What $\%$ of variations in the Weekly Riders are due to the X variables here? Give the answer in $\%$ rounded to $1$ decimal digit $($e$.$g$.,$ if $0\mathrm{.}6789,$ state it as $67\mathrm{.}9).$

$($c$)$ Suppose there is a plan to raise the price per ride to $$1\mathrm{.}10$ next year. If the population will be $1620($in thousands$),$ disposable per capita income is $$8,200,$ and the Parking Rate remains at $$2\mathrm{.}00,$ what do you expect the Weekly Riders to be$?$ Give the answer rounded to one decimal place $($e$.$g$.,123\mathrm{.}4).$

$($d$)$ What is the effect of population on the Weekly Riders, i$.$e$.,$ if population increases by $1($in thousand$),$ do you expect the Weekly Riders to increase or decrease? By how many $($again in thousands$)?$ Give the answer rounded to $3$ decimal places $($e$.$g$.,0\mathrm{.}123,1\mathrm{.}234,-1\mathrm{.}234).$

$($e$)$ If the price per ride went up by $$0\mathrm{.}10,$ by how much would you expect the Weekly Riders to increase or decrease? Give the answer rounded to $3$ decimal places $($e$.$g$.,0\mathrm{.}123,1\mathrm{.}234,-1\mathrm{.}234).$