Reference no: EM134037201

Quantitative Analysis, Statistical Analysis Report

Task

You are completing an individual statistical analysis as part of your internship with the Department of Housing. Your manager reports directly to the Minister for Housing and has been asked to investigate changes in the affordability of student accommodation between 2019 and 2026.

You will be provided with two datasets containing mean weekly rental costs (including all utility bills) for studio apartments suitable for a single student in Australian capital cities. During the assessment, you will analyse the data supplied using statistical techniques studied throughout the subject and prepare a professional report for your manager.

Your report will require you to apply appropriate statistical methods to analyse and interpret the data, communicate your findings using clear statistical reasoning, and provide evidence-based conclusions and recommendations regarding changes in student rental affordability.

This is an individual, in-class assessment that must be completed within the allocated workshop time and submitted electronically via MyKBS before the end of the workshop.

Assessment Description

This assessment is designed to develop your ability to apply statistical concepts and techniques to a realistic business scenario. Drawing on the knowledge and skills developed throughout the first half of the subject, you will analyse quantitative data, interpret statistical results, and communicate evidence-based findings to support business decision-making.

Using the datasets provided, you will apply descriptive and inferential statistical techniques to investigate changes in student rental affordability across Australian capital cities between 2019 and 2026. Your analysis will require you to perform statistical calculations using Excel and/or manual methods where appropriate, interpret the results in the context of the business scenario, and evaluate the reliability of your findings.

Successful completion of this assessment requires both technical competence and statistical reasoning. In addition to producing accurate statistical analyses, you are expected to explain and justify your conclusions, communicate your findings clearly to a non-technical audience, and present your recommendations in the form of a professional report.

This assessment supports the development of the subject learning outcomes by providing opportunities to apply statistical methods to real-world business problems, interpret quantitative evidence, and communicate data-driven recommendations effectively.

Assessment Instructions

Assessment 2 is an individual, in-class assessment that must be completed during your Week 6 workshop. At the start of the workshop, your lecturer will release the Assessment 2 Details document via MyKBS. This document will contain the datasets, business scenario and questions that you are required to complete.

You will have three hours to complete the assessment and submit your work electronically via MyKBS before the end of the workshop. Any submission made outside the scheduled workshop will receive a mark of zero unless an approved extension or Special Consideration has been granted in accordance with Kaplan Business School policies.

Using the datasets provided, you will prepare a professional report for your manager. Depending on the business scenario provided, your report may require you to complete the following tasks:

Data Exploration and Descriptive Analysis

Summarise and describe the characteristics of the supplied datasets.

Calculate and interpret descriptive statistics using Excel and/or manual calculations where appropriate.

Present statistical information using appropriate tables, charts and graphical summaries.

Compare rental costs across the datasets and identify key trends and patterns.

Probability and Confidence Interval Analysis

Calculate probabilities using appropriate statistical techniques.

Construct and interpret confidence intervals.

Explain the practical meaning of statistical results within the context of the business scenario.

Comparative Statistical Analysis

Compare student rental affordability between 2019 and 2026 using appropriate statistical methods.

Evaluate similarities and differences between the datasets.

Assess the reliability of the available data and discuss any limitations.

Sampling and Data Quality

Identify potential sampling errors and sources of bias.

Evaluate how these factors may influence the validity and reliability of the analysis.

Discuss the implications of data quality when interpreting the results.

Business Interpretation and Recommendations

Interpret all statistical findings within the context of student accommodation affordability.

Draw evidence-based conclusions supported by the results of your analysis.

Present practical recommendations that address the needs of the Department of Housing.

Communicate your findings clearly and professionally for a non-technical audience.

Your report should demonstrate appropriate statistical reasoning, accurate calculations, effective use of Excel where required, and clear written communication using appropriate statistical terminology and notation.