Attached is the first two phases.
Phase 3: Project Report and Excel Dashboard (15 Points)
The final part of the project consists of running the models in Excel, summarize the finding, report them, and provide your recommendations.
Phase 2 Deliverables
The final project deliverables consist of a report and Excel Spread Sheet
At the end of Week 8 of the course schedule, you need to provide a 4 pages maximum single space final project report. You need to provide a Final Project report that is composed of the following:
First, one page executive summary of your project reiterating your study, highlight the findings and provide recommendations.
Second, you will provide detailed results and specify the major findings. This including an individual discussion of the variables findings: which variables have the most impact in predicting your dependent variable? You will also discuss the overall significance of the model: the adjusted R-squared and the level of variance explained.
Finally, you close the report by providing your recommendations and highlight the relevance of your findings. You will also discuss these findings and provide explanations of your results. Keep in mind that you play the role of a consultant and you have to sell your hard work and its usefulness to your client.
Limited (0%-50%)
Satisfactory (50%-85%)
Superior (85%-100%)
Executive Summary (30%)
Missing or rudimentary executive summary.
Well-developed Executive summary.
Requires improvement in some components.
Well-developed Executive summary.
All components addressed.
Findings (40%)
Missing or rudimentary finding section.
Individual variable finding missing.
Overall model findings missing.
Well-developed finding report.
Requires improvement in some components.
Well Developed findings section.
All components addressed.
Recommendations and Conclusion
(30%)
Missing or rudimentary recommendations and conclusion section.
Well-developed recommendations and conclusion section.
Requires improvement in some components.
Well Developed recommendations and conclusion section.
All components addressed.
You are also required to submit an Excel Spreadsheet that contains all your calculations. The instructor will use the Excel Spreadsheet to go over your calculations and provide suggestions for improvement as needed.
