I gang

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.

Færdigheder: Excel, Statistikker

Se mere: 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

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

Please see PM for details.

$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

dear sir please check pm

$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

Hi, Please check your PMB. Regards

$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