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

How large a sample for central limit theorem

This result applies no matter what the shape of the probability distribution from which the samples are taken. Central Limit Theorem: How Large a Sample?

Test for the significance of the slope

Below you are given a partial computer output based on a sample of 21 observations, relating an independent variable (x) and a dependent variable (y).

Kinds of decision or actions are based on rankings

Nielsen publishes a weekly ranking of television programs as well as a weekly ranking of four major networks: ABC, CBS, NBC, and Fox. What kinds of decision or actions are ba

Null and directional hypothesis in research article

Find a research article and clearly define both the null and directional hypothesis that was or could have been tested during the statistical analysis of the data.

Compute value of the test statistic and the p-value

Determining whether or not the proportion of the population in favor of Candidate A is significantly more than 80%. The value of the test statistic and the p-value respectiv

Do you have statistical evidence that the new light differs

There are two ways to run the experiment. The first is to obtain a random sample of 12 drivers, divide them into two groups at random and assign one group to the standard ligh

Impact of campaign film on attitude toward political person

The impact of campaign film on attitudes toward a political candidate was investigated. Prior to showing the film, the attitudes of 15 people toward the candidate were asses

Compute the n mean standard deviation confidence interval

Compute (by hand) the N, Mean, Standard Deviation, Confidence Interval, and Z score for the variables "company market rate" and "accounting rate" respectively in the AccRet



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