Solved

Compare between simulation and observation

Posted on 2014-07-31
6
133 Views
Last Modified: 2014-08-27
Hello,

I have observed data collected from work field represent tasks time. I have simulate the work field activities and insert the same starting time of the real data. Now, I need to compare between the simulation output and real work output to see how much my simulation closer than the real work. My question is which type of t test should I run, paired t test or unequal variance t-test?
Please note that I have insert 2479 tasks to both system. However, the output of the real system is 2479 and the simulation 2214.
0
Comment
Question by:amq10
  • 4
  • 2
6 Comments
 
LVL 27

Expert Comment

by:d-glitch
Comment Utility
What is your data?  Time required to complete a task?  Are all the tasks the same?  Are all the workers equivalent?

How did you analyze and model the observed data?  
Do you have more than mean and SD?  Does it fit a normal distribution?

What is your simulation based on?

>>   Insert 2479 tasks to both system. However, the output of the real system is 2479 and the simulation 2214.
What happened to the other 265 tasks?  Did the simulator run out of time?

If you run the simulation again (with a different random seed), do you get different results?
If you run it ten times, do some complete more than 2479 tasks and some less?
0
 
LVL 27

Expert Comment

by:d-glitch
Comment Utility
I don't know how you are analyzing the data or modeling the process.
But given the limited info I have, this is how I would proceed:

1.

There are 2479 observations of task time.  Find the mean and STD and try to fit it to a normal distribution.

2.

Sort the data, and plot it:      (1, t_min) (2, t_next) . . .  (2479, t_max)This will give you a monotonically increasing curve you can plot against the cumulative normal distribution.

3.

No matter what the data looks like, you can still model it by generating random numbers between 1 and 2479, and using that number to index the times in the sorted list.
0
 

Author Comment

by:amq10
Comment Utility
sorry for delay to reply on experts answers,

the tasks are customers requests (customers problems and deal with that issues). in the real case, which I collect the data from the task arrive in specific time and takes time in process and then closed. I have designed the simulation based on the distribution of the process and insert the same time of arrival. I need to compare between the time from arrival until finish of the real and simulation to see how much the simulation is correct.

question is which test will be suitable for this kind of comparison. In my reading I found that t test the appropriate one due to the dame task will run in real and simulation and compare between its output.

Does my understanding correct?
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
LVL 27

Expert Comment

by:d-glitch
Comment Utility
>>  I have designed the simulation based on the distribution of the process

If the simulation is really based on the distribution (mean and variance) of the observed data, then the t-test should indicate that the means and variances are the same.

The t-test is usually used to compare two sets of observations, not one set of observations and a model.

I still don't understand how your model makes 265 tasks disappear.
0
 

Author Comment

by:amq10
Comment Utility
in this time forget the disappear tasks. I need to know now how to compare using t test
0
 
LVL 27

Accepted Solution

by:
d-glitch earned 500 total points
Comment Utility
You can use the t.test from Excel.
You can (but don't have to) use all of your data.

The parameters you have to decide on are:
    Tails:  1 or 2    I don't know which would be appropriate, probably 1.

    Type:   1    Paired                                           [If you choose equal sample sizes]
                 2   Two-sample equal variance       [If you want to unequal sample sizes or all of your data]    
                 3  Two-sample unequal variance   [Your samples should have equal variance]
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
We are taking giant steps in technological advances in the field of wireless telephony. At just 10 years since the advent of smartphones, it is crucial to examine the benefits and disadvantages that have been report to us.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now