For this assignment, you will use the data set found in Spotify music data set Spring 2022.xlsx Download Spotify music data set Spring 2022.xlsx to perform regression analysis using the technique taught in Lecture 7. This data set contains information from researching mass transit in random cities to understand which independent variables - price, rider income, population, and parking rates - are related to the number of weekly riders. The idea of this regression is to figure out which variable(s) have the most to do with weekly ridership.

To prepare to complete this assignment, first make sure you have access to Microsoft Excel. All OSU students can download a free copy of Office 365, which includes Excel. Visit the OSU Software Distribution Center webpageLinks to an external site. to do this. Once there, login to download the software.

If you already have Excel on your PC, make sure that it includes the Data Analysis Toolpak. Visit the Microsoft technical support webpage (Links to an external site.) to learn how to do this. More recent versions of Excel will include the Data Analysis toolpak. To determine if your version does, open Excel, click on the "Data" menu, and look for the Data Analysis icon in the toolbar.

To begin this assignment, start Excel and open the Spotify music data set Spring 2022.xlsx Download Spotify music data set Spring 2022.xlsx data set. You will need to:

1. Complete individual, simple regression analyses for each independent variable (Danceability, Duration, Loudness, Energy, etc.) with the dependent variable, Popularity.
2. Complete a multiple regression analysis of all independent variables with the dependent variable (Popularity).

Only after you've completed your regression analysis should you attempt to take the Lecture 7: Regression Analysis Assignment Quiz. During the quiz you will answer the questions based on the output of your regression analysis model. You will need to have your spreadsheet open so you can access your regression analysis output while you take the quiz.

year popularity danceability duration_ms energy liveness loudness 1921 0.653333333 0.418597333 260537.1667 0.231815133 0.20571 -17.04866667 1922 0.14084507 0.482042254 165469.7465 0.237815352 0.240719718 -19.27528169 1923 5.389189189 0.577340541 177942.3622 0.262406486 0.227462162 -14.12921081 1924 0.661016949 0.549894068 191046.7076 0.34434661 0.235219068 -14.23134322 1925 2.604316547 0.573863309 184986.9245 0.278593525 0.237667986 -14.14641367 1926 1.422351234 0.599880261 156881.6575 0.211467091 0.232369594 -18.49253846 1927 0.801626016 0.648268293 184993.5984 0.264321301 0.168450244 -14.42237398 1928 1.525773196 0.534287867 214827.9064 0.207947795 0.175289374 -17.19198255 1929 0.340336134 0.647669853 168999.4128 0.241800735 0.23600021 -16.53037605 1930 0.926715177 0.518175884 195150.2853 0.333523919 0.221310863 -12.86922141 1931 0.170807453 0.595221739 171553.4255 0.234496773 0.22742795 -16.5160942 1932 2.151394422 0.55779761 195749.3725 0.302067729 0.232496215 -13.36405578 1933 6.89869754 0.570290304 196219.2576 0.279899421 0.209071925 -13.06900868 1934 1.257785467 0.528705882 189356.1263 0.262131315 0.213452595 -14.75687543 1935 1.501317523 0.55586917 220124.247 0.246366976 0.229299868 -15.41474967 1936 5.080909091 0.558005545 220809.1864 0.308388609 0.221438273 -14.61299909 1937 3.328767123 0.54215723 223216.5586 0.311048295 0.225967732 -13.11514307 1938 2.096247961 0.479977977 249177.0995 0.28098124 0.237111093 -14.29058238 1939 4.36 0.5126828 221602.065 0.2826715 0.2391016 -13.90057 1940 0.93 0.52189235 182227.9445 0.310892895 0.2643351 -13.684048 1941 1.357291667 0.480481354 201904.575 0.265643198 0.201839896 -15.75553646 1942 1.126634958 0.464633888 222361.1683 0.256079471 0.212878419 -15.0290321 1943 1.181690141 0.455145634 240119.9099 0.279990042 0.239210704 -13.60212535 1944 3.192819149 0.500174468 245555.5864 0.253441449 0.238771941 -14.58205585 1945 2.1265 0.51914315 196161.557 0.226044416 0.20300995 -16.9814715 1946 1.656612529 0.414445012 267677.8231 0.222172309 0.210818329 -16.92177436 1947 1.615757576 0.471320848 233137.3842 0.2635512 0.223829394 -14.37760788 1948 1.527368421 0.463369474 199194.8742 0.242464841 0.219693579 -15.50540737 1949 0.4421994 223199.3275 0.246114615 0.20885855 -15.525845 1950 3.2065 0.5042531 215073.1255 0.314071195 0.2169584 -13.8638345 1951 3.1495 0.4624801 213154.641 0.254665655 0.2177774 -15.812066 1952 3.338 0.4570322 229434.727 0.25362601 0.2329723 -15.958866 1953 3.504615385 0.437426051 217455.5682 0.266196831 0.221734051 -15.49913487 1954 7.987 0.4656389 224029.368 0.264347385 0.21784115 -15.4080045 1955 10.1445 0.4881312 222137.446 0.29509634 0.22143535 -13.842262 1956 15.785 0.4878145 211846.9215 0.30476112 0.18225715 -14.1751955 1957 20.08205128 0.503481231 241604.8241 0.295279133 0.182748564 -14.12484872 1958 19.2575 0.4800214 214146.9005 0.308795755 0.20584085 -14.165171 1959 20.77333333 0.482114308 216292.8369 0.310994405 0.191842923 -14.46013692 1960 19.78378378 0.486029243 210209.6838 0.341142378 0.20786373 -13.8141027 1961 19.59842105 0.489165579 232186.6142 0.339531867 0.208912579 -14.17133053 1962 22.12736842 0.493164368 209294.4132 0.3710257 0.201895737 -13.17736421 1963 25.5355 0.48162135 200510.5485 0.365353885 0.2037453 -13.670647 1964 26.32102564 0.504176974 195536.4118 0.394438826 0.217232359 -13.0480759 1965 27.52 0.503450564 196342.0862 0.449027246 0.213839128 -11.88821333 1966 28.2815 0.5070205 216095.113 0.482208465 0.2180931 -11.3569195 1967 31.1905953 0.492688594 198987.5183 0.446823832 0.190917659 -11.70882941 3.939 1968 31.2595 0.5010081 214980.984 0.45696965 0.21735095 -12.043862 1969 32.844 0.4880978 242545.9405 0.48762513 0.2069659 -12.062166 1970 34.3945 0.5063075 242852.1515 0.49563305 0.2122688 -11.772558 1971 34.4475 0.50427385 260511.7935 0.496361255 0.21491455 -12.079936 1972 34.485 0.52099945 245914.2285 0.50452618 0.20695495 -11.7735635 1973 36.428 0.51544945 257002.7905 0.53613825 0.20137475 -11.260197 1974 32.2465 0.51533975 252555.791 0.514723655 0.20934635 -11.816489 1975 34.812 0.520998 254969.3715 0.523208505 0.21544135 -11.485939 1976 35.835 0.5297625 267676.967 0.55384325 0.2490322 -11.114237 1977 35.8465 0.5333237 257121.848 0.560287959 0.22321405 -11.0773545 1978 35.891 0.5407746 249051.887 0.561428865 0.21807095 -10.891868 1979 36.172 0.5620453 252860.2265 0.591012715 0.2134431 -10.9775135 1980 36.20666667 0.556152359 252835.5333 0.597777395 0.203754103 -10.70094205 1981 35.7525 0.5421847 250904.205 0.599382725 0.2250999 -10.9244045 1982 36.247 0.5642594 248357.306 0.590919389 0.20100675 -10.9331225 1983 36.268 0.5456293 251123.6985 0.601425235 0.19892245 -11.200171 1984 37.7745 0.53030895 251845.2565 0.591091675 0.1977062 -11.5232385 1985 37.013 0.5556424 252276.258 0.60151548 0.19920645 -11.3606885 1986 37.5775 0.5409334 254708.4055 0.6149546 0.21187945 -11.103995 1987 39.68512821 0.541019333 247543.3231 0.579839554 0.202018103 -11.62346718 1988 39.60051282 0.540459436 257442.5897 0.585679246 0.207707538 -11.51982103 1989 39.1825 0.54722745 254203.5935 0.584046375 0.1990802 -11.38413 1990 40.7855 0.53529865 256451.4035 0.571591395 0.1909609 -11.3274795 1991 41.65589744 0.555824359 245912.0062 0.559402364 0.188628923 -10.95576872 1992 42.994 0.55506485 246506.46 0.582864205 0.2002455 -10.5754045 1993 42.9975 0.56987815 251667.9675 0.56255991 0.19493225 -10.882701 1994 45.0615 0.55282995 250992.254 0.578772685 0.1921651 -10.282273 1995 44.801 0.55904575 246624.0915 0.57857951 0.2013737 -10.11945 1996 44.904 0.5878306 248180.983 0.586068475 0.1986863 -9.4438185 1997 45.582 0.57681385 245 749.2815 0.598698715 0.1984788 -9.2008755 1998 45.8945 0.58621165 248542.6075 0.605197505 0.1937309 -8.971168 1999 47.25832906 0.582157919 245177.7453 0.637522602 0.206308047 -8.266409534 2000 46.68404908 0.590918047 242724.6426 0.625412832 0.197686043 -8.247765849 2001 48.75012469 0.583317855 240307.796 0.626985522 0.187025636 -8.305095262 2002 48.6555 0.5761603 239503.283 0.641269796 0.1939112 -7.6866395 2003 48.62640737 0.575763306 244670.5752 0.660165261 0.196976305 -7.485545036 2004 49.27314344 0.567680366 237378.708 0.648867945 0.20219944 -7.601655137 2005 50.95333333 0.572280564 237229.5882 0.653208511 0.190081626 -7.466158974 2006 51.31384615 0.568230154 234042.9144 0.650326282 0.188289282 -7.265500513 2007 51.07589744 0.563414359 241049.9626 0.668304774 0.196126564 -7.044535897 2008 50.6301 7903 0.579192839 240107.3156 0.671460821 0.198431407 -6.843804092 2009 51.44081633 0.564190357 238140.0133 0.670748755 0.205252296 -7.046014796 2010 52.73015873 0.572488343 242811.8046 0.681777803 0.199700645 -6.909904266 2011 53.30738721 0.552866981 236998.7873 0.648300893 0.203308825 -7.574986118 2012 52.65501285 0.570881851 245807.4576 0.65657146 0.189733008 -7.260549614 2013 54.04706478 0.571148026 242267.6614 0.645596891 0.19963082 -7.472039474 2014 55.54314214 0.589947681 233728.3147 0.648795444 0.191821596 -7.0674399 2015 56.7006079 0.593774063 230029.0466 0.627064272 0.188856434 -7.625639311 2016 59.64718976 0.600202393 221396.5103 0.592855232 0.181169894 -8.061056205 2017 63.26355422 0.612217018 211115.6968 0.590421021 0.1917126 -8.312629518 2018 63.29624346 0.663500476 206001.0071 0.602434622 0.176325535 -7.168785069 2019 65.25654182 0.64481411 201024.7881 0.593224036 0.172616419 -7.722191893 2020 64.30197044 0.692904335 193728.3975 0.631231635 0.178535419 -6.595066995 Dependent (Y) variable: - popularity (Ranges from 0 to 100) Independent (X) variables: -danceability (Ranges from 0 to 1) duration_ms (Integer typically ranging from 200k to 300k) - energy (Ranges from 0 to 1) - liveness (Ranges from 0 to 1) - loudness (Float typically ranging from -60 to 0) -tempo (Float typically ranging from 50 to 150) tempo 101.5315 100.8845 114.0107 120.6896 115.5219 109.648 114.8465 106.7723 110.9484 109.8712 109.0253 115.1198 112.522 115.3908 110.668 109.8888 115.2632 111.6253 113.1746 108.4493 107.9151 106.0084 106.1968 105.9639 108.3241 103.1646 108.991 108.0584 108.8731 111.7497 109.6259 108.2323 110.0256 108.7131 111.0213 112.206 112.7523 113.3261 112.1177 112.5617 111.809 114.841 114.3246 115.0815 116.8354 116.3354 116.68 115.8326 117.0243 117.1116 118.2722 119.4129 120.1463 119.4165 118.684 120.5221 122.1854 120.3779 122.4568 122.985 123.1694 120.9186 121.0706 121.3767 121.9793 120.4993 120.8457 120.0244 120.579 120.0627 119.3626 122.5862 120.3649 118.4452 119.282 117.7084 118.1823 118.5401 119.5095 118.9993 117.7654 119.2397 120.9146 121.2903 121.618 121.7986 124.0875 123.5099 123.4638 123.5702 121.484 121.7817 120.8068 122.3053 120.1154 118.6526 117.2027 121.9223 120.2356 124.2831 year popularity danceability duration_ms energy liveness loudness 1921 0.653333333 0.418597333 260537.1667 0.231815133 0.20571 -17.04866667 1922 0.14084507 0.482042254 165469.7465 0.237815352 0.240719718 -19.27528169 1923 5.389189189 0.577340541 177942.3622 0.262406486 0.227462162 -14.12921081 1924 0.661016949 0.549894068 191046.7076 0.34434661 0.235219068 -14.23134322 1925 2.604316547 0.573863309 184986.9245 0.278593525 0.237667986 -14.14641367 1926 1.422351234 0.599880261 156881.6575 0.211467091 0.232369594 -18.49253846 1927 0.801626016 0.648268293 184993.5984 0.264321301 0.168450244 -14.42237398 1928 1.525773196 0.534287867 214827.9064 0.207947795 0.175289374 -17.19198255 1929 0.340336134 0.647669853 168999.4128 0.241800735 0.23600021 -16.53037605 1930 0.926715177 0.518175884 195150.2853 0.333523919 0.221310863 -12.86922141 1931 0.170807453 0.595221739 171553.4255 0.234496773 0.22742795 -16.5160942 1932 2.151394422 0.55779761 195749.3725 0.302067729 0.232496215 -13.36405578 1933 6.89869754 0.570290304 196219.2576 0.279899421 0.209071925 -13.06900868 1934 1.257785467 0.528705882 189356.1263 0.262131315 0.213452595 -14.75687543 1935 1.501317523 0.55586917 220124.247 0.246366976 0.229299868 -15.41474967 1936 5.080909091 0.558005545 220809.1864 0.308388609 0.221438273 -14.61299909 1937 3.328767123 0.54215723 223216.5586 0.311048295 0.225967732 -13.11514307 1938 2.096247961 0.479977977 249177.0995 0.28098124 0.237111093 -14.29058238 1939 4.36 0.5126828 221602.065 0.2826715 0.2391016 -13.90057 1940 0.93 0.52189235 182227.9445 0.310892895 0.2643351 -13.684048 1941 1.357291667 0.480481354 201904.575 0.265643198 0.201839896 -15.75553646 1942 1.126634958 0.464633888 222361.1683 0.256079471 0.212878419 -15.0290321 1943 1.181690141 0.455145634 240119.9099 0.279990042 0.239210704 -13.60212535 1944 3.192819149 0.500174468 245555.5864 0.253441449 0.238771941 -14.58205585 1945 2.1265 0.51914315 196161.557 0.226044416 0.20300995 -16.9814715 1946 1.656612529 0.414445012 267677.8231 0.222172309 0.210818329 -16.92177436 1947 1.615757576 0.471320848 233137.3842 0.2635512 0.223829394 -14.37760788 1948 1.527368421 0.463369474 199194.8742 0.242464841 0.219693579 -15.50540737 1949 0.4421994 223199.3275 0.246114615 0.20885855 -15.525845 1950 3.2065 0.5042531 215073.1255 0.314071195 0.2169584 -13.8638345 1951 3.1495 0.4624801 213154.641 0.254665655 0.2177774 -15.812066 1952 3.338 0.4570322 229434.727 0.25362601 0.2329723 -15.958866 1953 3.504615385 0.437426051 217455.5682 0.266196831 0.221734051 -15.49913487 1954 7.987 0.4656389 224029.368 0.264347385 0.21784115 -15.4080045 1955 10.1445 0.4881312 222137.446 0.29509634 0.22143535 -13.842262 1956 15.785 0.4878145 211846.9215 0.30476112 0.18225715 -14.1751955 1957 20.08205128 0.503481231 241604.8241 0.295279133 0.182748564 -14.12484872 1958 19.2575 0.4800214 214146.9005 0.308795755 0.20584085 -14.165171 1959 20.77333333 0.482114308 216292.8369 0.310994405 0.191842923 -14.46013692 1960 19.78378378 0.486029243 210209.6838 0.341142378 0.20786373 -13.8141027 1961 19.59842105 0.489165579 232186.6142 0.339531867 0.208912579 -14.17133053 1962 22.12736842 0.493164368 209294.4132 0.3710257 0.201895737 -13.17736421 1963 25.5355 0.48162135 200510.5485 0.365353885 0.2037453 -13.670647 1964 26.32102564 0.504176974 195536.4118 0.394438826 0.217232359 -13.0480759 1965 27.52 0.503450564 196342.0862 0.449027246 0.213839128 -11.88821333 1966 28.2815 0.5070205 216095.113 0.482208465 0.2180931 -11.3569195 1967 31.1905953 0.492688594 198987.5183 0.446823832 0.190917659 -11.70882941 3.939 1968 31.2595 0.5010081 214980.984 0.45696965 0.21735095 -12.043862 1969 32.844 0.4880978 242545.9405 0.48762513 0.2069659 -12.062166 1970 34.3945 0.5063075 242852.1515 0.49563305 0.2122688 -11.772558 1971 34.4475 0.50427385 260511.7935 0.496361255 0.21491455 -12.079936 1972 34.485 0.52099945 245914.2285 0.50452618 0.20695495 -11.7735635 1973 36.428 0.51544945 257002.7905 0.53613825 0.20137475 -11.260197 1974 32.2465 0.51533975 252555.791 0.514723655 0.20934635 -11.816489 1975 34.812 0.520998 254969.3715 0.523208505 0.21544135 -11.485939 1976 35.835 0.5297625 267676.967 0.55384325 0.2490322 -11.114237 1977 35.8465 0.5333237 257121.848 0.560287959 0.22321405 -11.0773545 1978 35.891 0.5407746 249051.887 0.561428865 0.21807095 -10.891868 1979 36.172 0.5620453 252860.2265 0.591012715 0.2134431 -10.9775135 1980 36.20666667 0.556152359 252835.5333 0.597777395 0.203754103 -10.70094205 1981 35.7525 0.5421847 250904.205 0.599382725 0.2250999 -10.9244045 1982 36.247 0.5642594 248357.306 0.590919389 0.20100675 -10.9331225 1983 36.268 0.5456293 251123.6985 0.601425235 0.19892245 -11.200171 1984 37.7745 0.53030895 251845.2565 0.591091675 0.1977062 -11.5232385 1985 37.013 0.5556424 252276.258 0.60151548 0.19920645 -11.3606885 1986 37.5775 0.5409334 254708.4055 0.6149546 0.21187945 -11.103995 1987 39.68512821 0.541019333 247543.3231 0.579839554 0.202018103 -11.62346718 1988 39.60051282 0.540459436 257442.5897 0.585679246 0.207707538 -11.51982103 1989 39.1825 0.54722745 254203.5935 0.584046375 0.1990802 -11.38413 1990 40.7855 0.53529865 256451.4035 0.571591395 0.1909609 -11.3274795 1991 41.65589744 0.555824359 245912.0062 0.559402364 0.188628923 -10.95576872 1992 42.994 0.55506485 246506.46 0.582864205 0.2002455 -10.5754045 1993 42.9975 0.56987815 251667.9675 0.56255991 0.19493225 -10.882701 1994 45.0615 0.55282995 250992.254 0.578772685 0.1921651 -10.282273 1995 44.801 0.55904575 246624.0915 0.57857951 0.2013737 -10.11945 1996 44.904 0.5878306 248180.983 0.586068475 0.1986863 -9.4438185 1997 45.582 0.57681385 245 749.2815 0.598698715 0.1984788 -9.2008755 1998 45.8945 0.58621165 248542.6075 0.605197505 0.1937309 -8.971168 1999 47.25832906 0.582157919 245177.7453 0.637522602 0.206308047 -8.266409534 2000 46.68404908 0.590918047 242724.6426 0.625412832 0.197686043 -8.247765849 2001 48.75012469 0.583317855 240307.796 0.626985522 0.187025636 -8.305095262 2002 48.6555 0.5761603 239503.283 0.641269796 0.1939112 -7.6866395 2003 48.62640737 0.575763306 244670.5752 0.660165261 0.196976305 -7.485545036 2004 49.27314344 0.567680366 237378.708 0.648867945 0.20219944 -7.601655137 2005 50.95333333 0.572280564 237229.5882 0.653208511 0.190081626 -7.466158974 2006 51.31384615 0.568230154 234042.9144 0.650326282 0.188289282 -7.265500513 2007 51.07589744 0.563414359 241049.9626 0.668304774 0.196126564 -7.044535897 2008 50.6301 7903 0.579192839 240107.3156 0.671460821 0.198431407 -6.843804092 2009 51.44081633 0.564190357 238140.0133 0.670748755 0.205252296 -7.046014796 2010 52.73015873 0.572488343 242811.8046 0.681777803 0.199700645 -6.909904266 2011 53.30738721 0.552866981 236998.7873 0.648300893 0.203308825 -7.574986118 2012 52.65501285 0.570881851 245807.4576 0.65657146 0.189733008 -7.260549614 2013 54.04706478 0.571148026 242267.6614 0.645596891 0.19963082 -7.472039474 2014 55.54314214 0.589947681 233728.3147 0.648795444 0.191821596 -7.0674399 2015 56.7006079 0.593774063 230029.0466 0.627064272 0.188856434 -7.625639311 2016 59.64718976 0.600202393 221396.5103 0.592855232 0.181169894 -8.061056205 2017 63.26355422 0.612217018 211115.6968 0.590421021 0.1917126 -8.312629518 2018 63.29624346 0.663500476 206001.0071 0.602434622 0.176325535 -7.168785069 2019 65.25654182 0.64481411 201024.7881 0.593224036 0.172616419 -7.722191893 2020 64.30197044 0.692904335 193728.3975 0.631231635 0.178535419 -6.595066995 Dependent (Y) variable: - popularity (Ranges from 0 to 100) Independent (X) variables: -danceability (Ranges from 0 to 1) duration_ms (Integer typically ranging from 200k to 300k) - energy (Ranges from 0 to 1) - liveness (Ranges from 0 to 1) - loudness (Float typically ranging from -60 to 0) -tempo (Float typically ranging from 50 to 150) tempo 101.5315 100.8845 114.0107 120.6896 115.5219 109.648 114.8465 106.7723 110.9484 109.8712 109.0253 115.1198 112.522 115.3908 110.668 109.8888 115.2632 111.6253 113.1746 108.4493 107.9151 106.0084 106.1968 105.9639 108.3241 103.1646 108.991 108.0584 108.8731 111.7497 109.6259 108.2323 110.0256 108.7131 111.0213 112.206 112.7523 113.3261 112.1177 112.5617 111.809 114.841 114.3246 115.0815 116.8354 116.3354 116.68 115.8326 117.0243 117.1116 118.2722 119.4129 120.1463 119.4165 118.684 120.5221 122.1854 120.3779 122.4568 122.985 123.1694 120.9186 121.0706 121.3767 121.9793 120.4993 120.8457 120.0244 120.579 120.0627 119.3626 122.5862 120.3649 118.4452 119.282 117.7084 118.1823 118.5401 119.5095 118.9993 117.7654 119.2397 120.9146 121.2903 121.618 121.7986 124.0875 123.5099 123.4638 123.5702 121.484 121.7817 120.8068 122.3053 120.1154 118.6526 117.2027 121.9223 120.2356 124.2831