what would be the formulas used for each question

what formula would use for average length of songs sung not by springsteen

The spreadsheet contains a list of songs that were played on the radio. For each song, we know the singer, the date the song was played, and the length of the song. Based on this data sutanwer the following questions by using data analysis functions and tools in Excel 1. How many song were sung by each singer? 2. How many songs were AT LEAST four minutes long? 3. How many songs played after June 15, 2005 werwung by Madonna? 4. What is the length of the played songs sung NOT by Springsteen? 1. Let the names of the singers only one 2. Show your mind your Depending on your method, you might need to create multiple worksheets to show work) Data View Help Insert Formulas Review Page Layout He Home X Cut Paste AA 1st $ - % Number Clipboard Font Anment > 55 -AVERAGEES(D2:0952 F F G H 01. Number of songs by each singer Manilow Mellencamp madonna Cher Eminem Moore Spears Springsteen 114 115 133 112 114 131 129 103 1 Song Number Singer 2 1 Cher 2 Cher 4 3 Cher 5 4 Cher 0 5 Cher 6 Cher 7 Chee 9 8 Cher 10 9 Cher 11 10 Cher 11 Chor 13 12. Ches 14 13 Cher 15 14 Cher 15. Cher 17 16 Cher 17 Cher 10 Cher 20 19 Cher 20 Cher 22 21 Cher 22 Che 24 23 Cher 2 Cher 25 Cher 2.Ch 21 Cher 20 Cher 10 29 Ches so Cher 31 Cher a Cher 14 13 Cher Cli 35 Cher Chat D Date Minutes 1/10/2004 5 1/10/2004 2 1/22/2004 2 212000 3 2/15/2004 2 2/15/2004 2 2/15/2004 2 2/15/2004 5 2/27/2004 5 2/21/2004 2/27/2004 2 2/21/2004 3 2127/2004 2 2127/2004 4 W222001 2 li 2004 5 4/1/2004 2 4/15/2004 2 U15/2004 2 4212004 41 512.1.2004 521/2004 521/2001 5121/2004 12/2004 6/2/2004 5 272004 62/2001 5 1/28/2004 2 6262004 5 626/2004 3 11.2004 5 2004 1720/2004 3 1002004 22004 4 1720/2004 3 92 il O c BP - 3 BE Brave The spreadsheet contains a list of songs that were played on the radio. For each song, we know the singer, the date the song was played, and the length of the song. Based on this data sutanwer the following questions by using data analysis functions and tools in Excel 1. How many song were sung by each singer? 2. How many songs were AT LEAST four minutes long? 3. How many songs played after June 15, 2005 werwung by Madonna? 4. What is the length of the played songs sung NOT by Springsteen? 1. Let the names of the singers only one 2. Show your mind your Depending on your method, you might need to create multiple worksheets to show work) Data View Help Insert Formulas Review Page Layout He Home X Cut Paste AA 1st $ - % Number Clipboard Font Anment > 55 -AVERAGEES(D2:0952 F F G H 01. Number of songs by each singer Manilow Mellencamp madonna Cher Eminem Moore Spears Springsteen 114 115 133 112 114 131 129 103 1 Song Number Singer 2 1 Cher 2 Cher 4 3 Cher 5 4 Cher 0 5 Cher 6 Cher 7 Chee 9 8 Cher 10 9 Cher 11 10 Cher 11 Chor 13 12. Ches 14 13 Cher 15 14 Cher 15. Cher 17 16 Cher 17 Cher 10 Cher 20 19 Cher 20 Cher 22 21 Cher 22 Che 24 23 Cher 2 Cher 25 Cher 2.Ch 21 Cher 20 Cher 10 29 Ches so Cher 31 Cher a Cher 14 13 Cher Cli 35 Cher Chat D Date Minutes 1/10/2004 5 1/10/2004 2 1/22/2004 2 212000 3 2/15/2004 2 2/15/2004 2 2/15/2004 2 2/15/2004 5 2/27/2004 5 2/21/2004 2/27/2004 2 2/21/2004 3 2127/2004 2 2127/2004 4 W222001 2 li 2004 5 4/1/2004 2 4/15/2004 2 U15/2004 2 4212004 41 512.1.2004 521/2004 521/2001 5121/2004 12/2004 6/2/2004 5 272004 62/2001 5 1/28/2004 2 6262004 5 626/2004 3 11.2004 5 2004 1720/2004 3 1002004 22004 4 1720/2004 3 92 il O c BP - 3 BE Brave