The worksheet titled "Question 5 Data" data related to the number of tracks sold according to the artist, album and song name, genre, and more.
1. Perform a regression analysis for the quantity of tracks sold using the independent variables price, the maximum chart position, as well as the duration of the track. The duration of the track is represented by the Millieseconds column.
2. Create your regression analysis on a new worksheet, and name the worksheet "Answer 5 Regression Analysis". This worksheet should appear after the "Question 5 Data" tab.
3. Once you have completed the regression analysis, answer the questions in the worksheet titled "Question 5.1 - 5.3" based on this regression analysis. Answer the three questions (Question 5.1 - 5.3) in the spaces provided in the worksheet. Please note that your answer should not exceed the space provided, approximately 50 words for Questions 5.2 and 5.3.