# 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.

Kemahiran: Excel, Statistik

Tentang Majikan:
( 3 ulasan ) Chennai, India

ID Projek: #4060793

saraiva

Stats experts here!

\$40 USD dalam 2 hari
(23 Ulasan)
4.7

## 10 pekerja bebas membida secara purata \$48 untuk pekerjaan ini

Ohuma

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

\$40 USD dalam sehari
(16 Ulasan)
5.7
ProDataAnalyzer

\$56 USD dalam 2 hari
(18 Ulasan)
4.7
satsin7

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

\$30 USD dalam sehari
(14 Ulasan)
4.4
javed1705

\$50 USD dalam sehari
(15 Ulasan)
4.3
palsetiavitesh

Hello Sir, Please Check PMB for bid details

\$30 USD dalam 5 hari
(3 Ulasan)
2.0
mfawzy6

Let's start

\$60 USD dalam 30 hari
(1 Ulasan)
0.0
winbond

Hi, details of Bid in PM

\$100 USD dalam 15 hari
(0 Ulasan)
0.0
MicroBrainCenter

\$100 USD dalam 8 hari
(1 Ulasan)
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 dalam 2 hari
(0 Ulasan)
0.0
vertexv

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

\$30 USD dalam 2 hari
(0 Ulasan)
0.0