Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

BUSA6004 – Introduction to Inference, Modelling, and Forecasting, Session 2, 2025

Assessment Task	Professional Practice: Business Inference, Modelling, and Forecasting Report
Due date	Week 9 – submitted during the tutorial Note: You have 70 marks worth of tasks in this document. The final 10 marks worth of tasks will be given during the Week 9 seminar. You are to complete all the tasks in this document before the Week 9 seminar, and we will give you class time to complete the final task. By the end of your Week 9 seminar, you will submit the entire report.
Weight (%)	40% (marked out of 80 marks, but worth 40% of your grade)
Task description	Individual Task
Submission Method	2 submissions: . Excel file (*.xls or *.xlsx file) . PDF file (*.pdf file) We will only mark the PDF. The Excel file will not be marked. However, not submitting the Excel file will mean that we will not mark your PDF. If you forget to include an item in your PDF file that is in your Excel file, it will not be marked.
Feedback mechanism(s)	Marking guide, Written comments, Cohort feedback
Feedback available (anticipated date)	2-3 weeks after submission
Links to Unit Learning Outcomes	ULO1: Identify and describe models of managing data. ULO2: Use quantitative research tools to assess the implications of strategic decisions from a whole of entity perspective and across a range of stakeholders. ULO3: Apply a range of research tools and models of business performance and productivity to measure and track sustainable value creation across organisational processes and projects.

ASSESSMENT DESCRIPTION

The task can be found at the end of this document.

Skills in focus for this assessment

• Digital Literacy

• Data and Information Literacy

ASSESSMENT INSTRUCTIONS

You will need to create two files – one Excel file and one PDF. There will be two submission links.

Please read each link’s description carefully and submit the correct file per link.

Failure to follow the submission guidelines below will result in the loss of marks.

• Submit your Excel file. This file will not be marked, however, you must submit this file.

• Submit a single PDF that you would like us to mark.

TIPS & FAQs

• You have to submit an Excel file and a single PDF.

• Follow the lectures and seminar content carefully.

• Follow iLearn for updates.

USE OF RESOURCES AND TECHNOLOGIES INCLUDING GENERATIVE ARTIFICIAL INTELLIGENCE (GAITs)

Green Zone: GAIT use permitted within academic integrity guide

If students use text produced by GAITs in their submission, it must be attributed appropriately by (a) being placed in quotation marks and (b) including an in-text citation and reference to the software used.

If the text is not attributed correctly, it constitutes a breach of academic integrity and be reported as plagiarism.

Acknowledgement Statement by students:

Please select one acknowledgement from the following (outside word count and outside the page count, first page or last page of PDF):

 I acknowledge that I have not used GAITs (e.g., ChatGPT) in drafting and proofreading this assignment.

 I acknowledge that I have only used GAITs (e.g., ChatGPT) in drafting and proofreading this assignment, which is permitted in the assignment instructions.

LATE SUBMISSION

A maximum penalty of five percentage points of the total possible marks will be applied per day to late submissions, for up to a maximum of seven calendar days. Tasks that have 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 provision does not apply to online exams or other assessment with a time-limit of less than 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 applies where the outcome is an extension to the due date – see the Special Consideration Policy for a schedule of all possible outcomes.

BUSA6004 Report, 2025 S2 (80 Marks, worth 40%)

Assume that you are working as a business analyst for a property developer in Sydney. You are tasked with analysing a large dataset of property sales data (available 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 not be marked. However, not submitting the Excel file will mean that we will not mark your 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 received zero grades for the assignment and for the entire unit in previous semesters, due to cases of plagiarism.

Question 1 – Data Cleaning (5 Marks)

There is a column called Sort ID. Use the filter button to only select the Sort ID that matches the last digit of your student ID. The rest of this question should be based on this filter. You should be looking at just 300 rows of data.

There are 5 cells which need to be cleaned. Explore your filtered data set to find the data that needs to be cleaned.

▪ In your Word file, write down contents of each of the 5 cells that needs to be cleaned, and note which column you found each cell in.

▪ In your Excel file, delete the entire row, if you find a cell that needs to be cleaned.

Question 2 – Research on Lookup Functions (5 Marks)

There is a column called Sort ID. Use the filter button to only select the Sort ID that matches the last digit of your student ID. The rest of this question should be based on this filter. You should be looking at just 295 rows of data (since you deleted 5 rows in Question 1).

Research how to use VLOOKUP and XLOOKUP. Using the sheet ‘Council Area’ and the functions: VLOOKUP and XLOOKUP, populate each of the columns Council Area 1 and Council Area 2 (in the main ‘Data’ sheet)– one for each Excel function. The answers should be the same across the two columns.

In your Word file – include the formula you used for the first cell in each column and annotate the formula so that the marker knows what cells and/or columns you are referring to.

Question 3 – Data Summary (10 Marks)

There is a column called Sort ID. Use the filter button to only select the Sort ID that matches the last digit of your student ID. The rest of this question should be based on this filter. You should be looking at just 295 rows of data.

For the variable, Price:

▪ Provide numerical summaries of centred-ness and spread.

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

The two dot points below should be answered within 100-200 words:

▪ 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?

Question 4 – Statistical Test (10 Marks)

Turn the Sort ID filter off. You should be looking at 2995 rows of data.

Choose one of the following Property Types: Apartment, House, Townhouse, Villa (you will have to turn on another filter in your spreadsheet).

For the variable of your choosing:

▪ Perform a statistical test to test whether there is evidence that the average price of the Property Type of your choosing is greater than $1.675 million.

▪ In your response, show all the steps of a hypothesis test.

The two dot points below should be answered within 100-200 words:

▪ 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?

Question 5 – Correlation Analysis (10 Marks)

Now select all Property Types but turn the Sort ID filter on according to the last digit of your Student ID. You should be looking at 295 rows of data.

Examine the correlation between Bedrooms and House Area.

▪ Examine the graphical and numerical correlation.

The two dot points below should be answered within 100-200 words:

▪ 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?

Question 6 – Regression (10 Marks)

Select all Property Types but turn the Sort ID filter on according to the last digit of your Student ID. You should be looking at 295 rows of data.

Construct a Regression Model based House Area, Bedrooms, and Bathrooms.

In your Word file include a screenshot of your regression results after you have professionally formatted your results in Excel.

In your Word file, provide the full regression equation of the model by using the variable names above – use professional formatting of your equation using the tools in Word.

Explain your coefficients, comment on the statistical significance of your regression results, and comment on the overall model.

Additionally, construct an appropriate Bubble Chart that represents all of the data. Make sure that you choose your axes carefully. Do not edit the minimum and maximum points of any axes. Include a screenshot of your Bubble Chart in your Word file.

Question 7 – Research Question (resources on iLearn) – Two-sample t-test (10 Marks)

Select all Property Types but turn the Sort ID filter on according to the last digit of your Student ID. You should be looking at 295 rows of data.

Research how to conduct a two-sample t-test in Excel.

Create a new sheet with 2 columns of data Apartment Prices and House Prices. You will have to filter your data to create these two new columns.

Conduct a two-sample t-test assuming unequal variances to test whether there is a significant difference between Apartment Prices and House Prices.

In your Word File, include screenshots of your output (professionally formatted in Excel), explain what you did, and explain and interpret your findings.

Question 8 – Research Question (resources on iLearn) – ANOVA (10 Marks)

Select all Property Types but turn the Sort ID filter on according to the last digit of your Student ID. You should be looking at 295 rows of data.

Research how to conduct a Single Factor (One Way) ANOVA in Excel.

Create a new sheet with 4 columns of data Apartment Prices, Townhouse Prices, House Prices, and Villa Prices. You will have to filter your data to create these four new columns.

Conduct a Single Factor (One Way) ANOVA to test whether there is a significant difference between the prices of these 4 categories.

In your Word File, include screenshots of your output (professionally formatted in Excel), explain what you did, and explain and interpret your findings.

Question 9 – In-class question/s (10 Marks)

During your seminar (tutorial) in Week 9, you will be given one additional question (that may have sub-parts) that you are to complete during the class. Complete the rest of this report before this class and leave space in your Word file to answer this last question. By the end of the seminar (tutorial) in Week 9, you will have completed this additional question, and you can submit the entire file after saving it as a PDF. You will submit the report during this class.