Regression Analysis: Air Pollution
Not what you're looking for?
The Questions, and the data needed is in the attachment.
1. Select 2 variables X and Y in your data set for a regression analysis. Display the scatter plot of the data.
2. Fit the simple linear regression model Y=ß0 +ß1 X + e to the data (X1, X2)..... (Xn, Yn). Report the least square estimates ß^0 and ß^1. You can use the functions LinReg(ax+b)
3. Compute the correlation coefficient r between X and Y. Interpret it.
4. How good is the regression model here? In other words, what proportion of the variations in the data does it explain?
5. Test whether the slope ß1 is zero or not, or equivalently test whether the population correlation coefficient ? is zero or not. Interpret the result.
Purchase this Solution
Solution Summary
This solution provides a step by step, detailed explanation of how to install the analysis toolpack addin in excel, how to perform linear regression analysis, and how to interpret results
Solution Preview
** Please see the attached file for the complete solution **
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.2083822206
R Square 0.0434231499
Adjusted R Square 0.0407951915
Standard ...
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.
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.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.