MAT240 - Module 5 Assignment

Introduction

This tutorial guides you through the process of completing the Module 5 assignment for MAT240. The assignment involves creating a sample of house listings from the Pacific region, performing a hypothesis test on the data, and writing up your findings in a report. This step-by-step guide will ensure you understand each phase of the assignment, from data collection to report writing.

Step 1: Gather House Listings Data

• Determine the Sample Size: You need to create a sample of 750 house listings.

• Source the Data: Use reliable real estate websites or databases that provide listings in the Pacific region.

• Extract Relevant Information: Ensure to gather key details such as:

  • Price
  • Square footage
  • Number of bedrooms and bathrooms
  • Location (city or neighborhood)

• Organize the Data: Input your data into an Excel spreadsheet, structuring it with clear headers for each column.

Step 2: Prepare Your Data for Analysis

• Clean the Data: Check for any missing or inconsistent values and rectify them. This may involve:

  • Removing duplicates
  • Filling in missing values or deciding to exclude certain listings

• Descriptive Statistics: Calculate basic statistics for your dataset, such as:

  • Mean
  • Median
  • Standard deviation

• Use Excel functions like AVERAGE, MEDIAN, and STDEV to assist with calculations.

Step 3: Perform the Hypothesis Test

• State Your Hypotheses:

  • Null Hypothesis (H0): There is no significant difference in house prices.
  • Alternative Hypothesis (H1): There is a significant difference in house prices.

• Select the Test Type: Depending on the data distribution, choose between a t-test or a z-test.

• Conduct the Test in Excel:

  • Use the T.TEST function for t-tests or Z.TEST for z-tests.
  • Input your data ranges and significance level (commonly set at 0.05).

• Analyze Results: Determine the p-value and compare it to your significance level to decide whether to reject or fail to reject the null hypothesis.

Step 4: Write Your Report

• Follow the Assignment Template: Ensure your report aligns with the provided template.

• Include Key Sections:

  • Introduction: Briefly explain the purpose of your analysis.
  • Methodology: Describe how you gathered and analyzed the data.
  • Results: Present the findings of your hypothesis test, including the p-value and any relevant statistics.
  • Conclusion: Summarize your findings and their implications.

• Use Visuals: Incorporate charts or graphs from your Excel analysis to enhance the presentation of your data.

Conclusion

Completing the Module 5 assignment involves a systematic approach to data collection, analysis, and report writing. By following these steps, you can effectively create a comprehensive report on house listings from the Pacific region and gain valuable insights through hypothesis testing. After finalizing your report, ensure to proofread it for clarity and coherence before submission. Good luck!