Question

Sarah is the office manager for a group of financial advisors who provide financial services for individual clients. She would like to investigate whether a relationship exists between the number of presentations made to prospective clients in a month and the number of new clients per month. The accompanying table shows the number of presentations and corresponding new clients for a random sample of six employees. Sarah would like to use simple regression analysis to estimate the number of new clients per month based on the number of presentations made by the employee per month. What is the average number of new clients per month for an employee who made 10 presentations per month? Click the icon to view the results for the random sample. Random sample results - X O A. 3.43 OB. 3.05 OC. 1.67 OD. 2.39 Employee Presentations New Clients OUT AWN نم نيا كا نيا اي نية Print Done

Answer 1

The answer is:

${\color{Purple} \text{A. }3.43}$

The regression line is:

û = 0.391304348 +0.304347826 * 2

When x=10 then

û = 0.391304348 + 0.304347826 * 10 = 3.43

The model run in excel is:

Clipboard Font To Alignment Number Styles cells 024 B 1 Presentations New Clients C D SUMMARY OUTPUT E F G H I J K L M 3 4 3 12 Regression Statistics Multiple R 0.516046847 R Square 0.266304348 Adjusted R Square 0.082880435 Standard Error 0.98907071 Observations ANOVA df Significance F 0.29464249 Regression Residual Total 1 4 5 SS M S F 1.420289855 1.420289855 1.451851852 3.913043478 0.97826087 5.333333333 Intercept Presentations Coefficients 0.391304348 0.304347826 Standard Error t Stat P-value 2.474825995 0.158113883 0.882028194 0.25258587 1.204928152 0.29464249 Lower 95% Upper 95% Lower 95.0% Upper 95.0% -6.47991417 7.262522868 -6.47991417 7.262522868 -0.39694298 1.00563863 -0.39694298 1.00563863 3.43

Let me know in the comments if anything is not clear. I will reply ASAP! Please do upvote if satisfied!