1305AFE - Business Data Analysis - Strategic Management Assignment Help

Assignment Task:

As this is an individual assessment item, students should work on their own and present their individual assignment submission, even if you discuss it in a group. All assignments submitted will go through a matching process, If found to have cheated, all submissions involved would receive a mark of zero for this assessment item. 

Question 1. 

The following data are final marks for a Strategic Management Accounting course at a University. 

a. Construct a frequency distribution and a relative frequency distribution for the data.

b. Construct a cumulative frequency distribution and a cumulative relative frequency distribution for the data.

c. Plot a relative frequency histogram for the data.

d. Construct an ogive for the data.

e. What proportion of the marks is less than or equal to 60?

f. What proportion of the marks is more than 70?

Question 2.

According to the Housing Mobility section of the General Social Survey, Victoria, 2006 (ABS, Catalogue Number: 4159.2.55.001), about 1494 thousand people aged 18 years or over moved in the last five years. Of these people, 758.4 thousand moved for housing reasons, 170.2 thousand moved for employment reasons, 398.6 thousand moved for family reasons and 167.2 thousand moved for other reasons.

a. Construct a pie chart. 

b. Interpret your pie chart.

Question 3.

Assume you are a Data Analyst in an international economic consultancy firm. Your team leader has given you a research task to investigate the empirical relationship between China’s export volumes and per capita GDP (Gross Domestic Product).

The data are stored in the file named “ASSIGNMENTDATA.XLSX” on the course website. Using EXCEL, answer the below questions: 

1. Using an appropriate graphical descriptive measure (relevant for time series data) describe the two variables.

2. Use an appropriate plot to investigate the relationship between Export volume index and GDP per capita. Assume the Export volume index as an independent variable. Interpret the plot.

3. Prepare a numerical summary report about the data on the two variables by including the summary measures, mean, median, range, variance, standard deviation, coefficient of variation, smallest and largest values, and the three quartiles, for each variable. 

4. Calculate the coefficient of correlation (r) between the Export volume index and GDP per capita. Then, interpret it. 

5. Estimate a simple linear regression model and present the estimated linear equation. Then, interpret the coefficient estimates of the linear model.

6. Determine the coefficient of determination R2 and interpret it.

7. Test whether GDP per capita positively and significantly increases with export volume index at the 5% significance level. 

8. What is the value of the standard error of the estimate Then, comment on the fitness of the linear regression model?

This 1305AFE: Strategic Management Assignment has been solved by our Strategic Management Experts at My Uni Paper. 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.