Data Collection & Input Analysis

 Write a one page summary in MS Word describing how/where you collected your data, what distribution was the best fit (for both Arrival & Service), and your interpretation of the Chi Square goodness-of-fit test for each.  

  

A refresher on squared error:

Squared error is the difference between an actual observed value and its fitted (or predicted) value in regression analysis. The smaller the squared error (i.e., towards zero), the better. A small squared error value very close to zero implies that the deviation between an observed value and its fitted value is almost zero => variability in the data is small => distribution x provides a good fit to the data. A large squared error implies that the deviation between an observed value and its fitted value is large => variability in the data is large => distribution x is not a good fit to the data.

A refresher on p-values

The results of Chi-square goodness-of-fit tests are shown by Input Analyzer. The results are presented in the form of p-values; the p-value is the largest value of the Type-I error probability (rejecting the null hypothesis when it is, in fact, true) that allows the distribution to fit the data. The null hypothesis states that the distribution fits the data. The alternative hypothesis says it doesn’t. In general, the higher the p-value, the better the fit. For example, if the p-value is greater than 0.05, then we would fail to reject the null hypothesis at significance level = 0.05.

Needed information is attached. 

2

>EnterData

1

2

0.00

.00

3

0.00 0.00

.00

4

0.00 0.00

.00

5

0.00 0.00

6

0.00 0.00

.00

7

0.00 2.00

8

0.00 0.00

.00

9

0.00 0.00

0.00 0.00

11

0.00 0.00

.00

0.00 0.00

0.00 0.00 15.00

14

0.00 0.00

.00

15

0.00 0.00

0.23

16

0.00 0.00

0.00 0.00 15.00 0.25

18

0.00 0.00 12.00 0.20

0.00 0.00

.00

20

0.00 0.00 14.00 0.23

0.00 0.00

22

0.00 0.00 12.00 0.20

23

0.00 0.00 15.00 0.25

0.00 0.00 14.00 0.23

25

0.00 0.00 13.00 0.22

26

0.00 0.00 14.00 0.23

27

0.00 0.00 15.00 0.25

0.00 0.00 14.00 0.23

29

0.00 0.00

30

0.00 0.00 14.00 0.23

31

0.00 0.00 13.00 0.22

0.00 0.00 14.00 0.23

0.00 0.00 14.00 0.23

34

0.00 0.00 14.00 0.23

0.00 0.00 13.00 0.22

0.00 0.00 18.00

37

0.00 0.00 26.00

0.00 0.00 12.00 0.20

39

0.00 0.00 14.00 0.23

40

0.00 0.00 13.00 0.22

0.00 0.00 15.00 0.25

0.00 0.00

43

0.00 0.00 15.00 0.25

44

0.00 0.00 12.00 0.20

45

0.00 0.00 15.00 0.25

0.00 0.00 12.00 0.20

0.00 0.00 15.00 0.25

48

0.00 0.00 11.00 0.18

49

0.00 0.00 15.00 0.25

50

0.00 0.00 16.00

0.27

0.00 0.00 11.00 0.18

						Data Collection Sheet for Lab #	1
Only edit the yellow section. The rest is calculated.
Collect time to the second if possible.
Readings	Arrival Time	Diff Hr	Diff Min	Diff Sec	Decimal Min
0:00:00
0:00:	3	9																																																																																																			0.00		39
0.	6	5
0:00:5	4				15
			0.	25
0:01:1	7		23
0.3	8
0:01:	29	1	2.00
		0.	20
0:01:	40		11
	0.	18
0:03:55								15.00
	2.25
0:04:11			16		0.	27	Process Summary:
0:04:27	16.00				0.27	Process of applying clear grain filler to wood veneer sheets. This is done by machine via roll coater but the machine is fed and emptied by hand. The arrival times logged are the times an operator took his hands off the sheet after unloading from the machine. This will be the waiting period before a second coat is applied.
10	0:04:	45		18.00
0.	30
0:04:59		14
																					0.23
12	0:05:11						12.00											0.20
13	0:05:	26																0.25
0:05:57		31
	0.52
0:06:11										14.00
0:06:	22			11.00						0.18
17	0:06:	37
0:06:	49
19	0:07:23		34
	0.57
0:07:37
21	0:07:	50					13.00
									0.22
0:08:02
0:08:17
24	0:08:31
0:08:	44
0:08:58
0:09:13
28	0:09:27
0:09:53		26.00
	0.	43
0:10:07
0:10:20
32	0:10:34
33	0:10:	48
0:11:02
35	0:11:15
36	0:11:33			0.30
0:11:59		0.43
38	0:12:11
0:12:25
0:12:38
41	0:12:53
42	0:13:10	17.00
	0.28
0:13:25
0:13:37
0:13:52
46	0:14:04
47	0:14:19
0:14:30
0:14:45
0:15:01
51	0:15:12

Run Conversion to dst

ISYE4500_Lab1

0.25

0.20
0.18
2.25
0.27
0.27
0.30
0.23
0.20
0.25
0.52
0.23
0.18
0.25
0.20
0.57
0.23
0.22
0.20
0.25
0.23
0.22
0.23
0.25
0.23
0.43
0.23
0.22
0.23
0.23
0.23
0.22
0.30
0.43
0.20
0.23
0.22
0.25
0.28
0.25
0.20
0.25
0.20
0.25
0.18
0.25
0.27
0.18

0.65

0.38

2

>EnterData

1

2

.00

0.00 0.00

4.00

4

0.00 0.00

0.00 0.00

.00

6

0.00 0.00

.00

7

0.00 0.00

0.00 0.00

.00

9

0.00 0.00

0.00 0.00

.00

11

0.00 0.00

12

0.00 0.00

13

0.00 0.00 12.00 0.20

14

0.00 0.00 14.00 0.23

15

0.00 0.00 15.00 0.25

16

0.00 0.00 14.00 0.23

0.00 0.00 13.00

18

0.00 0.00 14.00 0.23

0.00 0.00 13.00 0.22

20

0.00 0.00

21

0.00 0.00 14.00 0.23

22

0.00 0.00 14.00 0.23

23

0.00 0.00

0.00 0.00 14.00 0.23

25

0.00 0.00 13.00 0.22

0.00 0.00 15.00 0.25

27

0.00 0.00 12.00 0.20

28

0.00 0.00 12.00 0.20

0.00 0.00

30

0.00 0.00

31

0.00 0.00

0.00 0.00 12.00 0.20

0.00 0.00 17.00

34

0.00 0.00 12.00 0.20

35

0.00 0.00 13.00 0.22

0.00 0.00 17.00 0.28

0.00 0.00 11.00 0.18

0.00 0.00 15.00 0.25

0.00 0.00

40

0.00 0.00 12.00 0.20

0.00 0.00 14.00 0.23

42

0.00 0.00 12.00 0.20

43

0.00 0.00 12.00 0.20

44

0.00 0.00 16.00

0.27

0.00 0.00 11.00 0.18

46

0.00 0.00 13.00 0.22

47

0.00 0.00 14.00 0.23

0.00 0.00 13.00 0.22

49

0.00 0.00 12.00 0.20

50

0.00 0.00 13.00 0.22

0.00 0.00 13.00 0.22

						Data Collection Sheet for Lab #	1
Only edit the yellow section. The rest is calculated.
Collect time to the second if possible.
Readings	Service Time	Diff Hr	Diff Min	Diff Sec	Decimal Min
0:00:00
0:01:1	6																																																																																																			0.00	1.00			16
1.2	7
3	0:02:00		4
	0.73
0:02:	13									13.00
		0.	22
5	0:02:	27			14
						0.	23
0:02:3	9			12
		0.	20
0:02:53								14.00													0.23
8	0:03:	11		18	0.	30	Process Summary:
0:03:27	16.00				0.27	Process of applying clear grain filler to wood veneer sheets. This is done by machine via roll coater but the machine is fed and emptied by hand. The service times logged are the times an operator fed the machine a new sheet of veneer. Time was taken when the veneer touched the conveyor belt.
10	0:03:	42			15
		0.	25
0:03:54									12.00																			0.20
0:04:09			15.00							0.25
0:04:	21
0:04:	35
0:04:	50
0:05:04
17	0:05:17															0.22
0:05:	31
19	0:05:	44
0:05:55			11.00
					0.18
0:06:09
0:06:23
0:06:	40			17.00
0.	28
24	0:06:54
0:07:07
26	0:07:22
0:07:	34
0:07:	46
29	0:08:12	26.00
0.	43
0:08:22	10.00
	0.17
0:08:50	28.00
0.	47
32	0:09:02
33	0:09:19					0.28
0:09:31
0:09:44
36	0:10:01
37	0:10:12
38	0:10:27
39	0:10:	49	22.00
	0.37
0:11:01
41	0:11:15
0:11:27
0:11:39
0:11:55
45	0:12:06
0:12:19
0:12:33
48	0:12:46
0:12:58
0:13:11
51	0:13:24

Run Conversion to dst

ISYE4500_Lab1

0.73
0.22
0.23
0.20
0.23

0.27
0.25
0.20
0.25
0.20
0.23
0.25
0.23
0.22
0.23
0.22
0.18
0.23
0.23
0.28
0.23
0.22
0.25
0.20
0.20

0.17

0.20
0.28
0.20
0.22
0.28
0.18
0.25
0.37
0.20
0.23
0.20
0.20
0.27
0.18
0.22
0.23
0.22
0.20
0.22
0.22

1.27
0.30
0.43	0.47