See Attached

Unit 3: Expanded Information on Variables for
Project and Feasibility Paper
•
Using the “North Valley Real Estate” Excel Dataset located in the “Files”
Section of the course (Left-hand Side Menu Bar). The Final Research Project
for the course, and all supporting assignments, will be executed using the
“North Valley Real Estate” dataset.
As preparation for the final research paper, formulate a theory about the correlation
between a measurable dependent variable (the effect) and measurable independent
variables (the causes), at least 3 independent variables are required.
The topic area you need to consider is “What factors impact the successful selling of a
home on the open market?” Success can be defined as price, time on market, size, age,
or FICO; this is your decision as the analyst for this research.
Be sure to have at least three independent variables for the proposed research paper
and one selected dependent variable within the “North Valley Real Estate” Excel
Dataset. The topic proposal should include the following four items which serve as the
foundation for the final research paper, your regression model, after instructor feedback
is given.
•
•
•
•
•
Carry out a substantial research-based project
Demonstrate capacity to improve a business situation with data-driven
analytics
Demonstrate capacity to recommend change through statistical analysis
Demonstrate an understanding of statistical applications and reporting
frameworks
Analyze data and synthesize research findings
Directions
Combine this information with your assignment from Unit 2. You should include the
following topical areas as headers/sub-headers with explanation, description, and
written presentation:
Purpose Statement
In one paragraph, state the correlation and identify the primary independent variables.
State the correlation as in the following:
“The dependent variable _______ is determined by independent variables ________,
_________, ________, and ________.”
Identify and defend the “primary” independent variable, or the variable believed to have
the strongest impact on the dependent variable:
“The most important independent variable in this relationship is ________ because
_________.”
Definition of Variables
For each variable, write a single definition paragraph talking about the variable.
Paragraphs should be in this order: dependent variable, primary independent variable,
and at least two more independent variables. In addition to defining the independent
variables, defend why each determines the dependent variable.
For the primary independent variable, at least two research sources that discuss the
variable also must be cited. These sources need not be technical documents but should
contain evidence to justify the relationship between the primary independent variable
and the dependent variable. List these sources in the Reference Page, as needed. Note:
Citations from encyclopedias, Wikipedia, blogs, abstracts, or non-governmental websites
are not acceptable research sources in this assignment.
Data Description
For each of the variables, at least 30 observations of cross-sectional data must be
obtained. Thus, for the final research paper, a data matrix that is at least 30 rows by
numbers of variables must be presented. This is the case for your mandated dataset, just
be sure and acknowledge this in your paper.
Reference Page
The final page of the proposal should be a Reference Page listing at least ten research
sources, forming the basis to conduct citing as appropriate. Also, be sure and include
sources for any table of data.
Refer to Capstone Term Project Resource for guidelines on writing the paper.
record Agent
1 Marty
2 Rose
3 Carter
4 Peterson
5 Carter
6 Peterson
7 Carter
8 Isaacs
9 Peterson
10 Isaacs
11 Rose
12 Peterson
13 Marty
14 Rose
15 Rose
16 Isaacs
17 Carter
18 Peterson
19 Rose
20 Rose
21 Marty
22 Rose
23 Carter
24 Isaacs
25 Carter
26 Isaacs
27 Carter
28 Marty
29 Isaacs
30 Marty
31 Isaacs
32 Isaacs
33 Carter
34 Carter
35 Marty
36 Isaacs
37 Isaacs
38 Rose
39 Carter
Price
Size
Bedrooms Baths Pool (yes is 1)
Garage (Yes is 1) Days
Township
206424 1820
346150 3010
2
1.5
1
1
33
2
3
2
0
0
36
4
372360
310622
496100
294086
228810
384420
416120
487494
448800
388960
335610
276000
346421
453913
376146
694430
251269
547596
214910
188799
459950
3210
4
3
0
1
21
2
3330
3
2.5
1
0
26
3
4510
6
4.5
0
1
13
4
3440
4
3
1
1
31
4
2630
4
2.5
0
1
39
4
4470
5
3.5
0
1
26
2
4040
5
3.5
0
1
26
4
4380
6
4
1
1
32
3
5280
6
4
0
1
35
4
4420
4
3
0
1
50
2
2970
3
2.5
0
1
25
3
2300
2
1.5
0
0
34
1
2970
4
3
1
1
17
3
3660
6
4
1
1
12
3
3290
5
3.5
1
1
28
2
5900
5
3.5
1
1
36
3
2050
3
2
1
1
38
3
4920
6
4.5
1
1
37
5
1950
2
1.5
1
0
20
4
1950
2
1.5
1
0
52
1
4680
4
3
1
1
31
4
264160 2540
393557 3180
3
2.5
0
1
40
1
4
3
1
1
54
1
478675 4660
384020 4220
5
3.5
1
1
26
5
5
3.5
0
1
23
4
313200 3600
274482 2990
4
3
0
1
31
3
3
2
1
0
37
3
167962 1920
175823 1970
2
1.5
1
1
31
5
2
1.5
1
0
28
5
226498
316827
189984
366350
416160
308000
294357
337144
2520
4
3
1
1
28
3
3150
4
3
1
1
22
4
1550
2
1.5
1
0
22
2
3090
3
2
1
1
23
3
4080
4
3
0
1
25
4
3500
4
3
0
1
37
2
2620
4
3
1
1
15
4
2790
4
3
1
1
19
3
Mortgage type Years FICO Default (Yes is 1)
Fixed
2 824
0
Fixed
9 820
0
Fixed
18 819
0
Fixed
17 817
0
Fixed
17 816
0
Fixed
19 813
0
Adjustable
10 813
0
Fixed
6 812
0
Fixed
3 810
0
Fixed
6 808
0
Fixed
8 806
1
Adjustable
9 805
1
Adjustable
9 801
1
Fixed
20 798
0
Adjustable
10 795
0
Fixed
18 792
0
Adjustable
9 792
1
Adjustable
10 788
0
Fixed
16 786
0
Fixed
2 785
0
Fixed
6 784
0
Fixed
10 782
0
Fixed
8 781
0
Fixed
18 780
0
Fixed
20 776
0
Adjustable
9 773
0
Adjustable
9 772
1
Fixed
19 772
0
Fixed
5 769
0
Fixed
6 769
0
Adjustable
9 766
1
Fixed
8 763
1
Fixed
2 759
1
Fixed
17 758
0
Fixed
5 754
1
Fixed
12 753
0
Fixed
18 752
0
Fixed
10 751
0
Fixed
15 749
0
40 Peterson
41 Rose
42 Rose
43 Peterson
44 Rose
45 Marty
46 Marty
47 Marty
48 Rose
49 Isaacs
50 Isaacs
51 Isaacs
52 Isaacs
53 Peterson
54 Peterson
55 Rose
56 Carter
57 Isaacs
58 Carter
59 Carter
60 Rose
61 Peterson
62 Peterson
63 Isaacs
64 Isaacs
65 Marty
66 Isaacs
67 Peterson
68 Marty
69 Rose
70 Isaacs
71 Rose
72 Peterson
73 Rose
74 Rose
75 Marty
76 Marty
77 Carter
78 Marty
79 Marty
299730 2910
445740 4370
410592 4200
3
2
0
0
31
2
4
3
0
1
19
3
4
3
1
1
27
1
667732
523584
336000
202598
326695
321320
246820
546084
793084
174528
392554
263160
237120
225750
848420
371956
404538
250090
369978
209292
190032
5570
5
3.5
1
1
29
5
5050
6
4
1
1
19
5
3360
3
2
0
0
32
3
2270
3
2
1
0
28
1
2830
3
2.5
1
0
30
4
2770
3
2
0
1
23
4
2870
4
3
0
1
27
5
5910
6
4
1
1
35
5
6800
8
5.5
1
1
27
4
1600
2
1.5
1
0
39
2
3970
4
3
1
1
30
4
3060
3
2
0
1
26
3
1900
2
1.5
1
0
14
3
2150
2
1.5
1
1
27
2
7190
6
4
0
1
49
1
3110
5
3.5
1
1
29
5
3290
5
3.5
1
1
24
2
2810
4
3
0
1
18
5
3830
4
2.5
1
1
27
4
1630
2
1.5
1
0
18
3
1850
2
1.5
1
1
30
4
216720 2520
323417 3220
3
2.5
0
0
2
4
4
3
1
1
22
4
316210 3070
226054 2090
3
2
0
0
30
1
2
1.5
1
1
28
1
183920 2090
248400 2300
3
2
0
0
30
2
3
2.5
1
1
50
2
466560 5760
667212 6110
5
3.5
0
1
42
4
6
4
1
1
21
3
362710
265440
706596
293700
199448
369533
230121
169000
4370
4
2.5
0
1
24
1
3160
5
3.5
1
1
22
5
6600
7
5
1
1
40
3
3300
3
2
0
0
14
4
2330
2
1.5
1
1
25
3
4230
4
3
1
1
32
2
2030
2
1.5
1
0
21
2
1690
2
1.5
0
0
20
1
Fixed
13 748
0
Fixed
5 746
0
Adjustable
9 741
1
Fixed
4 740
0
Adjustable
10 739
0
Fixed
6 737
0
Fixed
10 737
0
Fixed
8 736
0
Fixed
6 736
0
Fixed
13 735
0
Adjustable
10 731
0
Fixed
6 729
0
Fixed
15 728
0
Fixed
17 726
0
Fixed
10 726
0
Fixed
18 723
0
Fixed
15 715
0
Fixed
5 710
0
Fixed
8 710
0
Fixed
14 707
0
Fixed
11 704
0
Fixed
10 703
0
Fixed
10 701
0
Adjustable
2 675
0
Adjustable
5 674
1
Adjustable
2 673
0
Adjustable
1 673
0
Adjustable
6 670
0
Adjustable
8 669
1
Adjustable
4 667
0
Adjustable
3 665
0
Adjustable
8 662
1
Adjustable
2 656
0
Adjustable
3 653
0
Adjustable
7 652
1
Adjustable
7 647
1
Adjustable
5 644
1
Adjustable
2 642
0
Adjustable
3 639
0
Adjustable
7 639
1
80 Peterson
81 Rose
82 Marty
83 Carter
84 Carter
85 Peterson
86 Carter
87 Carter
88 Carter
89 Rose
90 Carter
91 Marty
92 Isaacs
93 Carter
94 Peterson
95 Peterson
96 Marty
97 Peterson
98 Marty
99 Isaacs
100 Carter
101 Peterson
102 Isaacs
103 Marty
104 Peterson
105 Peterson
190291 2040
393584 4660
363792 2860
2
1.5
1
1
31
4
4
3
1
1
34
3
3
2.5
1
1
48
5
360960
310877
919480
392904
200928
537900
258120
558342
302720
240115
793656
218862
383081
351520
841491
336300
312863
275033
229990
195257
194238
3840
6
4.5
0
1
32
2
3180
3
2
1
1
40
1
7670
8
5.5
1
1
30
4
3400
3
2
1
0
40
2
1840
2
1.5
1
1
36
4
4890
6
4
0
1
23
1
2390
3
2.5
0
1
23
1
6160
6
4
1
1
24
3
3440
4
2.5
0
1
38
3
2220
2
1.5
1
0
39
5
6530
7
5
1
1
53
4
1930
2
1.5
1
0
58
4
3510
3
2
1
1
27
2
3380
3
2
0
1
35
2
7030
6
4
1
1
50
4
2850
3
2.5
0
0
28
1
3750
6
4
1
1
12
4
3060
3
2
1
1
27
3
2110
2
1.5
0
0
37
3
2130
2
1.5
1
0
11
5
1650
2
1.5
1
1
30
2
348528 2740
241920 2240
4
3
1
1
27
5
2
1.5
0
1
34
5
Adjustable
6 631
1
Adjustable
7 630
1
Adjustable
3 626
0
Adjustable
5 626
1
Adjustable
6 624
1
Adjustable
1 623
0
Adjustable
8 618
1
Adjustable
3 618
1
Adjustable
7 614
0
Adjustable
6 614
1
Adjustable
7 613
0
Adjustable
3 609
1
Adjustable
1 609
0
Adjustable
3 605
1
Adjustable
1 604
0
Adjustable
6 601
1
Adjustable
8 599
1
Adjustable
8 596
1
Adjustable
6 595
1
Adjustable
2 595
0
Adjustable
3 593
0
Adjustable
6 591
1
Adjustable
8 591
1
Adjustable
7 590
1
Adjustable
3 584
1
Adjustable
8 583
1