Explore BrainMass
Share

Regression Equation, R-squared Value, Intercept

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

Instructions:
? Write the regression equation
? What does R-squared value tell you?
? What meaning does intercept have?
? Which is warmer, a day with rain or a day without?
? Is KIAH_Precip a good predictor?
? Describe fit of regression

It might be supposed that rainy days would tend to be cooler than days without rain, other factors being equal. Furthermore, if that rain is widespread enough to affect more than one reporting station in a city, the effect might be expected to be even more pronounced.

The following output from the Excel Analysis ToolPak, shows a regression analysis on a year of Houston weather data. Precipitation data were collected for George Bush International Airport (KIAH) and for Hobby Airport (KHOU), coded as 1 for precipitation and 0 for no precipitation. These values were used as "binary predictors". The dependent variable is the departure of the daily high temperature from the 30 year normal for the date. So, for example, a day with a high temperature two degrees below normal would be shown as a departure value of -2.0.

Regression Statistics
Multiple R 0.1768
R Square 0.0313
Standard Error 6.8608
Observations 360

ANOVA
df SS MS F Significance F
Regression 2 542.19 271.10 5.7594 0.0035
Residual 357 16804.16 47.07
Total 359 17346.35

Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept 2.6668 0.4381 6.0878 0.0000 1.8053 3.5283
KIAH_Precip -2.3840 1.0423 -2.2873 0.0228 -4.4337 -0.3342
KHOU_Precip -0.6236 0.9994 -0.6240 0.5331 -2.5890 1.3419

a) Write the fitted regression equation
b) What does the R-squared value tell you?

c) What, if any, meaning does the intercept have?

d) Other things being equal, is the temperature warmer on days with or without rain at KIAH?
e) Does the 95% confidence interval for KIAH_Precip slope give us any confidence that precip vs. no precip at KIAH is an important predictor of temperature?

https://brainmass.com/statistics/regression-analysis/regression-equation-r-squared-value-intercept-293732

Solution Summary

A Complete, Neat and Step-by-step Solution is provided in the attached file.

\$2.19

Regression Analyses: Slope, the Y-Intercept, and R-Squared Value

Using Excel as your processing tool, work through three simple regression analyses. Please see the attached document for the necessary data.

1. First run a regression analysis using the BENEFITS column of all data points in the AIU data set as the independent variable and the INTRINSIC job satisfaction column of all data points in the data set as the dependent variable. Create a graph with the trendline displayed. What is the least squares regression line equation? What are the slope and the y-intercept? What is the R-squared value?

2. Next, run a regression analysis using the BENEFITS column of all data points in the data set as the independent variable and the EXTRINSIC job satisfaction column of all data points in the AIU data set as the dependent variable. Create a graph with the trendline displayed. What is the least squares regression line equation? What are the slope and the y-intercept? What is the R-squared value?

3. Next, run a regression analysis using the BENEFITS column of all data points in the data set as the independent variable and the OVERALL job satisfaction column of all data points in the AIU data set as the dependent variable. Create a graph with the trendline displayed. What is the least squares regression line equation? What are the slope and the y-intercept? What is the R-squared value?

4. Finally, make very specific comments and give reasons regarding any similarities or differences in the output results. Which regression produces the strongest correlation coefficient result? Why?

View Full Posting Details