Expected value;standard deviation;coefficient of variation
Not what you're looking for?
Problems involve:
expected value
standard deviation
coefficient of variation
pv
fv
pva
fva
(see attached)
I need these problems done using excel and showing how the answers were calculated. The answers are at the end of the attached problem set.
I need the formulas to each problem in an EXCEL spreadsheet as well as explanations as to what the answers mean in the context of the problem.
Describe and justify each assumption you have made
Explain, support and justify every statement you make
Support your conclusions with evidence such as facts and statistics from reliable sources, or a well-reasoned logical argument.
Purchase this Solution
Solution Summary
This post shows how to calculate expected value, standard deviation, coefficient of variation, pv, fv, pva, fva.
Solution Preview
See the attached file. Thanks
7.14
Sales Probability of Occurance
Ri pi (Ri-R-)
$800 2% ($1,200)
$1,000 8% ($1,000)
$1,400 20% ($600)
$2,000 40% $0
$2,600 20% $600
$3,000 8% $1,000
$3,200 2% $1,200
Expected return = R- Spi*Ri
2000
Standard Deviation=s (Spi*(Ri-R-)^2)^0.5
$601.33
Coefficient of Variation=CV s/R-
0.301
8.3
This is the future value of a one time ...
Purchase this Solution
Free BrainMass Quizzes
Basic Social Media Concepts
The quiz will test your knowledge on basic social media concepts.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.
Understanding the Accounting Equation
These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.