in excel - expected return, variance, standard deviation, coefficient of variation,95% confidence interval

Project Description:

the andrew jonathan slottje company

the andrew jonathan slottje company has proposed a new branch in dallas for next year. the project's returns are as follows:

year
project return (ri)
1994
0.11
1995
0.15
1996
0.13
1997
0.16
1998
0.17
1999
0.19
2000
0.21
2001
0.10
2002
0.09
2003
0.11

based on this information do the following:
calculate the expected return.
calculate the variance and standard deviation of all the returns.
calculate the coefficient of variation of all the returns.
create a chart to illustrate the trend in project returns over time.
add a solid line representing the expected return and dotted lines illustrating a 95% confidence interval about the expected return.
include a brief discussion that contains an analysis, as well as your recommendation, for this case.
notes
the expected return is equivalent to the mean value.
the coefficient of variation is defined as
standard deviation
coefficient of variation = ---------------------------- x 100
mean

this is a measure of the risk involved in the investment.
for 95% confidence is equal to 2.5710. based on this calculate the upper and lower confidence interval using the standard deviation of the sample distribution.
Skills Required:
Project Stats: Edited

Price Type: Negotiable

Completed
Total Proposals: 6
1 Current viewersl
203 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 4.9
    1175 Jobs 609 Reviews
    $70 in 1 Day
  • 5.0
    147 Jobs 118 Reviews
    $29 in 4 Hours
  • 4.9
    148 Jobs 96 Reviews
    $42 in 1 Day
  • 4.5
    355 Jobs 236 Reviews
    $30 in 1 Day
  • 4.9
    14 Jobs 9 Reviews
    $30 in 4 Hours