Description
Preparation
Review the Wk 2 Summative Assessment: Pastas R Us Statistical Report assessment.
Download the Pastas R Us data file.
Assignment Deliverable
Complete the following on the Data tab of the Pastas R Us data file:
Calculate “Annual Sales” for each restaurant. Annual Sales is the result of multiplying a restaurant’s “SqFt.” by “Sales/SqFt.” The first value has been provided for you.
Calculate the mean, standard deviation, skew, 5-number summary, and interquartile range (IQR) for each of the variables. The formulas and the first results have been provided for you.
Create a boxplot (sometimes referred to as a box and whisker chart) for the “Annual Sales” variable.
Create a histogram for the “Sales/SqFt” variable.
Respond to the following questions on the Questions tab of the Pastas R Us data file:
Does the annual sales boxplot look symmetric?
Would you prefer the IQR instead of the standard deviation to describe the dispersion of the annual sales variable? If so, why?
Does the histogram show that the sales per square foot distribution is symmetric?
If the sales per square foot distribution is not symmetric, what is the skew?
If there are any outliers, which one(s)? What is the “SqFt” area of the outlier(s)?
Is the outlier(s) smaller or larger than the average restaurant in the data? What can you conclude from this observation?
What measure of central tendency may be more appropriate to describe “Sales/SqFt”? Why?
Submit your assignment.
Assignment Support
Review “Create a Histogram” from Microsoft 365 Support to learn how to create a histogram in Microsoft Excel.
Review “Create a Box and Whisker Chart” from Microsoft 365 Support to learn how to create a box plot in Microsoft Excel.
Watch the selections from “Mastering Basic Charts and Graphs” from LinkedIn Learning in this week’s learning activities to see how to create histograms and box and whisker charts in Excel.
Watch “Excel Quick Tips” from LinkedIn Learning in this week’s learning activities to get answers to common questions about working with data in Excel.
Unformatted Attachment Preview
Location number
(Obs)
Obs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
Per Person
Sales Growth Over Loyalty Card % of Annual Sales Median Household Income Median Age
Square Feet Average Spending Previous Year (%)
Net Sales
Per Sq Ft
(3 Miles)
(3 Miles)
SqFt
Sales/Person
SalesGrowth%
LoyaltyCard%
Sales/SqFt
MedIncome
MedAge
2354
6,81
-8,31
2,07
701,97
45177
34,4
2604
7,57
-4,01
2,54
209,93
51888
41,2
2453
6,89
-3,94
1,66
364,92
51379
40,3
2340
7,13
-3,39
2,06
443,04
66081
35,4
2500
7,04
-3,30
2,48
399,20
50999
31,5
2806
6,93
-1,94
2,96
264,64
41562
36,3
2250
7,11
-0,77
2,28
571,59
44196
35,1
2400
7,13
-0,37
2,34
642,25
50975
37,6
2709
6,58
-0,25
2,20
461,45
72808
34,9
1990
6,77
-0,17
2,34
638,82
79070
34,8
2392
6,66
0,47
2,09
484,38
78497
36,2
2408
7,03
0,55
2,47
581,09
41245
32,2
2627
7,03
0,77
2,04
267,71
33003
30,9
2500
7,00
1,92
2,02
572,84
90988
37,7
1986
7,38
2,05
2,01
586,48
37950
34,3
2500
7,18
2,12
2,64
368,73
45206
32,4
2668
7,35
2,84
2,22
351,47
79312
32,1
2517
6,95
2,88
2,07
458,24
37345
31,4
1251
7,02
3,96
1,94
987,12
46226
30,4
2998
6,85
4,04
2,17
357,45
70024
33,9
2625
7,16
4,05
0,72
405,77
54982
35,6
2300
6,99
4,05
2,00
680,80
54932
35,9
2761
7,28
4,24
1,81
368,02
34097
33,6
2764
7,07
4,58
2,13
303,95
46593
37,9
2430
7,05
5,09
2,50
393,90
51893
40,6
2154
6,54
5,14
2,63
562,12
88162
37,7
2400
6,70
5,48
1,95
494,88
89016
36,4
2430
6,91
5,86
2,04
310,07
114353
40,9
2549
7,58
5,91
1,41
373,46
75366
35,0
2500
7,03
5,98
2,05
235,81
48163
26,4
3653
6,84
6,08
2,13
413,08
49956
37,1
2440
6,94
6,08
2,08
625,22
45990
30,3
2600
7,07
6,13
2,73
274,30
45723
31,3
2160
7,00
6,27
1,95
542,62
43800
29,6
Noodles Database – Page 1 of 8
Printed 1/12/2024
Doane/Seward
Location number
(Obs)
Obs
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
Per Person
Sales Growth Over Loyalty Card % of Annual Sales Median Household Income Median Age
Square Feet Average Spending Previous Year (%)
Net Sales
Per Sq Ft
(3 Miles)
(3 Miles)
SqFt
Sales/Person
SalesGrowth%
LoyaltyCard%
Sales/SqFt
MedIncome
MedAge
2800
7,08
6,57
2,04
178,56
68711
32,9
2757
6,75
6,90
1,62
375,33
65150
40,7
2450
6,81
6,94
1,95
329,09
39329
29,3
2400
7,64
7,12
1,64
297,37
63657
37,3
2270
6,62
7,39
1,78
323,17
67099
39,8
2800
6,76
7,67
2,23
468,84
75151
33,9
2520
7,11
7,91
2,15
352,57
93876
35,0
2487
7,05
8,08
2,83
380,34
79701
35,0
2629
6,90
8,27
2,37
398,12
77115
35,9
3200
7,17
8,54
3,07
312,15
52766
33,0
2335
6,75
8,58
2,19
452,16
32929
30,9
2500
7,45
8,72
1,28
698,64
87863
38,5
2449
7,00
8,75
1,76
367,19
73752
40,5
2625
6,96
8,79
2,51
431,93
85366
32,1
3150
7,30
8,90
1,90
367,06
39180
34,8
2625
6,96
9,12
1,98
400,53
56077
38,0
2741
6,71
9,47
2,41
414,36
77449
37,0
2500
6,82
10,17
2,17
481,11
56822
34,7
2450
6,58
10,66
2,16
538,06
80470
36,4
2986
7,56
10,97
0,29
330,48
55584
36,8
2967
6,98
11,34
1,85
249,93
78001
32,2
3000
7,28
11,45
1,88
291,87
75307
34,8
2500
6,76
11,51
2,19
517,40
76375
36,7
2600
6,92
11,73
2,56
551,58
61857
33,8
2800
6,73
11,83
2,16
386,81
61312
34,2
2986
6,91
11,95
2,10
427,50
72040
39,0
2223
6,77
12,47
1,98
453,94
92414
34,9
2300
7,33
12,80
0,87
512,46
92602
39,3
3799
7,87
13,78
1,07
345,27
59599
35,6
2700
6,95
14,09
3,38
234,04
72453
36,0
2650
7,33
14,23
1,17
348,33
67925
41,1
2500
6,95
14,60
2,14
348,47
42631
24,7
2994
7,21
14,88
0,93
294,95
75652
40,5
2718
7,25
15,42
2,22
361,14
39650
32,9
Noodles Database – Page 2 of 8
Printed 1/12/2024
Doane/Seward
Location number
(Obs)
Obs
69
70
71
72
73
74
Mean
Standard. Dev.
Min
Q1
Median
Q3
Max
Skew
IQR
Per Person
Sales Growth Over Loyalty Card % of Annual Sales Median Household Income Median Age
Square Feet Average Spending Previous Year (%)
Net Sales
Per Sq Ft
(3 Miles)
(3 Miles)
SqFt
Sales/Person
SalesGrowth%
LoyaltyCard%
Sales/SqFt
MedIncome
MedAge
3700
7,65
16,18
1,68
467,71
48033
30,3
2000
6,93
17,23
2,41
403,78
67403
36,2
2400
6,79
18,43
2,81
245,74
80597
32,4
2450
7,37
20,76
1,09
339,94
60928
43,5
2575
6,76
25,54
0,64
400,82
73762
41,6
2400
7,97
28,81
1,77
326,54
64225
31,4
2580,47
372,38
1251,00
2400,00
2500,00
2735,25
3799,00
0,53
335,25
Noodles Database – Page 3 of 8
Printed 1/12/2024
Doane/Seward
Location number % w/ Bachelor’s Degree
(Obs)
(3 Miles)
Obs
BachDeg%
1
31
2
20
3
24
4
29
5
18
6
30
7
14
8
33
9
28
10
29
11
39
12
23
13
22
14
37
15
24
16
17
17
37
18
22
19
36
20
34
21
26
22
20
23
20
24
26
25
21
26
37
27
34
28
34
29
30
30
16
31
28
32
36
33
18
34
36
Noodles Database – Page 4 of 8
Annual Sales
(in $000)
AnnualSales
1652,4
Printed 1/12/2024
Doane/Seward
Location number % w/ Bachelor’s Degree
(Obs)
(3 Miles)
Obs
BachDeg%
35
18
36
24
37
22
38
29
39
25
40
28
41
40
42
39
43
30
44
17
45
22
46
29
47
19
48
29
49
18
50
19
51
34
52
25
53
30
54
21
55
30
56
30
57
28
58
31
59
16
60
31
61
40
62
33
63
28
64
23
65
16
66
25
67
25
68
18
Noodles Database – Page 5 of 8
Annual Sales
(in $000)
AnnualSales
Printed 1/12/2024
Doane/Seward
Location number % w/ Bachelor’s Degree
(Obs)
(3 Miles)
Obs
BachDeg%
69
15
70
19
71
27
72
21
73
29
74
15
Annual Sales
(in $000)
AnnualSales
Mean
Standard. Dev.
Min
Q1
Median
Q3
Max
Skew
IQR
Noodles Database – Page 6 of 8
Printed 1/12/2024
Doane/Seward
Question
Does the annual sales box plot chart look symmetric?
Would you prefer the IQR instead of the standard
deviation to describe the dispersion of the annual
sales variable? If so, why?
Does the histogram show that the sales per square
foot distribution is symmetric?
If the sales per square foot distrubiton is not
symmetric, what is the skew?
If there are any outliers, which one(s)? What is the
“SqFt” area of the outlier(s)?
Is the outlier(s) smaller or larger than the average
restaurant in the database? What can you conclude
from this observation?
What measure of central tendency may be more
appropriate to describe “Sales/SqFt”? Why?
Answer
Purchase answer to see full
attachment
