Using the Milestone Two PowerPoint Template, complete the following, including key visualizations and analysis to support your recommendation:
- Validate or reject your initial hypothesis based on your analysis of the regressions.
- You will also need to qualify in the predictions and trends report what the rationale is behind using that attribute towards regression. Identify the right attribute size (independent variable) that would lead you to a monthly quantity sold range of 3,000–12,000 gallons.
- Predictions and Trends Analysis
- Section One: Overview
- What does your analysis tell you about your initial hypothesis—the option chosen in Phase One? Did you confirm it? Support your reasoning with your analysis results.
- Which combination of the attributes seems most appropriate to lead you to the expense range of $500–$2,750?
- Which combination of the attributes would seem appropriate to lead you to a monthly quantity sold range of 3,000–12,000 gallons?
- Section Two: Findings from Regression Analysis
- Briefly describe the key elements for each regression presented in Excel. Cite the regression coefficient, regression line equation, p value, and significance F in your description.
- Which of the independent variables are impactful, and why?
- Overall, what is your conclusion about the option to be recommended and the key attributes that TC Ice Cream should be alerted to?
- Section One: Overview