{"id":31265,"date":"2023-08-20T16:10:04","date_gmt":"2023-08-20T16:10:04","guid":{"rendered":"https:\/\/www.goodacademic.com\/blog\/questions\/excel-report-predictive-analysis-report-regression-analysis-logistic-regression-f-statistic\/"},"modified":"2023-08-20T16:10:04","modified_gmt":"2023-08-20T16:10:04","slug":"excel-report-predictive-analysis-report-regression-analysis-logistic-regression-f-statistic","status":"publish","type":"questions","link":"https:\/\/www.goodacademic.com\/blog\/questions\/excel-report-predictive-analysis-report-regression-analysis-logistic-regression-f-statistic\/","title":{"rendered":"EXCEL REPORT: Predictive Analysis Report [ Regression Analysis, Logistic Regression, F-Statistic ]"},"content":{"rendered":"<h2 style=\"margin-top: 30px; font-size: 1.5rem; line-height: 1.8rem; cursor: auto;\">Competencies<\/h2>\n<p style=\"margin-bottom: 1rem; font-size: 19px; line-height: 28px; cursor: auto; color: inherit;\">In this project, you will demonstrate your mastery of the following competencies:<\/p>\n<ul style=\"margin-left: 10px; margin-bottom: 1rem; padding-bottom: 10px; padding-left: 20px; font-size: 19px; line-height: 28px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">Apply predictive analysis methods to address a business problem<\/li>\n<li style=\"cursor: auto; color: inherit;\">Use data to forecast the future state of a business use case<\/li>\n<li style=\"cursor: auto; color: inherit;\">Integrate various visualizations to articulate data-driven narratives to both technical and nontechnical audiences<\/li>\n<\/ul>\n<h2 style=\"margin-top: 30px; font-size: 1.5rem; line-height: 1.8rem; cursor: auto;\">Scenario<\/h2>\n<p style=\"margin-bottom: 1rem; font-size: 19px; line-height: 28px; cursor: auto; color: inherit;\">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.<\/p>\n<p style=\"margin-bottom: 1rem; font-size: 19px; line-height: 28px; cursor: auto; color: inherit;\">To complete the project, you will:<\/p>\n<ol style=\"margin-left: 10px; margin-bottom: 1rem; padding-bottom: 10px; padding-left: 20px; font-size: 19px; line-height: 28px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">Select the client you will be working with for the project<\/li>\n<li style=\"cursor: auto; color: inherit;\">Analyze the given historical data for your chosen client and their identified business opportunity<\/li>\n<li style=\"cursor: auto; color: inherit;\">Select and apply an appropriate predictive model to forecast the data trends<\/li>\n<li style=\"cursor: auto; color: inherit;\">Utilize results produced from the predictive analysis to determine any trends or patterns in the data<\/li>\n<li style=\"cursor: auto; color: inherit;\">Create appropriate data visualizations to support your analysis and recommendations<\/li>\n<li style=\"cursor: auto; color: inherit;\">Assess the model to determine whether it can used to support the client\u2019s business strategy<\/li>\n<\/ol>\n<p style=\"margin-bottom: 1rem; font-size: 19px; line-height: 28px; cursor: auto; color: inherit;\">Select CLIENT B &#8211; BOSTON REALTY CO. a client we look into to complete your project.<\/p>\n<p style=\"margin-bottom: 1rem; font-size: 19px; line-height: 28px; cursor: auto; color: inherit;\"><span style=\"font-weight: bolder; cursor: auto; color: inherit;\">Client B:<span style=\"cursor: auto; color: inherit;\">&nbsp;<\/span><\/span>Boston Realty Co.<br style=\"cursor: auto; color: inherit;\">The CEO at Boston Realty Co. would like to determine sale prices for houses based on different factors. This information will help the organization\u2019s 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.<\/p>\n<h2 style=\"margin-top: 30px; font-size: 1.5rem; line-height: 1.8rem; cursor: auto;\">Directions<\/h2>\n<p style=\"margin-bottom: 1rem; font-size: 19px; line-height: 28px; cursor: auto; color: inherit;\">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.<\/p>\n<p style=\"margin-bottom: 1rem; font-size: 19px; line-height: 28px; cursor: auto; color: inherit;\"><span style=\"font-weight: bolder; cursor: auto; color: inherit;\">Part One: Summary Report<br style=\"cursor: auto; color: inherit;\"><\/span>For Part One, you will define the client\u2019s 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.<\/p>\n<ol style=\"margin-left: 10px; margin-bottom: 1rem; padding-bottom: 10px; padding-left: 20px; font-size: 19px; line-height: 28px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\"><span style=\"font-weight: bolder; cursor: auto; color: inherit;\">Define the client\u2019s business problem.<\/span><\/li>\n<ul style=\"margin-left: 10px; padding-bottom: 10px; padding-left: 20px; line-height: 28px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">Identify the independent and dependent variables<\/li>\n<ul style=\"margin-left: 10px; padding-bottom: 10px; padding-left: 20px; line-height: 28px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">How do they define the business problem? Explain.<\/li>\n<li style=\"cursor: auto; color: inherit;\">What can be predicted using these variables? Explain.<\/li>\n<\/ul>\n<\/ul>\n<li style=\"cursor: auto; color: inherit;\"><span style=\"font-weight: bolder; cursor: auto; color: inherit;\">Explain the patterns in the data and create visualizations.<\/span><\/li>\n<ul style=\"margin-left: 10px; padding-bottom: 10px; padding-left: 20px; line-height: 28px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">Using the residuals and coefficients in the provided Excel file, create relevant visualizations and analyze their shape.<\/li>\n<ul style=\"margin-left: 10px; padding-bottom: 10px; padding-left: 20px; line-height: 28px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">Is the data grouped in any particular way, or is it randomly scattered?<\/li>\n<li style=\"cursor: auto; color: inherit;\">Are there any outliers? If so, what might they indicate?<\/li>\n<\/ul>\n<li style=\"cursor: auto; color: inherit;\">Explain whether the shape of the data is appropriate to verify normal distributions. Justify your reasoning.<\/li>\n<li style=\"cursor: auto; color: inherit;\">Calculate the standard deviation (sd), mean, median, quartile values for each variable.<\/li>\n<ul style=\"margin-left: 10px; padding-bottom: 10px; padding-left: 20px; line-height: 28px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">What do these values indicate about the business problem? Explain.<\/li>\n<\/ul>\n<li style=\"cursor: auto; color: inherit;\">Determine the presence of outliers within each variable using a visualization technique. Justify your choice of the visualization technique.<\/li>\n<ul style=\"margin-left: 10px; padding-bottom: 10px; padding-left: 20px; line-height: 28px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">Determine whether you should replace outliers with mean values. Justify your reasoning.<\/li>\n<\/ul>\n<li style=\"cursor: auto; color: inherit;\">How can we interpret the F-statistic and the residual sum of squares value for this model? Explain.<\/li>\n<\/ul>\n<li style=\"cursor: auto; color: inherit;\"><span style=\"font-weight: bolder; cursor: auto; color: inherit;\">Perform a regression analysis.<\/span><\/li>\n<ul style=\"margin-left: 10px; padding-bottom: 10px; padding-left: 20px; line-height: 28px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">Apply and perform an appropriate regression model. Justify your reasoning for selecting the regression model you applied.<\/li>\n<li style=\"cursor: auto; color: inherit;\">Which of the variables provide the greatest response to the prediction?<\/li>\n<ul style=\"margin-left: 10px; padding-bottom: 10px; padding-left: 20px; line-height: 28px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">What does the responsiveness of the variables tell stakeholders? Explain.<\/li>\n<\/ul>\n<\/ul>\n<\/ol>\n<p style=\"margin-bottom: 1rem; font-size: 19px; line-height: 28px; cursor: auto; color: inherit;\"><span style=\"font-weight: bolder; cursor: auto; color: inherit;\">Part Two: Apply Model and Make Recommendations<br style=\"cursor: auto; color: inherit;\"><\/span>For Part Two, you will define how your algorithm\u2019s 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.<\/p>\n<ol style=\"margin-left: 10px; margin-bottom: 1rem; padding-bottom: 10px; padding-left: 20px; font-size: 19px; line-height: 28px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\"><span style=\"font-weight: bolder; cursor: auto; color: inherit;\">Define how the algorithm\u2019s performance will be assessed to determine its usefulness.<\/span><\/li>\n<ul style=\"margin-left: 10px; padding-bottom: 10px; padding-left: 20px; line-height: 28px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">Choose an assessment type based on the algorithm selected. Justify your selection.<\/li>\n<\/ul>\n<li style=\"cursor: auto; color: inherit;\"><span style=\"font-weight: bolder; cursor: auto; color: inherit;\">Produce the prediction model forecast.<\/span><\/li>\n<ul style=\"margin-left: 10px; padding-bottom: 10px; padding-left: 20px; line-height: 28px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">Identify the most appropriate model for predicting future business opportunities for the organization. Explain your reasoning.<\/li>\n<ul style=\"margin-left: 10px; padding-bottom: 10px; padding-left: 20px; line-height: 28px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">Show the residual output from the model and discuss how far the predicted variables are from the actual results.<\/li>\n<\/ul>\n<\/ul>\n<li style=\"cursor: auto; color: inherit;\"><span style=\"font-weight: bolder; cursor: auto; color: inherit;\">Assess the prediction model\u2019s performance<\/span><\/li>\n<ul style=\"margin-left: 10px; padding-bottom: 10px; padding-left: 20px; line-height: 28px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">Using the F-statistic, degrees of freedom, and residual sum of squares for the assessment, discuss how the model\u2019s coefficients can be used to select the optimal independent variables for the model.<\/li>\n<li style=\"cursor: auto; color: inherit;\">Discuss further optimization or enhancement opportunities or methodologies that might be applicable to improving the model.<\/li>\n<ul style=\"margin-left: 10px; padding-bottom: 10px; padding-left: 20px; line-height: 28px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">How will further optimization or enhancement to the model help support decision-making for the client?<\/li>\n<\/ul>\n<\/ul>\n<li style=\"cursor: auto; color: inherit;\"><span style=\"font-weight: bolder; cursor: auto; color: inherit;\">Create linear or logistical regression visualizations.<\/span><\/li>\n<ul style=\"margin-left: 10px; padding-bottom: 10px; padding-left: 20px; line-height: 28px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">Determine the key response indicator variables (KRIs) or independent variables.<\/li>\n<li style=\"cursor: auto; color: inherit;\"><span style=\"font-weight: bolder; cursor: auto; color: inherit;\">Include screenshots of the following visualizations:<\/span><\/li>\n<ul style=\"margin-left: 10px; padding-bottom: 10px; padding-left: 20px; line-height: 28px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">Create a bar chart of the coefficients for each independent variable.<\/li>\n<li style=\"cursor: auto; color: inherit;\">Create a line chart that shows the linear trend line.<\/li>\n<ul style=\"margin-left: 10px; padding-bottom: 10px; padding-left: 20px; line-height: 28px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">Analyze and interpret the trend line.<\/li>\n<li style=\"cursor: auto; color: inherit;\">What does the trend line tell you about the algorithm\u2019s performance?<\/li>\n<\/ul>\n<\/ul>\n<\/ul>\n<li style=\"cursor: auto; color: inherit;\"><span style=\"font-weight: bolder; cursor: auto; color: inherit;\">Determine if your analysis supports the business opportunity for the organization.<\/span><\/li>\n<ul style=\"margin-left: 10px; padding-bottom: 10px; padding-left: 20px; line-height: 28px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">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.<\/li>\n<ul style=\"margin-left: 10px; padding-bottom: 10px; padding-left: 20px; line-height: 28px; cursor: auto; color: inherit;\">\n<li style=\"cursor: auto; color: inherit;\">What aspects of your analysis support the identified business opportunity in your given scenario? Explain your reasoning.<\/li>\n<li style=\"cursor: auto; color: inherit;\">What aspects of your analysis do not support the identified business opportunity in your given scenario? Explain your reasoning.<\/li>\n<\/ul>\n<\/ul>\n<\/ol>\n<h2 style=\"margin-top: 30px; font-size: 1.5rem; line-height: 1.8rem; cursor: auto;\">What to Submit<\/h2>\n<p style=\"margin-bottom: 1rem; font-size: 19px; line-height: 28px; cursor: auto; color: inherit;\">To complete this project, you must submit the following:<\/p>\n<p style=\"margin-bottom: 1rem; font-size: 19px; line-height: 28px; cursor: auto; color: inherit;\"><span style=\"font-weight: bolder; cursor: auto; color: inherit;\">Predictive Analysis Report<br style=\"cursor: auto; color: inherit;\"><\/span>This should be a 3-to 5-page Word document, including any screenshots and visualizations. Sources should be cited according to APA style.<\/p>\n<p style=\"margin-bottom: 1rem; font-size: 19px; line-height: 28px; cursor: auto; color: inherit;\"><b>PROVIDE TURN IT IN REPORT AND AI VERIFICATION REPORT TO ENSURE CONTENT IS 100% ORIGINAL<\/b><\/p>\n<p style=\"margin-bottom: 1rem; font-size: 19px; line-height: 28px; cursor: auto; color: inherit;\"><b><br \/><\/b><\/p>\n<h2 style=\"margin-top: 30px; font-size: 1.5rem; line-height: 1.8rem; cursor: auto;\">Supporting Materials In The Attachments<\/h2>\n<p style=\"margin-bottom: 1rem; font-size: 19px; line-height: 28px; cursor: auto; color: inherit;\"><span style=\"color: inherit; background-color: var(--color-6); font-variant-ligatures: inherit; font-variant-caps: inherit; font-weight: bolder; cursor: auto;\"><span style=\"color: inherit; background-color: var(--color-6); font-variant-ligatures: inherit; font-variant-caps: inherit; font-weight: 400;\">The following resources support your work on the project:<\/span><\/span><\/p>\n<p style=\"margin-bottom: 1rem; font-size: 19px; line-height: 28px; cursor: auto; color: inherit;\"><span style=\"color: inherit; background-color: var(--color-6); font-variant-ligatures: inherit; font-variant-caps: inherit; font-weight: bolder; cursor: auto;\">Excel Workbook:<span style=\"cursor: auto; color: inherit;\">&nbsp;<\/span><\/span><a style=\"font-variant-ligatures: inherit; font-variant-caps: inherit; cursor: auto;\"><span style=\"cursor: auto; color: inherit;\">Boston Realty Data Set<\/span><\/a><\/p>\n<p style=\"margin-bottom: 1rem; font-size: 19px; line-height: 28px; cursor: auto; color: inherit;\">If you selected Client B, you would utilize this data set.<\/p>\n<p style=\"margin-bottom: 1rem; font-size: 19px; line-height: 28px; cursor: auto; color: inherit;\"><span style=\"font-weight: bolder; cursor: auto; color: inherit;\">Word Document:<\/span><span style=\"cursor: auto; color: inherit;\">&nbsp;<\/span><a style=\"cursor: auto;\"><span style=\"cursor: auto; color: inherit;\">Project Data Sets Description<\/span><\/a><span style=\"font-weight: bolder; cursor: auto; color: inherit;\"><br style=\"cursor: auto; color: inherit;\"><\/span>Use this document to learn more about the variables in each data set.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[759],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/31265"}],"collection":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/types\/questions"}],"author":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/comments?post=31265"}],"version-history":[{"count":0,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/31265\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/media?parent=31265"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/disciplines?post=31265"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/paper_types?post=31265"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/tagged?post=31265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}