In column B, use an appropriate Excel formula to return the first letter of the student's last name. (You may add columns for calculating interim steps if you'd like, though it isn't necessary.) 2. In column C, use an appropriate lookup formula to return the correct value from column J of the table, which says which days the student will be attending school in person. 3. Create a box-and-whisker plot that shows the distribution of Distance From School for each of the groups defined in Column C. 4. In cell J17, select the group who generally travels further to get to school. First Letter of Distance From Last Name In-Person Learning Days School 1.7 1.7 to Last name begins with A L Attend in persa Tuesday & Wed Thursday & Frid M Z Student Name Jessie Slyby Lisa Mahoney Luke Thakker Andrew Annunziata Patrick Bunce Garima Wisnieski Sean Nguyen 2.3 0.4 0.8 0.5 1.4 In general, students are traveling further to school on In column B, use an appropriate Excel formula to return the first letter of the student's last name. (You may add columns for calculating interim steps if you'd like, though it isn't necessary.) 2. In column C, use an appropriate lookup formula to return the correct value from column J of the table, which says which days the student will be attending school in person. 3. Create a box-and-whisker plot that shows the distribution of Distance From School for each of the groups defined in Column C. 4. In cell J17, select the group who generally travels further to get to school. First Letter of Distance From Last Name In-Person Learning Days School 1.7 1.7 to Last name begins with A L Attend in persa Tuesday & Wed Thursday & Frid M Z Student Name Jessie Slyby Lisa Mahoney Luke Thakker Andrew Annunziata Patrick Bunce Garima Wisnieski Sean Nguyen 2.3 0.4 0.8 0.5 1.4 In general, students are traveling further to school on