Wins Attendance (In Millions) 65 2.06 91 2.51 66 1.73 89 3.05 75 3.06 88 2.19 91 2.06 69 1.39 83 2.88 81 2.46 80 1.54 76 2.33 67 1.62 80 3.25 80 3.56 77 2.78 94 3.22 79 2.56 95 3.77 81 1.42 97 3.65 57 1.61 90 2.13 92 3.04 61 2.09 86 3.3 96 1.84 90 2.51 85 1.63 69 1.83   Draw a scatter diagram depicting the correlation between the two variables.    Determine the correlation coefficient between the two variables using Excel.   Present a regression output between a dependent and one independent variable.     Obtain estimated coefficients and R-squared and interpret them.     Write a short report on the findings.

College Algebra (MindTap Course List)
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.
icon
Related questions
Question

 

Wins

Attendance (In Millions)

65

2.06

91

2.51

66

1.73

89

3.05

75

3.06

88

2.19

91

2.06

69

1.39

83

2.88

81

2.46

80

1.54

76

2.33

67

1.62

80

3.25

80

3.56

77

2.78

94

3.22

79

2.56

95

3.77

81

1.42

97

3.65

57

1.61

90

2.13

92

3.04

61

2.09

86

3.3

96

1.84

90

2.51

85

1.63

69

1.83

 

  • Draw a scatter diagram depicting the correlation between the two variables. 

 

  • Determine the correlation coefficient between the two variables using Excel.

 

  • Present a regression output between a dependent and one independent variable.

 

 

  • Obtain estimated coefficients and R-squared and interpret them.

 

 

  • Write a short report on the findings.

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 7 steps with 11 images

Blurred answer
Similar questions
Recommended textbooks for you
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning