CH14 – Sales Manager’s Analysis of Salespersons’ Experience and Annual Sales
Essentials of Modern Business Statistics with Microsoft® Excel®
Anderson, Sweeney, Williams, Camm, and Cochran
07th Edition
Analyze the data collected by the sales manager on annual sales for new customer accounts and the number of years of experience for a sample of 10 salespersons. Create a scatter diagram for the data with years of experience as the independent variable, develop an estimated regression equation to predict annual sales, and use the equation to predict annual sales for a salesperson with 9 years of experience.
Calculator Preview
Your numbers will vary.