Question $3$

a$)$ Based on the scenario above of the sales calls and the number of units sold, you will determine the confidence interval of $95\%$ for any $25$ sales call. A new agent by the name of Jorge has just joined and made $25$ calls. Determine the estimated amount of sales call.

b$)$ In addition, it has been hypothesized that the number of experience $($months$)$ impacts on the predicted units sold.

Jane $-$ Sales Call $(14)$ Exprerience $($Mths$)(16)$ Unit Sold $(28)$

Alex $-$ Sales Call $(35)$ Exprerience $($Mths$)(36)$ Unit Sold $(66)$

Rodriguez $-$ Sales Call $(22)$ Exprerience $($Mths$)(14)$ Unit Sold $(38)$

Beatrice $-$ Sales Call $(29)$ Exprerience $($Mths$)(45)$ Unit Sold $(70)$

Patrick $-$ Sales Call $(6)$ Exprerience $($Mths$)(12)$ Unit Sold $(22)$

James $-$ Sales Call $(15)$ Exprerience $($Mths$)(13)$ Unit Sold $(27)$

Abdul $-$ Sales Call $(17)$ Exprerience $($Mths$)(15)$ Unit Sold $(28)$

Zareth $-$ Sales Call $(20)$ Exprerience $($Mths$)(20)$ Unit Sold $(47)$

Timothy $-$ Sales Call $(12)$ Exprerience $($Mths$)(8)$ Unit Sold $(14)$

Bonnie $-$ Sales Call $(29)$ Exprerience $($Mths$)(32)$ Unit Sold $(68)$

Table $3$: Call center performance with added parameter $($experience$)$

Based on this model, remodel the relationship as Multiple regression. Use MS Excel to solve it$.$