Sheet1 Retail turnover per capita - Chain Volume Measures ; Total (State) ;FINAL CONSUMPTION EXPENDITURE: Chain volume measures ; Unit $$ Millions Sep-19831455.981889 Dec-19831459.682410...

1 answer below »
please see the attachment


Sheet1 Retail turnover per capita - Chain Volume Measures ; Total (State) ;FINAL CONSUMPTION EXPENDITURE: Chain volume measures ; Unit $$ Millions Sep-19831455.981889 Dec-19831459.682410 Mar-19841462.582711 Jun-19841465.782461 Sep-19841470.182200 Dec-19841476.082453 Mar-19851485.083559 Jun-19851500.885247 Sep-19851515.786605 Dec-19851526.087364 Mar-19861531.187880 Jun-19861530.488410 Sep-19861522.989018 Dec-19861512.389354 Mar-19871512.089528 Jun-19871530.990165 Sep-19871551.491216 Dec-19871562.992190 Mar-19881565.592900 Jun-19881568.793543 Sep-19881582.894623 Dec-19881600.996143 Mar-19891614.397695 Jun-19891622.298848 Sep-19891627.299721 Dec-19891633.1100541 Mar-19901637.3101400 Jun-19901632.7101929 Sep-19901623.0102007 Dec-19901609.9101812 Mar-19911605.7101910 Jun-19911618.5102435 Sep-19911641.8103169 Dec-19911664.1103948 Mar-19921677.3104715 Jun-19921681.2105413 Sep-19921681.7105905 Dec-19921680.7106212 Mar-19931680.3106458 Jun-19931685.5106887 Sep-19931700.0107626 Dec-19931723.3108514 Mar-19941749.7109534 Jun-19941773.1110713 Sep-19941789.2111958 Dec-19941808.5113375 Mar-19951832.7114573 Jun-19951859.5115502 Sep-19951884.3116397 Dec-19951901.3117328 Mar-19961912.9118275 Jun-19961917.2119047 Sep-19961918.5119597 Dec-19961923.7120374 Mar-19971938.6121686 Jun-19971963.7123509 Sep-19971988.8125225 Dec-19972004.8126496 Mar-19982013.7127686 Jun-19982015.8129205 Sep-19982027.7131188 Dec-19982055.0133267 Mar-19992091.8134997 Jun-19992133.5136580 Sep-19992167.0137998 Dec-19992183.8139137 Mar-20002186.3140239 Jun-20002180.2141288 Sep-20002181.5142416 Dec-20002198.2143654 Mar-20012221.2144742 Jun-20012244.1145635 Sep-20012264.9146449 Dec-20012292.7147556 Mar-20022327.1149395 Jun-20022360.4151593 Sep-20022382.6153353 Dec-20022396.2154454 Mar-20032416.3155335 Jun-20032458.7156808 Sep-20032517.6159178 Dec-20032574.7161902 Mar-20042616.9164435 Jun-20042643.2166648 Sep-20042656.8168338 Dec-20042658.7169702 Mar-20052654.4170947 Jun-20052651.8172211 Sep-20052654.2173534 Dec-20052665.4174872 Mar-20062686.0176281 Jun-20062706.4177986 Sep-20062728.6180171 Dec-20062749.9182775 Mar-20072774.4185510 Jun-20072804.2188216 Sep-20072831.2190775 Dec-20072844.8192828 Mar-20082837.1193874 Jun-20082810.5193659 Sep-20082787.1192931 Dec-20082777.2192773 Mar-20092781.2193351 Jun-20092799.7194468 Sep-20092822.1195683 Dec-20092837.8196911 Mar-20102847.1198439 Jun-20102852.8200454 Sep-20102852.8202611 Dec-20102843.8204673 Mar-20112831.9206350 Jun-20112831.6207570 Sep-20112842.5208615 Dec-20112860.1209924 Mar-20122876.6211372 Jun-20122882.3212534 Sep-20122880.4213118 Dec-20122878.2213419 Mar-20132881.6214187 Jun-20132891.3215542 Sep-20132901.7217221 Dec-20132917.3218859 Mar-20142937.5220279 Jun-20142941.0221681 Sep-20142952.4223238 Dec-20142975.0224750 Mar-20152986.7226221 Jun-20152996.0227832 Sep-20153003.9229611 Dec-20153009.7231416 Mar-20163014.6233148 HOLMES INSTITUTE FACULTY OF HIGHER EDUCATION HI6007 STATISTICS AND RESEARCH METHODS FOR BUSINESS DECISION MAKING GROUP ASSIGNMENT Assessment Details and Submission Guidelines Trimester T1 2019 Unit Code HI6007 Unit Title Statistics and Research Methods for Business Decision Making Assessment Type Assessment 2 Assessment Title Group Assignment Purpose of the assessment (with ULO Mapping) 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 Total Marks 30 Word limit N/A Due Date Lecture 10 Submission Guidelines  All work must be submitted on Blackboard by the due date along with a completed Assignment Cover Page.  The assignment must be in MS Word format, no spacing, 12-pt Arial font and 2 cm margins on all four sides of your page with appropriate section headings and page numbers.  Reference sources must be cited in the text of the report, and listed appropriately at the end in a reference list using Harvard referencing style. Page 2 of 6 HI6007 STATISTICS AND RESEARCH METHODS FOR BUSINESS DECISION MAKING Assignment Specifications Purpose: This assignment aims at Understand various qualitative and quantitative research methodologies and techniques, and other general purposes are: 1. Explain how statistical techniques can solve business problems 2. Identify and evaluate valid statistical techniques in a given scenario to solve business problems 3. Explain and justify the results of a statistical analysis in the context of critical reasoning for a business problem solving 4. Apply statistical knowledge to summarize data graphically and statistically, either manually or via a computer package 5. Justify and interpret statistical/analytical scenarios that best fits business solution 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.) Instructions:  Your assignment must be submitted in WORD format only!  When answering questions, wherever required, you should copy/cut and paste the Excel output (e.g., plots, regression output etc.) to show your working/output.  Submit your assignment through Safe-Assign in the course website, under the Assignments and due dates, Assignment Final Submission before the due date.  You are required to keep an electronic copy of your submitted assignment to re-submit, in case the original submission is failed and/or you are asked to resubmit.  Please check your Holmes email prior to reporting your assignment mark regularly for possible communications due to failure in your submission. Important Notice: All assignments submitted undergo plagiarism checking; if found to have cheated, all involving submissions would receive a mark of zero for this assessment item. Page 3 of 6 HI6007 STATISTICS AND RESEARCH METHODS FOR BUSINESS DECISION MAKING Please read below information carefully and respond all questions listed. Question 1 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. (4 Marks) (a) Use an appropriate graphical technique to compare the value of Australian exports (in A$ bn) in 2004-05 and 2014-15, broken down by country of export destination. (1 mark) (b) Use an appropriate graphical technique to compare the percentage value of Australian exports (in %) in 2004-05 and 2014-15, broken down by country of export destination. (1 mark) (c) Comment your observations in parts (a) and (b). (2 marks) Question 2. The following data are the 40 days umbrella sales from a store. (8 Marks) 63 74 42 65 51 54 36 56 68 57 62 64 76 67 79 61 81 77 59 38 84 68 71 94 71 86 69 75 91 55 48 82 83 54 79 62 68 58 41 47 a. Construct a frequency distribution and a relative frequency distribution for the data. (2 marks) b. Construct a cumulative frequency distribution and a cumulative relative frequency distribution for the data. (2 marks) c. Plot a relative frequency histogram for the data. (1 mark) d. Construct an ogive for the data. (1 mark) e. What proportion of the grades is less than 60? (1 mark) f. What proportion of the grades is more than 70? (1mark) Use following class intervals to answer the above questions Classes Frequency Relative Frequency Cumulative Frequency Cumulative Relative Frequency 30 - 40 40 - 50 50 - 60 60 - 70 70 - 80 80 - 90 90 - 100 Page 4 of 6 HI6007 STATISTICS AND RESEARCH METHODS FOR BUSINESS DECISION MAKING Question 3. (18 Marks) 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. Relevant Variables: 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: a. Using an appropriate graphical descriptive measure (relevant for time series data) describe the two variables. (1 mark) b. Use an appropriate plot to investigate the relationship between FINAL CONSUMPTION EXPENDITURE and RETAIL TURNOVER PER CAPITA. Briefly explain the selection of each variable on the X and Y axes and why? (2 marks) c. 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. (3 marks) d. Calculate the coefficient of correlation (r) between FINAL CONSUMPTION EXPENDITURE and RETAIL TURNOVER PER CAPITA. Then, interpret it. (2 marks) e. Estimate a simple linear regression model and present the estimated linear equation. Then, interpret the coefficient estimates of the linear model. (4 marks) f. Determine the coefficient of determination R2 and interpret it. (2 marks) g. Test whether FINAL CONSUMPTION EXPENDITURE positively and significantly increases with RETAIL TURNOVER PER CAPITA at the 5% significance level. (3 marks) h. What is the value of the standard error of the estimate
Answered Same DayMay 31, 2021HI6007

Answer To: Sheet1 Retail turnover per capita - Chain Volume Measures ; Total (State) ;FINAL CONSUMPTION...

Rajeswari answered on May 31 2021
152 Votes
41483 Assignment
Question No.1
a)
The graphs for the 2004-05 and 2014-15 are given below:
On comparison we find that almost all countries increased in the 10 year period., except United Kingdom. China shows the maximum increase.
Percent growth:

c) We find that except United Kingdom
other countries increased over the years the exports. While China showed highest actual increase in the 10 year period, Japan stood next. Newzealand almost the same over the lapse of years. Singapore almost doubled.
Coming to percent increase, we find that while Japan showed highest contribution in 2004-05 followed by China, U.S and Newzealand, in 2014-15, China showed the highest followed by Japan. Though actual increased for all countries except UK, percentage contribution shows an increase only for China while all other countries show a percent decline in the contribution.
Question No.2
The sales of umbrella for 40 days is given in the question.
    
    
    Frequency distribution
    
    
    
    
    
    
    
    
    Classes
    Frequency
    Relative frequency
    cumulative frequency
    Cumulative relative frequency
    
    
    
    
    
    
    a)&b)
    30-40
    2
    0.05
    2
    0.05
    
    40-50
    4
    0.1
    6
    0.15
    
    50-60
    8
    0.2
    14
    0.35
    
    60-70
    11
    0.275
    25
    0.625
    
    70-80
    8
    0.2
    33
    0.825
    
    80-90
    5
    0.125
    38
    0.95
    
    90-100
    2
    0.05
    40
    1
    
    
    
    
    
    
    
    total
    40
    1
    
    
    Relative frequency
    Frequency/Total=Freq/40
    
    Cumulative frequency is calculated as the total of all frequencies upto that class
    
    
    
    
    
    
    Cumulative reqlative frequency is calculated as cumulative frequency /40
    
    
    
    
    
    
    always last row of cumulative frequency will be equal to total and
    Last row of cumulative relative frequency will be equal to 1.
c) Relative histogram is shown below:
d) Ogive for the data is given below:
e) Proportion of grades less than 60 =
f) Proportion of grades more than 70=
Question No.3
a) Graph for time series data for X =
On x axis the numbers marked are the quarters starting from 1 to 131 i.e. June 2010 is marked as 1, and so on.
Graph representation for Y = final consumption
b) On x axis we plotted the retail and y axis the final exp. This is because of the assumption that retail is independent and final one is dependent. The graph is shown below:
c) The main measurements for X and Y are shown below:
    c)
    X
    Y
    Mean
    2205.8
    146019.9
    Median
    2180.2
    139137.0
    Min
    1455.9
    81889.0
    Max
    3014.6
    233148.0
    Range
    1558.7
    151259.0
    Variance
    295059.6
    2200016261.9
    Std dev
    543.2
    46904.3
    Coeff of var.
    0.2
    0.3
    Quartile I
    1653.0
    103558.5
    quartile 3
    2793.4
    192800.5
    Quartile 2
    2180.2
    139137.0
    IQR
    1140.5
    89242.0
    
    
    
    d)
    
    
    Correlation coefficient
    r
    0.98769713
This is using the formula correlation coefficient =
e) Linear regression model and scatter plot are shown...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here