assignment

profileJohnsonIntern
week1PastasRUs1.xlsx
Home>Business & Finance homework help>Operations Management homework help>assignment

ChartDataSheet_

This worksheet contains values required for MegaStat charts.
Residuals X data 3/19/2007 7:49.25
66 18 45177 34.4 31
69 16 51888 41.2 20
67 10 51379 40.3 24
70 4 66081 35.4 29
78 0 50999 31.5 18
62 28 41562 36.3 30
70 28 44196 35.1 14
84 29 50975 37.6 33
68 22 72808 34.9 28
60 42 79070 34.8 29
80 36 78497 36.2 39
64 32 41245 32.2 23
80 22 33003 30.9 22
88 78 90988 37.7 37
42 35 37950 34.3 24
68 32 45206 32.4 17
80 48 79312 32.1 37
84 32 37345 31.4 22
35 27 46226 30.4 36
84 24 70024 33.9 34
78 16 54982 35.6 26
80 39 54932 35.9 20
70 70 34097 33.6 20
76 33 46593 37.9 26
56 12 51893 40.6 21
65 32 88162 37.7 37
62 0 89016 36.4 34
66 20 114353 40.9 34
76 24 75366 35 30
92 36 48163 26.4 16
112 34 49956 37.1 28
66 15 45990 30.3 36
70 28 45723 31.3 18
60 15 43800 29.6 36
86 10 68711 32.9 18
76 0 65150 40.7 24
68 16 39329 29.3 22
64 0 63657 37.3 29
52 36 67099 39.8 25
78 26 75151 33.9 28
64 28 93876 35 40
82 32 79701 35 39
86 30 77115 35.9 30
92 16 52766 33 17
72 10 32929 30.9 22
90 24 87863 38.5 29
64 20 73752 40.5 19
80 20 85366 32.1 29
102 30 39180 34.8 18
70 26 56077 38 19
62 26 77449 37 34
68 20 56822 34.7 25
74 24 80470 36.4 30
84 14 55584 36.8 21
70 32 78001 32.2 30
96 32 75307 34.8 30
70 22 76375 36.7 28
76 32 61857 33.8 31
62 28 61312 34.2 16
92 23 72040 39 31
60 20 92414 34.9 40
54 15 92602 39.3 33
110 23 59599 35.6 28
78 0 72453 36 23
72 31 67925 41.1 16
74 29 42631 24.7 25
94 0 75652 40.5 25
80 16 39650 32.9 18
124 0 48033 30.3 15
46 20 67403 36.2 19
66 0 80597 32.4 27
63 28 60928 43.5 21
72 15 73762 41.6 29
76 24 64225 31.4 15
NormalPlot data 3/19/2007 7:49.03
-259.9497306439 -2.3669115357
-188.5900144767 -2.0061237235
-178.1863109741 -1.8007082352
-165.2888689211 -1.6514108613
-156.2930386781 -1.5318456091
-147.1995334043 -1.4308738679
-145.0204151759 -1.3426905457
-132.7962270775 -1.2638662791
-132.5838765031 -1.1921973902
-127.8657575015 -1.1261791757
-124.4916500844 -1.0647357757
-123.016384493 -1.0070695657
-118.431306853 -0.952571595
-110.8440652315 -0.9007655189
-110.1477551652 -0.8512709934
-109.3430277914 -0.8037789242
-105.1097263145 -0.7580342264
-104.7616892077 -0.7138235056
-100.1917272772 -0.6709660579
-96.9455399284 -0.6293071641
-78.5222407532 -0.588713006
-66.833182556 -0.5490667518
-63.9367962151 -0.5102654979
-54.9666697606 -0.4722178495
-49.5089341383 -0.4348419815
-43.817663257 -0.3980640685
-30.5622414309 -0.3618169976
-29.7056802184 -0.3260393031
-28.8211160258 -0.2906742745
-21.3829190469 -0.2556692022
-20.8096302471 -0.220974732
-18.0336858908 -0.1865443062
-16.4732294274 -0.152333674
-15.5268611118 -0.1183004556
-12.5832024808 -0.0844037498
-11.5991899485 -0.0506037738
-10.6416197419 -0.0168615273
-6.4663288735 0.0168615273
6.6082090726 0.0506037738
10.1026389027 0.0844037498
10.1556691582 0.1183004556
11.5424324103 0.152333674
13.4792557233 0.1865443062
15.0213966843 0.220974732
18.9663798116 0.2556692022
19.2122025279 0.2906742745
19.5938287738 0.3260393031
19.7419844304 0.3618169976
23.7470781354 0.3980640685
25.1736217387 0.4348419815
28.9194386872 0.4722178495
38.4697564504 0.5102654979
50.9831788417 0.5490667518
53.0357068283 0.588713006
61.102903906 0.6293071641
63.1204953548 0.6709660579
63.8380153718 0.7138235056
71.0833539728 0.7580342264
71.3281648375 0.8037789242
75.1828858929 0.8512709934
75.2802525469 0.9007655189
81.3206554357 0.952571595
81.6351025536 1.0070695657
105.576464442 1.0647357757
115.0253844293 1.1261791757
122.2233804168 1.1921973902
150.1178490106 1.2638662791
180.3934285167 1.3426905457
196.2671375845 1.4308738679
205.7993140008 1.5318456091
234.8563337617 1.6514108613
289.7338930992 1.8007082352
336.0904495556 2.0061237235
372.5195939607 2.3669115357
Residuals X data 3/19/2007 8:01.41
66 18 45177 34.4 31
69 16 51888 41.2 20
67 10 51379 40.3 24
70 4 66081 35.4 29
78 0 50999 31.5 18
62 28 41562 36.3 30
70 28 44196 35.1 14
84 29 50975 37.6 33
68 22 72808 34.9 28
60 42 79070 34.8 29
80 36 78497 36.2 39
64 32 41245 32.2 23
80 22 33003 30.9 22
88 78 90988 37.7 37
42 35 37950 34.3 24
68 32 45206 32.4 17
80 48 79312 32.1 37
84 32 37345 31.4 22
35 27 46226 30.4 36
84 24 70024 33.9 34
78 16 54982 35.6 26
80 39 54932 35.9 20
70 70 34097 33.6 20
76 33 46593 37.9 26
56 12 51893 40.6 21
65 32 88162 37.7 37
62 0 89016 36.4 34
66 20 114353 40.9 34
76 24 75366 35 30
92 36 48163 26.4 16
112 34 49956 37.1 28
66 15 45990 30.3 36
70 28 45723 31.3 18
60 15 43800 29.6 36
86 10 68711 32.9 18
76 0 65150 40.7 24
68 16 39329 29.3 22
64 0 63657 37.3 29
52 36 67099 39.8 25
78 26 75151 33.9 28
64 28 93876 35 40
82 32 79701 35 39
86 30 77115 35.9 30
92 16 52766 33 17
72 10 32929 30.9 22
90 24 87863 38.5 29
64 20 73752 40.5 19
80 20 85366 32.1 29
102 30 39180 34.8 18
70 26 56077 38 19
62 26 77449 37 34
68 20 56822 34.7 25
74 24 80470 36.4 30
84 14 55584 36.8 21
70 32 78001 32.2 30
96 32 75307 34.8 30
70 22 76375 36.7 28
76 32 61857 33.8 31
62 28 61312 34.2 16
92 23 72040 39 31
60 20 92414 34.9 40
54 15 92602 39.3 33
110 23 59599 35.6 28
78 0 72453 36 23
72 31 67925 41.1 16
74 29 42631 24.7 25
94 0 75652 40.5 25
80 16 39650 32.9 18
124 0 48033 30.3 15
46 20 67403 36.2 19
66 0 80597 32.4 27
63 28 60928 43.5 21
72 15 73762 41.6 29
76 24 64225 31.4 15
NormalPlot data 3/19/2007 8:01.03
-259.9497306439 -2.3669115357
-188.5900144767 -2.0061237235
-178.1863109741 -1.8007082352
-165.2888689211 -1.6514108613
-156.2930386781 -1.5318456091
-147.1995334043 -1.4308738679
-145.0204151759 -1.3426905457
-132.7962270775 -1.2638662791
-132.5838765031 -1.1921973902
-127.8657575015 -1.1261791757
-124.4916500844 -1.0647357757
-123.016384493 -1.0070695657
-118.431306853 -0.952571595
-110.8440652315 -0.9007655189
-110.1477551652 -0.8512709934
-109.3430277914 -0.8037789242
-105.1097263145 -0.7580342264
-104.7616892077 -0.7138235056
-100.1917272772 -0.6709660579
-96.9455399284 -0.6293071641
-78.5222407532 -0.588713006
-66.833182556 -0.5490667518
-63.9367962151 -0.5102654979
-54.9666697606 -0.4722178495
-49.5089341383 -0.4348419815
-43.817663257 -0.3980640685
-30.5622414309 -0.3618169976
-29.7056802184 -0.3260393031
-28.8211160258 -0.2906742745
-21.3829190469 -0.2556692022
-20.8096302471 -0.220974732
-18.0336858908 -0.1865443062
-16.4732294274 -0.152333674
-15.5268611118 -0.1183004556
-12.5832024808 -0.0844037498
-11.5991899485 -0.0506037738
-10.6416197419 -0.0168615273
-6.4663288735 0.0168615273
6.6082090726 0.0506037738
10.1026389027 0.0844037498
10.1556691582 0.1183004556
11.5424324103 0.152333674
13.4792557233 0.1865443062
15.0213966843 0.220974732
18.9663798116 0.2556692022
19.2122025279 0.2906742745
19.5938287738 0.3260393031
19.7419844304 0.3618169976
23.7470781354 0.3980640685
25.1736217387 0.4348419815
28.9194386872 0.4722178495
38.4697564504 0.5102654979
50.9831788417 0.5490667518
53.0357068283 0.588713006
61.102903906 0.6293071641
63.1204953548 0.6709660579
63.8380153718 0.7138235056
71.0833539728 0.7580342264
71.3281648375 0.8037789242
75.1828858929 0.8512709934
75.2802525469 0.9007655189
81.3206554357 0.952571595
81.6351025536 1.0070695657
105.576464442 1.0647357757
115.0253844293 1.1261791757
122.2233804168 1.1921973902
150.1178490106 1.2638662791
180.3934285167 1.3426905457
196.2671375845 1.4308738679
205.7993140008 1.5318456091
234.8563337617 1.6514108613
289.7338930992 1.8007082352
336.0904495556 2.0061237235
372.5195939607 2.3669115357

Data

Pastas R Us, Inc. Database (n = 74 restaurants)
Square Feet Per Person Average Spending Sales Growth Over Previous Year (%) Loyalty Card % of Net Sales Annual Sales Per Sq Ft Median HH Income (3 Miles) Median Age (3 Miles) % w/ Bachelor's Degree (3 Miles) Annual Sales
Differences
Obs SqFt Sales/Person SalesGrowth% LoyaltyCard% Sales/SqFt MedIncome MedAge BachDeg% Annual Sales min 499968.0
1 2354 6.81 -8.31 2.07 701.97 45177 34.4 31 1652437.4 Q1 877477.575 377509.6
2 2604 7.57 -4.01 2.54 209.93 51888 41.2 20 546657.7 Median 1035749.205 158271.6
3 2453 6.89 -3.94 1.66 364.92 51379 40.3 24 895148.8 Q3 1228866.96 193117.8
4 2340 7.13 -3.39 2.06 443.04 66081 35.4 29 1036713.6 Max 1746600.0 517733.0
5 2500 7.04 -3.30 2.48 399.20 50999 31.5 18 998000.0
6 2806 6.93 -1.94 2.96 264.64 41562 36.3 30 742579.8
7 2250 7.11 -0.77 2.28 571.59 44196 35.1 14 1286077.5 Bin Frequency Interval
8 2400 7.13 -0.37 2.34 642.25 50975 37.6 33 1541400.0 99 0.0 0-99
9 2709 6.58 -0.25 2.20 461.45 72808 34.9 28 1250068.1 199 1.0 100-199
10 1990 6.77 -0.17 2.34 638.82 79070 34.8 29 1271251.8 299 11.0 200-299
11 2392 6.66 0.47 2.09 484.38 78497 36.2 39 1158637.0 399 26.0 300-399
12 2408 7.03 0.55 2.47 581.09 41245 32.2 23 1399264.7 499 19.0 400-499
13 2627 7.03 0.77 2.04 267.71 33003 30.9 22 703274.2 599 10 500-599
14 2500 7.00 1.92 2.02 572.84 90988 37.7 37 1432100.0 699 5 600-699
15 1986 7.38 2.05 2.01 586.48 37950 34.3 24 1164749.3 2 700-799
16 2500 7.18 2.12 2.64 368.73 45206 32.4 17 921825.0
17 2668 7.35 2.84 2.22 351.47 79312 32.1 37 937722.0
18 2517 6.95 2.88 2.07 458.24 37345 31.4 22 1153390.1
19 1251 7.02 3.96 1.94 987.12 46226 30.4 36 1234887.1
20 2998 6.85 4.04 2.17 357.45 70024 33.9 34 1071635.1
21 2625 7.16 4.05 0.72 405.77 54982 35.6 26 1065146.3
22 2300 6.99 4.05 2.00 680.80 54932 35.9 20 1565840.0
23 2761 7.28 4.24 1.81 368.02 34097 33.6 20 1016103.2
24 2764 7.07 4.58 2.13 303.95 46593 37.9 26 840117.8
25 2430 7.05 5.09 2.50 393.90 51893 40.6 21 957177.0
26 2154 6.54 5.14 2.63 562.12 88162 37.7 37 1210806.5
27 2400 6.70 5.48 1.95 494.88 89016 36.4 34 1187712.0
28 2430 6.91 5.86 2.04 310.07 114353 40.9 34 753470.1
29 2549 7.58 5.91 1.41 373.46 75366 35.0 30 951949.5
30 2500 7.03 5.98 2.05 235.81 48163 26.4 16 589525.0
31 3653 6.84 6.08 2.13 413.08 49956 37.1 28 1508981.2
32 2440 6.94 6.08 2.08 625.22 45990 30.3 36 1525536.8
33 2600 7.07 6.13 2.73 274.30 45723 31.3 18 713180.0
34 2160 7.00 6.27 1.95 542.62 43800 29.6 36 1172059.2
35 2800 7.08 6.57 2.04 178.56 68711 32.9 18 499968.0
36 2757 6.75 6.90 1.62 375.33 65150 40.7 24 1034784.8
37 2450 6.81 6.94 1.95 329.09 39329 29.3 22 806270.5
38 2400 7.64 7.12 1.64 297.37 63657 37.3 29 713688.0
39 2270 6.62 7.39 1.78 323.17 67099 39.8 25 733595.9
40 2800 6.76 7.67 2.23 468.84 75151 33.9 28 1312752.0
41 2520 7.11 7.91 2.15 352.57 93876 35.0 40 888476.4
42 2487 7.05 8.08 2.83 380.34 79701 35.0 39 945905.6
43 2629 6.90 8.27 2.37 398.12 77115 35.9 30 1046657.5
44 3200 7.17 8.54 3.07 312.15 52766 33.0 17 998880.0
45 2335 6.75 8.58 2.19 452.16 32929 30.9 22 1055793.6
46 2500 7.45 8.72 1.28 698.64 87863 38.5 29 1746600.0
47 2449 7.00 8.75 1.76 367.19 73752 40.5 19 899248.3
48 2625 6.96 8.79 2.51 431.93 85366 32.1 29 1133816.3
49 3150 7.30 8.90 1.90 367.06 39180 34.8 18 1156239.0
50 2625 6.96 9.12 1.98 400.53 56077 38.0 19 1051391.3
51 2741 6.71 9.47 2.41 414.36 77449 37.0 34 1135760.8
52 2500 6.82 10.17 2.17 481.11 56822 34.7 25 1202775.0
53 2450 6.58 10.66 2.16 538.06 80470 36.4 30 1318247.0
54 2986 7.56 10.97 0.29 330.48 55584 36.8 21 986813.3
55 2967 6.98 11.34 1.85 249.93 78001 32.2 30 741542.3
56 3000 7.28 11.45 1.88 291.87 75307 34.8 30 875610.0
57 2500 6.76 11.51 2.19 517.40 76375 36.7 28 1293500.0
58 2600 6.92 11.73 2.56 551.58 61857 33.8 31 1434108.0
59 2800 6.73 11.83 2.16 386.81 61312 34.2 16 1083068.0
60 2986 6.91 11.95 2.10 427.50 72040 39.0 31 1276515.0
61 2223 6.77 12.47 1.98 453.94 92414 34.9 40 1009108.6
62 2300 7.33 12.80 0.87 512.46 92602 39.3 33 1178658.0
63 3799 7.87 13.78 1.07 345.27 59599 35.6 28 1311680.7
64 2700 6.95 14.09 3.38 234.04 72453 36.0 23 631908.0
65 2650 7.33 14.23 1.17 348.33 67925 41.1 16 923074.5
66 2500 6.95 14.60 2.14 348.47 42631 24.7 25 871175.0
67 2994 7.21 14.88 0.93 294.95 75652 40.5 25 883080.3
68 2718 7.25 15.42 2.22 361.14 39650 32.9 18 981578.5
69 3700 7.65 16.18 1.68 467.71 48033 30.3 15 1730527.0
70 2000 6.93 17.23 2.41 403.78 67403 36.2 19 807560.0
71 2400 6.79 18.43 2.81 245.74 80597 32.4 27 589776.0
72 2450 7.37 20.76 1.09 339.94 60928 43.5 21 832853.0
73 2575 6.76 25.54 0.64 400.82 73762 41.6 29 1032111.5
74 2400 7.97 28.81 1.77 326.54 64225 31.4 15 783696.0
Q1 2400 6.825 3.98 1.8575 332.845 46953 32.525 20.25 877477.575
Q3 2741 7.18 11.45 2.34 481.11 76375 37.6 30 1210806.48
IQR 341 0.355 7.47 0.4825 148.265 29422 5.075 9.75 333328.905

Noodles Database - Page &P of &N Printed &D Doane/Seward

Variabe Statistics

SqFt
Mean 2580.473
Standard Error 43.58345
Median 2500
Mode 2500
Standard Deviation 374.919
Sample Variance 140564.3
Kurtosis 3.760921
Skewness 0.527171
Range 2548
Minimum 1251
Maximum 3799
Sum 190955
Count 74
IQR 341
Sales/Person
Mean 7.044054
Standard Error 0.034556
Median 7
Mode 7.03
Standard Deviation 0.297261
Sample Variance 0.088364
Kurtosis 0.854399
Skewness 0.903632
Range 1.43
Minimum 6.54
Maximum 7.97
Sum 521.26
Count 74
IQR 0.355
SalesGrowth%
Mean 7.414054
Standard Error 0.770109
Median 7.03
Mode 4.05
Standard Deviation 6.62473
Sample Variance 43.88705
Kurtosis 1.146166
Skewness 0.493747
Range 37.12
Minimum -8.31
Maximum 28.81
Sum 548.64
Count 74
IQR 7.47
Sales/SqFt
Mean 420.3054
Standard Error 15.95377
Median 396.01
Mode ERROR:#N/A
Standard Deviation 137.2395
Sample Variance 18834.69
Kurtosis 2.880513
Skewness 1.235897
Range 808.56
Minimum 178.56
Maximum 987.12
Sum 31102.6
Count 74
IQR 148.625
LoyaltyCard%
Mean 2.026486
Standard Error 0.064212
Median 2.075
Mode 2.04
Standard Deviation 0.552371
Sample Variance 0.305114
Kurtosis 1.4536
Skewness -0.75689
Range 3.09
Minimum 0.29
Maximum 3.38
Sum 149.96
Count 74
IQR 0.4825
MedIncome
Mean 62807.7027
Standard Error 2081.329454
Median 62757
Mode ERROR:#N/A
Standard Deviation 17904.27295
Sample Variance 320562990
Kurtosis -0.511606009
Skewness 0.297838012
Range 81424
Minimum 32929
Maximum 114353
Sum 4647770
Count 74
IQR 29422
MedAge
Mean 35.20135
Standard Error 0.424833
Median 35
Mode 34.8
Standard Deviation 3.654552
Sample Variance 13.35575
Kurtosis 0.163881
Skewness -0.167
Range 18.8
Minimum 24.7
Maximum 43.5
Sum 2604.9
Count 74
IQR 5.075
BachDeg%
Mean 26.31081
Standard Error 0.814285
Median 26.5
Mode 29
Standard Deviation 7.004745
Sample Variance 49.06646
Kurtosis -0.9373
Skewness 0.140544
Range 26
Minimum 14
Maximum 40
Sum 1947
Count 74
IQR 9.75
Annual Sales
Mean 1059381.314
Standard Error 32598.56372
Median 1035749.205
Mode ERROR:#N/A
Standard Deviation 280423.4483
Sample Variance 78637310376
Kurtosis -0.132071628
Skewness 0.361413331
Range 1246632
Minimum 499968
Maximum 1746600
Sum 78394217.27
Count 74
IQR 333328.9

Annual Sales Box plot

The box plot does not loook symetrical. The variable is more skewed towards the minimum. I would prefer the standard deviation to describe this variable because the standard deviation indicates how dispersed values are from the mean.

Annual Sales

0 0 0 0 0 377509.57499999995 158271.63000000012 193117.75499999989 517733.04000000004

Histogram

Bin Frequency Interval
99 0 0-99
199 1 100-199
299 11 200-299
399 26 300-399
499 19 400-499
599 10 500-599
699 5 600-699
799 2 700-799
The data is skewed to the left
There is a single outlier in the 100-199 sales/sqft area
The area is smaller than the average sqft area
The best measure of central tendency to describe sales/sqft is standard deviation since there are outliers

Sales/Sqft

0-99 100-199 200-299 300-399 400-499 500-599 600-699 700-799 0 1 11 26 19 10 5 2

Sales/Sqft

Count