+1(978)310-4246 credencewriters@gmail.com
  

do the project include excel  word and power pointYour excel document should include the following, each on a new, clearly labeled sheet:
· The raw data (with original categorical variables not yet changed to numeric)
· Output from correlation checks between your 
NUMERIC
 independent variables (do not include categorical variables, even if you have made them into new columns of 1’s and 0’s)
· A clean version of your data – missing cells filled in, categorical variables changed to numeric ones, variables with too high of correlations removed
· Baseline Regression (can be on same sheet as clean data)
· A new sheet for each time you remove a variable during variable elimination (highlight the adjusted r-squared)
· When you have found your final model, plot the overall residuals
Your word document should be a description of your data, research/business question, and the work you did in Excel:
· Statement of research purpose
· Clear, understandable statement of research goal. Any initial hypothesis?
· Data citation
· Where did you gather the data? How many observations?
· Data Description
· What variables are you using? Numeric/Categorical? Independent/Dependent?
· Data Cleaning
· Categorical Variables (what does a 1/0 indicate?)
· Did you delete and name/id variables?
· Check for multicollinearity
· Record values for correlations between the 
NUMERIC
 variables (not any categorical ones – i.e. ones with 1/0)
· Did you decide to remove any variables?
· Baseline Regression
· What is the dependent variable
· What independent variables are in the model
· Variable Elimination
· Do you want to remove a variable? Which one? Why? (what is it’s p-value)
· After you remove a variable, is the adjusted r-squared bigger or smaller than the baseline model’s?
· Is this new model better?
· Write out final model (y = …) plug in values from best regression
· Do the overall residuals for the final model pass our assumptions?
· Interpret the output (even if residuals do not pass)
· Is this a good model? (F-test)
· At least 1 interpretation of a slope coefficient
· At least 1 hypothesis test interpretation for an independent variable (p-value)

Power point should have Executive summary. Summarize the project and the final results you would like to present to your classmates. 4 pages。Sheet1

Independent Independent Independent Independent Independent Dependent Independent Independent Independent Independent

No. House Age Distance to MRT station Number of convenience stores Latitude Longitude Hours price of unit area Garden Location Number of convenience parks Housing facilities(Level:1-5)

1 32 84.87882 10 24.98298 121.54024 $37.90 Yes South 2 2

2 19.5 306.5947 9 24.98034 121.53951 $42.20 Yes South 2 5

3 13.3 561.9845 5 24.98746 121.54391 $47.30 Yes South 3 2

4 13.3 561.9845 5 24.98746 121.54391 $54.80 Yes City Center 6 3

5 5 390.5684 5 24.97937 121.54245 $43.10 Yes South 2 2

6 7.1 2175.03 3 24.96305 121.51254 $32.10 Yes South 3 3

7 34.5 623.4731 7 24.97933 121.53642 $40.30 Yes North 2 5

8 20.3 287.6025 6 24.98042 121.54228 $46.70 Yes City Center 1 3

9 31.7 5512.038 1 24.95095 121.48458 $18.80 No South 0 2

10 17.9 1783.18 3 24.96731 121.51486 $22.10 Yes City Center 2 1

11 34.8 405.2134 1 24.97349 121.53372 $41.40 Yes North 2 4

12 6.3 90.45606 9 24.97433 121.5431 $58.10 Yes South 3 2

13 13 492.2313 5 24.96515 121.53737 $39.30 Yes South 5 3

14 20.4 2469.645 4 24.96108 121.51046 $23.80 No North 2 5

15 13.2 1164.838 4 24.99156 121.53406 $34.30 Yes City Center 6 5

16 35.7 579.2083 2 24.9824 121.54619 $50.50 No City Center 3 3

17 0 292.9978 6 24.97744 121.54458 $70.10 Yes City Center 4 2

18 17.7 350.8515 1 24.97544 121.53119 $37.40 Yes North 5 2

19 16.9 368.1363 8 24.9675 121.54451 $42.30 No South 1 4

20 1.5 23.38284 7 24.96772 121.54102 $47.70 No City Center 3 1

21 4.5 2275.877 3 24.96314 121.51151 $29.30 No South 2 2

22 10.5 279.1726 7 24.97528 121.54541 $51.60 No North 3 2

23 14.7 1360.139 1 24.95204 121.54842 $24.60 No South 4 2

24 10.1 279.1726 7 24.97528 121.54541 $47.90 Yes South 0 2

25 39.6 480.6977 4 24.97353 121.53885 $38.80 No North 1 4

26 29.3 1487.868 2 24.97542 121.51726 $27 No City Center 0 2

27 3.1 383.8624 5 24.98085 121.54391 $56.20 No South 2 2

28 10.4 276.449 5 24.95593 121.53913 $33.60 No South 3 2

29 19.2 557.478 4 24.97419 121.53797 $47 Yes North 4 3

30 7.1 451.2438 5 24.97563 121.54694 $57.10 Yes City Center 1 4

31 25.9 4519.69 0 24.94826 121.49587 $22.10 Yes City Center 1 3

32 29.6 769.4034 7 24.98281 121.53408 $25 Yes South 2 5

33 37.9 488.5727 1 24.97349 121.53451 $34.20 Yes North 3 2

34 16.5 323.655 6 24.97841 121.54281 $49.30 No South 0 3

35 15.4 205.367 7 24.98419 121.54243 $55.10 Yes South 3 4

36 13.9 4079.418 0 25.01459 121.51816 $27.30 No South 2 5

37 14.7 1935.009 2 24.96386 121.51458 $22.90 No South 5 3

38 12 1360.139 1 24.95204 121.54842 $25.30 Yes City Center 1 4

39 3.1 577.9615 6 24.97201 121.54722 $47.70 No North 2 2

40 16.2 289.3248 5 24.98203 121.54348 $46.20 No North 0 5

41 13.6 4082.015 0 24.94155 121.50381 $15.90 No City Center 0 3

42 16.8 4066.587 0 24.94297 121.50342 $18.20 Yes North 2 4

43 36.1 519.4617 5 24.96305 121.53758 $34.70 No City Center 5 3

44 34.4 512.7871 6 24.98748 121.54301 $34.10 No

  
error: Content is protected !!