Develop the multiple linear regression model.
Please use Excel
Develop the multiple linear regression model to estimate the number of trips attracted (y) to the cities/municipalities in Metro Manila using the available office floor space (x) and the number of offstreet parking spaces (x2). Number of Offstrest Parking Spaces, X Office Floor Space (sq.m) x City/Municipality Estimated Number of trips attracted, y 59873 22508 185367 Muntinlupa Makati 56338 625520 180675 40050 538978 176791 Manila 19342 147078 67893 San Juan 19360 118280 34520 Pasay Pasig Caloocan 11854 141676 54331 1162 26350 3452 35230 392675 38332 Quezon City 3822 67259 7332 Pateros 2530 7895 73860 9650 27885 Taguig Paranaque Navotas Malabon 110034 867 15882 1322 1250 5230 25830 3225 52253 15896 Las Pinas Valenzuela Mandaluyong 1225 12530 2486 6895 82360 25578 2586 21570 5689 Marikina
Solved
Theory of probability
1 Answer
Jope Algorta
Login to view answer.