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