record AgentPrice
Size
1 Marty
206424 1820
2 Rose
346150 3010
3 Carter
372360 3210
4 Peterson
310622 3330
5 Carter
496100 4510
6 Peterson
294086 3440
7 Carter
228810 2630
8 Isaacs
384420 4470
9 Peterson
416120 4040
10 Isaacs
487494 4380
11 Rose
448800 5280
Bedrooms
12 Peterson
388960 4420
13 Marty
335610 2970
14 Rose
276000 2300
15 Rose
346421 2970
16 Isaacs
453913 3660
17 Carter
376146 3290
18 Peterson
694430 5900
19 Rose
251269 2050
20 Rose
547596 4920
21 Marty
214910 1950
22 Rose
188799 1950
23 Carter
459950 4680
24 Isaacs
264160 2540
25 Carter
393557 3180
26 Isaacs
478675 4660
27 Carter
384020 4220
28 Marty
313200 3600
29 Isaacs
274482 2990
30 Marty
167962 1920
31 Isaacs
175823 1970
32 Isaacs
226498 2520
33 Carter
316827 3150
34 Carter
189984 1550
35 Marty
366350 3090
36 Isaacs
416160 4080
37 Isaacs
308000 3500
38 Rose
294357 2620
39 Carter
337144 2790
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
299730 2910
41 Rose
445740 4370
42 Rose
410592 4200
43 Peterson
667732 5570
44 Rose
523584 5050
45 Marty
336000 3360
46 Marty
202598 2270
47 Marty
326695 2830
48 Rose
321320 2770
49 Isaacs
246820 2870
50 Isaacs
546084 5910
51 Isaacs
793084 6800
52 Isaacs
174528 1600
53 Peterson
392554 3970
54 Peterson
263160 3060
55 Rose
237120 1900
56 Carter
225750 2150
57 Isaacs
848420 7190
58 Carter
371956 3110
59 Carter
404538 3290
60 Rose
250090 2810
61 Peterson
369978 3830
62 Peterson
209292 1630
63 Isaacs
190032 1850
64 Isaacs
216720 2520
65 Marty
323417 3220
66 Isaacs
316210 3070
67 Peterson
226054 2090
68 Marty
183920 2090
69 Rose
248400 2300
70 Isaacs
466560 5760
71 Rose
667212 6110
72 Peterson
362710 4370
73 Rose
265440 3160
74 Rose
706596 6600
75 Marty
293700 3300
76 Marty
199448 2330
77 Carter
369533 4230
78 Marty
230121 2030
79 Marty
169000 1690
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
190291 2040
81 Rose
393584 4660
82 Marty
363792 2860
83 Carter
360960 3840
84 Carter
310877 3180
85 Peterson
919480 7670
86 Carter
392904 3400
87 Carter
200928 1840
88 Carter
537900 4890
89 Rose
258120 2390
90 Carter
558342 6160
91 Marty
302720 3440
92 Isaacs
240115 2220
93 Carter
793656 6530
94 Peterson
218862 1930
95 Peterson
383081 3510
96 Marty
351520 3380
97 Peterson
841491 7030
98 Marty
336300 2850
99 Isaacs
312863 3750
100 Carter
275033 3060
101 Peterson
229990 2110
102 Isaacs
195257 2130
103 Marty
194238 1650
104 Peterson
348528 2740
105 Peterson
241920 2240
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
ooms
Baths
Pool (yes is 1)
2
1.5
1
3
2
0
4
3
0
3
2.5
1
6
4.5
0
4
3
1
4
2.5
0
5
3.5
0
5
3.5
0
6
4
1
6
4
0
4
3
0
3
2.5
0
2
1.5
0
4
3
1
6
4
1
5
3.5
1
5
3.5
1
3
2
1
6
4.5
1
2
1.5
1
2
1.5
1
4
3
1
3
2.5
0
4
3
1
5
3.5
1
5
3.5
0
4
3
0
3
2
1
2
1.5
1
2
1.5
1
4
3
1
4
3
1
2
1.5
1
3
2
1
)
4
3
0
4
3
0
4
3
1
4
3
1
3
2
0
4
3
0
4
3
1
5
3.5
1
6
4
1
3
2
0
3
2
1
3
2.5
1
3
2
0
4
3
0
6
4
1
8
5.5
1
2
1.5
1
4
3
1
3
2
0
2
1.5
1
2
1.5
1
6
4
0
5
3.5
1
5
3.5
1
4
3
0
4
2.5
1
2
1.5
1
2
1.5
1
3
2.5
0
4
3
1
3
2
0
2
1.5
1
3
2
0
3
2.5
1
5
3.5
0
6
4
1
4
2.5
0
5
3.5
1
7
5
1
3
2
0
2
1.5
1
4
3
1
2
1.5
1
2
1.5
0
2
1.5
1
4
3
1
3
2.5
1
6
4.5
0
3
2
1
8
5.5
1
3
2
1
2
1.5
1
6
4
0
3
2.5
0
6
4
1
4
2.5
0
2
1.5
1
7
5
1
2
1.5
1
3
2
1
3
2
0
6
4
1
3
2.5
0
6
4
1
3
2
1
2
1.5
0
2
1.5
1
2
1.5
1
4
3
1
2
1.5
0
Garage (Yes is 1) Days
1
33
0
36
1
21
0
26
1
13
1
31
1
39
1
26
1
26
1
32
1
35
1
50
1
25
0
34
1
17
1
12
1
28
1
36
1
38
1
37
0
20
0
52
1
31
1
40
1
54
1
26
1
23
1
31
0
37
1
31
0
28
1
28
1
22
0
22
1
23
1
25
1
37
1
15
1
19
0
31
1
19
1
27
1
29
1
19
0
32
0
28
0
30
1
23
1
27
1
35
1
27
0
39
1
30
1
26
0
14
1
27
1
49
1
29
1
24
1
18
1
27
0
18
1
30
0
2
1
22
0
30
1
28
0
30
1
50
1
42
1
21
1
24
1
22
1
40
0
14
1
25
1
32
0
21
0
20
1
31
1
34
1
48
1
32
1
40
1
30
0
40
1
36
1
23
1
23
1
24
1
38
0
39
1
53
0
58
1
27
1
35
1
50
0
28
1
12
1
27
0
37
0
11
1
30
1
27
1
34
Township
2
4
2
3
4
4
4
2
4
3
4
2
3
1
3
3
2
3
3
5
4
1
4
1
1
5
4
3
3
5
5
3
4
2
3
4
2
4
3
2
3
1
5
5
3
1
4
4
5
5
4
2
4
3
3
2
1
5
2
5
4
3
4
4
4
1
1
2
2
4
3
1
5
3
4
3
2
2
1
4
3
5
2
1
4
2
4
1
1
3
3
5
4
4
2
2
4
1
4
3
3
5
2
5
5
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.
Term Research Paper: Paper must be in APA style
Category
Purpose
Statement and
Model
Criteria
State why the dependent variable has been chosen for analysis
Identify the primary independent variable and defend why it is
important
Write the general form of the model
Define and defend all variables
State the Expectations for each independent variable
Addressed for each variable
Definition of
Variables
How is the variable defined in data source?
Which unit of measurement is used?
For independent variables, why does the variable determine
change in the dependent variable?
What sign is expected for the independent variable’s
coefficient, positive or negative and why?
Describe the data and identify the data sources
Identify which general sources and from which specific tables
Data Description are the data taken
Which year or years were the data collected
Are there any data limitations
Perform Multiple Linear Regression analysis on data, present
regression output and evaluate results (significance of
Presentation and Adjusted R-squared and independent variables)
Interpretation of Write the regression (prediction) equation
Results
Identify and interpret the adjusted R2 (one paragraph)
Discussion of the empirical results from the regression analysis
Use the proper format to list the works cited under two
headings:
Reference Page Research: a minimum of two sources
Data: a separate citation for each of the variables used in the
paper
