Company Year Metric Value

Company A $2020$ Advertising Spend $50,000$

Company A $2020$ Sales Team Size $4$

Company A $2020$ Website Traffic $200,000$

Company A $2020$ Revenue $100,000$

Company A $2021$ Advertising Spend $60,000$

Company A $2021$ Sales Team Size $5$

Company A $2021$ Website Traffic $220,000$

Company A $2021$ Revenue $110,000$

Company A $2022$ Advertising Spend $45,000$

Company A $2022$ Sales Team Size $3$

Company A $2022$ Website Traffic $180,000$

Company A $2022$ Revenue $95,000$

Company B $2020$ Advertising Spend $70,000$

Company B $2020$ Sales Team Size $6$

Company B $2020$ Website Traffic $240,000$

Company B $2020$ Revenue $120,000$

Company B $2021$ Advertising Spend $55,000$

Company B $2021$ Sales Team Size $4$

Company B $2021$ Website Traffic $210,000$

Company B $2021$ Revenue $105,000$

Company B $2022$ Advertising Spend $65,000$

Company B $2022$ Sales Team Size $5$

Company B $2022$ Website Traffic $230,000$

Company B $2022$ Revenue $115,000$

Company C $2020$ Advertising Spend $40,000$

Company C $2020$ Sales Team Size $3$

Company C $2020$ Website Traffic $170,000$

Company C $2020$ Revenue $90,000$

Company C $1978$ Revenue $1,000,000$

Company C $2021$ Advertising Spend $75,000$

Company C $2021$ Sales Team Size $6$

Company C $2021$ Website Traffic $250,000$

Company C $2021$ Revenue $125,000$

Company C $2022$ Advertising Spend $50,000$

Company C $2022$ Sales Team Size $4$

Company C $2022$ Website Traffic $200,000$

Company C $2022$ Revenue $100,000$ The objective of this assignment is to apply multiple linear regression analysis using Microsoft Excel to understand the relationships between marketing and sales variables and their impact on a company's revenue. i need excel for this