with excel formulas please

The following is a partial relative frequency distribution of class ranks in a Business College. Required: Determine the relative frequency for Sophomores: Relative Frequency Distribution Table Class Rank Freshmen Sophomore 18 19 20 Freshmen 21 Sophomore 22 Junior 23 Senior 24 25 Relative Frequency Class Rank 1 Junior 2 Senior 3 14 Suppose 800 students are enrolled in the college, determine the frequency distribution for these data 15 16 Number of Students Enrolled 17 800 0.36 0.2 0.14 A Gunded Workshoot scratch sheet Relative Frequency

The following is a partial relative frequency distribution of class ranks in a Business College. Required: Determine the relative frequency for Sophomores: Relative Frequency Distribution Table 4 Suppose 800 students are enrolled in the college, determine the frequency distribution for these dat: 15