Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How can I go about performing a two-way factorial ANOVA calculation within Excel on this data? I cannot use the ToolPak, I must work it
How can I go about performing a two-way factorial ANOVA calculation within Excel on this data? I cannot use the ToolPak, I must work it out in the excel workbook using the cells.
TOTAL NUMBER OF POINTS SCORED BY TEAM PER YEAR, SEPERATED BY CONFERENCES | ||||
2021 | 2022 | 2023 | ||
AFC Conference | Buffalo Bills | 483 | 455 | 451 |
New England Patriots | 462 | 364 | 236 | |
Miami Dolphins | 341 | 397 | 496 | |
New York Jets | 310 | 296 | 268 | |
Cincinnati Bengals | 460 | 418 | 366 | |
Pittsburgh Steelers | 343 | 308 | 304 | |
Cleveland Browns | 349 | 361 | 396 | |
Baltimore Ravens | 387 | 350 | 483 | |
Tennessee Titans | 419 | 298 | 305 | |
Indianapolis Colts | 451 | 289 | 396 | |
Houston Texans | 280 | 289 | 377 | |
Jacksonville Jaguars | 253 | 404 | 377 | |
Kansas City Chiefs | 480 | 496 | 371 | |
Las Vegas Raiders | 374 | 395 | 332 | |
Los Angeles Chargers | 474 | 391 | 346 | |
Denver Broncos | 335 | 287 | 357 | |
NFC Conference | Dallas Cowboys | 530 | 467 | 509 |
Philadelphia Eagles | 444 | 477 | 433 | |
Washington Commanders | 335 | 321 | 329 | |
New York Giants | 258 | 365 | 266 | |
Green Bay Packers | 450 | 370 | 383 | |
Minnesota Vikings | 425 | 424 | 344 | |
Chicago Bears | 311 | 326 | 360 | |
Detroit Lions | 325 | 453 | 461 | |
Tampa Bay Buccaneers | 511 | 313 | 348 | |
New Orleans Saints | 364 | 330 | 402 | |
Atlanta Falcons | 313 | 365 | 321 | |
Carolina Panthers | 304 | 347 | 236 | |
Los Angeles Rams | 460 | 307 | 404 | |
Arizona Cardinals | 449 | 340 | 330 | |
San Francisco 49ers | 427 | 450 | 360 | |
Seattle Seahawks | 395 | 407 | 364 |
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