For this question, download the following data: SpotifyA_2023.dta…

For this question, download the following data: SpotifyA_2023.dta Download SpotifyA_2023.dta. You will need to use Stata to answer the following questions. Read each sub-question carefully for rounding instructions.
You have access to my actual Spotify streaming dataset for the past year, where I went down a very deep rabbit hole of K-pop and K-R&B. Analyze my streaming data (and possibly judge me). You will need Stata to complete this portion of the assignment.
The variables in this dataset are:
Name of Variable Description
artists name of artist
soloist 1 if soloist, 0 if group
track_name song name
album_name album name
popularity popularity ranking of song, from 0 – 100; 100 is max popularity
duration_ms song length, in milliseconds
explicit is the song explicit. 1 if yes, 0 otherwise
danceability How danceable is the song from 0 – 1. Closer to 1 is more danceable
energy Song’s “energy” from 0-1. Closer to 1 has more energy
key Song’s key coded as a number.
loudness How “loud” the song is in decibels
mode major or minor key, 0 = major, 1 is minor
speechiness 0 -1, closer to 1 is more speechy
acousticness 0-1, closer to 1 is more acoustic
instrumentalness 0-1, closer to 1 has more instrumentation
liveness 0-1, closer to 1 is more lively music
valence 0-1, closer to 1 is “happier”. Closer to 0 is “sadder”
tempo Speed of music
time_signature Song’s time signature.
ms_played How many milliseconds of the song was played
date Date played
minutes how many minutes played
repeats how many times the song was repeated by me
A. How many observations are in this data set?
B. How many songs had a popularity rating higher than 80?
C. How many songs in this sample are from BLACKPINK? Remember, since artists are strings, put the text you want in Quotes. For example, to filter by artists BTS, you’d use “BTS” rather than BTS.
D. How about for Red Velvet? Hint: This is case sensitive and space sensitive, so be sure to use Red Velvet exactly as is. _______
We want to know how musical “energy” for specific artists (in sample). So, let’s examine the above two groups, BLACKPINK and Red Velvet.
E. Who has more energetic songs? Red Velvet or BLACKPINK? Select your answer by typing the LETTER associated with the option. For example, if you choose option C, only type in “C”. _________
Red Velvet
BLACKPINK
F. What is the difference in energy between the two groups on average? Round to 2 decimal places, ie: 41.567 = 41.57. _________
Now, we want to know some summary statistics of another competing group, TWICE.
G. What is the average popularity of TWICE songs in our sample? Remember, Stata is case sensitive, so be sure to use TWICE rather than Twice. Round to to the nearest whole number. ie, 2.56 =3. _________
H. What is the median popularity value of TWICE songs? Round to to the nearest whole number. ie, 2.56 =3. __________
I. What is the standard deviation of the popularity of TWICE songs? Round to to the nearest whole number. ie, 2.56 =3. __________
Now, let’s compare with a solo artist. Specifically, we’re going to look at IU.
J. What is the average popularity for IU? Again, case sensitive, so be sure to use IU as your string text. Round to to the nearest whole number. ie, 2.56 =3._________
You want to see if there is a relationship between popularity and danceability.
K. Calculate the correlation between these two variables. Round to 2 decimal places, ie: 41.567 = 41.57. __________
L. In sample, which song did I listen to the most? ie: what song was played the most in sample? Select your answer by typing the LETTER associated with the option. For example, if you choose option C, only type in “C”. ___________
I CAN’T STOP ME
SOLO
MONEY
HIP
YEAH YEAH YEAH
BAD BOY
28 Reasons
LILAC
Psycho
M. How many times did I apparently repeat this song (don’t judge me) ___________
N. What was the most “popular” song I listened to? Select your answer by typing the LETTER associated with the option. For example, if you choose option C, only type in “C”.
Talk That Talk
Love Dive
ZOOM
MONEY
28 Reasons
Feel My Rhythm
After LIKE
Love Shot
FEARLESS
O. How many of Kpop group LE SSERAFIM’s (Use LE SSERAFIM as the case correct spelling) songs are “happier/more positive”? Spotify uses the valence measure, between 0 and 1 to measure this. For our purposes, anything >= 0.6 is considered happy.
P. Which song is the saddest for BTS? That is, which song has the lowest valence for BTS (Use BTS as the case correct spelling)? Remember, lower value = “sadder”. Select your answer by typing the LETTER associated with the option. For example, if you choose option C, only type in “C”. __________
Dynamite
Butter
Butterfly
ON
Permission to Dance
Q. How fast is the fastest song for MAMAMOO? Tempo is a measure of speed, so you want the highest value for MAMAMOO. The correct case is MAMAMOO. Round to to the nearest whole number. ie, 2.56 =3. __________
R. What is the SHARE (%) of songs by BLACKPINK that have a danceability of above 0.8? Round to to the nearest whole number. ie, 2.56 =3. Do NOT include the % symbol.
S. How many solo artists are in this sample?
T. Which songs are more popular? Soloists or groups? Select your answer by typing the LETTER associated with the option. For example, if you choose option C, only type in “C”.
Soloists
Groups
Some soloists are actually part of groups. Let’s compare the popularity and danceability of songs by soloists from groups and compare them with their own groups.
U. First, let’s examine the group Red Velvet and member SEULGI. How many solo songs does she have in sample?
V. What is the average popularity and “sadness” of her solo songs? Round to 2 decimal places, ie: 41.567 = 41.57.
Average Popularity:
Average Sadness:
W. Compare this to her group. How many songs does Red Velvet have in sample?
X. How popular is their most popular song? Hint: what is the highest popularity ranking they have in sample? Round to to the nearest whole number. ie, 2.56 =3.
Y. What is the average popularity and “sadness”” of Red Velvet songs? Round to 2 decimal places, ie: 41.567 = 41.57.
Average Popularity:
Average Sadness:
Z. Is the most popular Red Velvet Song more or less popular than SEULGI’s solo song? For reference, you’ll notice that Seulgi’s only song in sample is “28 Reasons”. Is Red Velvet’s most popular song more or less popular than “28 Reasons”? Select your answer by typing the LETTER associated with the CORRECT option. For example, if you choose option C, only type in “C”.
More Popular
Less Popular