[go: up one dir, main page]
Scribd
Upload
94 views5 pages

Math108x Excel CHECKPOINTpredictions

This document contains a scatterplot and linear regression equation relating baseball team payroll (in millions of dollars) to winning percentage. It predicts the winning percentages for the Toronto and San Diego baseball teams based on their payroll. It also contains the month numbers, month names, and total car sales by month, with a linear regression equation to model this relationship.

Uploaded by

Jackson Lumbasio
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
94 views5 pages

Math108x Excel CHECKPOINTpredictions

This document contains a scatterplot and linear regression equation relating baseball team payroll (in millions of dollars) to winning percentage. It predicts the winning percentages for the Toronto and San Diego baseball teams based on their payroll. It also contains the month numbers, month names, and total car sales by month, with a linear regression equation to model this relationship.

Uploaded by

Jackson Lumbasio
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 5

Baseball

Payroll vs. Wins


Input Variable: Team Payroll
Output Variable: (in millions of dollars)

235.41
Equation: y=0.0007x+0.4142 191.21
180.26
Toronto's predicted 177.35
winning percentage: 174.01
San Diego's predicted 171.69
winning percentage: 171.02
167.42
161.91
149.67
137.13
135.05
134.46
127.89
125.99
121.00
118.75
103.99
89.08
87.78
87.57
84.87
80.40
74.62
64.55
60.39
49.43
46.83
45.70
35.91
. Wins
Win Percentage
(Written as a decimal)

0.64
0.56
0.57
0.48
0.51 Win Percentage
0.49 (Written as a decimal)
0.58 0.7
0.48 0.6
0.40 f(x) = 0.000703828338484471(Put your scatterplot here.)
x + 0.414244545373412
0.5
0.44
0.56 0.4
0.55 0.3
0.56
0.2
0.65
0.57 0.1
0.45 0
0 50 100 150 200 250
0.51
0.46
0.32
0.46
0.58
0.37
0.48
0.53
0.56
0.61
0.41
0.49
0.32
0.38
plot here.)
412

200 250
Car Sales
Month vs. Cars Sold
Input Variable: Total Number of
Month Number
Output Variable: Cars Sold
1 207718
Equation: y=1204.6x+201475 2 209593
3 206083
Predicted cars sold in 4 206547
month 2 (April):
20900 5 200301
Predicted cars sold in 6 200120
month 7 (September):
212500 7 204241
8 209278
X-coordinate of 9 216130
vertex of parabola: -167.25 10 213351
Month for vacation: 12 11 217703
12 220598

Month Numbers
Month Name Month Number
March 1
April 2
May 3
June 4
July 5
August 6
September 7
October 8
November 9
December 10
January 11
February 12
Chart Title
225000

220000

215000 f(x) = 1204.59090909091 x + 201475.409090909


210000

205000
(Put your scatterplot here.)
200000

195000

190000

185000
0 2 4 6 8 10 12 14

You might also like