Calculate the descriptive statistics of z score

Assignment Help Basic Statistics
Reference no: EM132280418

Assignment: Descriptive statistics


Rental costs are significant part of the overall cost of a University education for many international students. The student union at a large city-based university is concerned about the affordability of reasonably priced student housing. They take a survey of one- bedroom accommodation within half an hour's travelling time to the campus. In the survey, data of the weekly rental cost (in dollars), and the location of the property were collected. The locations of properties are in two categories, "near" which contains properties which are in the same area, and "other" which are not in the same area of the university, but are within 30 minutes by public transportation.


Question 1

When student search for a rental property, it is useful to divide the properties into different categories according to the weekly rent as shown in the following table.

Intervals (dollars)



0 to 200



Over 200 to 250



Over 250 to 300



Over 300 to 350



Over 350



Find the frequencies and percentage associated with these 5 categories. Create a bar chart of the frequencies associated with these 5 categories and a pie chart of the percentage associated with these 5 categories. Briefly discuss the table and chart.

Question 2

Construct a histogram of the weekly rents. Briefly state what the histogram is telling us about the distribution of the weekly rent. To construct the histogram, you should obtain the frequency of the weekly rental cost for each category as shown in the table.



0 to50


Over 50 to 100


Over 100 to 150


Over 150 to 200


Over 200 to 250


Over 250 to 300


Over 300 to 350


Over 350 to 400


Over 400 to 450


Over 450


Question 3
Using excel to find the descriptive statistics for the weekly rents. Give your answers in this table to two decimal places.

Table Descriptive statistics of weekly rents



Standard Error






Standard Deviation


Sample Variance
















First quartile


Third quartile


Interquartile range


Coefficient of variation


Question 4
Briefly comment on the three measures of central tendency given in the table. Comment on the distribution of the weekly rent.

Question 5
Briefly comment on the four measures of variability given in the table.

Question 6
Calculate the z scores with excel function, and calculate the descriptive statistics of z score, comment on the mean and standard deviation of z score.

Question 7
Any value with Z score less than -3.0, or greater than +3.0 is classified as outliers. Identify the outlier in the dataset if there is any outlier? Compare the data analysis results with and results without outliers. Comment on the change of central tendency, variation, and the distribution.

Question 8
The weekly rent of property "near" and "other" could be quite different in many aspects. Therefore, the analyst decided to analyse the data separately for the properties "near" and "other"

Create histogram for both "near", and "other". Briefly state what the histogram is telling you about the shape of the two distributions.

Question 9
Calculate the descriptive statistics for both "near" and "other".

Question 10
Discuss and compare the central tendency and variation of the properties "near" and "other".

Attachment:- Assignment Data.rar

Verified Expert

Rent level of the rental property falls between $200 and $300 which indicates the most of the rental property has rent around $250 for the purpose.Near category has higher rent of the rented property than that of rental property in Other category.A measure of central tendency is higher in case of Near category than that in Other category.The variability in the case of Near category is higher than that in the case of Other category.

Reference no: EM132280418

Conduct the appropriate test and state your conclusions

A random sample of 21 employees with increased benefits yielded the following number of days spent off the job in one year: 5, 17, 1, 0, 2, 3, 1, 1, 5, 2, 7, 5, 0, 3, 3, 4,

Linear programming problem

Consider the following linear programming problem: A workshop of Peter's Potters makes vases and pitchers. Profit on a vase is $3.00; profit on a pitcher is $4.00. Each vase

What proportion of the population is excluded

The minimum height required for men to join the U.S. Army is 60 inches. What proportion of the population is excluded?- What proportion of the population is taller than Napole

Identify null hypothesis and alternative hypothesis

A skeptical paranormal researcher claims that the proportion of Americans that have seen a UFO is less than 1 in every one thousand. State the null hypothesis and the altern

Construct confidence interval has a normal distribution

Construct a 95% confidence interval for the population mean, μ. assume the population has a normal distribution. In a random sample of 26 computers.

Why you suspect distribution may be skewed to the right

Explain why you could estimate the probability that 100 people selected at random had worked for their employers an average of 10 years or more, but you could not estimate t

Can she claim that her school is different

She believed that year's students to be typical of those who will take AP Stats at that school and was pleased when 65% of her 54 students achieved scores of 3 or better. Ca

Probability that next week-s show will have thirty viewers

What is the probability that next week's show will: Have between 30 and 37 million viewers? (Round z-score computation to 2 decimal places and your final answer to 4 decimal



4/11/2019 4:12:22 AM

This assignment must be submitted using the Moodle assignment submission system. This assignment is marked out of 50 and is worth 10% of the total assessment. Each question is worth 5 marks. Copy and paste the relevant Excel tables, and graphs into a Word document. Ensure that all graphs and tables used are well labelled, including titles. The assignment is to be handed in as an electronic copy of the completed Word document or as a pdf document. Do not submit the Excel file in which you completed your working.

Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd