to do excel and ppt

1010ApartmentDistrictResearchAssignment.xlsx

Home >Information Systems homework help >to do excel and ppt

Apartment Research Instructions

4-RENT Property Management Company -- Scenario 2. -There are 8 employee teams at 4-RENT Apartment Management Company. -Your company is nation-wide and offers bonuses based on occupancy rates. -The teams are competing for a trip to Hawaii (and a grade for the assignment). -You and your team are assigned the apartments in an area of town (called a district) to manage. -The purpose of your study is to provide your supervisor an analysis of your district. -Using Excel tools you learned as an undergraduate student at DU, create a Statistical Analysis. RUBRIC 1. Analyze the inventory of apartments or studios in your district, the rental revenue, and amenities offered in each district or neighborhood to explain your findings. 2. Compare your district to the other 4-RENT districts (samples) and to the company's entire inventory (population). 3. Focus on one or more HIGHLIGHTED properties for an analysis. 4. Every statistic and analysis from Collaborative Statistics, Chapters 1-4, is required for full credit. 5. Minimum for a C (75%): Box plot, pie chart, bar chart, histogram, standardized distribution, stacked bar, scatter plot, linear equation, trend line. 6. All of your work must show on your Excel spreadsheet. All spreadsheets must be 'live'. DELIVERABLE You will present your analysis to the managers following these strict instructions: -Turn in your excel spreadsheet with all of your charts and graphs and your Power Point as one group. -Between 3 and 6 Power Point slides -Between 3 and 3.5 minutes -This is a competition, teams will be graded in rank order and only one team MAY score 100% (BUT, the expectations are much higher this time). -The rest are graded based on the bar set by the top team. -May the best analysis win

Sample Data

Studio Rent Research Groups - Districts Near City Center					Studio Rent Research Groups -Neighborhoods 10 miles from City Center
	1 - Coffee Bars	2 - Pool Halls	3 - Speakeasies	4 - 02 Bars		5 - Lakes	6 -Beaches	7 - Shops	8 - Mountains
	Rents	Rents	Rents	Rents		Rents	Rents	Rents	Rents
1	400	350	350	400		250	329	500	250
2	400	350	350	450		300	329	500	250
3	400	389	350	450		300	329	650	250
4	400	388	350	450		300	329	650	250
5	400	389	350	450		300	329	650	250
6	410	399	350	450		300	329	650	250
7	410	399	350	450		300	329	650	250
8	410	399	355	450		300	365	650	250
9	410	399	355	460		300	365	700	250
10	425	399	355	460		300	365	700	300
11	425	410	355	460		305	365	700	300
12	425	410	360	460		305	365	700	300
13	425	410	360	460		305	365	700	300
14	425	410	378	460		305	365	700	300
15	425	410	378	460		305	365	700	300
16	435	410	389	460		305	365	725	300
17	435	410	388	460		305	365	725	300
18	435	410	389	460		305	389	725	300
19	435	415	399	460		305	389	725	300
20	435	415	399	480		305	389	750	300
21	435	415	399	480		305	389	750	350
22	435	415	399	480		305	389	750	350
23	435	415	399	480		310	389	750	350
24	435	415	410	500		310	389	750	350
25	435	415	410	500		310	389	750	350
26	465	415	410	500		310	389	750	350
27	465	425	415	500		310	389	750	350
28	465	425	415	500		310	389	775	350
29	465	425	415	500		310	389	775	400
30	465	425	415	500		315	389	775	400
31	465	425	425	510		318	389	775	400
32	465	435	425	510		318	389	780	400
33	465	435	425	510		318	390	780	400
34	479	435	435	510		318	390	780	400
35	479	452	435	510		318	390	780	400
36	479	452	435	510		318	390	780	400
37	479	452	435	510		322	390	795	400
38	479	452	435	510		325	390	795	350
39	479	455	435	520		325	390	795	350
40	500	455	435	520		325	401	800	375
41	500	455	435	520		325	401	800	375
42	500	455	435	520		325	401	800	375
43	500	462	452	530		325	401	800	375
44	500	462	452	530		325	401	800	375
45	534	462	452	530		325	401	850	375
46	534	462	452	540		327	401	850	375
47	534	462	455	540		327	405	850	375
48	549	462	455	540		327	405	850	375
49	549	462	455	540		327	405	850	375
50	549	462	455	540		327	405	850	375
51	549	462	462	540		327	405	850	375
52	549	462	462	540		327	405	950	375
53	549	468	462	540		330	479	950	379
54	555	468	462	550		330	479	950	379
55	555	468	462	550		330	479	975	379
56	555	468	462	550		330	479	975	379
57	555	468	463	550		330	479	975	579
58	555	479	463	550		333	479	975	579
59	576	479	463	550		333	499	985	579
60	576	479	463	560		333	499	985	579
61	576	479	463	560		333	499	985	579
62	576	500	464	560		333	499	995	579
63	576	500	464	560		333	499	995	579
64	576	500	464	560		333	499	995	579
65	576	500	464	560		333	499	995	579
66	576	500	464	560		333	499		579
67	589	534	465	570		333	599		579
68	599	534	465	570		333	599		629
69	599	534	465	570		333	599		629
70	599	549	465	570		338	599		629
71	599	549	465	570		602	599		629
72	599	549	465	570		602	599		629
73	599	549	465	570		610	599		629
74	599	549	465	580		610	599		629
75	599	549	466	580		610	599		629
76	599	555	466	580		610	599		679
77	599	555	466	580		610	599		679
78	599	555	466	580		610	599		679
79	610	555	466	590		610	650		679
80	610	555	466	600		612	650		779
81	610	561	466	600		612	650		779
82	610	561	466	600		612	650		779
83	610	561	466	600		612	650		779
84	610	561	467	600		612	750		779
85	650	561	467	600		615	750		779
86	650	561	467	600		615	750		779
87	650	566	467	610		615	750		799
88	650	566	467	610		615	750		799
89	660	566	467	610		615	750		799
90	660	566	467	610			750		799
91	660	566	467	610			999		799
92	660	566	468				999		799
93	675	599	468				1020		799
94	675		468				1021		1009
95	675		468				1022		1009
96	825		468						1009
97			550						1009
98			550						1109
99			550						1109
100			550						1109
									1109
									1109
									1109
									1109
									1109

Population Data

District	Inventory
1	400
1	400
1	400
1	400
1	400
1	410
1	410
1	410
1	410
1	425
1	425
1	425
1	425
1	425
1	425
1	435
1	435
1	435
1	435
1	435
1	435
1	435
1	435
1	435
1	435
1	465
1	465
1	465
1	465
1	465
1	465
1	465
1	465
1	479
1	479
1	479
1	479
1	479
1	479
1	500
1	500
1	500
1	500
1	500
1	534
1	534
1	534
1	549
1	549
1	549
1	549
1	549
1	549
1	555
1	555
1	555
1	555
1	555
1	576
1	576
1	576
1	576
1	576
1	576
1	576
1	576
1	589
1	599
1	599
1	599
1	599
1	599
1	599
1	599
1	599
1	599
1	599
1	599
1	610
1	610
1	610
1	610
1	610
1	610
1	650
1	650
1	650
1	650
1	660
1	660
1	660
1	660
1	675
1	675
1	675
1	825
2	350
2	350
2	389
2	388
2	389
2	399
2	399
2	399
2	399
2	399
2	410
2	410
2	410
2	410
2	410
2	410
2	410
2	410
2	415
2	415
2	415
2	415
2	415
2	415
2	415
2	415
2	425
2	425
2	425
2	425
2	425
2	435
2	435
2	435
2	452
2	452
2	452
2	452
2	455
2	455
2	455
2	455
2	462
2	462
2	462
2	462
2	462
2	462
2	462
2	462
2	462
2	462
2	468
2	468
2	468
2	468
2	468
2	479
2	479
2	479
2	479
2	500
2	500
2	500
2	500
2	500
2	534
2	534
2	534
2	549
2	549
2	549
2	549
2	549
2	549
2	555
2	555
2	555
2	555
2	555
2	561
2	561
2	561
2	561
2	561
2	561
2	566
2	566
2	566
2	566
2	566
2	566
2	599
3	350
3	350
3	350
3	350
3	350
3	350
3	350
3	355
3	355
3	355
3	355
3	360
3	360
3	378
3	378
3	389
3	388
3	389
3	399
3	399
3	399
3	399
3	399
3	410
3	410
3	410
3	415
3	415
3	415
3	415
3	425
3	425
3	425
3	435
3	435
3	435
3	435
3	435
3	435
3	435
3	435
3	435
3	452
3	452
3	452
3	452
3	455
3	455
3	455
3	455
3	462
3	462
3	462
3	462
3	462
3	462
3	463
3	463
3	463
3	463
3	463
3	464
3	464
3	464
3	464
3	464
3	465
3	465
3	465
3	465
3	465
3	465
3	465
3	465
3	466
3	466
3	466
3	466
3	466
3	466
3	466
3	466
3	466
3	467
3	467
3	467
3	467
3	467
3	467
3	467
3	467
3	468
3	468
3	468
3	468
3	468
3	550
3	550
3	550
3	550
4	400
4	450
4	450
4	450
4	450
4	450
4	450
4	450
4	460
4	460
4	460
4	460
4	460
4	460
4	460
4	460
4	460
4	460
4	460
4	480
4	480
4	480
4	480
4	500
4	500
4	500
4	500
4	500
4	500
4	500
4	510
4	510
4	510
4	510
4	510
4	510
4	510
4	510
4	520
4	520
4	520
4	520
4	530
4	530
4	530
4	540
4	540
4	540
4	540
4	540
4	540
4	540
4	540
4	550
4	550
4	550
4	550
4	550
4	550
4	560
4	560
4	560
4	560
4	560
4	560
4	560
4	570
4	570
4	570
4	570
4	570
4	570
4	570
4	580
4	580
4	580
4	580
4	580
4	590
4	600
4	600
4	600
4	600
4	600
4	600
4	600
4	610
4	610
4	610
4	610
4	610
5	250
5	300
5	300
5	300
5	300
5	300
5	300
5	300
5	300
5	300
5	305
5	305
5	305
5	305
5	305
5	305
5	305
5	305
5	305
5	305
5	305
5	305
5	310
5	310
5	310
5	310
5	310
5	310
5	310
5	315
5	318
5	318
5	318
5	318
5	318
5	318
5	322
5	325
5	325
5	325
5	325
5	325
5	325
5	325
5	325
5	327
5	327
5	327
5	327
5	327
5	327
5	327
5	330
5	330
5	330
5	330
5	330
5	333
5	333
5	333
5	333
5	333
5	333
5	333
5	333
5	333
5	333
5	333
5	333
5	338
5	602
5	602
5	610
5	610
5	610
5	610
5	610
5	610
5	610
5	612
5	612
5	612
5	612
5	612
5	615
5	615
5	615
5	615
5	615
6	329
6	329
6	329
6	329
6	329
6	329
6	329
6	365
6	365
6	365
6	365
6	365
6	365
6	365
6	365
6	365
6	365
6	389
6	389
6	389
6	389
6	389
6	389
6	389
6	389
6	389
6	389
6	389
6	389
6	389
6	389
6	389
6	390
6	390
6	390
6	390
6	390
6	390
6	390
6	401
6	401
6	401
6	401
6	401
6	401
6	401
6	405
6	405
6	405
6	405
6	405
6	405
6	479
6	479
6	479
6	479
6	479
6	479
6	499
6	499
6	499
6	499
6	499
6	499
6	499
6	499
6	599
6	599
6	599
6	599
6	599
6	599
6	599
6	599
6	599
6	599
6	599
6	599
6	650
6	650
6	650
6	650
6	650
6	750
6	750
6	750
6	750
6	750
6	750
6	750
6	999
6	999
6	1020
6	1021
6	1022
7	500
7	500
7	650
7	650
7	650
7	650
7	650
7	650
7	700
7	700
7	700
7	700
7	700
7	700
7	700
7	725
7	725
7	725
7	725
7	750
7	750
7	750
7	750
7	750
7	750
7	750
7	750
7	775
7	775
7	775
7	775
7	780
7	780
7	780
7	780
7	780
7	795
7	795
7	795
7	800
7	800
7	800
7	800
7	800
7	850
7	850
7	850
7	850
7	850
7	850
7	850
7	950
7	950
7	950
7	975
7	975
7	975
7	975
7	985
7	985
7	985
7	995
7	995
7	995
7	995
8	250
8	250
8	250
8	250
8	250
8	250
8	250
8	250
8	250
8	300
8	300
8	300
8	300
8	300
8	300
8	300
8	300
8	300
8	300
8	300
8	350
8	350
8	350
8	350
8	350
8	350
8	350
8	350
8	400
8	400
8	400
8	400
8	400
8	400
8	400
8	400
8	400
8	350
8	350
8	375
8	375
8	375
8	375
8	375
8	375
8	375
8	375
8	375
8	375
8	375
8	375
8	375
8	379
8	379
8	379
8	379
8	579
8	579
8	579
8	579
8	579
8	579
8	579
8	579
8	579
8	579
8	579
8	629
8	629
8	629
8	629
8	629
8	629
8	629
8	629
8	679
8	679
8	679
8	679
8	779
8	779
8	779
8	779
8	779
8	779
8	779
8	799
8	799
8	799
8	799
8	799
8	799
8	799
8	1009
8	1009
8	1009
8	1009
8	1109
8	1109
8	1109
8	1109
8	1109
8	1109
8	1109
8	1109

4-RENT Inventory

Studios and Apartments Managed by District

Inventory 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 400 400 400 400 400 410 410 410 410 425 425 425 425 425 425 435 435 435 435 435 435 435 435 435 435 465 46 5 465 465 465 465 465 465 479 479 479 479 479 479 500 500 500 500 500 534 534 534 549 549 549 549 549 549 555 555 555 555 555 576 576 576 576 576 576 576 576 589 599 599 599 599 599 599 599 599 599 599 599 610 610 610 610 610 610 650 650 650 650 660 660 660 660 675 675 675 825 350 350 389 388 389 399 399 399 399 399 410 410 410 410 410 410 410 410 415 415 415 415 415 415 415 415 425 425 425 425 425 435 435 435 452 452 452 452 455 455 455 455 462 462 462 462 462 462 462 462 462 462 468 468 468 468 468 479 479 479 479 500 500 500 500 500 534 534 534 549 549 549 549 549 549 555 555 555 555 555 561 561 561 561 561 561 566 566 566 566 566 566 599 350 350 350 350 350 350 350 355 355 355 355 360 360 378 378 389 388 389 399 399 399 399 399 410 410 410 415 415 415 415 425 425 425 435 435 435 435 435 435 435 435 435 452 452 452 452 455 455 455 455 462 462 462 462 462 462 463 463 463 463 463 464 464 464 464 464 465 465 465 465 465 465 465 465 466 466 466 466 466 466 466 466 466 467 467 467 467 467 467 467 467 468 468 468 468 468 550 550 550 550 400 450 450 450 450 450 450 450 460 460 460 460 460 460 460 460 460 460 460 480 480 480 480 500 500 500 500 500 500 500 510 510 510 510 510 510 510 510 520 520 520 520 530 530 530 540 540 540 540 540 540 540 540 550 550 550 550 550 550 560 560 560 560 560 560 560 570 570 570 570 570 570 570 580 580 580 580 580 590 600 600 600 600 600 600 600 610 610 610 610 610 250 300 300 300 300 300 300 300 300 300 305 305 305 305 305 305 305 305 305 305 305 305 310 310 310 310 310 310 310 315 318 318 318 318 318 318 322 325 325 325 325 325 325 325 325 327 327 327 327 327 327 327 330 330 330 330 330 333 333 333 333 333 333 333 333 333 333 333 333 338 602 602 610 610 610 610 610 610 610 612 612 612 612 612 615 615 615 615 615 329 329 329 329 329 329 329 365 365 365 365 365 365 365 365 365 365 389 389 389 389 389 389 389 389 389 389 389 389 389 389 389 390 390 390 390 390 390 390 401 401 401 401 401 401 401 405 405 405 405 405 405 479 479 479 479 479 479 499 499 499 499 499 499 499 499 599 599 599 599 599 599 599 599 599 599 599 599 650 650 650 650 650 750 750 750 750 750 750 750 999 999 1020 1021 1022 500 500 650 650 650 650 650 650 700 700 700 700 700 700 700 725 725 725 725 750 750 750 750 750 750 750 750 775 775 775 775 780 780 780 780 780 795 795 795 800 800 800 800 800 850 850 850 850 850 850 850 950 950 950 975 975 975 975 985 985 985 995 995 995 995 250 250 250 250 250 250 250 250 250 300 300 300 300 300 300 300 300 300 300 300 350 350 350 350 350 350 350 350 400 400 400 400 400 400 400 400 400 350 350 375 375 375 375 375 375 375 375 375 375 375 375 375 379 379 379 379 579 579 579 579 579 579 579 579 579 579 579 629 629 629 629 629 629 629 629 679 679 679 679 779 779 779 779 779 779 779 799 799 799 799 799 799 799 1009 1009 1009 1009 1109 1109 1109 1109 1109 1109 1109 1109

District

Monthly Rent

Names and Neighborhoods

Studio Rent Research Groups - Districts Near City Center
	1 - Coffee Bars	2 - Pool Halls	3 - Speakeasies	4 - 02 Bars
Studio Rent Research Groups - Neighborhoods 10 miles from City Center
	5 - Lakes	6 -Beaches	7 - Shops	8 - Mountains

1 - Coffee Bars2 - Pool Halls3 - Speakeasies4 - 02 Bars5 - Lakes6 -Beaches7 - Shops8 - Mountains