Need help with solving 2 items from Business Statistics. I received an excel spreadsheet with data from Spotify in it. I already cleaned the Data sheet, so right now I need to know the best approach on how to solve it using excel (steps on how to do it). A written explanation need to be provided as well.

Item 1: Show general patterns.

Item 2: How has the average popularity varied over the years? Decades? Show on a time-series.

Obs: The Years go from 1921 to 2020. Since I couldn't upload the file, I'm posting a pic.

AutoSave . Off) H Search Leonardo Ramos Coutinho LR File Insert Page Layout Formulas Data Review View Help Share Comments X Cut ab Wrap Text General AutoSum Calibri Conditional Format as Cell Insert Delete Format Fill AY O Sort & Find & Ideas Format Painter EE Z E Merge & Center $ ~ % 9 08 20 Formatting * Table Styles Clear Sensitivity Filter ~ Select Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity Q19 X Y fix D E G H K M N Q ARTISTS Song Name Year Popularity Acousticness Danceability Energy Explicit Liveness Loudness Tempo Valence 'Dennis Day' Clancy Lowered the Boom 1921 0.732 0.819 0.341 No 0.16 0.963 3 'Sergei Rachmaninoff', 'Jame Piano Concerto No. 3 in D Minor, Op. 30: Ill. Fir 1921 0.982 0.279 0.211 No 0.665 20.096 80.954 0.0594 4 'John Mccormack' The Wearing of the Green 1921 0.996 0.203 No 0.115 10.589 66.221 0.406 5 'Sergei Rachmaninoff', 'Jame Piano Concerto No. 3 in D Minor, Op. 30: Ill. Fir O O O O O O O O N O O O O O O O N W W W N A A O UT DO 0.518 0.982 0.279 0.211 No 0.665 -20.096 80.954 0.0594 6 'Phil Regan' When Irish Eyes Are Smiling 0.193 No 0.229 -10.096 101.665 0.253 'Phil Regan' Come Back To Erin 1921 0.957 0.259 0.212 No 0.236 85.726 0.218 8 'Sergei Rachmaninoff', 'Zubin Rhapsody on a Theme of Paganini, Op. 43: Var. 1921 0.992 0.241 0.109 No 0.0771 0.0379 'Frank Parker' Danny Boy 1921 0.967 0.275 0.309 No 0.381 9.316 100.109 0.165 10 'Dennis Day' How Can You Buy Killarny 1921 0.941 0.274 No 0.0984 9.75 0.212 11 'Sergei Rachmaninoff' Morceaux de fantaisie, Op. 3: No. 2, PrAOlude 0.993 0.389 0.088 No 0.363 21.091 92.867 0.0731 12 'Ignacio Corsini' La MaAtanita - Remasterizado 1921 0.996 0.485 0.13 No 0.104 21.508 64.678 0.721 13 'FortugAO' Il Etait SyndiquAC 1921 0.982 0.684 0.504 -16.415 109.378 0.771 14 'Maurice Chevalier' Dans La Vie Faut Pas S'en Faire 0.463 0.26 No 0.258 0.826 15 'Ignacio Corsini' Por Que Me Dejaste - Remasterizado 1921 0.994 0.378 0.115 No 0.11 27.039 0.578 16 'Georgel' La VipA"re 1921 0.99 0.315 0.363 No 0.292 12.562 174.532 0.493 17 'Mehmet Kemiksiz' Ud Taksimi 0.912 0.415 0.42 No 0.108 10.766 70.758 18 'Zay Gatsby' Power Is Power 0.0175 0.527 0.691 Yes 0.358 -7.298 159.935 0.493 19 'Sergei Rachmaninoff', 'Ruth 10 PrAludes, Op. 23: No. 5 in G Minor. Alla ma 1921 0.98 0.384 0.171 No 0.116 -20.476 107.698 0.282 20 'Hector Berlioz', 'Arturo Tosc RAjkA czy March 1921 0.996 0.541 0.283 No 0.393 -14.808 108.986 0.664 21 'THE GUY' When We Die 0.418 Yes -11.566 80.073 0.0778 22 'Christopher Lynch' A Ballynure Ballad 1921 0.971 0.54 0.0848 No 0.0887 -16.055 100.296 23 'FortugA@' Je Suis Toujours La 1921 0.994 0.67 0.113 No 0.213 0.672 24 'John Mccormack', 'Edwin So Mother Machree 1921 0.994 0.4 0.155 No 0.103 -13.976 170.251 .24 25 'Ignacio Corsini' Flor Marchita - Remasterizado 0.995 0.648 0.0995 No 0.112 22.429 71.978 26 'Hanende A brahim Efendi' A mtidadAt AAYkAtma 1921 0.995 0.223 0.245 No 0.354 14.387 142.136 0.381 27 'Mehmet Kemiksiz' Ney Taksimi 1921 0.41 28 'Sergei Rachmaninoff' Morceaux de fantaisie, Op. 3: No. 2, PrAOlude 1921 O 0.97 0.269 0.143 No 0.166 9.003 141.386 0.993 0.389 0.088 No 0.363 21.091 92.867 0.0731 29 'Maurice Chevalier' Je M'donne 1921 0.996 0.274 No -14.001 data + 100% Type here to search O 1 0 4074) ENG 6:26 PM 22/07/2020