Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Applied Statistics Expert

Statistics for Financial Decisions Short written Assessment

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.

Assignment:

The daily sales figures and prices for our Schmeckt Gut Energy Bars sold in the countries of Nockaragua, Macronesia and Industria are provided with the attached EXCEL file. The board of directors of Schmeckt Gut is interested in investigating this data in more detail. The board would like you to answer the following questions by using statistical methods and concepts that have been addressed in the modules.

a) What is the expected sale (number of energy bars sold) and what is the expected revenue on any given day in each of the three countries?

b) Based on the data, what is the probability that Schmeckt Gut:

(i) Sells at least the expected number of energy bars?

(ii) Reaches at least the expected revenue?

c) What are the average number of energy bars sold and revenues achieved for each week day (Monday's, Tuesday's, ... Saturday's and Sunday's) in each country?

(i) Create probability distributions of the average number of sales and the average revenues achieved over any given week (Monday to Sunday)?

(ii) Present your distributions for each country in graphs.

(iii) Given the probability distributions for every day of the week (Monday to Sunday), what are the expected sales and what are the expected revenues for each day of the week (Monday to Sunday) for each country?

(iv) On which day are we experiencing, on average, the highest sales (number of energy bars sold) and on which day the lowest sales?

(v) On which day are we experiencing, on average, the highest revenue and on which day the lowest revenue?

(vi) What is the expected number of energy bars sold on these specific days? What is the expected revenue on these specific days? Knowing the actual data, what is the probability that we meet the expected sales and revenues on these days?

d) With the knowledge of the above, advise the board in which country we should invest in marketing our Energy Bars. Explain your rational.

Attachment:- Assignment Files.rar

Applied Statistics, Statistics

  • Category:- Applied Statistics
  • Reference No.:- M92493644
  • Price:- $60

Guranteed 36 Hours Delivery, In Price:- $60

Have any Question?


Related Questions in Applied Statistics

Business statistics project -problem description the

BUSINESS STATISTICS PROJECT - Problem Description: The blockchain is a decentralized ledger of all transactions across a peer-to-peer network. Using this technology, participants can confirm transactions without a need f ...

Construct a regression model for predicting total charges

Construct a regression model for predicting total charges from length of stay for DRG 105. a. State the null and alternative hypotheses and alpha level. b. Prepare a scatter diagram with the regression line for the two v ...

Quantitative methods in health statistical analysis report

Quantitative Methods in Health Statistical Analysis Report - Question 1 - Are you a Lark or an Owl? Studies indicate that about 10% of us are morning people (Larks) while 20% are evening people (Owls) and the rest are no ...

Questions -question 1 - briefly explain what each of the

Questions - Question 1 - Briefly explain what each of the following theories says about corporate cash holdings: The static tradeoff theory: Information asymmetry. The agency costs of debt. Managerial agency theory. The ...

Using minitab statistics to calculate the various

Using Minitab Statistics to calculate the various T-Tests The steps required for completing the deliverables for this assignment (screen shots that correspond to these instructions can be found immediately following them ...

Assignment - research topicpurpose the purpose of this task

Assignment - Research topic Purpose: The purpose of this task is to ensure you are progressing satisfactorily with your research project, and that you have clean, useable data to analyse for your final project report. Ta ...

Business analytics and statistics research report -this

Business Analytics and Statistics Research Report - This assignment is based on fictional data. You are creating a business report for the CEO of a retail company called, Athlete Panda. It must be professional in present ...

Assessment - analytical reportobjectives - this assessment

Assessment - Analytical Report Objectives - This assessment addresses Unit Learning Outcomes: Discriminate the most appropriate descriptive and inferential statistics to use in a given health context, Analyse health data ...

Applied statistics - regression assignmentin this

Applied Statistics - Regression Assignment In this assignment you are expected to set up a regression equation, run that regression and interpret and evaluate the results. You will need to carefully state all null hypoth ...

Part a -question 1 - true or false in data collection the

Part A - Question 1 - True or False: In data collection, the most common technique to ensure proper representation of the population is to use a random sample. True False Question 2 - Most analysts focus on the cost of H ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As