# use sas to solve questions

### Get perfect grades by consistently using our affordable writing services. Place your order and get a quality paper today. Take advantage of our current 20% discount by using the coupon code GET20

Order a Similar Paper Order a Different Paper

Regression Analysis on House Price in Chicago

Basic concepts on regression analysis.

We have the following Chicago community data on SAS.

/* Chicago Community */

filename webdat url “https://bigblue.depaul.edu/jlee141/econdata/eco520/chicago_cca.csv” ;

/* Import Chicago Community data*/

PROC IMPORT OUT= chicago_cca

DATAFILE= webdat DBMS=CSV REPLACE;

RUN;

proc contents ; run ;

data community ; set chicago_cca ;

income = income/1000;

Black= Black*100;

Unemp= Unemp*100;

Hispanic = Hispanic*100 ;

label Black= “Black Population Ratio” ;

label Hispanic=”Hispanic Population Ratio” ;

label unemp=”Unemployment Rate” ;

label income=”Median Income in $1000″ ;

proc means ; run ;

**1. Simple regression Model**

Letâ€™s investigate the relationship between income (Y) and unemployment rate (X) using SAS.

1) Find the correlation coefficient and covariance between X and Y.

2) Scatter plot between X and Y with regression line

3) Perform regression analysis using the following code:

proc reg data= community ;

Model income = unemp;

run ;

4) Using SAS code save the predicted value of income from above model and called â€œyhat1â€ and save the residuals called â€œres1â€. Scatter plot themincome, yhat1, and res1 with unemp as the X variable.Explain what you found from the plots.

5) Carefully find or calculate the following statistics using **the regression output** and explain their meanings.

- Total Sum of Square (SST)
- Regression Sum of Square (SSR)
- Error Sum of Square (SSE)
- R square
- Adjusted R square
- Variance of Y
- Variance of Error
- Standard Error and variance of b1
- Standard Error and variance of b2
- T statistic and P-value of t statistic

6) Perform the following hypothesis tests using the output

- Ho: B1 = 0,Ha: B1 Â¹ 0
- Ho: B2 = 0, Ha: B3 Â¹ 0
- Ho: B1 = B2 = 0 , Ha: Ho is not true

**2. Multiple Regression Model**

1) Estimate a multiple regression model using the following code:

proc reg data= community ;

Model income = unemp Hispanic black / VIF;

run ;

2) Carefully explain the difference between R square and Adjusted R square. Compare this model with the simple regression model, which one is better and why?

3) Perform the F test. Setup your hypothesis and perform the test.

4) Carefully explain the multicollinearity and what are the consequences of multicollinearity. From the output of the multiple regression model, do you find the multicollinearity?

### Have your paper completed by a writing expert today and enjoy posting excellent grades. Place your order in a very easy process. It will take you less than 5 minutes. Click one of the buttons below.

Order a Similar Paper Order a Different Paper