The manager of a commuter rail transportation system was recently asked by her governing board to determine which factors have a significant impact on the demand for rides in the large city served by the transportation network. The system manager collected data on variables thought to be possibly related to the number of weekly riders on the city's rail system. The file P10_20.xlsx contains these data.Estimate a multiple regression equation using the given data. Interpret each of the estimated regression coefficients. Enter your answers in thousands. For example, an answer of 1.234 thousand should be entered as 1.234, not 1,234. Round your answers to three decimal places, if necessary.Holding all else constant, ridership by approximately thousands when the price per ride rises by $1.00.Holding all else constant, ridership by approximately thousands when the population increases by 1,000.Holding all else constant, ridership by approximately thousands when the disposable per capita income rises by $1.00.Holding all else constant, ridership by approximately thousands when the parking rate rises by $1.00.What proportion of the total variation in the number of weekly riders is not explained by this estimated multiple regression equation? Round your answer to one decimal place, if necessary. % The manager of a commuter rail transportation system was recently asked by her governing board to determine which factors have a significant impact on the demand for rides in the largecity served by the transportation network. The system manager collected data on variables thought to be possibly related to the number of weekly riders on the city's rail system. The fileP10_20.xlsx contains these data.a. Estimate a multiple regression equation using the given data. Interpret each of the estimated regression coefficients. Enter your answers in thousands. For example, an answer of 1.234thousand should be entered as 1.234, not 1,234. Round your answers to three decimal places, if necessary.Holding all else constant, ridership decreasesby approximatelythousands when the price per ride rises by $1.00.by approximatelythousands when the population increases by 1,000.Holding all else constant, ridership increasesHolding all else constant, ridership decreasesby approximately%thousands when the disposable per capita income rises by $1.00.Holding all else constant, ridership increases +by approximatelythousands when the parking rate rises by $1.00.b. What proportion of the total variation in the number of weekly riders is not explained by this estimated multiple regression equation? Round your answer to one decimal place, ifnecessary. 12345678910111213141516171819202122232425262728Year123456789101112131415161718192021222324252627Weekly Riders1,2001,1901,1951,1001,1051,1151,1301,0951,0901,0871,0801,0201,0101,0101,005995930915920940950910930933940948955Price per Ride$0.15$0.15$0.15$0.25$0.25$0.25$0.25$0.30$0.30$0.30$0.30$0.40$0.40$0.40$0.40$0.40$0.75$0.75$0.75$0.75$0.75$1.00$1.00$1.00$1.00$1.00$1.00PopulationIncome1,800$2,9001,790$3,1001,780$3,2001,778 $3,2501,750 $3,2751,740$3,2901,725$4,1001,725$4,3001,720$4,4001,705 $4,6001,710$4,8151,700 $5,2851,695$5,6651,695 $5,8001,690 $5,9001,630 $5,9151,640 $6,3251,635$6,5001,630 $6,6121,620 $6,8831,615 $7,0051,605 $7,234$7,500$7,6001,590 $7,8001,600 $8,0001,610 $8,1001,5901,595Parking Rate$0.50$0.50$0.60$0.60$0.60$0.70$0.75$0.75$0.75$0.80$0.80$0.80$0.85$1.00$1.05$1.05$1.05$1.10$1.25$1.30$1.50$1.55$1.65$1.75$1.75$1.90$2.00

1) The objective is to estimate a multiple regression equation using the given data.

The manager of a commuter rail transportation system was recently asked by her governing board to determine which factors have a significant impact on the demand for rides in the large city served by the transportation network. The system manager collected data on variables thought to be possibly related to the number of weekly riders on the city's rail system. The file P10_20.xlsx contains these data. Estimate a multiple regression equation using the given data. Interpret each of the estimated regression coefficients. Enter your answers in thousands. For example, an answer of 1.234 thousand should be entered as 1.234, not 1,234. Round your answers to three decimal places, if necessary. Holding all else constant, ridership by approximately thousands when the price per ride rises by $1.00. Holding all else constant, ridership by approximately thousands when the population increases by 1,000. Holding all else constant, ridership by approximately thousands when the disposable per capita income rises by $1.00. Holding all else constant, ridership by approximately thousands when the parking rate rises by $1.00. What proportion of the total variation in the number of weekly riders is not explained by this estimated multiple regression equation? Round your answer to one decimal place, if necessary.

12th Edition

ISBN:9781305652231

Author:R. David Gustafson, Jeff Hughes

Publisher:R. David Gustafson, Jeff Hughes

Chapter8: Sequences, Series, And Probability

Section8.CR: Chapter Review

Problem 37E: Find the positive geometric mean between 4 and 64.