(solution) Stay a While Longer – Apartments Search Unit # Unit

(solution) Stay a While Longer – Apartments Search Unit # Unit

Could you also be willing to help with these two assignments as well.  I have attached both of them.  There is a week three lab and a week 5 lab.

Stay a While Longer – Apartments Search
Unit # Unit #
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1201
1202
1203
1204
1205
1206
1207
1208
1209
1210
1301
1302
1303
1304
1305
1306
1307
1308
1401
1402
1403
1404
1405
1406
1407
1408
1501
1502
1503
1504
1505
1506 Rental Price Apartment Complex # Bed
Turning Leaf Circle
1
Turning Leaf Circle
1
Turning Leaf Circle
2
Turning Leaf Circle
2
Turning Leaf Circle
3
Turning Leaf Circle
3
Turning Leaf Circle
2
Turning Leaf Circle
2
Turning Leaf Circle
3
Turning Leaf Circle
3
Turning Leaf Circle
1
Turning Leaf Circle
1
Turning Leaf Circle
2
Turning Leaf Circle
2
Turning Leaf Circle
3
Turning Leaf Circle
3
Turning Leaf Circle
2
Turning Leaf Circle
2
Turning Leaf Circle
3
Turning Leaf Circle
3
Piedra Springs
1
Piedra Springs
1
Piedra Springs
1
Piedra Springs
1
Piedra Springs
2
Piedra Springs
2
Piedra Springs
2
Piedra Springs
2
Eagles Domain Road
1
Eagles Domain Road
2
Eagles Domain Road
3
Eagles Domain Road
1
Eagles Domain Road
2
Eagles Domain Road
3
Eagles Domain Road
2
Eagles Domain Road
2
Hickory Ridge Villas
1
Hickory Ridge Villas
1
Hickory Ridge Villas
1
Hickory Ridge Villas
1
Hickory Ridge Villas
2
Hickory Ridge Villas
2 Rental Price Occupied
$
765.00
Yes
$
765.00
Yes
$
895.00
No
$
895.00
Yes
$ 1,225.00
No
$ 1,225.00
Yes
$
895.00
No
$
895.00
Yes
$ 1,225.00
No
$ 1,225.00
Yes
$
775.00
Yes
$
775.00
Yes
$
875.00
Yes
$
875.00
No
$ 1,050.00
Yes
$ 1,050.00
No
$
875.00
Yes
$
875.00
Yes
$ 1,050.00
No
$ 1,050.00
Yes
$
875.00
No
$
875.00
No
$
900.00
No
$
900.00
Yes
$ 1,355.00
No
$ 1,355.00
Yes
$ 1,355.00
Yes
$ 1,355.00
No
$
875.00
No
$
950.00
No
$ 1,355.00
Yes
$
875.00
No
$
950.00
Yes
$ 1,355.00
No
$
975.00
Yes
$
975.00
Yes
$
550.00
Yes
$
550.00
No
$
550.00
No
$
550.00
Yes
$
850.00
No
$
850.00
Yes Last Remodel
2005
2003
1999
2005
2007
2005
2005
2009
2008
2009
2011
2010
2011
2011
2005
2005
2000
2000
2005
2005
2008
2001
2001
2001
2005
2005
2011
2011
2005
2011
2011
2011
2011
2002
2002
2002
2011
2011
2003
2001
2003
2011 Pet Deposit 1507
1601
1602
1603
1604
1605
1606
1607 Hickory Ridge Villas
Cypress Trail
Cypress Trail
Cypress Trail
Cypress Trail
Cypress Trail
Cypress Trail
Cypress Trail 2
1
1
2
2
3
3
3 $
$
$
$
$
$
$
$ 850.00
1,225.00
1,225.00
1,355.00
1,355.00
1,675.00
1,695.00
1,710.00 No
Yes
Yes
No
Yes
No
Yes
No 2011
2005
2005
2005
2011
2011
2005
2005 Recommendation Criteria Range Unit # Development # Bed Rental Price Occupied Database Statistics No. of Apts. to Remodel
Value of Lost Rent
Year of Oldest Remodel Advanced Filter based on Criteria Range Unit # Development
1101 Turning Leaf Circle
1102 Turning Leaf Circle
1103 Turning Leaf Circle
1104 Turning Leaf Circle
1105 Turning Leaf Circle
1106 Turning Leaf Circle
1107 Turning Leaf Circle
1108 Turning Leaf Circle
1109 Turning Leaf Circle
1110 Turning Leaf Circle
1201 Turning Leaf Circle
1202 Turning Leaf Circle
1203 Turning Leaf Circle
1204 Turning Leaf Circle
1205 Turning Leaf Circle
1206 Turning Leaf Circle
1207 Turning Leaf Circle
1208 Turning Leaf Circle
1209 Turning Leaf Circle
1210 Turning Leaf Circle
1301 Piedra Springs
1302 Piedra Springs
1303 Piedra Springs
1304 Piedra Springs
1305 Piedra Springs
1306 Piedra Springs
1307 Piedra Springs
1308 Piedra Springs
1401 Eagles Domain Road
1402 Eagles Domain Road
1403 Eagles Domain Road
1404 Eagles Domain Road
1405 Eagles Domain Road # Bed Rental Price Occupied
1
765 Yes
1
765 Yes
2
895 No
2
895 Yes
3
1225 No
3
1225 Yes
2
895 No
2
895 Yes
3
1225 No
3
1225 Yes
1
775 Yes
1
775 Yes
2
875 Yes
2
875 No
3
1050 Yes
3
1050 No
2
875 Yes
2
875 Yes
3
1050 No
3
1050 Yes
1
875 No
1
875 No
1
900 No
1
900 Yes
2
1355 No
2
1355 Yes
2
1355 Yes
2
1355 No
1
875 No
2
950 No
3
1355 Yes
1
875 No
2
950 Yes 1406 Eagles Domain Road
1407 Eagles Domain Road
1408 Eagles Domain Road
1501 Hickory Ridge Villas
1502 Hickory Ridge Villas
1503 Hickory Ridge Villas
1504 Hickory Ridge Villas
1505 Hickory Ridge Villas
1506 Hickory Ridge Villas
1507 Hickory Ridge Villas
1601 Cypress Trail
1602 Cypress Trail
1603 Cypress Trail
1604 Cypress Trail
1605 Cypress Trail
1606 Cypress Trail
1607 Cypress Trail 3
2
2
1
1
1
1
2
2
2
1
1
2
2
3
3
3 1355 No
975 Yes
975 Yes
550 Yes
550 No
550 No
550 Yes
850 No
850 Yes
850 No
1225 Yes
1225 Yes
1355 No
1355 Yes
1675 No
1695 Yes
1710 No Last Remodel Pet Depost Recommendation Last Remodel Pet Deposit
2005
2003
1999
2005
2007
2005
2005
2009
2008
2009
2011
2010
2011
2011
2005
2005
2000
2000
2005
2005
2008
2001
2001
2001
2005
2005
2011
2011
2005
2011
2011
2011
2011 Recommendation
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0 0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0 2002
2002
2002
2011
2011
2003
2001
2003
2011
2011
2005
2005
2005
2011
2011
2005
2005 0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0 0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0 Input Area
Complex Cost
Down Payment
# of Pmts per Year
Years
APR
1st Payment Date Payment # Summary Calculations
Loan Amount
No. Periods
Monthly Rate
Monthly Payment
Total Interest Paid Payment Date Beginning Balance Interest Paid Principal Payment Ending Balance Employee Statistics
ID Number Position
10474 Key Account Manager
11025 Sales Representative
11062 Key Account Manager
11653 Administrative Assistant
14731 Key Account Manager
14869 Support Specialist
15039 Support Specialist
15190 Sales Representative
16015 Sales & Marketing Director
16034 Budget Manager
16754 Sales Representative
18283 Support Specialist
22923 Key Account Manager
24168 Sales & Marketing Director
25280 Manager
27427 Budget Manager
30047 Administrative Assistant
30836 Sales & Marketing Director
31615 Administrative Assistant
33143 Key Account Manager
34737 Support Specialist
36528 Key Account Manager
37828 Sales Representative
38088 Support Specialist
38180 Sales Representative
39483 Support Specialist
39692 Budget Manager
42434 Support Specialist
42694 Budget Manager
43987 Key Account Manager
45418 Manager
45849 Support Specialist
46521 Budget Manager
47711 Manager
49542 Sales & Marketing Director Salary Job Satisfaction
35855
41708
47572
30176
45883
32650
32750
45670
89900
55389
49617
35230
44854
77846
70125
62263
30982
84937
32709
45983
33501
48706
45927
31632
49575
37404
65492
35316
68365
41130
72862
30701
66009
74767
97159 Salary Rank
3
2
3
4
4
1
3
5
4
2
3
3
2
3
3
4
2
4
4
5
1
5
2
5
3
4
3
2
2
4
3
5
2
4
5 Summary Information
Position
Administrative Assistant
Budget Manager
Sales & Marketing Director
Key Account Manager
Manager
Sales Representative
Support Specialist Average Satisfaction Sales & Marketing Directors with >= 4 Satisfaction
Count
Average Salary
Managers with >= 4 Satisfaction
Count
Average Salary
Quartile
1
2
3
4
Correlation Average Salary