Question: Phone Solutions Inc. provides assistance to users of a personal finance software package. Users of the software call with their questions and trained consultants provide answers and information. One concern that Phone Solutions must deal with is the staffing of its call centers. As part of the staffing issue, it seeks to reduce the average variability in the time each consultant spends with each caller. A study of this issue is currently underway at the company’s three call centers. Each call center manager has randomly sampled 50 days of calls, and the collected times, in minutes, are in the file Assignment #2 data.xls, on the "Phone Solutions" worksheet.

1. Call Center I has set the goal that the variation in phone calls, measured by the standard deviation of length of calls in minutes, should be less than 3.5 minutes. Using the data in the file, can the operations manager of Call Center 1 conclude her consultants are meeting the goal? Use a 0.10 level of significance. (Hint: use Excel’s CHIINV function to find the critical value, write it like that: =CHIINV(probability = .90 , degree of freedom) )
2. Can the manager conclude there is greater variability in the average length of phone calls for Call Center 3 than for Call Center 2? use a 5% level of significance to conduct the appropriate test.

Price: $2.99

Solution: The downloadable solution consists of 2 pages
Deliverable: Word Document