Particulars • Due: Week 9, 8am, Thursday 18th January, 2018 • Marks: 30% • Words: 2,000 • Submission: Online to the MIS770 Assignment TWO drop box in CloudDeakin Email submissions will not be accepted • Note: This assignment is to be completed individually

Particulars
• Due: Week 9, 8am, Thursday 18th January, 2018
• Marks: 30%
• Words: 2,000
• Submission: Online to the MIS770 Assignment TWO drop box in CloudDeakin Email submissions will not be accepted
• Note: This assignment is to be completed individually
Assurance of Learning
This assignment assesses the following Graduate Learning Outcomes and related Unit Learning Outcomes:
Unit Learning Outcome (ULO)
Graduate Learning Outcome (GLO)
GLO4: Critical thinking: evaluating information using critical and analytical thinking and judgment
ULO4: Manipulate and summarise data that accurately represents real world problems
ULO4: Interpret and appraise statistical output to assist in real‐world decision making
Overview
The purpose of this assignment is to investigate a dataset which will enable you to answer questions posed in a Memorandum (see Memorandum section below). In order to answer the memorandum questions, you’ll need to analyse a given dataset, interpret the results, and then draw appropriate conclusions.
The aims of the assignment are to:
• provide you with some examples of the application of data analysis within an organisation
• test your understanding of the material in the relevant topics
• test your ability to analyse and interpret your results
• test your ability to effectively communicate the results of your analysis to others
Before attempting the assignment, make sure you have prepared yourself well. At a minimum, please read the relevant sections of the prescribed textbook and review the materials provided in Modules 1 and 2.
MIS770 – Analytical Skills Foundations Trimester 3, 2017
Assignment 2 – Kingfisher Bay House and Rental Prices
1 | P a g eP a g e P a g e
MIS770 Assignment Two T3, 2017 2 | P a g e
Scenario
You play the role of Sandy Stedwell who is the Manager of the Research and Analysis section at the Real Estate Institute of Victoria (REIV). Your role includes analysing a variety of housing data including house prices, affordability, investment returns, rental availability and rental returns. You are often required to report outcomes of your analysis to senior managers at the Institute who have little or no knowledge of data analysis.
Of specific interest to the REIV are the increasing house prices in Melbourne and potentially what this will mean for buyers yet to enter the market. A recent analysis, which received publicity in the media, showed that there were more Melbourne suburbs with a median house price of over $1 million, with this trend only set to continue as evidenced from recent auction and private sales figures.
Just recently, you have been working on a pilot survey from the City of Kingfisher Bay concerning house prices, rental costs and returns, as well as other related data. In light of the above, the REIV is very interested to see where the City of Kingfisher Bay, and more specifically its suburbs, is/are positioned when it comes to house prices and affordability.
Hannah Zhou, the Director of the Housing Affordability Division at the Real Estate Institute, has written to you regarding the Kingfisher Bay housing survey. Her memo to you is reproduced below:
Memorandum
Date: 14th December 2017
To: Sandy Stedwell, Manager, Research and Analysis, Real Estate Institute
From: Hannah Zhou, Director, Housing Affordability Division, Real Estate Institute
Subject: Analysis of Kingfisher Bay’s housing and rental data
Dear Sandy,
There were some recent media articles regarding the lack of available rental properties across Melbourne causing a significant increase in both house and rental prices. The City of Kingfisher Bay was highlighted as one of the most expensive areas in Melbourne to purchase or rent. The Kingfisher Bay Council is concerned about the focus and believes the claims are untrue. They have commissioned us to investigate both the house prices and the rental prices across the different suburbs that make up Kingfisher Bay.
From my initial meeting with the Kingfisher Bay Shire, five main questions were identified (see below). Can you please make use of the latest data we have collected on the Kingfisher Bay suburbs and provide a quick summary to each of the questions:
1. House prices in Kingfisher Bay
(a) Provide an overall summary of house prices in Kingfisher Bay.
(b) The media articles focus on median house prices and not the mean. I have never been able to understand why this is
so; surely the “average” is the “average”. Can you provide a straightforward answer for me?
(c) Provide an accurate estimate of the average house price for all houses in Kingfisher Bay.
(d) Likewise, what is the estimation of the proportion of all houses in Kingfisher Bay that are $1million and more?
2. House prices vs. condition/suburb
(a) If you can, please supply me with a brief summary on the condition of houses in Kingfisher Bay.
(b) Does there appear to be any differences
i. among the suburbs in terms of condition?
ii. in house prices by condition in Kingfisher Bay?
iii. in the house prices between the suburbs?
(c) From your completed analyses so far, can you determine whether suburb or condition has a bigger impact on house prices?
3. House prices vs. factors influencing house prices
(a) It is widely believed that higher house prices are being driven by those seeking good rental investments. Is there any basis to this belief?
(b) What are the key indicators of higher house prices?
MIS770 Assignment Two T3, 2017 3 | P a g e
4. Concerns raised by real estate agents and developers
I had a recent meeting with representatives from real estate companies and developers. During the meeting, these representatives made several claims that I am suspicious of and hence I would like you to investigate the claims listed below:
(a) They stated that the weekly rent in Kingfisher Bay is at least $600, and hence rated as the most unaffordable area to live in Melbourne metropolitan and surrounding suburbs. Is that true for all suburbs in Kingfisher Bay? Can you check this claim for each of the three suburbs in Kingfisher Bay?
(b) It was also mentioned that there was a lack of development across the Kingfisher Bay area as at least 75% of houses are 10 years or older. Can I disprove this claim and say that it is below 75%?
5. Future Surveys
Finally, I am interested in your opinion about future surveys for the purpose of comparisons and tracking house prices and rental availability. In particular, I want to be able to estimate the average house price to within $50,000 and the true proportion of vacant houses in the market to within 3%. Are you able to advise me on the required sample size that satisfies those criteria?
I look forward to your response, Signed, Hannah Zhou
Requirements
 Your report should be no longer than 2000 words and there is no need to include, Charts and Tables, or Appendices in the report
 Your Charts/Graphics and Tables are only to be placed in the Data Analysis file i.e. the Excel spreadsheet
 The report is to be written as a stand‐alone document (assume Hannah will only read your report). Thus, you should not have any references in the report to your data analysis output. Eg. “According to Table 1 in the analysis …”
 Your report must contain an executive summary that explains in plain language what the report is for and summarises the main findings. The executive summary should be no more than 2/3 page
 The body of your report must be set out in the same order as in the originating memorandum from Hannah, with each section (question) clearly marked
 Use plain language and your explanations succinct. Avoid the use of technical or statistical jargon as Hannah will not necessarily understand even simple statistical terms. As a guide to the meaning of “Plain Language”, imagine you are explaining your findings to a person without any statistical training (e.g. someone who has not studied this unit). What type of language would you use in this case?
 Marks will be lost if you use unexplained technical terms, irrelevant material, or have poor presentation/organization
 All Microsoft Excel data analysis output associated with each question in the Memorandum is to be placed in the corresponding tab in the yourstudentid.xlsx file
MIS770 Assignment Two T3, 2017 4 | P a g e
Data Analysis Instructions/Guidelines
 In order to prepare a reply to Hannah’s memorandum, you will need to examine and analyse the dataset
Kingfisher Bay 2017.xlsx thoroughly.
 Hannah has asked a number of questions and your Data Analysis output (i.e. your charts, tables, graphs etc.) should be structured such that each question is answered on the separate tab/worksheet provided in your Excel document. There are also extra tabs in Kingfisher Bay 2017.xlsx called CI, SampleSize and HT and you should use the various templates contained in these tabs in your “Confidence Interval”, “Sample size” and “Hypothesis” answers.
 In order to effectively answer the questions, your Data Analysis output needs to be appropriate. Accordingly, you’ll need to establish which of the following techniques are applicable for each question:
o Summary Measures (e.g. Descriptive Statistics, Inc. Outlier detection)
o Comparative Summary Measures (i.e. Descriptive Statistics for multiple levels of a variable)
o Suitable tables and charts or graphics (Module 1) that will illustrate more clearly, other important features of a variable
o Scatter diagrams, Correlation analysis and Cross Tabulations (sometimes called Contingency Tables), used to establish the relationships (dependencies) between two variables (see Additional Materials under Topic 3 – creating Cross Tabulations in Excel using Pivot Tables)
o Confidence Intervals: You can assume that a 95% confidence level is appropriate. We use Confidence Intervals when we have no idea about the population parameter we are investigating. Additionally, we would use Confidence Intervals if we are asked to provide an estimate of a population parameter. You can use the relevant Excel template provided in the dataset and copy to the applicable question tab
o Hypothesis Tests: You can assume that a 5% level of significance is appropriate. We Use Hypothesis Tests when we are testing a Claim, a Theory or a Standard. You can use the relevant Excel template provided in the dataset and then copy to the applicable question tab
Note: There is an Appendix at the end of each Chapter of the Prescribed Textbook which describes the basic Excel steps associated with that Topic. Chapters 1 to 9 are applicable for this assessment.
Submission
Your completed assignment should be in two separate files:
 Data Analysis (Part A): An Excel document containing separate tabs/ worksheets with charts/ tables/ graphs for each question
 Report (Part B): A Word document of no more than 2000 words which is not to contain any charts/ tables/ graphs
 All interpretations should be presented in your “Report” and the excel document should only contain your intermediate
analysis and final output
The assignment is to be submitted to the MIS770 assignment two dropbox in Deakin’s Cloud Campus before 8am on Thursday 18th January 2018. Note: The Cloud Unit site is the ONLY method of submission acceptable.
Please name/rename each file using the format: yourstudentid.docx and yourstudentid.xlsx
When you are required to submit an assignment through your CloudDeakin unit site, you will receive an email to your Deakin email address confirming that it has been submitted. You should check that you can see your assignment in the Submissions view of the Assignment dropbox folder after upload, and check for, and keep, the email receipt for the submission.
If you need to request an extension, please email the Unit Chair (lasitha@deakin.edu.au) by no later than Monday 15th January 2018. You will need to provide a valid reason together with supporting documentation (e.g. doctors’ certificate, etc.) as well as the work completed to date.
Notes:
Penalties for late submission: The following marking penalties will apply if you submit an assessment task after the due date without an approved extension:
 5% will be deducted from available marks for each day up to five days, and work that is submitted more than five days after the due date will not be marked. You will receive 0% for the task. ‘Day’ means working day for paper submissions and calendar day for electronic submissions.
 The Unit Chair may refuse to accept a late submission where it is unreasonable or impracticable to assess the task after the due date.
 For more information about academic misconduct, special consideration, extensions, and assessment feedback, please refer to the document “Your rights and responsibilities as a student in this Unit” in the first folder next to the Unit Guide of the Resources area in the CloudDeakin unit site.
MIS770 Assignment Two T3, 2017 5 | P a g e
Building evidence of your experiences, skills and knowledge (Portfolio)‐ Building a portfolio that evidences your skills, knowledge and experience will provide you with a valuable tool to help you prepare for interviews and to showcase to potential employers. There are a number of tools that you can use to build a portfolio. You are provided with cloud space through OneDrive, or through the Portfolio tool in the Cloud Unit Site, but you can use any storage repository system that you like.
Remember that a Portfolio is YOUR tool. You should be able to store your assessment work, reflections, achievements and artefacts in YOUR Portfolio. Once you have completed this assessment piece, add it to your personal Portfolio to use and showcase your learning later, when applying for jobs, or further studies. Curate your work by adding meaningful tags to your artefacts that describe what the artefact represents.
Supporting Materials
You will find the data in the file called Kingfisher Bay 2017.xlsx, on CloudDeakin for download.
Please ensure you read the relevant sheets in that file. In particular, ensure you read the sheets called “Kingfisher Bay – Background” and “Variable Descriptions”. Save a copy for your assignment purposes. Also ensure you read the information which follows.
Marking Rubric
Poor
Needs Improvement
Satisfactory
Good
Very Good
Exemplary
Executive summary
(Marks: 10)
0 points
Does not communicate any of the main findings of the analysis in an accurate or useful way, or the findings are basic.
0 – 2.4 Marks
2.5 points
Explains some of the main findings of the analysis accurately and enables reader to draw a few reasonable conclusions.
2.5 ‐ 4.9 Marks
5 points
Explains most of the main findings of the analysis accurately and enables reader to draw some reasonable conclusions.
5 ‐ 5.9 Marks
6 points
Explains nearly all of the main findings of the analysis accurately and enables reader to draw
mostly reasonable conclusions.
6 ‐ 6.9 Marks
7 points
Provides detailed and accurate descriptions of the most important features of the analysis
along with appropriately qualified conclusions.
7 ‐ 7.9 Marks
10 points
Provides an outstanding descriptions and conclusions that is carefully considered and insightful.
8 ‐ 10 Marks
Data Analysis and Graphics (Marks: 40)
0 points
Uses irrelevant or inappropriate techniques to analyse the data, or Data analysis and visualisation tools have been used to analyse the data but in an incomplete or inaccurate manner.
A very poor presentation of the analysis, or the analysis does not follow principles of good graphical display.
0 – 9.4 Marks
9.5 points
Uses some appropriate data analysis and visualisation tools to analyse the data but there are many errors in the analysis.
The presentation of the analysis needs improvement.
9.5 – 19.9 Marks
20 points
Uses appropriate data analysis and visualisation tools to analyse the data but there are several errors in the analysis.
The presentation of the analysis is satisfactory.
20 – 23.9 Marks
24 points
Uses appropriate data analysis and visualisation tools to analyse the data but there are some errors in the analysis.
The presentation of the analysis is of a
respectable standard.
24 – 27.9 Marks
28 points
Comprehensive analysis of the data using appropriate
techniques, but there are some minor errors in
the analysis.
Uses data visualisations to understand the patterns in data.
The analysis is well organised and follows principles of good graphical display.
28 – 31.9 Marks
40 points
Skilful and comprehensive analysis of data using many different techniques.
Uses data visualisations to produce novel insights.
An exemplary presentation of the analysis.
32 – 40 Marks
Interpreting Results and Communication
(Marks: 40)
0 points
Does not communicate any of the main findings of the analysis in an accurate and/or useful way, or the interpretation and communication of
findings is at a basic level.
The written communication is unprofessional or difficult to follow and contains numerous spelling or grammatical errors.
0 – 9.4 Marks
9.5 points
Explains some of the main findings of the analysis accurately which only enables the reader to draw a few reasonable conclusions.
The written communication is not very easy to follow and/or it contains too many errors.
9.5 – 19.9 Marks
20 points
Explains most of the main findings of the analysis accurately and enables the
reader to draw some reasonable conclusions.
The written communication is
clear and easy to follow but it
contains minor spelling or
grammatical errors. 20 – 23.9 Marks
24 points
Explains nearly all of the main findings of the
analysis
accurately and enables the reader to draw mostly reasonable conclusions.
The written communication is clear and easy to
follow and generally free of spelling or grammatical errors.
24 – 27.9 Marks
28 points
Provides detailed and accurate descriptions of the most important features of the analysis along with appropriately qualified conclusions.
The written communication is professional, easy to follow and has a good structure.
28 – 31.9 Marks
40 points
Provides an outstanding descriptions and conclusions that is carefully considered and insightful.
The written communication is truly professional, logical and easy to follow.
32 ‐ 40 Marks
Overall Assignment Presentation
(Marks: 10)
0 points
A very poor presentation of the analysis or it is mostly disorganised.
The report is un‐ professional, difficult to follow and/or contains numerous spelling or grammatical errors.
0 – 2.4 Marks
2.5 points
Little attempt has been made to follow the assignment Requirements/ Instructions/ Guidelines.
Unsatisfactorily presented
2.5 – 4.9 Marks
5 point
The presentation of the analysis is satisfactory.
The report is clear and easy to follow but it
contains minor spelling or
grammatical errors.
5 ‐5.9 Marks
6 points
The presentation of the analysis is of a
respectable standard.
The report is clear and easy to follow and generally free of spelling or grammatical errors.
6 ‐6.9 Marks
7 points
The analysis is well organised and follows principles of good graphical display.
The report is professional, easy to follow with good structure.
7 ‐7.9 Marks
10 points
An exemplary presentation of the analysis.
The report is truly professional, logical and easy to follow.
8 ‐ 10 Marks

发表评论

%d 博主赞过: