- Please Use Microsoft Excel Only With Formulas 1 (93.01 KiB) Viewed 42 times
*** PLEASE USE MICROSOFT EXCEL ONLY WITH FORMULAS ****
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
*** PLEASE USE MICROSOFT EXCEL ONLY WITH FORMULAS ****
*** PLEASE USE MICROSOFT EXCEL ONLY WITH FORMULAS ****
Bus and subway ridership in Washington, D.C., during the summer months is believed to be heavily tied to the number of tourists visiting the city. During the past 12 years, the following data have been obtained: Year Numbers of Tourist (1,000,000s) Ridership (100,000s) 1 7 15 2 2 10 6 13 4 15 14 25 27 24 20 27 44 34 17 3 4 5 6769 8 5|6|240 15 15 16 12 14 10 11 12 7 3 Answer the following questions. For all three questions, show computation by showing all the computational steps. Do NOT use the Excel Regression function. (a) Develop a regression model through manual calculation. (b) What is expected ridership if 10 million tourists visit the city? (c) Suppose SST=1100, SSE=180. What is the value of r²? Explain it in the context of this problem. What is the value of correlation coefficient between these two variables? MUST retain all the formulas in the worksheet. If I cannot verify the formulas used and see static results only, a minimum 50% penalty will be applied.
Bus and subway ridership in Washington, D.C., during the summer months is believed to be heavily tied to the number of tourists visiting the city. During the past 12 years, the following data have been obtained: Year Numbers of Tourist (1,000,000s) Ridership (100,000s) 1 7 15 2 2 10 6 13 4 15 14 25 27 24 20 27 44 34 17 3 4 5 6769 8 5|6|240 15 15 16 12 14 10 11 12 7 3 Answer the following questions. For all three questions, show computation by showing all the computational steps. Do NOT use the Excel Regression function. (a) Develop a regression model through manual calculation. (b) What is expected ridership if 10 million tourists visit the city? (c) Suppose SST=1100, SSE=180. What is the value of r²? Explain it in the context of this problem. What is the value of correlation coefficient between these two variables? MUST retain all the formulas in the worksheet. If I cannot verify the formulas used and see static results only, a minimum 50% penalty will be applied.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!