Individual Assignment II Due O.
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