A corporate sponsor of the Winter Olympics wants to understa…

Written by Anonymous on February 16, 2026 in Uncategorized with no comments.

Questions

A cоrpоrаte spоnsor of the Winter Olympics wаnts to understаnd the relationship between advertising spending during the Games and product revenue generated during the same period. The company collected the following data from the past five Winter Olympics (amounts in millions of dollars): Winter Olympics Year Advertising Spending (X) Product Revenue (Y) Year 1 10 25 Year 2 15 32 Year 3 20 40 Year 4 25 47 Year 5 30 55 Assume a linear relationship between advertising spending and product revenue. USE Excel to complete this problem. Question:Using the data provided, calculate the simple linear regression equation of the form Y^=b0+b1X where: XX = Advertising Spending (in millions of dollars) YY = Product Revenue (in millions of dollars) Show your calculations for the slope (b1b_1) and intercept (b0b_0, and provide the final regression equation. Then briefly interpret the meaning of the slope coefficient in the context of the Winter Olympics sponsorship decision.

Comments are closed.