Australia's Exports and Imports of Services by Selected Regions Exports ($m) Imports ($m) Country 2017 2018 2017 2018 Africa 1,255 1,308 1,398 1,618 Americas 12,653 14,139 19,831 21,355 Asia 48,164 53,358 33,604 37,677 Europe 13,374 14,261 23,661 25,714 Oceania and Antartica 6,075 6,453 8,198 9,135 Other 3,457 3,266 2,581 2,284 Source: Australian Government: Department of Foreign Affairs and Trade Composition of Trade Australia 2018A recording label/entertainment promoter wishes to do a linear regression analysis to predict the concert attendance of an established Korean-pop band in their upcoming tour in 2021. He believes that the expected number of concert attendees is related and can be explained by the number of times that the band's songs have been downloaded in the social media. Yearly data concerning the two variables are collected and stored in 'ConcertDownloads16' worksheet in the xls. data file attached. ~ a) Based on the information provided above, specify the dependent variable and the independent variable for doing the regression analysis. Briefly explain the reasoning for your selection. 1 mark b) Using Excel, draw a chart to evaluate the number of concert attendance over time. Display your chart and provide a brief comment on what you can observe from the chart. 1 mark c) Using Excel, calculate the correlation value of the relationship between the two concerned variables. Then, provide an interpretation of the correlation calculated in terms of the relationship between the two variables. ~ 1 mark d) Use Excel to estimate a simple linear regression model. Display the Excel regression summary table and write the estimated linear equation. Then, provide an interpretation of the slope coefficient estimate of the linear model. 2.5 markse) Display the value of the coefficient of determination. Then, provide an interpretation of the coefficient of determination value in terms of the relationship between the two variables. 1.5 marks