Question

ttempts: Average: 17 8. Using Excel- Scatter diagrams, estimated regression equations, and trendlines Suppose a company records data on sales calls, including the length of each call and whether a saie was made. The manager is interested in determining whether there is a relationship between the average time spent per cal and the number of sales made by each enployee, so she obtairs the average ail length and the total number ๙ saes over a 2-week period for a random sample of 30 employees. To answer the questions that follow, download an Exoel8 spreadsheet containing the given data by clicking on the following words in bold Download Excel File. The upper let-band corner of the Excel spreadsheet in the fie you download should look lke the folowing sample spreadsheet Average Length of Calls (Minutes) 2.3 Employee 1.1

Answer 1