Using Excel and Megastat to find the regression equation
Not what you're looking for?
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
--------------------------------------------------------------------------------
Purchase this Solution
Solution Summary
Compute regression equation using two softwares, excel and megastat. Then interpret and compare the results. Also develop plots
Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.
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.