Mohammed Yunus

Dear Shantanu and All, First, I cannot have file size as part of CTQ as it is not possible to collect data as this information is no where stored. I can, however, get file length which is possible though very difficult to extract that now. As advised by you, I have collated three days' data for each shift and put in three different columns. Tried for Test for Equal Variance (Levene/Bartlett). In the dialogue box, for "Factors" box I took first shift data and for "Response" column I took both second and third shift data. The Levenes P-Value is 0.785 and Barlett's p-Value is 0.152. Please let me know what was followed is correct. Normality Test (STAT-> Basic Stats -> Normality Test) resulted in <0.005 for all three shifts. I could not help my self determine the minimum sample size required for ANOVA(STAT>Power and Sample Size>One-Way ANOVA). Not sure what data should go under which field.

Dear Pankaj, I had collated three days data for each shift. The data is 40 for each shift. I collated all in one column and did the following: Display Descriptive Statistics and here are the results. Variable N N* Mean SE Mean StDev Minimum Q1 Median Q3 C4 360 0 0.3983 0.0205 0.3889 0.1000 0.1525 0.2550 0.4100 Variable Maximum C4 2.3800 ========================= Later I did the "Graphical Summary" and got the P-Value as <0.005 Mean 0.39828 StDev 0.38891 Variance 0.15125

We have a software developed by our internal software team. Users of my department have been complaining of slowness in downloading each file and uploading. ( weare medical transcription company and I hope you know it's business. listen to the audio and type. Out dept does the quality proofing so listen and read, no typing as such).Downloadinga file includes voice file and a word document, which take some where around 15-20 seconds, around 10-15 seconds to load a demographic pane which will have patient related infromation. And once the proofing is done, the uploading of file take around 10-15 seconds.This is observed based on manual observation. Users have also complained that at times it takes ages to download. so, appx 45 seconds are wasted for each file. Each QA does appx 50 files and we have 50 QAs. So, 45 seconds x 50 files x 50 QAs = Unproductive time per day. Formally, we have notified to software team and they are working on it. WE have nt even given them the target of within how many seconds a file should download or upload. WE just said optimize it. They are working on that. With my persoanl interestI have taken the logs ofusers from different shifts and extracted the file name, the time when user clicked to download, when the file got downloaded. Similarly I have extracted the file name, when the user clikced on upload and when exactly the file got uploaded. I have added the total time for upload from the time of click and total time of upload from the time of click and grand total of time spent on download and upload. I have taken first, general, second and night shift logs. And collected for three days as sample for each QA. Can any one please tell me what should I do next.