Solution Found!
Technology Randomly select 50 songs from your music player
Chapter 2, Problem 3DP(choose chapter or problem)
Problem 3DP
Technology Randomly select 50 songs from your music player or music organization program. Find the length (in seconds) for each song. Use these data to create a frequency table with 6 categories. Sketch a frequency polygon for the frequency table. Is the shape of the distribution of times uniform, skewed, or bell–shaped? Also note the genre of each song. Create a Pareto chart showing the frequencies of the various categories. Finally, note the year each song was released. Create a pie chart organized by decade to show the percentage of songs from various time periods.
Questions & Answers
QUESTION:
Problem 3DP
Technology Randomly select 50 songs from your music player or music organization program. Find the length (in seconds) for each song. Use these data to create a frequency table with 6 categories. Sketch a frequency polygon for the frequency table. Is the shape of the distribution of times uniform, skewed, or bell–shaped? Also note the genre of each song. Create a Pareto chart showing the frequencies of the various categories. Finally, note the year each song was released. Create a pie chart organized by decade to show the percentage of songs from various time periods.
ANSWER:
Solution:
Step 1 of 5:
Given that, randomly select 50 songs from the music player or the music organizer program.
We have to find the length (in seconds) for each song.
From the excel we have taken 300 songs randomly (in seconds).
The formula is “randbetween (300,600)”.
Then, the 50 random numbers are given below.
590 |
569 |
564 |
561 |
559 |
555 |
554 |
551 |
545 |
540 |
535 |
535 |
533 |
526 |
522 |
519 |
518 |
512 |
505 |
505 |
493 |
489 |
486 |
474 |
471 |
469 |
452 |
448 |
444 |
436 |
435 |
434 |
430 |
429 |
428 |
428 |
417 |
405 |
400 |
395 |
392 |
386 |
373 |
366 |
364 |
356 |
345 |
342 |
336 |
329 |
Now we have to make a frequency table with 6 categories.
That is,
Class boundaries |
Frequency |
300-350 |
5 |
350-400 |
8 |
400-450 |
11 |
450-500 |
7 |
500-550 |
12 |
550-600 |
8 |
N = 51 |