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.

1. Based on the table above, visualize the overall relationship through a Scatter Diagram Comment on the scatter diagram.
2. Describe the use of the regression model in analytics modeling. Name 3 basic assumptions.
3. Using manual computation, derive a simple linear relationship. Comment on the regression model
4. Now, repeat the process with automated solution (through MS Excel)