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

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

Assignment - statistics in educational researchpart a -

Assignment - Statistics in Educational Research Part A - Show all your work Q1) A teacher asked each of her students how many novels they had read in the previous six months. The results are shown below. 0 1 5 4 2 1 3 2 ...

Business statistics assignment -the purpose of this

Business Statistics Assignment - The purpose of this assignment is to improve your understanding in choosing between and using methods to assess the relationship between variables and make comparisons across different se ...

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

A company produces labeled packaging material and the

A company produces labeled packaging material and the company intends to buy a new machine for shaping and labeling. The company has been approached by two different companies and the production manager did a test on the ...

Assessment task -you become interested in the non-skeletal

Assessment Task - You become interested in the non-skeletal effects of vitamin D and review the literature. On the basis of your reading you find that there is some evidence to suggest that vitamin D deficiency is linked ...

Business statistics project assignment -there will be two

BUSINESS STATISTICS PROJECT ASSIGNMENT - There will be two parts to this assignment: Part A: Group Work (A Business Report) Part B: Individual Reflective Piece (A Ministerial Brief) The response to Part A must be provide ...

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

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

Go to the webliography source for the national cancer

Go to the Webliography source for the National Cancer Institute's Surveillance, Epidemiology, and End Results (SEER) Program. In the Fast Stats, create your own cancer statistical report, "Stratified by Data Type," and u ...

  • 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