What is the expected sale

Assignment Help Applied Statistics

Reference no: EM131416375

Statistics for Financial Decisions 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.

Reference no: EM131416375

Questions Cloud

Problem regarding the threads main view : If a project is poorly designed and constructed, will a well-planned and well-executed implementation effort help the project to succeed? Will a well-designed and well-constructed system overcome a poor implementation effort?

How are the target-firm shareholders harmed by such actions : How are the target-firm shareholders harmed by such actions? Explain.

Technology security on the systems design process : What is the impact of information technology security on the systems design process? What key factors need to be addressed in the development cycle before systems construction and implementation? After?

What is the basic determinant of tax status in a merger? : Merger and Taxes Describe the advantages and disadvantages of a taxable merger as opposed to a tax-free exchange. What is the basic determinant of tax status in a merger? Would an LBO be taxable or nontaxable? Explain.

What is the expected sale : STAT 6003: Statistics for Financial Decisions Assessment. 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

How does stress impact the body : What did the self-assessment tell you about your level of stress? Were you surprised by the results? Explain.How does stress impact the body? How do you recognize "signs" of stress?The readings for this Module discuss the relationship between motiva..

Is there a possibility of reverse synergy : Why might a company do this? Is there a possibility of reverse synergy?

User for a series of names : Design a program that asks the user for a series of names (in no particular order). After the final person's name has been entered, the program should display the name that is first alphabetically and the name that is last alphabetically.

How could the company hedge its exchange rate risk : Ignoring taxes, what are East Coast Yachts' projected gains or losses from this proposed arrangement at the current exchange rate of $0.73€? What happens to profits if the exchange rate changes to $0.80€? At what exchange rate will the company bre..

Reviews

len1416375

3/6/2017 7:19:28 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. 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.

len1416375

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

Write a Review

Required(*) Message

Applied Statistics Questions & Answers

Define the random variable x

A. In a recent sample of 84 used car sales costs, the sample mean was $6,425 with a standard deviation of $3,156. Assume the underlying distribution is approximately normal. a. Which distribution should you use for this problem? Explain your choice...

The volume of orders generated by each

SeaFair Fashions relies on its sales force of 220 to do initial screening of all new fashions. The company is presently bringing out new line of swimwear and has invited 40 salespeople to its Orlando home office. An issue of the constant concern to S..

The random var x has a normal distribution with population m

The random var x has a normal distribution with population mean (u) of 40 and a population variance (q^2) of 36. Find the value of x. Call it x0, such that... A) P (X >= x0) = 0.10 B) P(X =x0) = 0.40

Test question and assess lanies symptoms

Formulate a test question and assess Lanie''s symptoms - Review the presenting problem and the assessment question that you developed in your Week 1 Assignment and consider any additional questions that you might formulate. R

Calculate the total deviation

Refer back to your SPSS output from Assessment 4 Question 3. Based on that output, what is the 95 percent confidence interval of the difference? Assume the within-group deviation is 108.45 and the between-group deviation is 48.68. Calculate the tot..

What the assumed probabilities in a would actually be

What is the probability that at least one of the 24 people would have seen the cut if it was there? How might we estimate what the assumed probabilities in a would actually be?

A new phone answering system for a company

A new phone answering system for a company is capable of handling seven calls every 10 minutes. Prior to installing th new system company analysts determined that the incoming calls to the system are Poisson with a mean equal to three every 10 minut..

The mean wage rate for hourly workers at general motors

The mean wage rate for hourly workers at General Motors is [Mu=$14.25] per hour (Detroit News, April 14, 1989). Assume that the population standard deviation [s=$2.00]. What is the probability that the sample mean [x] is at least $13.80 per hour but ..

Explore the national water information system

CE 26400 Data Analysis - Fall 2016 - Explore the National Water Information System (http://waterdata.usgs.gov/nwis) to find dis- charge gauges across the United States with long time series record

Accordance to lognormal distribution with mttf

A flange bolt wears out because of fatigue in accordance to lognormal distribution with MTTF = 10.00 hr and s =2.00. If preventive maintainance consists of periodically replacing the bolt, what is the reliability at 550hr with and without pre..

A purchasing agent at the kelly bread company

A purchasing agent at the Kelly Bread Company wants to estimate the mean daily usage of rye flour. She takes a sample for 50 straight days and finds that the sample mean is 180 pounds with a sample standard deviation of 38.5 pounds.a.) State the 90% ..

The specimen and how the infectious agent

a. Describe the handing of the specimen and how the infectious agent, in this case a bacterial pathogen, is isolated from the sputum b. Explain techniques used to isolate bacteria from a clinical specimen using the learnSmart lab exercise," Isolation..

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

User Account

All Pages