A 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 bands songs have been downloaded in the social media Yearly data concerning the two variables are collected and stored in the file attached 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 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 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 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 e) 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 A 1 Year 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 B C Concert attendees Song downloads 2005 1,236,332 1,230,425 2006 1,256,431 1,230,543 2007 1,277,532 1,246,663 2008 1,317,656 1,245,532 2009 1,307,456 1,325,662 2010 1,328,889 1,256,666 2011 1,422,331 1,283,245 2012 1,456,021 1,412,222 2013 1,485,456 1,453,333 2014 1,493,332 1,466,665 2015 1,533,356 1,477,565 2016 1,563,331 1,492,235 2017 1,573,345 1,423,355 2018 1,583,356 1,411,235 2019 1,602,345 1,722,300 2020 1,633,331 1,734,455 A 1 Year 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 B C Concert attendees Song downloads 2005 1,236,332 1,230,425 2006 1,256,431 1,230,543 2007 1,277,532 1,246,663 2008 1,317,656 1,245,532 2009 1,307,456 1,325,662 2010 1,328,889 1,256,666 2011 1,422,331 1,283,245 2012 1,456,021 1,412,222 2013 1,485,456 1,453,333 2014 1,493,332 1,466,665 2015 1,533,356 1,477,565 2016 1,563,331 1,492,235 2017 1,573,345 1,423,355 2018 1,583,356 1,411,235 2019 1,602,345 1,722,300 2020 1,633,331 1,734,455

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 06, 2024

A 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

A 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 bands songs have been downloaded in the social media. Yearly data concerning the two variables are collected and stored in the file attached.

image text in transcribed

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.

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.

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.

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.

e). 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.

A . 1 Year 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 B C Concert attendees Song downloads 2005 1,236,332 1,230,425 2006 1,256,431 1,230,543 2007 1,277,532 1,246,663 2008 1,317,656 1,245,532 2009 1,307,456 1,325,662 2010 1,328,889 1,256,666 2011 1,422,331 1,283,245 2012 1,456,021 1,412,222 2013 1,485,456 1,453,333 2014 1,493,332 1,466,665 2015 1,533,356 1,477,565 2016 1,563,331 1,492,235 2017 1,573,345 1,423,355 2018 1,583,356 1,411,235 2019 1,602,345 1,722,300 2020 1,633,331 1,734,455 A . 1 Year 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 B C Concert attendees Song downloads 2005 1,236,332 1,230,425 2006 1,256,431 1,230,543 2007 1,277,532 1,246,663 2008 1,317,656 1,245,532 2009 1,307,456 1,325,662 2010 1,328,889 1,256,666 2011 1,422,331 1,283,245 2012 1,456,021 1,412,222 2013 1,485,456 1,453,333 2014 1,493,332 1,466,665 2015 1,533,356 1,477,565 2016 1,563,331 1,492,235 2017 1,573,345 1,423,355 2018 1,583,356 1,411,235 2019 1,602,345 1,722,300 2020 1,633,331 1,734,455