Please help me with my homework.

I uploaded pictures of me trying to do it and I don't know if I'm on the right track.

• Identify the independent and dependent variable.

• Create a scatterplot and perform a trendline analysis in Excel. This analysis will provide you with your regression equation and coefficient of determination. Upload this Excel file containing these results to your main discussion post

• State your regression equation in terms of your independent and dependent variable. Interpret what the slope and y-intercept represent within the context of this application.

• State and interpret your coefficient of determination within the context of this application.

• If you take the square root of your coefficient of determination, you will obtain the correlation coefficient. Determine the correlation coefficient and interpret it within the context of this application.

Team Name Team Code Revenue ($mil) Current Value ($mil)

Atlanta Hawks ATL 105 295

Boston Celtics BOS 151 452

Charlotte Bobcats CHA 98 281

Chicago Bulls CHI 169 511

Cleveland Cavaliers CLE 161 355

Dallas Mavericks DAL 146 438

Denver Nuggets DEN 113 316

Detroit Pistons DET 147 360

Golden State Warriors GSW 119 363

Houston Rockets HOU 153 443

Indiana Pacers IND 95 269

Los Angeles Clippers LAC 102 305

Los Angeles Lakers LAL 214 643

Memphis Grizzlies MEM 92 266

Miami Heat MIA 124 425

Milwaukee Bucks MIL 92 258

Minnesota timberwolves MIN 95 264

New Jersey Nets NJN 89 312

New Orleans Hornets NOH 100 280

New York Knicks NYK 226 655

Oklahoma City Thunder OKC 118 329

Orlando Magic ORL 108 385

Philadelphia 76ers PHI 110 330

Phoenix Suns PHX 147 411

Portland Trail Blazers POR 127 356

Sacramento Kings SAC 103 293

San Antonio Spurs SAS 135 404

Toronto Raptors TOR 138 399

Utah Jazz UTA 121 343

Washington Wizards WAS 107 322

PROBABILITY OUTPUT SUMMARY OUTPUT Normal Probability Plot Percentile 105 Regression Statistics 1.724138 39 Multiple F 0.942067 250 5.172414 92 R Square 0.887491 200 8.62069 92 Adjusted | 0.883324 150 12.06897 95 Standard [ 11.73133 100 15.51724 95 50 Observati 29 18.96552 98 20 40 60 80 100 120 22.41379 100 ANOVA Sample Percentile 25.86207 102 df SS MS F gnificance F 29.31034 103 Regressio 1 29311.18 29311.18 212.98 2.5E-14 32.75862 107 Residual 27 3715.85 137.6241 36.2069 108 Total 28 33027.03 39.65517 110 43.10345 113 Coefficientsandard Err t Stat 46.55172 118 P-value Lower 95%Upper 95%ower 95.09pper 95.0% 50 119 Intercept 8.157053 8.468523 0.96322 0.343985 -9.21892 25.53303 -9.21892 25.53303 53.44828 121 295 0.321642 0.02204 14.59384 2.5E-14 0.276421 0.366864 0.276421 0.366864 56.89655 124 60.34483 127 63.7931 135 67.24138 138 70.68966 146 74.13793 147 77.58621 147 81.03448 151 84.48276 153 87.93103 161 91.37931 169 94.82759 214 98.27586 226Team Name Team Code Revenue ($mil) Current Value ($mil) Atlanta Hawks ATL 105 295 Boston Celtics BOS 151 452 Charlotte Bobcats CHA 98 281 Chicago Bulls CHI 169 511 Cleveland Cavaliers CLE 161 355 Dallas Mavericks DAL 146 438 Denver Nuggets DEN 113 316 Detroit Pistons DET 147 360 Golden State Warriors GSW 119 363 Houston Rockets HOU 153 443 Indiana Pacers IND 95 269 Los Angeles Clippers LAC 102 305 Los Angeles Lakers LAL 214 643 Memphis Grizzlies MEM 92 266 Miami Heat MIA 124 425 Milwaukee Bucks MIL 92 258 Minnesota Timberwolves MIN 95 264 New Jersey Nets NJN 89 312 New Orleans Hornets NOH 100 280 New York Knicks NYK 226 655 Oklahoma City Thunder OKC 118 329 Orlando Magic ORL 108 385 Philadelphia 76ers PHI 110 330 Phoenix Suns PHX 147 411 Portland Trail Blazers POR 127 356 Sacramento Kings SAC 103 293 San Antonio Spurs SAS 135 404 Toronto Raptors TOR 138 399 Utah Jazz UTA 121 343 Washington Wizards WAS 107 322