1. Create two frequency tables based on two separate questions from your survey.
2. Create bar graph and a pie chart based on the data in the frequency tables.
3. Determine the class intervals and create frequency distribution for each of the frequency tables.
4. Create one frequency polygon of the data from the frequency distribution.

Use the table below to create an individual Excel document for each of the required items.

data collection Draw Page Layout Formulas Data View Tell me Share Comments Calibri (Body) 12 A General Conditional Formatting v Insert v Format as Table v Paste B VA Ideas Sensitivity i Cell Styles v Format v Filter Select X fx B D E M 3 Rank Teams Active Players Forwards Midfielders Defensemen Goalkeepers Transfer Fees Managers Est. Total Salary 1 Manchester City F.C. 24 $29,907,000 $76,084,000 $32,240,000 $7,540,000 2167,580,000 E20m $145,771,000 2 Manchester United F.C. 27 $27,300,000 $39,260,000 $43,935,000 $24,700,000 $179,060,000 $7.5m $135,195,000 3 Liverpool F.C. 24 $27,820,000 $46,020,000 $29,536,000 19,350,000 17.5m 2109,356,000 4 Chelsea F.C. 28 825,790,000 $45,420,000 $27,480,000 $51,300,000 E5m $107,690,000 5 Arsenal F.C. 22 827,147,273 $33,900,000 $32,1 19,000 $6,240,000 $139,540,000 E6m 199,406,273 6 Tottenham Hotspur F.C. 24 $17,680,000 $33,280,000 $24,778,000 $6,240,000 $132,180,000 E15m 281,978,000 10 7 Everton F.C. 24 $21,225,000 $28,351,000 $24,180,000 $133,840,000 E11m $78,956,000 8 Crystal Palace 25 $25,870,000 218,200,000 $22,672,000 $5,200,000 $6,950,000 E5m $71,942,000 9 Leicester City 28 $15,600,000 $25,664,000 $20,280,000 $8,996,000 $113,320,000 f5m $70,540,000 13 10 West Ham United F.C. 27 85,980,000 $26,520,000 $17,940,000 $1 19,460,000 E7m $53,820,000 14 11 Southampton F.C. 22 210,660,000 $18,356,000 16,380,000 $4,680,000 $62,250,000 :5m $50,076,000 15 12 Watford 30 212,636,000 $14,456,000 $12,272,000 $41,590,000 E4m $43,056,000 16 13 Burnley F.C. 25 23,640,000 $16,328,000 $12,636,000 $14,773,000 E3m $37,024,000 17 14 AFC Bournemouth 29 211,960,000 19,880,000 $12,684,000 $2,236,000 $63,500,000 E4m E36,760,000 18 15 Newcastle United F.C. 27 26,448,000 $11,441,000 $15,496,000 $2,600,000 $104,200,000 4.5m $35,985,000 16 Brighton & Hove Albion 28 87,020,000 $10,660,000 $10,684,000 E3,486,666 $57,940,000 E3.5m 31,850,666 20 17 Wolverhampton Wanderers F.C. 21 25,416,000 $14,374,000 24,767,000 $5,200,000 $132,140,000 E4m $29,757,000 21 18 Norwich City F.C. 25 21,144,000 $5,044,000 26,302,000 1884,000 $1,496,000 E4m $13,374,000 22 19 Sheffield United F.C. 25 $2,652,000 13,692,000 25,096,000 $780,000 $66,980,0 E4m 212,220,000 23 20 Leeds Utd 25 $2,652,001 E3,682,001 $5,090,001 $770,001 14m $12,210,000 24 21 West Brom 24 $2,602,002 $3,672,002 $5,086,002 $760,002 $66,780,002 E4m $12,200,000 25 22 Bentford 24 $2,650,003 $3,662,003 $5,076,003 $770,003 266,680,003 E4m $12,150,000 26 25 $2,602,004 E3,652,004 $5,066,004 $750,004 $66,580,004 E4m $12,130,000 27 24 Nottam Forest 26 82,612,005 $3,642,005 $5,056,005 $780,005 $66,380,005 E4m $12,120,000 28 27 82,651,006 $5,046,006 $780,006 $66,480,006 E4m $12,110,000 29 26 Swansea 23 12,654,007 E3,492,007 25,036,007 $780,100 $66,280,007 E4m $11,220,000 30 27 Preston 24 $2,610,008 $3,392,008 $5,026,008 $780,208 $66,580,008 E4m $11,210,000 31 28 Millwall 25 $2,502,009 $3,390,009 $5,016,009 $780,109 $66,180,009 E4m $11,200,000 32 24 $2,630,010 E3,382,010 $4,096,010 $780,110 E66,988,010 E3m $11,150,000 33 30 Blackburn 25 $2,550,011 $3,380,011 $4,596,011 $680,011 $66,900,011 E2m $11,130,000 Sheet1 100%