Develop graphs using applicable excel tools

Assignment Help Applied Statistics
Reference no: EM131416357

Statistics for Financial Decisions Assessment: Short written assessments

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.

Instructions:

You are required to apply your knowledge and draw links between the scenario and the learning resources. In your answers, reflect upon and analyse issues of the key discussion points of the module. Your answers should also effectively communicate and demonstrate that key concepts have been reviewed and that you can apply these concepts to the problems posted.

The board is interested in a comparison analysis of a third country as potential market for our Schmeckt Gut products. You are expected to provide this analysis for a country of your choice. Please find below detailed expectations of the board:

1. Download the data of the World Development Indicators from the World Bank.

2. Using this database, select a country of your choice and compare the country's:

a. GDP growth rate (%)

b. Inflation rate (%)

c. GDP per Capita (PPP $)

with those of Industria and the Federated Islands (data provided in the Module content).

Provide a table with the data and develop graphs using applicable EXCEL tools. 

3. For the same country, use the World Bank Doing Business Indicators and compare the Indicators for the section 'Paying Taxes' with that of Industria and the Federated Islands. Provide a table and applicable graphs using EXCEL tools.

4. Based on your analysis, make recommendations to the board, which market the Schmeckt Gut company should target first.

Reference no: EM131416357

Questions Cloud

Probability of randomly selected student spend given amount : What is probability that a randomly selected student spends less than $450 on textbooks this semester?- What is the probability that a randomly selected student spends more than $240 on textbooks this semester?
Problem regarding the relevant protocol : Research and discuss in detail the following: VPN, SSL, SSH and any other relevant protocol. Provide examples of how and where they are used.
Discuss important elements of agency law : Within the Discussion Board area, write 400-600 words that respond to the following questions with your thoughts. Discuss important elements of agency law related to employee commitments to other companies.
Which of these methods is most likely to bring about result : This question could be addressed by the case study method as depending upon the specific question could lead to the method employed.  Perhaps it would be important to focus on the "whom" or "what" when defining "long lasting consequences".  For ex..
Develop graphs using applicable excel tools : STAT 6003: Statistics for Financial Decisions Assessment: Short written assessments. Provide a table with the data and develop graphs using applicable EXCEL tools
Probability of total rainfall : For a randomly selected year, what is the probability that total rainfall will be in each of the following intervals?- Less than 10 inches.
Determine the mac address of network card : Your child must complete an after-school project in which she must post her work to a moderated online forum specially set up by her teacher. Your computer, which is using a newly installed Network Interface Controller (NIC), is unable to access t..
Prepare a december adjusted trial balance : Prepare a December adjusted trial balance. Prepare a classified balance sheet for year ending December 31, 2014. Prepare in journal form, without explanation, the closing entries for the year ended December 31, 2014.
What is the value of each company before the merger : If the companies continue to operate separately, what is the total value of the companies, the total value of the equity, and the total value of the debt?

Reviews

len1416357

3/6/2017 7:13:54 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.

len1416357

3/6/2017 7:13:48 AM

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

len1416357

3/6/2017 7:13:33 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.

Write a Review

Applied Statistics Questions & Answers

  Hypothesis testing

What assumptions about the number of pedestrians passing the location in an hour are necessary for your hypothesis test to be valid?

  Calculate the maximum reduction in the standard deviation

Calculate the maximum reduction in the standard deviation

  Calculate the expected value, variance, and standard deviati

Calculate the expected value, variance, and standard deviation of the total income

  Determine the impact of social media use on student learning

Research paper examines determine the impact of social media use on student learning.

  Unemployment survey

Find a statistics study on Unemployment and explain the five-step process of the study.

  Statistical studies

Locate the original poll, summarize the poling procedure (background on how information was gathered), the sample surveyed.

  Evaluate the expected value of the total number of sales

Evaluate the expected value of the total number of sales

  Statistic project

Identify sample, population, sampling frame (if applicable), and response rate (if applicable). Describe sampling technique (if applicable) or experimental design

  Simple data analysis and comparison

Write a report on simple data analysis and comparison.

  Analyze the processed data in statistical survey

Analyze the processed data in Statistical survey.

  What is the probability

Find the probability of given case.

  Frequency distribution

Accepting Manipulation or Manipulating

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!

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