BUGEN1502 Business Statistics-Percentage of Rental Properties
1. Using COUNTIF, construct a frequency distribution for the availability of rental properties. (Complete Table (a)).
2. Provide an appropriate chart showing the percentage of rental properties in each availability category.
3. Briefly summarise the information obtained in the above table and graph about the number of rental properties in each category.
The remaining questions are based on analysis of the similarities and differences in weekly rent for those properties which are within a five?minutes walk of public transport (labelled as Near) and properties which do not have easy access to public transport (labelled as Other).
4. Provide a table of summary stats for the weekly rents for each of the Two categories (Near and Other) (Table (d)). Give your answers in this table to two decimal places and make sure you indicate units.
5. Complete the grouped frequency table for the weekly rents for the two categories for the sample (Table (e)). Find frequency and hence calculate percentage frequency for the two categories.
6. Construct percentage frequency polygons of the weekly rents for each of the two categories of rental properties as one chart as Graph.
7. Comment on the shapes of the two distributions
8. Based on your answers to questions 4, 5 and 6, discuss and compare the central locations of the distributions for different categories of rental properties.
9. List the four measures of variability given in the table. The rents of which category of rental property show more variability.
10. Comment on any particular interesting and unusual features of the weekly rent distributions for the two categories of rental properties. What conclusions do you think the student union should draw about the affordability of student housing which has easily accessible public transport options to the university.
Answer:
llspacing="0" width="100%">
| (all tables should be formatted) | Frequency | Percentage Frequency | Cummulative Percentage Frequency | |||||
| Lower limit | Upper Limit | Midpoint | Near | Other | Near | Other | Near | Other |
| 10 | 50 | 30 | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.00 |
| 50 | 90 | 70 | 0 | 1 | 0.00 | 0.67 | 0.00 | 0.67 |
| 90 | 130 | 110 | 0 | 5 | 0.00 | 3.33 | 0.00 | 4.00 |
| 130 | 170 | 150 | 2 | 46 | 1.33 | 30.67 | 1.33 | 34.67 |
| 170 | 210 | 190 | 50 | 61 | 33.33 | 40.67 | 34.67 | 75.33 |
| 210 | 250 | 230 | 47 | 33 | 31.33 | 22.00 | 66.00 | 97.33 |
| 250 | 290 | 270 | 3 | 4 | 2.00 | 2.67 | 68.00 | 100.00 |
| 290 | 330 | 310 | 0 | 0 | 0.00 | 0.00 | 68.00 | 100.00 |
| 330 | 370 | 350 | 7 | 0 | 4.67 | 0.00 | 72.67 | 100.00 |
| 370 | 410 | 390 | 17 | 0 | 11.33 | 0.00 | 84.00 | 100.00 |
| 410 | 450 | 430 | 16 | 0 | 10.67 | 0.00 | 94.67 | 100.00 |
| 450 | 490 | 470 | 6 | 0 | 4.00 | 0.00 | 98.67 | 100.00 |
| 490 | 530 | 510 | 2 | 0 | 1.33 | 0.00 | 100.00 | 100.00 |
| 530 | 570 | 550 | 0 | 0 | 0.00 | 0.00 | 100.00 | 100.00 |
| TOTAL | 150 | 150 | ||||||
Buy BUGEN1502 Business Statistics-Percentage of Rental Properties Answers Online
Talk to our expert to get the help with BUGEN1502 Business Statistics-Percentage of Rental Properties Answers to complete your assessment on time and boost your grades now
The main aim/motive of the management assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignments. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at urgenthomework.com are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.
