QMS102 SPSS ASSIGNMENT #1 Fall 2015

QMS102 SPSS ASSIGNMENT #1 Fall 2015Due Date: Your project is due in Week 10 and it is due in class. There will bea penalty for submitting late.Marks: Each question is worth 5 marks with a total of 35 marks. (Note: There will be a1 mark penalty for every day late.)Group: You are allowed to work independently or in a group of two.You will analyze data that shows some details of a sample of 80 properties that haverecently been sold by a certain real estate company in the province of Alberta.Reports will be graded based upon the ability to present clear and correct results that demonstrate thatthey have learned the rules and techniques that they have been taught in the course. Questions 1 to 7below must be answered using one SPSS input data file. It may be necessary to add variables to theoriginal input data in order to answer the questions.As a minimum, your report must include the following:1. A title page that stresses the content of the report but also includes your name, student numberand course number.2. A brief introduction about what you are attempting to do in this report including a mention ofwhat data is being analyzed, what computer package is being used and what methods will beused.3. The answers to the questions.4. An appendix that includes your input data file as it appears when the project is finished.5. A table showing the variable properties, i.e. variable view.6. The original data sheets that were given to the group.Notes: 1. All statistical results in your report must have been created in an SPSS output file (i.e.do not import and edit in a word processor).2. No handwriting will be considered for marking purposes.The real estate data consists of 6 variables:X1 = LocationX2 = TypeX3 = List Price ($000’s),X4 = SizeX5 = Numbers of BedroomsX6 = Number of Bathrooms.Required:1. Input the data for variables x1 (Location), x2 (Type), x3 (List Price), x4 (Size), x5 (Beds)and x6 (Baths) into an SPSS data sheet. Use labeling techniques for x1 and x2,e.g. 0 = Calgary area, 1= Edmonton area, etc.2. For each variable, identify the type of data and measurement scales.3. Make a pie chart showing the percent of properties with 2, 3, 4 and 5 bedrooms.4. Make a clustered bar chart showing the number of properties that have 1, 1.5, 2, etc.bathrooms in each of the 3 locations.5. Using the type variable as a ‘split file’ variable:a) Make 3 histograms of the price data. Use ‘similar’ classes for each histogram.6. Using the location variable as a ‘split file’ variable:a) Make one table (edit by removing items not asked for) that shows only the mean,median, and 80th percentile of the size data for each of the 3 groups of data. Referto all 3 statistics and comment on which location has the largest house sizes.b) Make one table (edit by removing items not asked for) that shows only the standarddeviation and interquartile range of the size data for the 3 groups of data. Based oneach statistical measure, which region has the least amount of variability in housesize?7. Make a graph of multiple box-whisker plots of list price data for the different type oflocation. Based on observing the graphs only (no other calculations): which locationgenerally had the highest prices? Comment on the variability of each group of prices. Bespecific and concise with your comments. Are there any locations where a price isunusual?