SPREADSHEET EXERCISE #$4$

Refer to the Baseball $2023$ data, which report information on the $30$ Major League

Baseball team for the $2023$ season.

a$.$ Compute descriptive statistics on variable size $($number of people baseball stadium

can accommodate$).$ Plot Histogram. Draw the inference.

b$.$ Draw the $2-$D Column chart for a team and Average Player Salary. Draw the

inference. COLUMN F

c$.$ Can we conclude that there is a difference in the mean salary of American League

teams versus the National League? ONE MORE PAY MORE THAN OTHER

Or

d$.$ Can we conclude that there is a difference in the mean home attendance of teams in

the American League versus the National League?

e$.$ Can we conclude that there is a difference in the mean number of wins between the

top $10$ teams with the highest salaries and the bottom $10$ teams with the lowest

salaries? Does higher payroll tend to win more?Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off?

$\backslash$table$[[1,$Team,League,Size,Surface,Roof,Salary,Wins,Attendance,ERA,Batting$],[3,$Atlanta,$0,50,062,0,0,206,239,131,105,3,191,505,3\mathrm{.}34,0\mathrm{.}276],[4,$Chicago Cubs,$0,41,019,0,0,189,629,358,83,2,775,149,3\mathrm{.}22,0\mathrm{.}254],[5,$Cincinnati,$0,42,059,0,0,96,577,288,82,2,038,310,3\mathrm{.}83,0\mathrm{.}249],[7,$Los Angels Dodgers,$0,56,000,0,0,240,278,296,100,3,837,079,2\mathrm{.}83,0\mathrm{.}257],[8,$Miami Marlins,$0,36,742,0,1,105,435,809,84,1,162,819,3\mathrm{.}22,0\mathrm{.}259],[,$Milwaukee,$0,41,900,0,1,125,338,345,92,2,551,317,3\mathrm{.}07,0\mathrm{.}240],[0,$New York Mats,$0,41,922,0,0,343,605,067,75,2,573,555,3\mathrm{.}78,0\mathrm{.}238],[,$Philadelphia,$0,43,500,0,0,245,419,295,93,3,052,605,2\mathrm{.}93,0\mathrm{.}256],[2,$Pittsburgh,$0,38,127,0,0,68,945,975,76,1,630,624,3\mathrm{.}75,0\mathrm{.}239],[,$Washington,$0,41,418,0,0,93,378,663,71,1,865,832,3\mathrm{.}73,0\mathrm{.}254],[7,$Baltimore,$1,45,971,0,0,71,061,047,101,1,936,798,2\mathrm{.}93,0\mathrm{.}255],[,$Boston,$1,37,500,0,0,182,926,796,78,2,672,130,3\mathrm{.}13,0\mathrm{.}258],[9,$Chicago White Sox,$1,40,615,0,0,162,863,836,61,1,669,628,4\mathrm{.}11,0\mathrm{.}238],[$o$,$Cleveland,$1,38,000,0,0,91,861,627,102,1,834,068,3\mathrm{.}33,0\mathrm{.}250],[1,$Detroit,$1,41,000,0,0,121,494,514,78,1,612,876,2\mathrm{.}97,0\mathrm{.}236],[2,$Houston,$1,42,000,0,1,237,107,748,91,3,052,347,3\mathrm{.}34,0\mathrm{.}259],[,$Kansas City,$1,37,903,0,0,96,083,853,56,1,307,052,3\mathrm{.}53,0\mathrm{.}244],[\frac{1}{4},$Los Angeles Angels,$1,45,483,0,0,230,534,276,73,2,640,575,4\mathrm{.}00,0\mathrm{.}245],[,$Minnesota,$1,39,021,1,0,156,104,540,90,1,974,124,2\mathrm{.}75,0\mathrm{.}243],[5,$New York Yankees,$1,49,642,0,0,279,131,154,91,3,269,016,3\mathrm{.}18,0\mathrm{.}227]]$