BUS-660 Module 3 Simple Regression Models - Problems 4-13, 4-14, 4-15, and 4-19.

profileOntime Writer
 (Not rated)
 (Not rated)
Chat

Quantitative 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
    BUS-660 Module 3 Simple Regression Models - Problems 4-13, 4-14, 4-15, and 4-19.
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      bus-660_module_3_simple_regression_models_-_problems_4-13_4-14_4-15_and_4-19..doc
    • attachment
      bus-660_module_3_simple_regression_models_-_problems_4-13_4-14_4-15_and_4-19..xls