Answered step by step
Verified Expert Solution
Question
1 Approved Answer
International Analytical Center is trying to understand which one of numbers of Sales Employees or the Marketing Budget would have a stronger relationship and
International Analytical Center is trying to understand which one of numbers of Sales Employees or the Marketing Budget would have a stronger relationship and influence on the company Sales. Then which one of numbers of Sales Employees or the Marketing Budget could be used to the future trends of sales of the company. Given the information collected in the previous six years about Sales and Employees numbers and Marketing Budget. Store (Y) (XI) Sales Sales (million) Employees 2014 1.85 2015 1.83 2016 1.82 2017 1.79 2018 1.75 2019 1.73 227787 21 21 20 21 (X2) Marketing Budget (1000) 192 196 188 184] 173 175 1. Find the Correlation coefficient of Sales (Y) against Employees (X1) and Marketing (X2) What do you conclude? Which one of Employees or Marketing has stronger relationship and influence on the Sales, and why? 2. Find the Regression equation of Sales (Y) against Employees (XI). 3. Find the Regression equation of Sales (Y) against Marketing (X2), what you conclude. 4. Use the Regression equation to obtain the predicted Sales for 2020 if Employees numbers become (25) and if Marketing Budget become:(200)
Step by Step Solution
★★★★★
3.46 Rating (156 Votes )
There are 3 Steps involved in it
Step: 1
To analyze the relationship and influence of Sales Y with both Sales Employees X1 and Marketing Budget X2 you can calculate the correlation coefficien...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started