Team Baltimore Revenue 245 Value 1000 1280 Run a regression that will use revenu
ID: 3183366 • Letter: T
Question
Team
Baltimore
Revenue
245
Value
1000
1280
Run a regression that will use revenue to predict team value in excel. Thanks!
Team
Baltimore
Revenue
245
Value
1000
Boston 370 2100 Chicago White Sox 227 975 Cleveland 207 825 Detroit 254 1125 Houston 175 800 Kansas City 231 700 Los Angeles Angels 304 1300 Minnesota 223 895 New York Yankees 508 3200 Oakland 202 725 Seattle 250 1100 Tampa Bay 188 625 Texas 266 1220 Toronto 226 870 Arizona 211 840 Atlanta 267 1150 Chicago Cubs 302 1800 Cincinnati 227 885 Colorado 214 855 Los Angeles Dodgers 403 2400 Miami 188 650 Milwaukee 226 875 New York Mets 263 1350 Philadelphia 265 1250 Pittsburgh 229 900 St. Louis 294 1400 San Diego 225 890 San Francisco 387 2000 Washington 2871280
Run a regression that will use revenue to predict team value in excel. Thanks!
Explanation / Answer
The regression equation will be team value=a+b×revenue
In order to get value of a just use intercept function
The syntax will be =intercept(range containing team value,range containing revenue)
For b use the slope function
The syntax will be =slope(range containing team value,range containing revenue)
By range containg team value/revenue I mean the cell address for the whole column containg the data values
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.