# Statistics assignment

We need 2 assignments to be completed on Statistics. We've been doing a simulated trading exercise for 17 days and we need to answer 10 questions in an Xcel sheet.

Questions 1 to 7 are the same for both assignments. Only the las 3 questions will use different values.

Questions are:

1. Compute the daily return of the sector shares

2. Calculate the average return

3. Test for the significance of the average returns.

4. Test if the pairwise differences between the average returns are significant.

5. Test if there is a difference in returns across the four sector shares.

6. Determine the covariance and correlation between the returns.

7. Run regression analysis test between the four sector shares and the market return in order to determine the ? values.

8. Find the expected return of the portfolio

9. Find the variance of the portfolio

10. Compute your final profit/loss realised at the end of the trading days.

Evner: Excel, Statistikker

Om arbejdsgiveren:
( 3 bedømmelser ) Chennai, India

Projekt ID: #4060793

## Tildelt til:

saraiva

Stats experts here!

\$40 USD in 2 dage
(23 bedømmelser)
4.7

## 10 freelancers are bidding on average \$48 for this job

Ohuma

Statistician here with experience in the sue of MS Excel for analysis

\$40 USD på 1 dag
(16 bedømmelser)
5.7
ProDataAnalyzer

\$56 USD in 2 dage
(18 bedømmelser)
4.7
satsin7

I have more than 15 years of real financial experience. Pls see PMB

\$30 USD på 1 dag
(14 bedømmelser)
4.4
javed1705

\$50 USD på 1 dag
(15 bedømmelser)
4.3
palsetiavitesh

Hello Sir, Please Check PMB for bid details

\$30 USD in 5 dage
(3 bedømmelser)
2.0
mfawzy6

Let's start

\$60 USD in 30 dage
(1 bedømmelse)
0.0
winbond

Hi, details of Bid in PM

\$100 USD in 15 dage
(0 bedømmelser)
0.0
MicroBrainCenter

\$100 USD in 8 dage
(1 bedømmelse)
0.0
Prashantsd

I am specialist in excel advanced vba. Have worked on many calculation and statistical projects. You would know the expertise level only when you get the work done.

\$40 USD in 2 dage
(0 bedømmelser)
0.0
vertexv

Uni tutor in stats assignments like this. Go to the top of the class.

\$30 USD in 2 dage
(0 bedømmelser)
0.0