Analyzing Beer Sales Trends: A Linear Approach to Predict Future Growth
This analysis employs a linear trendline to model beer sales, highlighting a steady increase over time. The slope of the trendline is 1203.5, with a y-intercept of 17,798 and an x-intercept at 14.8. By inputting the year value of 30, we can predict sales to reach approximately 53,903, indicating a consistent annual growth of around 1,000 units. Furthermore, a hypothetical reduction in the legal drinking age to 18 would elevate the y-intercept while maintaining a similar trend in the graph.
Analyzing Beer Sales Trends: A Linear Approach to Predict Future Growth
E N D
Presentation Transcript
1. We chose linear trendline because it mostly resembles the line and also because its steady increase. • 5. The slope is 1203.5, the y intercept is 17,798, and the x intercept is 14.8.
6. After plugging in 30 for x I got 53,903 which means my answer does seem possible because it is increase by about 1000 every year. If I was an analyst I would still use the plug in method. • 7. If congress was to lower the drinking age to 18 the y intercept would increase, but the graph would look about the same.