Purchase Solution

Regression analysis for mutual fund data

Not what you're looking for?

Ask Custom Question

Linear regression analysis; construct confidence intervals for regression parameters; correlation coefficient .

We can use two products at my work, which are mutual funds and see if there is a correlation between the two. The two different funds are: a domestic stock mutual fund, which only invests in large organizations (large cap companies) based here in the US and an international mutual fund, which only invests in large foreign-based companies. We can see the relationships between them and the magnitude of those relationships.

Date: USIFX Monthly 2006 USSPX Monthly 2006
Close Close
Dec 1 27 21.24
Nov 1 28.91 21.05
Oct 2 28.1 20.66
Sept 1 27.54 20.01
Aug 1 27.49 19.59
Jul 3 26.57 19.14
Jun 1 26.01 19.03
May 1 25.84 19.09
Apr 3 26.79 19.65
Mar 1 25.63 19.40
Feb 1 24.90 19.24
Jan 3 24.95 19.19

Purchase this Solution
Solution Summary

The solution contains calculation of regression equation, coefficient of determination, confidence interval for regression coefficients and regression coefficients. Interpretation of the results are also given.

Solution Preview

Please see the attachments. Calculations are done in Excel.

The relationship between the two mutual funds can be illustrated in a scatter diagram

The scatter diagram suggests that there is a positive correlation between the two variables. The degree of relationship is measured by the correlation coefficient

Correlation = 0.753011296

Regression Analysis
The regression ...

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • Regression Analysis: Random Selection

    -Based on your regression analysis of the data, when is the average total return for a mutual fund with an expense ratio of 0.75%? Please see attachment for complete solution.

  • Correlation & Regression Analysis

    367296 Regression Analysis for Mutual fund data: scatter diagram, coefficients, interpret Sample Number Assets ($ millions) Return (%) 1 AARP 622.2 10.8 2 Babson 160.4 11.3 3 Compass

  • Interpreting Scatter Diagram, and Independent/Dependent Variable

    Answer Data: Y (Return %) X( Assets) 10.80 622.20 11.30 160.40 11.40 275.70 9.10 433.20 9.20 437.90 11.60 494.50 9.50 158.30 8.20 681.00 6.80 241.30 In the present problem, the given data relates total asset holdings of various mutual fund

  • Mutual Bond Funds and Investment

    53241 Mutual Bond Funds and Investment We are studying mutual bond funds for the purpose of investing several funds. For this particular study, we want to focus on the assets of a fund and its five-year performance.

  • Regression and testing of hypothesis problems

    Sig. .000 .000 a Kruskal Wallis Test b Grouping Variable: Fund Type 8. Linear Regression Linear regression is suitable for the data See graph below 9.

  • Coefficients of correlation and determination, regression equations, and weighted moving averages

    We are studying mutual bond funds for the purpose of investing in several funds. For this particular study, we want to focus on the assets of a fund and its five-year performance.

  • Statistics - Correlation coefficient

    Please help me to understand the problem thanks. 13-16 We are studying mutual bond funds for the purpose of investing in several funds. For this particular study, we want to focus on the assets of a fund and its five-year performance.

  • Solution to some stats problems

    We are studying mutual bond funds for the purpose of investing in several funds. For this particular study, we want to focus on the assets of a fund and its five-year performance.

  • Asset Classes for Caterpiller and a mutual fund

    255917 Asset Classes for Caterpiller and a mutual fund Asset Classes Select a mutual fund and a Dow 30 organization. Based on your selections, determine the asset classes for your selected mutual fund and Dow 30 organization.

View More Related Solutions