Please work the problems in Excel and show the steps.

50. FILE Mr. William Profit is studying companies going public for the first time. He is particu- larly interested in the relationship between the size of the offering and the price per share. A sample of 15 companies that recently went public revealed the following information. Size Price Size Price ($ millions). per Share, ($ millions). per Share, Company y Company X 9.0 10.8 160.7 11.3 94.4 11.3 10 96.5 10.6 27.3 11.2 11 83.0 10.5 179.2 11.1 12 23.5 10.3 71.9 11.1 13 58.7 10.7 97.9 11.2 93.8 11.0 93.5 11.0 34.4 10.8 70.0 10.7 a. Determine the regression equation. b. Conduct a test to determine whether the slope of the regression line is positive. c. Determine the coefficient of determination. Do you think Mr. Profit should use the regression equation to accurately predict price per share? Why?41, FILE For each of the 32 National Football League teams, the numbers of points scored and allowed during the 2018 season are shown here: Points Points Points Points Team Wins Scored Allowed Team Wins Scored Allowed New York Jets 333 441 Chicago Bears 12 421 283 Cleveland Browns 359 392 Philadelphia Eagles 9 367 348 Denver Broncos 329 349 Tennessee Titans 9 310 303 Jacksonville Jaguars 245 316 Kansas City Chiefs 12 565 421 Minnesota Vikings 360 341 Baltimore Ravens 10 389 287 Oakland Raiders 290 467 Houston Texans 11 402 316 Cincinnati Bengals 368 455 Buffalo Bills 6 269 374 Washington Redskins 281 359 New Orleans Saints 13 504 353 Los Angeles Rams 13 527 BE Detroit Lions 6 324 360 Tampa Bay Buccaneers 396 464 Seattle Seahawks 10 428 347 Miami Dolphins 319 433 Indianapolis Colts 10 433 344 Pittsburgh Steelers 428 360 San Francisco 49ers 4 342 435 Green Bay Packers 376 400 Dallas Cowboys 10 339 324 New England Patriots 436 325 Carolina Panthers 376 382 New York Giants 412 Los Angeles Chargers 12 428 329 Arizona Cardinals 225 425 Atlanta Falcons 414 423 Assuming these are sample data, answer the following questions, You may use statisti- cal software to assist you. a. What is the correlation coefficient between these variables? Interpret your results. b. At the .05 significance level, can you conclude there is a negative association between "points scored" and "points allowed"