Business Case: Business Model and Predictive Model Regression$)$

Question $2$

A business analyst has been tasked to study the relationship of telemarketing effectiveness. It has been hypothesized the conversion of effective sales is proportion to the number of calls.

A time series study over $1$ month has been conducted to evaluate the median sales and the number of calls made per day. Table $2$ illustrates the result. The business analyst is required to perform a few data visualizations and use appropriate data analytics to justify the result.

Jane $-$ Sales call $(14)$ Unit Sold $(28)$

Alex $-$ Sales call $(35)$ Unit Sold $(66)$

Rodriguez $-$ Sales call $(22)$ Unit Sold $(38)$

Beatrice $-$ Sales call $(29)$ Unit Sold $(70)$

Patrick $-$ Sales call $(6)$ Unit Sold $(22)$

James $-$ Sales call $(15)$ Unit Sold $(27)$

Abdul $-$ Sales call $(17)$ Unit Sold $(28)$

Zareth $-$ Sales call $(20)$ Unit Sold $(47)$

Timothy $-$ Sales call $(12)$ Unit Sold $(14)$

Bonnie $-$ Sales call $(29)$ Unit Sold $(68)$

Table $2$: Call center performance

a$)$ Based on the table above, visualize the overall relationship through a Scatter Diagram comment on the scatter diagram.

b$)$ Describe the use of regression model in analytics modelling. Name $3$ basic assumptions.

c$)$ Using manual computation, derive a simple linear relationship. Comment on the

regression model

d$)$ Now, repeat the process with automated solution $($through MS Excel$)$