Explore BrainMass

Explore BrainMass

    Using Excel and Megastat to find the regression equation

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    12.33 Use Excel's Add Trend-line feature to fit a linear regression to the scatter plot. Is a linear model credible?

    12.35 Use Megastat to fit the regression model, including residuals and standardized residuals.

    12.37 ( a) based on the R2 and ANOVA table for your model, how would you assess the fit? (b) Interpret the p-value for the F statistic. (c) would you say that your model's fit is good enough to be of practical value?

    12.42 Use Megastat to generate 95 percent confidence and prediction intervals for various x-values.

    Portfolio Returns (%) on Selected
    Mutual Funds
    Last Year (X) This Year (Y)
    11.9 15.4
    19.5 26.7
    11.2 18.2
    14.1 16.7
    14.2 13.2
    5.2 16.4
    20.7 21.1
    11.3 12.0
    â?'1.1 12.1
    3.9 7.4
    12.9 11.5
    12.4 23.0
    12.5 12.7
    2.7 15.1
    8.8 18.7
    7.2 9.9
    5.9 18.9

    --------------------------------------------------------------------------------

    © BrainMass Inc. brainmass.com June 4, 2020, 12:23 am ad1c9bdddf
    https://brainmass.com/statistics/regression-analysis/using-excel-and-megastat-to-find-the-regression-equation-335423

    Solution Summary

    Compute regression equation using two softwares, excel and megastat. Then interpret and compare the results. Also develop plots

    $2.19

    ADVERTISEMENT