Sedang Disiapkan

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

Lihat lebih lanjut: assignment, portfolio statistics, Statistics assignment, variance, statistics, regression test, correlation, c++ statistics, c statistics, assignment 55, excel portfolio, analysis sheet excel, questions statistics, statistics test, test assignment, excel assignment sheet, excel correlation, portfolio analysis assignment, assignment portfolio analysis, regression run, shares market, test trading, questions excel answer, market analysis excel, calculate correlation

Tentang Majikan:
( 3 ulasan ) Chennai, India

ID Projek: #4060793

Dianugerahkan kepada:

saraiva

Stats experts here!

$40 USD dalam 2 hari
(23 Ulasan)
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 dalam sehari
(16 Ulasan)
5.7
ProDataAnalyzer

Please see PM for details.

$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

dear sir please check pm

$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

Hi, Please check your PMB. Regards

$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