Regression Analysis
Not what you're looking for?
See attached Excel files.
Calculations
Looking for
Single Regression Models
Multiple Regression Model with ONLY statistically significant Coefficients
Explanation of data collection, SOURCE of data, regression methodology and
specific hypothesis tests F test, and T test (or p-value).
Obtain a correlation matrix
Obtain your "best" multiple regression model using the combined data
Interpret your output. Write up your explanation. Be sure to explain which independent variables are most strongly related to price (in each city #1 and all three cities #2)
? which are least strongly related to price,
? if the directions (positive, negative) of the correlations make sense,
? if there appears to be any multicollinearity,
? your logic in excluding/including independent variables in your "best" mode
Ho: β1 = β 2 = β 3 = 0
Ha : β1 and/or β 2 and/or β 3 is not equal to 0
Explanation of "best" regression model and HOW it is determined to be better
than other models. Should only include ONLY statistically significant
coefficients and the best R2 values (given the coefficients that are included)
Explanation of conclusions drawn from the results for the CAR BUYER
Selling price = Intercept + Coefficient * x1 (Age) + Coefficient * x4
What the results of the regression equation mean to the buyer of that vehicle.
For instance:
If the buyer would accept a car that was one year older, he/she would expect the selling price to be on average $912 less. ( If - $912 is the coefficient on the age variable and it is statistically significantly different from -0-)
If the city (dummy variable) is statistically significant then that coefficient is the difference in the selling price associated with that city (keeping the age and mileage of the car the same).
Likely either age OR mileage will be in "best" model since they are often explaining the same decrease in price. DO explain multicollinearity.
Purchase this Solution
Solution Summary
The solution provides step by step method for the calculation of regression analysis. Formula for the calculation and Interpretations of the results are also included.
Purchase this Solution
Free BrainMass Quizzes
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.
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.
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.