Provide a statistical overview of the data provided in excel

Assignment Help Applied Statistics

Reference no: EM131416473

Statistics for Financial Decisions

Learning Outcomes

1. Analyse and present data graphically using spreadsheet 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.

Assessment 2: Presentation

Context:

The presentation asks students to present their preliminary results of their final report (Assessment No. 3) in which they are to apply their knowledge on the concepts and ideas discussed during the Modules in a comprehensive work. The presentation allows students to present their preliminary findings while reflecting back on their previous learning performances and outcomes, and to make use of previous submissions and feedback provided.

Instructions:

You are expected to present your preliminary findings of your final report (Assessment no. 3). You are expected 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) in your presentation of your preliminary findings to 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 that key concepts covered during this course can be applied by you in a comprehensive manner. Please keep in mind that the final 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).

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

2. Market place Sweden - Estimate of potential sales figures in 2016 and forecast to 2020

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)
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:

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

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.

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.

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.

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.

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

You can also use any other suitable programs

Present your main results that will assist the Board in their decision making

Focus on the main results and explain which techniques you have applied to achieve these results and why you used these techniques.

What do these results imply?

What are your main recommendations?

Your presentation should not be longer than 15 minutes

Assessment 3: Report

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

Attachment:- Assignment Files.rar

Reference no: EM131416473

Questions Cloud

Cultural history of a smile : In like manner Selzer "dissects" the violence of a knife with a new poeticism. Cunningham dives into art history and advertising to assay the cultural history of a smile.

How much should such an option sell for in the open market : Should the company buy a call option or a put option on gold? In order to avoid bankruptcy, what strike price and time to expiration would the company like this option to have?

Explain what symbol would be used to represent given : Explain what symbol (p^, μ, etc.) would be used to represent each of the following:- The mean of the sampling distribution of the sample mean.

What goes into a relapse prevention plan : Why are relapse prevention plans an important part of the process for substance abuse treatment?What goes into a relapse prevention plan?Are there programs in your area that you may suggest in a relapse prevention program?

Provide a statistical overview of the data provided in excel : STAT 6003: Statistics for Financial Decisions. 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 analysi..

Which of given will researchers know after they taken sample : They plan to take a random sample of 100 runners who complete a marathon and record their temperatures. Which of the following will the researchers know after they have taken the sample?

How close do they stand when they are talking : Go to a church service that serves a specific ethnicity other than your own and, if possible, one that uses another language.Spend at least an hour, more if possible, observing the setting. What do you notice about the way the members communicate?

How will this change in policy affect accounts receivable : In reaction to sales by its main competitor, Sewage Spray, Essence of Skunk is considering a change in its credit policy to terms of 2/10, net 30, to preserve its market share. How will this change in policy affect accounts receivable?

Which of given would be same as it was for the first sample : If a different sample of 100 marathon runners was taken from the same population, which of the following would be the same as it was for the first sample, and which would be different?

Reviews

len1416473

3/6/2017 7:48:02 AM

Uses ethical principles to identify competing interests and views. Sophisticated understanding of the ethical and moral positions. Well-articulated viewpoint based on moral-ethical reasoning. Expertly written and adheres to the academic genre. Demonstrates expert use of high-quality, credible and relevant research sources to support and develop arguments and position statements. Shows extensive evidence of reading beyond the key reading. There are no mistakes in using the APA Style. Expertly presented; the presentation is logical, persuasive, and well supported by evidence, demonstrating a clear flow of ideas and arguments. Engages and sustains audience’s interest in the topic, demonstrates high levels of cultural sensitivity. Effective use of diverse presentation aids, including graphics and multi-media.

3/6/2017 7:47:55 AM

Highly sophisticated and creative analysis, synthesis of new with existing knowledge. Strong application by way of pretested models and / or independently developed models. Recommendations are clearly justified based on the analysis/synthesis. Applying knowledge to new situations/other cases.

3/6/2017 7:47:46 AM

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. Specific position (perspective or argument) is presented expertly, authoritatively and imaginatively, accurately taking into account the complexities of the issue(s) and scope of the assignment. Limits of position are acknowledged. Justifies any conclusions reached with sophisticated arguments.

3/6/2017 7:47:37 AM

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. Exceeds minimum standard and exhibits high levels of independence. Consistently demonstrates a systematic and critical understanding of context and purpose of the assignment. A sophisticated understanding of the field or discipline/s.

Write a Review

Required(*) Message

User Account

All Pages