|Assessment Details and Submission Guidelines|
|Unit Title||Statistics and Research Methods for Business Decision Making|
|Assessment Type||Assessment 2|
|Assessment Title||Group Assignment|
|Purposeofthe assessment (with ULO|
|Students are required to show the understanding of the principles and techniques of business research and statistical analysis taught in the course.|
|Weight||30 % of the total assessments|
This assignment aims at Understand various qualitative and quantitative research methodologies and techniques, and other general purposes are:
Assignment Structure should be as the following:
This is an applied assignment. Students have to show that they understand the principles and techniques taught in this course. Therefore students are expected to show all the workings, and all problems must be completed in the format taught in class, the lecture notes or prescribed text book. Any problems not done in the prescribed format will not be marked, regardless of the ultimate correctness of the answer.
(Note: The questions and the necessary data are provided under “Assignment and Due date” in the Blackboard.)
All assignments submitted undergo plagiarism checking; if found to have cheated, all involving submissions would receive a mark of zero for this assessment item.
Please read below information carefully and respond all questions listed.
Australian exports (goods and services) along with its top 8 export markets in 2004-05 and 2014-15 are shown in the table stored in file EXPORTS.XLSX (in the course website). Using this data, answer the questions below.
The following data are the 40 days umbrella sales from a store.(8 Marks)
4. Construct a frequency distribution and a relative frequency distribution for the data.
5. Construct a cumulative frequency distribution and a cumulative relative frequency distribution for the data.
6. Plot a relative frequency histogram for the data.
7. Construct an ogive for the data.(1 mark)
8. What proportion of the grades is less than 60?(1 mark)
9. What proportion of the grades is more than 70?(1mark) Use following class intervals to answer the above questions
Assume you are a research analyst in an economic consultancy firm. Your team leader has given you a research task to investigate whether the per capita retail turnover in Australia is a good predictor of the final consumption expenditure of the country.
FINAL CONSUMPTION EXPENDITURE: (Trend) in $ Millions; - quarterly data from September 1983 to March 2016.
RETAIL TURNOVER PER CAPITA - (Trend) Total (State) in $;- quarterly data from September 1983 to March 2016.
[Quarterly time series data (for the period September 1983 to March 2016) are from the Australian Bureau of Statistics (ABS)]
The data are stored in the file named “ASSIGNMENTDATA.XLSX” in the course website. Using EXCEL, answer below questions:
RETAIL TURNOVER PER CAPITA at the 5% significance level.
8. What is the value of the standard error of the estimate (se). Then, comment on the fitness of the linear regression model?
Solution 1a: Stacked Column graph was used to represent the given data as follows:
Solution 1b: 100% Stacked Column graph was used to represent the given data as follows:
Solution 1c: It can be seen that while Stacked Column graph in part (a) represents absolute numbers, 100% Stacked Column graph in part (b) represents percentages was used to represent the given data. The first graph gives absolute export numbers for Top 8 countries while the second graph gives percentage share of 8 countries in given exports total.
For example, while the first graph does not indicate decrease in proportion of United Kingdom’s share in Top 8 countries’ exports numbers from 2004-05 to 2014-15, it is evident in the second graph where pink bar reduces in width. Similarly, China’s drastic jump in percentage terms normalises.
Solution 2 a & b: Following table presents the information required:
|Classes||Frequency||Relative Frequency||Cumulative Frequency||Cumulative Relative Frequency|
Frequency was calculated using Frequency’ formula and relative frequency is frequency divided by total sales. Cumulative numbers present total from first Class interval till the Corresponding Class interval.
Solution 2c: Relative Frequency Histogram was made using column chart on Relative Frequency Data:
Solution 2d: Ogive was made using line chart on Cumulative Relative Frequency data:
Solution 2e: This was calculated by counting all the data points that are less than 60. The arrived at number was divided by total number of data points as follows:
It can be seen that 35% of the grades are less than 60.
Solution 2f: This was calculated by counting all the data points that are greater than 70. The arrived at number was divided by total number of data points as follows:
It can be seen that 37.5% of the grades are greater than 70.
Solution 3a: Line charts were used to present the two variables. It can be seen that both the variables indicate an increasing trend over the quarters as follows:
Solution 3b: Scatter Plot chart was used to present the two variables. Independent variable, Retail Turnover per Capita ($) is on x-axis while the dependent variable, Final Consumption expenditure ($Mn) is on y-axis. It can be seen that both the variables indicate a positive linear trend:
Solution 3c: Descriptive Statistics tool was used to generate following output:
|Retail Turnover per Capita ($)||Final Consumption expenditure ($Mn)|
|Standard Error||47.46||Standard Error||4,098.05|
|Standard Deviation||543.19||Standard Deviation||46,904.33|
|Sample Variance||2,95,059.60||Sample Variance||22000,16,261.88|
The above present required summary of mean, median, mode, range, standard deviation, variance, etc.
Solution 3d: Correlation tool was used as follows:
|Retail Turnover per Capita ($)||Final Consumption expenditure ($Mn)|
|Retail Turnover per Capita ($)||1|
|Final Consumption expenditure ($Mn)||0.99||1|
It can be seen that degree of correlation is very high at 0.99 which indicates a positive linear relationship such that an increase of one unit in retail turnover per capita causes an increase of 0.99 units in final consumption expenditure (Rumsey, 2016).
Solution 3e: Regression tool was used as follows:
From above, the linear regression equation can be interpreted as:
y = -42,102.53 + 85.29 x
Solution 3f: The values of R and R2 help in determining the degree of relationship between independent and dependent variables. These are also called as Coefficients of Determination (Jackson, 2009).
In the given case, R value is 0.99 which indicates that there is high degree of correlation between the variables in consideration. R2 is at 0.98 with adjusted R2 being 0.98. The value of R2 is nothing but the proportion of change in dependent variable that can be explained through the independent variables (Lang et al., 2013). As can be seen, at 98.0%, a high proportion of change in value of ‘Final Consumption Expenditure ($Mn)’ can be attributed to change in Retail Turnover per Capita ($).
Solution 3g: From above table, we can see that the p-value for variable, Retail Turnover per Capita ($) is 0.0000 which is less than the assumed significance level of α = 0.05. Hence, we can conclude that the FINAL CONSUMPTION EXPENDITURE positively and significantly increases with RETAIL TURNOVER PER CAPITA at the 5% significance level.
Solution 3h: From above table, we can see that the Standard error of estimate is 2700.17 for the constant and 1.19 for the x variable.
We can see that the Significance value is 0.0000 which is less than the assumed significance level of α = 0.05. Hence, we can conclude that the regression model is a good linear fit. This is further supported by value of R and R2