Analyse and present data graphically using spreadsheet software (Excel). 2. Critically evaluate summary statistics against suitable benchmarks. 3. Apply judgment to select appropriate methods of data...

1 answer below »


Analyse and present data graphically using


spreadsheet software (Excel).


2. Critically evaluate summary statistics against suitable


benchmarks.



3. Apply judgment
 to select appropriate methods of



data analysis drawing on knowledge of regression


analysis, probability, probability distributions and


sampling distributions.


4. Select and apply a range of data analysis tools to



inform problem solving
 and decision making.



5. Conduct quantitative research both individually and as


part of a team and articulate and present findings to a


wide range of stakeholders, from accounting and nonaccounting


backgrounds.




Assessment 3 Briefs: Report Page 1 of 9 ASSESSMENT BRIEF Subject Code and Title STAT 6003: Statistics for Financial Decisions Assessment Assessment 3: Report Individual/Group Individual Length NA Learning Outcomes 1. Analyse and present data graphically usingspreadsheet software (Excel). 2. Critically evaluate summary statistics against suitable benchmarks. 3. Apply judgement to select appropriate methods of data analysis drawing on knowledge of regression analysis, probability, probability distributions and sampling distributions. 4. Select and apply a range of data analysis tools to inform problem solving and decision making. 5. Conduct quantitative research both individually and as part of a team and articulate and present findings to a wide range of stakeholders, from accounting and non- accounting backgrounds. Submission By 11:55pm AEST/AEDT Sunday one week after Module 6 Weighting 50% Total Marks 100 marks Context: The report asks students to apply their knowledge on the concepts and ideas discussed during the Modules in a comprehensive work. The report allows students to reflect back on their previous learning performances and outcomes, and to make use of previous submissions. Instructions: You are expected to submit a report that requires you to apply your knowledge from all Modules and draws links between the scenario and the learning resources. Furthermore, you are expected to incorporate feedback given to your short written assessments (assessment no.1) and feedback provided to your presentation (assessment no. 2) in your final report. Your answers should reflect upon and analyse issues of the key discussion points of the Modules. Your answers should also effectively communicate and demonstrate Assessment 3 Briefs: Report Page 2 of 9 that key concepts covered during this course can be applied by you in a comprehensive manner. The report also asks you to apply critical thinking and analysis. -------------------------------------------------------------------------------------------------------------------------------------- Report and presentation As discussed above, your final two assessments are inter-linked: - Assessment 3 requires you to write a report. - For Assessment 2 you are to present the preliminary findings of your report (Assessment 3). o The presentation (Assessment 2) provides you with an opportunity to receive feedback from the learning facilitator which you are then to implement and address in your final report. Introduction: 1. Analysis of sales and country data, forecasting of sales figures until 2020 The Board of Directors of Schmeckt Gut instructs you to write a report of the development of sales in Industria, Nokaragua and the Federated Islands over the past 25 years. Furthermore, the board would like you to use forecasting methodologies to project the sales for the next 5 years (until 2020) by applying reasonable assumptions based on the data provided and your analysis. Additional details are provided below. 2. Market place Sweden – Estimate of potential sales figures in 2016 and forecast to 2020 Schmeckt Gut has recently entered the Swedish market and the Board is interested in an estimate of this year’s sales as well as potential sales for the next 5 years (until 2020). Additional details are provided below. Data set: The excel file provides you with four data sets for the 4 countries of interest which include: • Sales figures in US$ (not available for Sweden) • GDP data in US$ • Average Price Index (in %) • Population (15-65 years of age) Assessment 3 Briefs: Report Page 3 of 9 • Survey score – this is the average result of a customer satisfaction survey (0=not satisfies, 10=very satisfied) • Number of average advertisements • Number of stores All data is exogenous and independent except in their relation with the sales figures. Detailed tasks 1. Analysis of sales and country data, forecasting of sales figures until 2020 • Provide a statistical overview of the data provided in the excel sheets for each country (you can also do a comparison analysis) • Conduct a correlation analysis between sales development and: o (i) advertisements, (ii) number of stores and (iii) the survey results • Conduct a multi regression time series analysis and use the results to forecast the sales until 2020. o Hint: You should use natural logs (ln) for your analysis as discussed in your assignment of Module 5. o For your reasonable assumptions which are required for the forecasting, you should apply hypothesis testing techniques for the GDP, Prices and Population developments.  For example, if you forecast a GDP growth of 3.5%, knowing the past GDP growth figures, is the forecast of 3.5% an acceptable growth figure for the forecast or should that Null hypothesis be rejected? 2. Market place Sweden – Estimate of potential sales figures in 2016 and forecast to 2020 • Based on your analysis in part 1, which country (Industria, Federated Islands, Nokaragua) is closest related to Sweden? Justify your selection. o Hint: Look at average GDP per capita statistics (GDP divided by Population) and Price Index. • Once you have identified the country that is closet related to Sweden, use that country’s characteristics of the analysis undertaken in the first part to estimate/forecast the potential sales for the Swedish market. o Use the forecasts from the IMF to project GDP growth rates and a potential price index (CPI or Inflation rate) for the years 2016 to 2020.  See pg 40 of the ‘IMF 2015 ARTICLE IV CONSULTATION’ report for Sweden for the data. Assessment 3 Briefs: Report Page 4 of 9 3. Other suggestions - Based on your analysis in parts 1 and 2, are there any other suggestions you have for the Board on how Schmeckt Gut can boost sales in the countries? Your presentation: - Create a presentation (for example with PowerPoint) and turn your presentation into a video. o See https://support.office.com/en-us/article/Turn-your-presentation-into-a- video-c140551f-cb37-4818-b5d4-3e30815c3e83 for details should you decide to use PowerPoint o You can also use any other suitable programs - Present your main results that will assist the Board in their decision making o Focus on the main results and explain which techniques you have applied to achieve these results and why you used these techniques. o What do these results imply? o What are your main recommendations? - Your presentation should not be longer than 15 minutes - Submit your narrated video on Blackboard. https://support.office.com/en-us/article/Turn-your-presentation-into-a-video-c140551f-cb37-4818-b5d4-3e30815c3e83 https://support.office.com/en-us/article/Turn-your-presentation-into-a-video-c140551f-cb37-4818-b5d4-3e30815c3e83 Assessment 3 Briefs: Report Page 5 of 9 Learning Rubrics Assessment Attributes Fail (Unacceptable) Pass (Functional) Credit (Proficient) Distinction (Advanced) High Distinction (Exceptional) Grade Description (Grading Scheme) Evidence of unsatisfactory achievement of one or more of the learning objectives of the course, insufficient understanding of the course content and/or unsatisfactory level of skill development. Evidence of satisfactory achievement of course learning objectives, the development of relevant skills to a competent level, and adequate interpretation and critical analysis skills. Evidence of a good level of understanding, knowledge and skill development in relation to the content of the course or work of a superior quality on the majority of the learning objectives of the course. Demonstration of a high level of interpretation and critical analysis skills. Evidence of a high level of achievement of the learning objectives of the course demonstrated in such areas as interpretation and critical analysis, logical argument, use of methodology and communication skills. Evidence of an exceptional level of achievement of learning objectives across the entire content of the course demonstrated in such areas as interpretation and critical analysis, logical argument, creativity, originality, use of methodology and communication skills. Content, Audience and Purpose Points for this criteria Does not meet minimum standard Demonstrates no awareness of context and/or purpose of the assignment. Meets minimum standard Demonstrates limited awareness of context and/or purpose of the assignment Moves beyond minimum standard Demonstrates consistent awareness of context and/or purpose of the assignment. Exceeds minimum standard Demonstrates an advanced and integrated understanding of context and/or purpose of the assignment. Exceeds minimum standard and exhibits high levels of independence Consistently demonstrates a systematic and critical understanding of context and purpose of the assignment. Knowledge and understanding Limited understanding of required concepts and knowledge Knowledge or understanding of the field or discipline. Resembles a recall or summary of key ideas. Thorough knowledge or understanding of the field or discipline/s. Supports personal opinion and information substantiated by Highly developed understanding of the field or discipline/s. A sophisticated understanding of the field or discipline/s. http://www.tua.edu.au/media/50742/a240_grading-scheme.pdf Assessment 3 Briefs: Report Page 6 of 9 Points for this criteria Key components of the assignment are not addressed. Often conflates/confuses assertion of personal opinion with information substantiated by evidence from the research/course materials. evidence from the research/course materials. Demonstrates a capacity to explain and apply relevant concepts. Discriminates between assertion of personal opinion and information substantiated by robust evidence from the research/course materials and extended reading. Well demonstrated capacity to explain and apply relevant concepts. Systematically and critically discriminates between assertion of personal opinion and information substantiated by robust evidence from the research/course materials and extended reading. Mastery of concepts and application to new situations/further learning. Critical reasoning, presentation and defence of an argument and/or position
Answered Same DayDec 05, 2019STAT6003Torrens University Australia

Answer To: Analyse and present data graphically using spreadsheet software (Excel). 2. Critically evaluate...

David answered on Dec 26 2019
102 Votes
Regression analysis helps me to predict the sales of federated island, Industria, Nokaragua, and Sweden country. I am given ln(GDP), price index, population, advertisement and stores for countries federated island, Industria, Nokaragua, and Sweden country. I perform three regression analysis to predict sales of federated island, Industria and Nokaragua on basis of co
esponding
ln(GDP), price index, population, advertisement and stores for each country. The values of future independent variables are predicted by using formula of growth rate. I plug in these calculated independent variables in the co
esponding regression equation for 3 countries federated island, Industria, Nokaragua in order to obtain the predicted value of sales. For the prediction of sales co
esponding to Sweden, I choose the best appropriate regression model among 3 models created for countries federated island, Industria and Nokaragua. The value of GDP/population and Price index for Sweden is compared with that of federated island, Industria and Nokaragua. The country among federated island, Industria and Nokaragua with closest GDP/population and Price to Sweden is selected to prediction of Sweden sales. Then I plug in the calculated values of independent variables (using growth rate) in the co
esponding regression equation for selected country.
There are 25 observations of sales for each country. The mean sale of federated island, Industria and Nokaragua is $713,603, $17,372,234 and $7,859,679. Industria highest mean and median of sales. And federated Island has the lowest mean and median of sales. The minimum and maximum of sales for Federated Islands, Industria and Nokaragua is ($432,967 ; $957,950) ($11,919,253 ; $23,103,581) and ($5,162,754 ; $10,554,044) respectively.
Advertisement and Stores have a strong linear relationship between them for three countries of my interest Federated Islands, Industria and Nokaragua. Hence there is problem of Multi-co-linearity. Survey store has weak linear relationship with Sales. Hence I Remove survey store as independent variable in further regression analysis. Fox, J. (1997). 
For country Federated Islands, (Sales, GDP) (Sales, population 15-65) has positive linear relationship. Sales and price index have a weak negative linear relationship. The regression output is given below.
    SUMMARY OUTPUT
    
    
    
    Regression Statistics
    Multiple R
    0.99731
    R Square
    0.994628
    Adjusted R Square
    0.993215
    Standard E
o
    14614.74
    Observations
    25
    ANOVA
    
    
    
    
    
     
    df
    SS
    MS
    F
    Significance F
    Regression
    5
    751407540992
    150281508198
    703.5963
    7.18053E-21
    Residual
    19
    4058219974
    213590525
    
    
    Total
    24
    755465760966
     
     
     
     
    Coefficients
    Standard E
o
    t Stat
    P-value
    Lower 95%
    Upper 95%
    Lower 95.0%
    Upper 95.0%
    Intercept
    -1295339
    640295.1687
    -2.02303359
    0.057371
    -2635491.824
    44814.56
    -2635492
    44814.56
    ln(gdp)
    82937.48
    36853.36199
    2.250472565
    0.036458
    5802.506939
    160072.5
    5802.507
    160072.5
    Price index
    -19470
    2528.258944
    -7.700948584
    2.94E-07
    -24761.69892
    -14178.3
    -24761.7
    -14178.3
    Population 15-65
    -21.1937
    8.052980923
    -2.631787281
    0.01643
    -38.04881555
    -4.33865
    -38.0488
    -4.33865
    Advertisement
    42453.3
    4096.434857
    10.36347511
    2.95E-09
    33879.36399
    51027.24
    33879.36
    51027.24
    Stores
    19081.54
    5497.566605
    3.47090629
    0.002559
    7574.999367
    30588.08
    7574.999
    30588.08
There is 99.46% variation in sales which is explained by ln(GDP), price index, population 15-65, advertisement and stores. Regression equation is given by sales = -1295338.63 + 82937.488ln(GDP) - 19470*Price_index - 21.197*population + 42453.3*advertisement + 19801.54*stores. Ho: coefficient of independent...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here