EXCEL REPORT: Predictive Analysis Report [ Regression Analysis, Logistic Regression, F-Statistic ]

Competencies

In this project, you will demonstrate your mastery of the following competencies:

• Apply predictive analysis methods to address a business problem
• Use data to forecast the future state of a business use case
• Integrate various visualizations to articulate data-driven narratives to both technical and nontechnical audiences

Scenario

You are a business analyst working for a management consulting firm. Your firm contracts you to work with different clients to understand their business problems and recommend data-based solutions. Your manager has asked you to choose one of the following client organizations for your next assignment. For either client, you will conduct a predictive analysis of historical data to help the client identify new business opportunities based on their noted business problem.

To complete the project, you will:

1. Select the client you will be working with for the project
2. Analyze the given historical data for your chosen client and their identified business opportunity
3. Select and apply an appropriate predictive model to forecast the data trends
4. Utilize results produced from the predictive analysis to determine any trends or patterns in the data
5. Create appropriate data visualizations to support your analysis and recommendations
6. Assess the model to determine whether it can used to support the client’s business strategy

Select CLIENT B – BOSTON REALTY CO. a client we look into to complete your project.

Client B: Boston Realty Co.
The CEO at Boston Realty Co. would like to determine sale prices for houses based on different factors. This information will help the organization’s realtors better guide their customers who are deciding to buy or sell a house. It will also help the company better understand the current real estate scenario in Boston and predict future home values. The CEO hopes your analysis will help Boston Realty Co. identify where to expand the business and secure additional office space.

Directions

Write an analysis report recommending a new business opportunity for your selected organization based on your predictive analysis of the corresponding dataset. Use your work from the project milestone to complete your report. Remember to address any feedback you may have received from your instructor in your milestone assignment.

Part One: Summary Report
For Part One, you will define the client’s business problem and explain what their historical data will enable you to predict. Using visualizations you create, you will analyze, select, and then perform the appropriate regression analysis for the given data.

1. Define the client’s business problem.
• Identify the independent and dependent variables
• How do they define the business problem? Explain.
• What can be predicted using these variables? Explain.
2. Explain the patterns in the data and create visualizations.
• Using the residuals and coefficients in the provided Excel file, create relevant visualizations and analyze their shape.
• Is the data grouped in any particular way, or is it randomly scattered?
• Are there any outliers? If so, what might they indicate?
• Explain whether the shape of the data is appropriate to verify normal distributions. Justify your reasoning.
• Calculate the standard deviation (sd), mean, median, quartile values for each variable.
• What do these values indicate about the business problem? Explain.
• Determine the presence of outliers within each variable using a visualization technique. Justify your choice of the visualization technique.
• Determine whether you should replace outliers with mean values. Justify your reasoning.
• How can we interpret the F-statistic and the residual sum of squares value for this model? Explain.
3. Perform a regression analysis.
• Apply and perform an appropriate regression model. Justify your reasoning for selecting the regression model you applied.
• Which of the variables provide the greatest response to the prediction?
• What does the responsiveness of the variables tell stakeholders? Explain.

Part Two: Apply Model and Make Recommendations
For Part Two, you will define how your algorithm’s performance will be assessed to determine its usefulness. You will then produce the prediction model forecast, assess its performance, and create various visualizations to identify and subsequently recommend a new business opportunity for your client. Lastly, you will explain how the recommended business opportunity addresses the business problem.

1. Define how the algorithm’s performance will be assessed to determine its usefulness.
• Choose an assessment type based on the algorithm selected. Justify your selection.
2. Produce the prediction model forecast.
• Identify the most appropriate model for predicting future business opportunities for the organization. Explain your reasoning.
• Show the residual output from the model and discuss how far the predicted variables are from the actual results.
3. Assess the prediction model’s performance
• Using the F-statistic, degrees of freedom, and residual sum of squares for the assessment, discuss how the model’s coefficients can be used to select the optimal independent variables for the model.
• Discuss further optimization or enhancement opportunities or methodologies that might be applicable to improving the model.
• How will further optimization or enhancement to the model help support decision-making for the client?
4. Create linear or logistical regression visualizations.
• Determine the key response indicator variables (KRIs) or independent variables.
• Include screenshots of the following visualizations:
• Create a bar chart of the coefficients for each independent variable.
• Create a line chart that shows the linear trend line.
• Analyze and interpret the trend line.
• What does the trend line tell you about the algorithm’s performance?
5. Determine if your analysis supports the business opportunity for the organization.
• Use the analysis and KRI information to either support or not support the business opportunity for the organization. Justify your recommendation with conclusions from your analysis.
• What aspects of your analysis support the identified business opportunity in your given scenario? Explain your reasoning.
• What aspects of your analysis do not support the identified business opportunity in your given scenario? Explain your reasoning.

What to Submit

To complete this project, you must submit the following:

Predictive Analysis Report
This should be a 3-to 5-page Word document, including any screenshots and visualizations. Sources should be cited according to APA style.

PROVIDE TURN IT IN REPORT AND AI VERIFICATION REPORT TO ENSURE CONTENT IS 100% ORIGINAL

Supporting Materials In The Attachments

The following resources support your work on the project:

Excel Workbook: Boston Realty Data Set

If you selected Client B, you would utilize this data set.

Word Document: Project Data Sets Description
Use this document to learn more about the variables in each data set.