Market Research

In this Excel file, you’ll find a complete regression analysis workflow using dummy data. The first sheet contains the structured raw data used for the analysis, while the second sheet presents the regression results, including coefficients, R-squared values, and significance levels. This setup provides a clear, side-by-side view of both the input and output for easier understanding and interpretation. 

In this article, we explore how regression analysis using dummy data can reveal the relationship between advertising budgets such as Facebook Ads, Google Ads, and Instagram Ads and product sales. Learn how to run the regression in Excel and interpret key outputs like coefficients, p-values, and R-squared to uncover how each ad channel contributes to sales performance.