Assume that you are working as a business analyst for a construction company in the state of Victoria (a state in Australia). You are tasked with analysing a large dataset of property sales data. This file has been provided to you on iLearn. You are

BUSA6004 and Introduction to Inference,Modelling,and Forecasting, Session 1, 2025

AssessmentTask

Assignment1

Duedate

Friday11thApril,23:55pm

Weight(%)

20%

Taskdescription

IndividualAssignment

SubmissionMethod

Turn-It-In

Feedbackmechanism(s)

Detailedmarkingguide

Feedbackavailable (anticipated date)

2-3weeksaftersubmission

LinkstoUnitLearningOutcomes

ULO1,ULO2,ULO3

INTEGRITYMATTERS

Integritymattersathome,inyourworkplaceandhereatUniversity.Asa highly valued member of the Macquarie University Community, you carry great responsibility to uphold the good name of our institution. Our reputation is your reputation and will stay with you for life when your degree opens amazing opportunities for you.

IfyouareeverunsurewhetheryouractionsfallwithintheguidelinesofAcademic

Integrity,pleasedonthesitatetoreachout.ContacttheAcademicLiteraciesUnit oryour Tutor/Unit Convenor.

ASSESSMENTDESCRIPTION

Theassignmentquestionsappearattheendofthisdocument.

Skillsinfocusforthisassessment

  • Discipline Knowledge
  • Digital, Data, and Information Literacy
  • Critical Thinking and Problem Solving

ASSESSMENTINSTRUCTIONS

PleaseconvertyourWorddocumentinto aPDFbefore submission.

Pleasesubmityour Excelfile inthe separatelink thatis provided.

USEOFRESOURCESANDTECHNOLOGIESINCLUDINGGENERATIVEARTIFICIAL

INTELLIGENCE

For this assessment, students are not permitted to use GAITs, for any purpose, including summarising texts on the subject. Students may continue to use: spelling/grammar checkers, e.g., Microsoft spell-check, Grammarly.

EngagingwithGAITsforthisassessmentconstitutesabreachofacademicintegrityandbereported as plagiarism.

AcknowledgementStatementbystudents:IacknowledgethatIhavenotusedGAITs(e.g.,ChatGPT) in drafting and proofreading this assignment.

LATESUBMISSION

A maximum penalty of five percentage points of the total possible marks will be applied perdaytolatesubmissions,foruptoamaximumofsevencalendardays.Tasksthathave not been submitted within the maximum number of additional late days will receive a mark of zero, unless otherwise specified in the late penalties section of the Unit Guide.

Late submission for a task will only be permitted when specified in the unit guide. This provisiondoesnotapplytoonlineexamsorotherassessmentwithatime-limitoflessthan 24 hours.

Where an application for Special Consideration is approved and the outcome is an extension to the due date of a task, submissions that are received after the new due date will be subject to late penalties that are calculated from the new due date. This only applieswheretheoutcomeisanextensiontotheduedate seetheSpecialConsideration Policy for a schedule of all possible outcomes.

Assume that you are working as a business analyst for a construction company in the state of Victoria (a state in Australia). You are tasked with analysing a large dataset of property sales data. This file has been provided to you on iLearn.

You are to submit an Excel file and a Word file (converted to a PDF). We will only mark the PDF. The Excel file will only be looked at in exceptional circumstances such as suspicion of plagiarism and other possible violations of academic integrity.

You are strongly encouraged to submit your own work. Several students receivedzero grades fortheassignmentandfortheentireunitinprevioussemesters,duetocasesofplagiarism.

Thisquestionrelatestotheentiredataset.

Chooseoneofthefollowing3variables:DistancefromCity,LandSize,BuildingArea. Forthevariableofyourchoosing:

  • Provide numerical summaries of centred-ness and
  • Provide two graphical summaries where each of them showcases centred-ness and spread.

Thetwodotpointsbelowshouldbeansweredwithin100-200words:

  • What are some insights that you can draw from your summaries above?
  • What further steps would you take to provide more depth to these numerical and graphical summaries?

Thisquestionrelatestoafilteredversionofthedataset.

Chooseoneofthefollowing:PriceofUnits,PriceofHouses(youwillhavetosort/filteryour spreadsheet).

Forthevariableofyourchoosing:

  • Performastatisticaltesttotestwhetherthereisevidencethattheaveragepriceis greater than $1.2 million (for Houses) or the average price is greater than $0.7 million (forUnits).Inyourresponse,showallthestepsofahypothesis

Thetwodotpointsbelowshouldbeansweredwithin100-200words:

  • What are some insights that you can draw from your test above?
  • What further analysis would you conduct to provide more depth to this test?

Thisquestionrelatestotheentiredatasetthatis,makesureyouturnallfiltersoff.

Chooseanytwopairingsfromthefollowing:Price,DistancefromCity,LandSize,BuildingArea.

Foreachofthetwopairingsthatyouhavechosen:

  • Examine the graphical and numerical

Thetwodotpointsbelowshouldbeansweredwithin100-200words:

  • What are some insights that you can draw from your analysis above?
  • What further steps would you take to provide more depth to this correlation analysis?

Question4BusinessInsights(10Marks)

Yourresponsetothisquestionshouldbe175225words.

Suppose that you are a business analyst who is employed by a construction company. Analyse your findingsabove to provide business insights and strategic direction to your company as they formulate their medium-to-long-term business strategy. You can complementyouranalysiswithresearch;however,youmustrefertotheanalysisfromthis datasetinyouranswer.

Inansweringthisquestion,applytheinsightssharedbytheindustryguestpanelinourfirst lectureaboutusingdatatogainthebuy-inofstakeholdersandusingdatatotellastory.

Reminders

  • Please label your question numbers clearly in your
  • You do not need to copy the question in your Word
  • Please convert your Word document to a PDF before
  • Please remember that there will be a separate submission link for your Excel file and for your PDF file
Assume that you are working as a business analyst for a construction company in the state of Victoria (a state in Australia). You are tasked with analysing a large dataset of property sales data. This file has been provided to you on iLearn. You are
Scroll to top