Pose nr

Maskine 1

Maskine 2

Maskine 3

Maskine 4

Opgave C1-3
En fabrik har fire maskiner, som laver poser med mel.
Der skal være mindst 250 gram i hver pose.
I regnearket er indsat vægten af 100 poser fra hver maskine.
Hvilken maskine er bedst?

C2: 252.4481
D2: 254.4463
E2: 252.0364
C3: 254.3986
D3: 257.0185
E3: 252.6825
C4: 256.111
D4: 252.5724
E4: 254.0869
C5: 253.9525
D5: 258.7837
E5: 252.4825
C6: 253.9333
D6: 258.7285
E6: 252.9205
C7: 252.2979
D7: 255.0685
E7: 252.8972
C8: 255.072
D8: 253.3421
E8: 252.4895
C9: 255.4256
D9: 255.9146
E9: 251.006
C10: 251.1492
D10: 254.8393
E10: 253.221
C11: 254.9616
D11: 256.2547
E11: 253.6348
C12: 254.892
D12: 254.824
E12: 253.9277
C13: 254.3166
D13: 260.5515
E13: 250.9812
C14: 255.5378
D14: 255.9173
E14: 253.9669
C15: 255.1767
D15: 253.584
E15: 253.7786
C16: 254.8109
D16: 256.4025
E16: 252.8475
C17: 254.3102
D17: 255.9022
E17: 253.9158
C18: 257.5178
D18: 259.8147
E18: 253.56
C19: 259.2549
D19: 255.5728
E19: 253.3601
C20: 252.8218
D20: 256.3561
E20: 252.1134
C21: 254.5466
D21: 258.3249
E21: 253.494
C22: 255.2531
D22: 256.3537
E22: 253.3078
C23: 253.4791
D23: 255.823
E23: 252.2
C24: 256.2304
D24: 256.4517
E24: 252.5917
C25: 257.4092
D25: 252.1259
E25: 251.3641
C26: 255.1341
D26: 257.2178
E26: 254.2347
C27: 255.6447
D27: 252.3577
E27: 252.2251
C28: 255.8227
D28: 257.5052
E28: 252.3685
C29: 254.3913
D29: 255.1451
E29: 250.9807
C30: 254.526
D30: 253.5015
E30: 252.8828
C31: 253.8492
D31: 257.6794
E31: 253.5292
C32: 252.7715
D32: 258.5773
E32: 252.1497
C33: 256.7254
D33: 259.1964
E33: 251.9752
C34: 256.9225
D34: 253.3489
E34: 252.8704
C35: 257.3342
D35: 256.0984
E35: 253.674
C36: 254.1311
D36: 257.2233
E36: 251.8309
C37: 252.7862
D37: 254.6963
E37: 252.1824
C38: 257.1176
D38: 250.9428
E38: 253.0177
C39: 253.6473
D39: 258.1148
E39: 254.1807
C40: 254.9423
D40: 259.099
E40: 252.3888
C41: 252.9644
D41: 256.8541
E41: 252.4038
C42: 254.6286
D42: 256.6174
E42: 251.4496
C43: 256.9076
D43: 251.0436
E43: 253.4492
C44: 253.6149
D44: 257.3129
E44: 252.8376
C45: 255.2151
D45: 257.0843
E45: 252.6014
C46: 254.3193
D46: 251.7238
E46: 253.505
C47: 254.9787
D47: 257.1923
E47: 252.8807
C48: 253.2699
D48: 256.3819
E48: 252.8547
C49: 254.5639
D49: 257.3791
E49: 253.5484
C50: 256.7485
D50: 254.8309
E50: 253.3872
C51: 255.6518
D51: 252.7646
E51: 251.6517
C52: 254.3518
D52: 256.6958
E52: 253.8289
C53: 254.6448
D53: 256.0586
E53: 253.188
C54: 254.6246
D54: 257.9709
E54: 252.2356
C55: 257.2613
D55: 256.3279
E55: 253.2647
C56: 257.1544
D56: 258.1674
E56: 252.532
C57: 255.3551
D57: 254.57
E57: 252.1716
C58: 254.7948
D58: 255.9235
E58: 252.3827
C59: 256.078
D59: 255.0996
E59: 253.0279
C60: 254.4338
D60: 256.1621
E60: 251.1023
C61: 253.9195
D61: 256.7929
E61: 252.4267
C62: 255.0459
D62: 256.1133
E62: 251.931
C63: 254.238
D63: 256.6724
E63: 251.7215
C64: 254.6664
D64: 252.9716
E64: 252.6436
C65: 258.812
D65: 256.0057
E65: 254.2982
C66: 255.7887
D66: 257.4877
E66: 253.0364
C67: 255.681
D67: 256.4806
E67: 249.837
C68: 255.5706
D68: 252.9104
E68: 253.2942
C69: 256.4427
D69: 252.3534
E69: 251.3502
C70: 252.8832
D70: 257.3903
E70: 253.2752
C71: 254.6666
D71: 256.0031
E71: 251.5745
C72: 255.7302
D72: 258.0586
E72: 252.683
C73: 252.0811
D73: 256.2366
E73: 254.387
C74: 255.857
D74: 255.9546
E74: 253.8947
C75: 255.9297
D75: 252.8992
E75: 252.3863
C76: 253.2564
D76: 253.8671
E76: 252.0909
C77: 257.5295
D77: 255.6976
E77: 251.9688
C78: 256.5531
D78: 255.5575
E78: 252.7297
C79: 256.0505
D79: 254.6812
E79: 252.518
C80: 254.3505
D80: 259.7143
E80: 252.4866
C81: 256.5562
D81: 259.5177
E81: 252.1361
C82: 256.1881
D82: 253.0425
E82: 252.9073
C83: 254.5533
D83: 257.2419
E83: 252.0492
C84: 252.0799
D84: 256.8981
E84: 253.6022
C85: 256.5317
D85: 257.5995
E85: 252.3266
C86: 256.2199
D86: 255.284
E86: 252.3117
C87: 256.2777
D87: 255.669
E87: 253.6369
C88: 256.7154
D88: 256.223
E88: 250.4349
C89: 255.4837
D89: 259.9054
E89: 251.0711
C90: 254.9334
D90: 255.4575
E90: 251.8676
C91: 256.5654
D91: 257.6286
E91: 252.1983
C92: 256.458
D92: 254.7192
E92: 252.3864
C93: 251.8126
D93: 255.5009
E93: 252.8401
C94: 256.082
D94: 254.5061
E94: 253.881
C95: 255.7408
D95: 256.8385
E95: 253.1033
C96: 259.2989
D96: 255.1698
E96: 252.378
C97: 256.8618
D97: 255.6496
E97: 251.6842
C98: 257.3219
D98: 256.2603
E98: 253.957
C99: 256.064
D99: 254.7052
E99: 252.8315
C100: 251.4095
D100: 257.1325
E100: 250.457
C101: 252.9976
D101: 257.379
E101: 253.0993
A2 = 1
A3: A2 + 1
A4: A3 + 1
A5: A4 + 1
A6: A5 + 1
A7: A6 + 1
A8: A7 + 1
A9: A8 + 1
A10: A9 + 1
A11: A10 + 1
A12: A11 + 1
A13: A12 + 1
A14: A13 + 1
A15: A14 + 1
A16: A15 + 1
A17: A16 + 1
A18: A17 + 1
A19: A18 + 1
A20: A19 + 1
A21: A20 + 1
A22: A21 + 1
A23: A22 + 1
A24: A23 + 1
A25: A24 + 1
A26: A25 + 1
A27: A26 + 1
A28: A27 + 1
A29: A28 + 1
A30: A29 + 1
A31: A30 + 1
A32: A31 + 1
A33: A32 + 1
A34: A33 + 1
A35: A34 + 1
A36: A35 + 1
A37: A36 + 1
A38: A37 + 1
A39: A38 + 1
A40: A39 + 1
A41: A40 + 1
A42: A41 + 1
A43: A42 + 1
A44: A43 + 1
A45: A44 + 1
A46: A45 + 1
A47: A46 + 1
A48: A47 + 1
A49: A48 + 1
A50: A49 + 1
A51: A50 + 1
A52: A51 + 1
A53: A52 + 1
A54: A53 + 1
A55: A54 + 1
A56: A55 + 1
A57: A56 + 1
A58: A57 + 1
A59: A58 + 1
A60: A59 + 1
A61: A60 + 1
A62: A61 + 1
A63: A62 + 1
A64: A63 + 1
A65: A64 + 1
A66: A65 + 1
A67: A66 + 1
A68: A67 + 1
A69: A68 + 1
A70: A69 + 1
A71: A70 + 1
A72: A71 + 1
A73: A72 + 1
A74: A73 + 1
A75: A74 + 1
A76: A75 + 1
A77: A76 + 1
A78: A77 + 1
A79: A78 + 1
A80: A79 + 1
A81: A80 + 1
A82: A81 + 1
A83: A82 + 1
A84: A83 + 1
A85: A84 + 1
A86: A85 + 1
A87: A86 + 1
A88: A87 + 1
A89: A88 + 1
A90: A89 + 1
A91: A90 + 1
A92: A91 + 1
A93: A92 + 1
A94: A93 + 1
A95: A94 + 1
A96: A95 + 1
A97: A96 + 1
A98: A97 + 1
A99: A98 + 1
A100: A99 + 1
A101: A100 + 1
B2: 249.6871
B3: 249.8618
B4: 255.2835
B5: 247.7757
B6: 250.4391
B7: 248.3699
B8: 254.4978
B9: 255.7269
B10: 250.7516
B11: 252.8324
B12: 251.4968
B13: 257.6027
B14: 249.3535
B15: 251.525
B16: 253.1995
B17: 250.3193
B18: 248.8501
B19: 253.6045
B20: 252.025
B21: 253.4826
B22: 251.3118
B23: 257.4657
B24: 249.9059
B25: 250.653
B26: 252.5198
B27: 249.9929
B28: 253.0187
B29: 251.1559
B30: 256.9826
B31: 251.5887
B32: 255.2401
B33: 254.3296
B34: 252.1949
B35: 254.0128
B36: 249.7596
B37: 249.6935
B38: 257.053
B39: 257.9112
B40: 252.4751
B41: 252.5012
B42: 253.1026
B43: 249.6452
B44: 251.402
B45: 252.3322
B46: 256.4331
B47: 251.0166
B48: 256.0954
B49: 252.7378
B50: 255.7947
B51: 258.8679
B52: 253.7462
B53: 251.8533
B54: 261.1163
B55: 253.1932
B56: 252.9614
B57: 249.5556
B58: 254.921
B59: 250.6666
B60: 248.0949
B61: 252.3134
B62: 254.8097
B63: 257.0429
B64: 252.0067
B65: 253.9262
B66: 254.8452
B67: 257.1912
B68: 254.347
B69: 252.147
B70: 255.6132
B71: 247.3517
B72: 247.5236
B73: 257.0856
B74: 253.6366
B75: 253.9804
B76: 253.8905
B77: 255.6001
B78: 247.6644
B79: 254.4454
B80: 255.6408
B81: 254.4854
B82: 251.4536
B83: 252.5029
B84: 252.6741
B85: 256.0864
B86: 254.2077
B87: 257.3813
B88: 254.5464
B89: 257.7167
B90: 258.9814
B91: 254.6612
B92: 247.4799
B93: 248.4299
B94: 254.2357
B95: 252.9569
B96: 255.3704
B97: 248.9857
B98: 254.2822
B99: 253.1993
B100: 254.6121
B101: 250.4106