nagarajan.arvind

Hi Pankaj, I believe I can offer my suggestion to your case. As you have already collected the user logs, you can do a Root Cause Analysis to identify whether the download time exhibit variation with respect to specific factors (Like Specific User A,B,etc or any specific time of the day). You can use Pareto Chart to identify the % wise breakdown which you can further use to drill down or forward it to your IT Team for detailed technical analysis. I would try mapping the data on a scatter plot to check for outliers and identify them as special causes which trigger greater download time. Further, you can check for normality by plotting the data as a histogram in an excel and fitting a gaussian curve over them. I believe that you would end up doing Hypothesis Testing using F Test ( For comparing variances of different data from different periods) as we need to estimate whether significant difference in download time for different periods exists. Please check whether you have to use ANOVA or CHI for this purpose. Even though you have more than 30 data sets, I think F Test or CHI Test would suit this analysis more than normal distribution. Once you have identified whether significant difference in download time exists for different periods for the data, you can arrive at a solution either by rescheduling your process flow or restructuring your handling time. I hope I am adding value to your idea. I would like to know if Mr. Shantanu is in sync with mine..... Thanks & Regards, Arvind N

How do we compute the P Value for a F Test. I came across a situation where I computed the F Stat and F Critical Value (from the F Table). But was unable to calculate the P Value using the same method used in Normal Z Distribution. If we take a log of both the F Values, will this make the F DIst to a Lognormal Distribution as the lower bound be capped at zero. If yes, can this dist give us the accurate P Value ? Kindly let me know how to calculate the P Value for F Dist and Chi Squared Distributions. Thanks & Regards, Arvind N

Hi Shalini, I am new to fraternity and hence the delay in this post. I would say we have to look at both Productivity (Output Per Manhour) and Efficiency (Probability of Successful Strikes yielding Revenue) as the base for this question. I am from a BPO and understand the billing process for callers. I feel that in order to ensure RoI on callers, we have to set certain targets both in terms of productivity and efficiency. For Productivity, we can have compliance to daily targets. This will only ensure that the stipulated calls per day has been made, nothing else. For Efficiency, I suggest a Minor Market Research on the product and the targeted population to study their buying behavior and their demographics which will enable us to identify "Whom we should call and Whom we should not". This will save a lot of time and provide a lot of clarity on our calls. Other things like Total Talk Time/Day and Ratios Sought etc will be encompassed in the productivity targets itself. The final objective is to secure a higher revenue which I believe can be attained by market research and sampling. Hope my perspective holds good. Thanks Arvind N