BUS-660 Module 3 Simple Regression Models - Problems 4-13, 4-14, 4-15, and 4-19.
Ontime WriterQuantitative Methods – Simple Regression Models
Grand Canyon University
Text book: Quantitative Analysis for Management (12th Edition)
Complete Problems 4-13, 4-14, 4-15, and 4-19.
Use Excel's regression option to perform the regression.
Use an Excel spreadsheet file for the calculations and explanations, with one worksheet per problem. Use the problem number for each worksheet name. Cells should contain the formulas (i.e., if a formula was used to calculate the entry in that cell).
Problem 4-13 Data
Student | Final Average | First Test Grade |
1 | 93 | 98 |
2 | 78 | 77 |
3 | 84 | 88 |
4 | 73 | 80 |
5 | 84 | 96 |
6 | 64 | 61 |
7 | 64 | 66 |
8 | 95 | 95 |
9 | 76 | 69 |
Problem 4-19 Data
Year | Number of Tourists (1,000,000s) | Ridership (100,000s) |
1 | 7 | 15 |
2 | 2 | 10 |
3 | 6 | 13 |
4 | 4 | 15 |
5 | 14 | 25 |
6 | 15 | 27 |
7 | 16 | 24 |
8 | 12 | 20 |
9 | 14 | 27 |
10 | 20 | 44 |
11 | 15 | 34 |
12 | 7 | 17 |
Problem 4-32 Data……………..
- 9 years ago
Purchase the answer to view it
- bus-660_module_3_simple_regression_models_-_problems_4-13_4-14_4-15_and_4-19..doc
- bus-660_module_3_simple_regression_models_-_problems_4-13_4-14_4-15_and_4-19..xls