Files and Resources:
All related files for the Final Project are available in the Modules → Final Project Folder on Canvas.You will find a ZIP folder that includes:
Two datasets:
House Price Data
Basketball Season Wins Data
A Final Project Summary Report Template
After unzipping the folder, review the files and choose one dataset to complete your project. The template is based on the House Price dataset, so if you select the Basketball dataset, simply adjust variable names as needed.
Please read each instruction in the provided Summary Report Template carefully to ensure you meet all project requirements.
Competency:
This project demonstrates your ability to:Perform regression analysis to address an authentic, real-world problem.
Scenario:
Imagine you are a data analyst for a real estate company tasked with predicting house prices using various attributes provided in the dataset. You will use Excel Data Analysis Tools to conduct statistical analyses and develop regression models to support data-driven decision-making.
If you choose the basketball dataset, your goal will be to predict team wins based on team performance metrics. Regardless of the dataset, your report should explain findings in a way that non-technical stakeholders can easily understand.
Directions:
For this project, you must submit two components:
Excel File (workbook) – Your working file containing all statistical analyses and results.
Summary Report – A 5–7 page document prepared using the provided template, explaining your findings and interpretations.
Please make sure your report:
Includes all required sections from the template.
Uses 12-point Times New Roman, double spacing, and 1-inch margins.
Contains APA-style citations for any external sources used.
Is submitted as a Word document or PDF.
Submission Checklist:
Excel file with all analysis steps and outputs Final Project Summary Report (Word or PDF format)
Important Notes:
The datasets have been cleaned for this assignment.
Choose only one dataset to complete your project. (!!!! I ALREADY DID THE EXCEL FILE, ONLY NEED TO DO SUMMARY REPORT)