User Account

All Pages

Analysis of sales and country data

Assignment Help Applied Statistics
Reference no: EM131761135

Statistics for Financial Decisions Assessment: Report

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

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.

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)
  • 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 and turn your presentation into a video.

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

- Submit your narrated video on Blackboard.

Attachment:- Assignment Files.rar

Reference no: EM131761135

Questions Cloud

How much finance charge will he get credit : How much finance charge will he get credit for if he pays the loan in full immediately?
Economy works via the interactions of economic agents : The economy works via the interactions of economic agents (interactions of economic choices). Economists claim that pursuing self-interest based on our skills
Calculate the amount of bad debt expense : Calculate the amount of bad debt expense recorded by Betty DeRose
What is the size of the labor force : Country A with a civilian population of 75 mil (all over age 16), has 47 mil employed and 19 mil unemployed persons, of which 3 mil is frictionally unemployed.
Analysis of sales and country data : STAT 6003: Statistics for Financial Decisions Assessment: Report. Analysis of sales and country data, forecasting of sales figures until 2020
Describe how cancellation works in fractions : Describe how cancellation works in fractions and give an example.
Prepare journal entries to record the transactions : Neal started a new business on jan 1 2017 the following transactions took place during the month of operations.
Economic basis for that bias : Might there be an economic basis for that "bias" (beyond the claim that people don't consider the issue carefully because of some, say, physiological limitation
Explain how to multiply fractions : explain how to multiply fractions. Make up an example problem of your own showing how this works.

Reviews

len1761135

12/12/2017 12:24:30 AM

Australian student, total 2500 words and I already attached the excel work, Rest need it as per the guidelines. I don't need power point presentation, I will do it myself. Please analyse the data for Industria, Federated Islands and Nokaragua. Please select the country from among Industria, Federated Islands and Nokaragua that is closest to Sweden. Please justify your selection using the variables included. For example, which of Industria, Federated Islands and Nokaragu has GDP closer to Sweden for the given years. You could compare using the other variables. Please fill in the missing variables for Sweden from the country closest to Sweden.

len1761135

12/12/2017 12:24:24 AM

Once selected, you run the regression for Sweden using data up to 2015. Identify the significant variables and form the equation using the significant variables. Next, you need to forecast sales for Sweden over 2016-2020. For that, you need the data for the independent variables over 2016-2020. You need the growth rates data to predict the values of independent variables over 2016-2020. You may use the IMF data to predict the values of the independent variables over 2016-2020. An example to calculate the population for 2016 is to multiply the population for 2015 by (1 + growth rate). You can accordingly predict for 2017-2020. Please remember that you need to analyse and forecast for all four countries.

len1761135

12/12/2017 12:24:18 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. 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.

len1761135

12/12/2017 12:24:12 AM

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

len1761135

12/12/2017 12:24:06 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.

Write a Review

Applied Statistics Questions & Answers

  Does the value of r indicate that the program is effective

Discussion- Determining a Linear Correlation. Does the value of r indicate that the program is effective in reducing weight? Why or why not?

  Draw all of venn diagrams

Draw all of Venn Diagrams - Using circle Venn Diagrams and What are all of the subsets of U?

  Find the probability that the company will meet its goal

Find the probability that the company will meet its goal on a particular 100 miles of line. Find the probability that the company will not meet its goal on a particular 100 miles of line.

  Which of sales invoices should be included in random sample

Determine which 50 of the 977 sales invoices should be included in the random sample. Note: There are many possible answers to this exercise.

  What are the range and standard deviation

Find the mean, median and mode of this information and what are the range and standard deviation - Use the Empirical Rule to establish an interval which includes about 95 percent of the observations.

  Cars arrive at a car wash randomly and independently

Cars arrive at a car wash randomly and independently; the probability of an arrival is the same for any two time intervals of equal length. The mean arrival rate is 15 cars per hour. A) What is the probability that 12 or more cars will arrive during..

  What is the difference between nominal, ordinal, and scale

What is the difference between Nominal, Ordinal, and Scale?My assignment has 3 variables: 1) reinforcement schedules (random or spaced)2) reinforcers (token, money, and food)3) dependent variable (test scores)

  A standard normal distribution

One way to find probabilities from a Standard Normal Distribution is to use probability tables, which are located inside the front cover of your textbook. According to the table, what is the probability when z ≤ -1.75?  The probability when z ≤ 1...

  What is your linear speed in feet per minute

What is your linear speed in feet per minute

  Describes the impact of simultaneous changes in objective

"Range of optimality" describes the impact of simultaneous changes in objective function values and right-hand-side values.

  How many properties in your sample consist of brick building

BE01106 - BUSINESS STATISTICS How many properties in your sample consist of brick buildings - Which building type occurs most frequently in your sample and Determine the Inter-Quartile Range of your sample "Sold Price" data and provide a brief expla..

  Forecasting with time series analysis objective crusty

forecasting with time series analysis objective crusty pizza executives have to forecast december sales for the 10

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd