1305AFE : Business Data Analysis - Imports of Services - Management Assignment Help

Assignment Task :

Answer all questions. 

QUESTION 1      

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 band’s songs have been downloaded in the social media.  Yearly data concerning the two variables are collected and stored in ‘ConcertDownloads17’ worksheet in the xls. data file attached.

1. 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.                                                                                                                                                                  

2. Using Excel, draw a chart to evaluate the number of song downloads over time.  Display your chart and provide a brief comment on what you can observe from the chart.   

3. 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.                                                                    

4. 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.                                                                 

5. 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.                                                                                                           

QUESTION 2               

Refer to the data stored in ‘ExportImport’ worksheet in the .xls data file attached.  The data show Australia’s exports and imports of services by selected regions in 2017 and 2018.  

1. Use Excel to draw an appropriate graphical technique to compare the value of Australia’s imports of services (in $m) in 2017 and 2018, broken down by region of import origin.  Display your chart output.  Provide comments on the information you observe from the chart output.                                                                                                 

2. Use Excel to draw an appropriate graphical technique to display the percentage value of Australia’s exports of services (in %) in 2018, broken down by region of export destination.  Display your chart output.  Provide comments on the information you observe from the chart output. 

This Management Assignment has been solved by our Management Experts at onlineassignmentbank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.