Music table

1. You will create a database of 25 songs from your music player or music organization program (iTunes, Pandora, etc.). Either select the songs randomly (perhaps by using a random shuffle) or systematically (every 5th song, or every 10th song, etc.). Creating an Excel spreadsheet is suggested/recommended for your database. You will need to turn in your database along with the other components of your project.
For each song, record the following information:
• Title of Song
• Artist
• Genre (Country, Pop, Rap, Gospel, etc.)
• Year the song was released.
• The length (in seconds) for each song. (This may be the most tedious of the
variables to record. Multiply the minutes by 60 and then add any remaining seconds to get your total length. Here are a couple of examples:
o 3 minute 25 second (3:25) song = 3*60 + 25 = 205 seconds o 4 minute 17 second (4:17) song = 4*60 + 17 = 257 seconds
2. Write a brief statement or two about how you selected your songs, and from how many. Did you use a random shuffle, use random numbers, systematic sampling, or something else? Give the actual number or an estimate of about how many songs are in your music library.
3. Using the lengths of each song (in seconds), create a frequency table with at least 4 to 6 rows.
The frequency table should include: -Bin
-Frequency
-Relative Frequency
-Cumulative Frequency
Remember to use a consistent bin size and one that is appropriate for your data. For example, if your shortest song is 130 seconds (2:10) and your longest song is 277 seconds (4:37), then it might be appropriate to use a 50-point bins as follows:
50 – 99 100 – 149 150 – 199 200 – 249 250 – 299
Again, this is not a one-size-fits-all table! You want to try to create a table that is consistent and with no gaps (no zero rows). If you have a zero row, then try increasing the bin size.
4. Create a histogram for the frequency table and write a statement about the shape of your data. Is it bi-modal, symmetric (bell-shaped), uniform, left-skewed, right-skewed, or no pattern at all?
5. Usingthegenreofeachsong,createapiechartthatshowsthepercentagesof each category. If all of your songs are within the same genre, then find some other logical way to group them – perhaps by artist or decades.
6. Lastly, look at your list of years and identify the following: a. Minimum(theearliestyear)
b. Maximum(thelatestyear)
c. Range (Maximum – Minimum)
Make a comment about the range and what your preferences in music are. Do you tend to like songs from only the last 10 years or is your range of time broader than that?

Last Completed Projects