Individual Assignment II Due Oct. There can be multiple ways to complete the analysis. You only need to use one way to complete it. The significance...

Sample std deviation

1.30

1.16

Please use T Test with equal variance assumed to complete the analysis and make strategic recommendations.

3.    Your client is a socially and environmentally responsible investor who is currently holding S&P 500 and looking for investment opportunities with both financial return as well as social outcome. Domini Social equity fund is a fund who is specialized in investing in socially responsible firms. You collected the monthly return of the fund (DSEFX) as well as S&P 500.

·     Please conduct some research of DSEFX fund to understand the stocks that the fund is investing in.

·     Please conduct descriptive analysis of DSEFX and introduce this fund to your client. (No more than 3 sentences.)

·     Does this fund generate non negative return? Please conduct necessary analysis and illustrate all your steps, and explain it to your client.

·     How does this fund perform compared with S&P 500? Please conduct necessary analysis and illustrate all your steps and explain it to your client.

4.    A review website wants to identify the type of characteristics of reviewers who attract more audience to the website. Please run a regression model to determine how Content Quantity, Centrality, and other reviewer characteristics determine Viewership. Please interpret your model results and make recommendations to the website.

Data Description

·     REVIEWERID: this is a unique ID assigned to the reviewer. It is a "dummy" ID and does not have any special meaning.

·     STARTYEAR: this column indicates the year in which the reviewer started writing reviews at the website.

·     NCAT: there are many categories of products being reviewed at the website. This column indicates the number of categories for which the reviewer writes reviews.

·     Popularity: the website periodically votes on the popularity of reviews. Multiple levels of popularity recognition exist:

o  Level 0: the reviewer was not recognized as a popular reviewer

o  Level 1: the reviewer was recognized as a Top1000 reviewer

o  Level 2: the reviewer was recognized as a Top500 reviewer

o  Level 3: the reviewer was recognized as a Top200 reviewer

o  Level 4: the reviewer was recognized as a Top100 reviewer

o  Level 5: the reviewer was recognized as a Top50 reviewer

o  Level 6: the reviewer was recognized as a Top10 reviewer

·     Lead: this column indicates whether the reviewer was designated as a Lead (1 means yes, 0 means no), which is another recognition at the website.

·     Advisor: this column indicates whether the reviewer was designated as an Advisor (1 means yes, 0 means no), which is another recognition at the website.

·     Viewership: this column stores the average daily viewership of the reviewer (number of times users read the reviewer's product reviews).

·     Content: this column stores the average amount of content of the reviewer. This measure is a weighted measure of the number of review articles the reviewer has, where reviews that were written a long time ago is discounted (since it is less likely to be relevant).

·     Centrality: this is a weighted measure of how many other reviewers trust this reviewer. This is a ratio level measurement. A higher value indicates the reviewer is trusted by more reviewers.

·     OutDegree: this column indicates how many other reviewers this reviewer trusts.

• Attachment 1
• Attachment 2
• Attachment 3