Create a scatterplot investigating the relationship between the amount of money major league baseball teams spen

Create a scatterplot investigating the relationship between the amount of money major league baseball teams spend on their players and the number of wins they have in a season. Here is the data for the payroll amounts for MLB teams in 2018 (rounded to the nearest million) and the number of wins they had that season.

Team

2018 Payroll (million $)

2018 Wins

Cubs

212

95

Yankees

205

100

Nationals

204

82

Red Sox

204

108

Giants

200

73

Angels

177

80

Dodgers

171

92

Astros

166

103

Cardinals

165

88

Mariners

153

89

Rockies

151

91

Mets

149

77

Phillies

145

80

Reds

134

67

Brewers

128

96

Indians

123

91

Braves

118

90

Twins

115

78

Diamondbacks

108

82

Rangers

107

67

Tigers

105

64

Royals

103

58

Athletics

103

97

White Sox

91

62

Orioles

80

47

Pirates

76

82

Padres

76

66

Blue Jays

71

73

Marlins

71

63

Rays

53

90

• Create a scatterplot for this data. Place the explanatory on the horizontal axis and response variable on the vertical axis. Label the axes and identify the scale on each axis
• Calculate the correlation value, r, using the formula:
  ????=????(∑????????)−(∑????)(∑????)[????(∑????2)(∑????)2][????(∑????2)−(∑????)2]√r=n(∑xy)−(∑x)(∑y)[n(∑x2)(∑x)2][n(∑y2)−(∑y)2]
• Select two points and use them to define the line of best fit, . Identify these points and sketch the line on the scatterplot.
• Use the line you defined to estimate the number of wins $150 million would buy in 2018. How does this compare to the Rockies and Mets performance that year.
• Identify any outliers on the scatterplot. For this case, an outlier is defined as any team that is more than 15 wins away from the predicted value from the line of best fit.