Question
- Generate a general information table. Name the worksheet Descriptive Statistics. - Use the Mean and Standard Deviation information generated from Descriptive Statistics, analyze the
- Generate a general information table. Name the worksheet Descriptive Statistics.
- Use the Mean and Standard Deviation information generated from Descriptive Statistics, analyze the Atlanta Football teams performance relative to all teams records. What factor(s) would you consider? And what is Atlanta Football teams record based on the factors you chose. Are they in top or bottom 0.3%; top or bottom 5%; or top or bottom 32%, etc.?
- List your computations and assessment of Falcons performance under the descriptive statistics table.
- Use the same football data to generate a Correlation table of all factors. Name the worksheet Correlation Analysis.
- Based on the Correlation table, analyze what factors are considered to be positively or negatively related to winning or losing. Ex: does Yards Gain much to do with Wins? Or, does Points Allowed much to do with losing? Make useful recommendations to Mr. Karn, and write down your assessment under the Correlation Table.
Yds Gain Pts Score Yds Allow Pts Allow Takeaway Giveaway Wins Arizona 6533 489 5147 313 33 24 13 Atlanta 5990 339 5562 345 23 30 8 Baltimore 5749 328 5398 401 14 28 5 Buffalo 5775 379 5702 359 25 19 8 Carolina 5871 500 5167 308 39 19 15 Chicago 5514 335 5527 397 17 21 6 Cincinatti 5728 419 5453 279 28 17 12 Cleveland 5311 278 6067 432 21 30 3 Dallas 5361 275 5570 374 11 33 4 Denver 5688 355 4530 296 27 31 12 Detroit 5547 358 5594 400 18 24 7 Green Bay 5353 368 5547 323 22 17 10 Houston 5564 339 4963 313 25 20 9 Indianapolis 5142 333 6066 408 25 30 8 Jacksonville 5581 376 6000 448 18 28 5 Kansas City 5299 405 5269 287 29 15 11 Miami 5307 310 6019 389 16 19 6 Minnesota 5139 365 5507 302 22 17 11 New England 5991 465 5431 315 21 14 12 New Orleans 6461 408 6620 476 22 20 7 NY Giants 5956 420 6725 442 27 21 6 NY Jets 5925 387 5098 314 30 24 10 Oakland 5336 359 5818 399 25 24 7 Philadelphia 5830 377 6426 430 26 31 7 Pittsburgh 6327 423 5809 319 30 28 10 San Diego 5949 320 5791 398 20 24 4 San Francisco 4860 238 6199 387 12 17 5 Seattle 6058 423 4668 277 22 16 10 St. Louis 4761 280 5885 330 26 21 7 Tampa Bay 6014 342 5446 417 23 28 6 Tennessee 4988 299 5475 423 19 33 3 Washington 5661 388 6090 379 26 22 9
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started