# 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
267 Total views
Project posted by:

### Proposals

Proposals Reputation Price offered
• 4.9
2228 Jobs 1101 Reviews
\$70 in 1 Day
• 5.0
149 Jobs 119 Reviews
\$29 in 4 Hours
• 4.9
167 Jobs 100 Reviews
\$42 in 1 Day
• 4.6
462 Jobs 283 Reviews
\$30 in 1 Day
• 4.9
19 Jobs 10 Reviews
\$30 in 4 Hours