Question
In: Statistics and Probability
Q1. Quickmeal Description of data Quickmeal is a local grocery shop that carries a limited variety...
Q1. Quickmeal
Description of data
Quickmeal is a local grocery shop that carries a limited variety of meat products, vegetable and fruits, dairy products, and beverages. The owner of Quickmeal, let’s call him John, wants to expand his business. John wants to understand the purchasing behaviour of his customers, so he can predict future demands. He recorded daily sales of products in June. The dataset is called “Quickmeal”, which is available in different formats. It shows the daily sales in Canadian Dollars for four different types of products. This is the structure of data:
|
Day |
Day of the month |
|
Meat |
Sales of meat products in CAD |
|
Bev |
Sales of beverages in CAD (except dairy beverages) |
|
FRVEG |
Sales of all fruits and Vegetables in CAD |
|
Dairy |
Sales of all dairy products in CAD |
Analyze data and help John to understand his customers. Label your graphs appropriately and provide full descriptions.
- Prepare histogram and boxplot for beverages. Copy your plots (Label them as Figure 4 and Figure 5). Comment on data distribution. Do you see any unusual case(s)? (Hint. Let software take care of plots.) (4 points)
Data:
| day | meat | Bev | FRVEG | dairy |
| 1 | 201.5 | 58.2 | 211.2 | 75.5 |
| 2 | 153.5 | 57.3 | 213.5 | 65.7 |
| 3 | 210.5 | 49.5 | 249.5 | 75.3 |
| 4 | 209.5 | 51.5 | 279.5 | 74.4 |
| 5 | 189.5 | 53.5 | 283.5 | 80.9 |
| 6 | 348.5 | 61.5 | 303.5 | 79 |
| 7 | 401.5 | 63.5 | 421.5 | 73.6 |
| 8 | 225.68 | 64.602 | 232.32 | 85.1 |
| 9 | 171.92 | 63.603 | 234.85 | 78.6 |
| 10 | 235.76 | 54.945 | 274.45 | 82.2 |
| 11 | 234.64 | 57.165 | 307.45 | 70.9 |
| 12 | 212.24 | 59.385 | 311.85 | 91.8 |
| 13 | 390.32 | 68.265 | 333.85 | 85.9 |
| 14 | 449.68 | 70.485 | 463.65 | 72.9 |
| 15 | 259.532 | 73.64628 | 278.784 | 72.4 |
| 16 | 197.708 | 72.50742 | 281.82 | 68.1 |
| 17 | 271.124 | 62.6373 | 329.34 | 70.1 |
| 18 | 269.836 | 65.1681 | 368.94 | 60.5 |
| 19 | 244.076 | 67.6989 | 374.22 | 75.4 |
| 20 | 448.868 | 77.8221 | 400.62 | 62.3 |
| 21 | 517.132 | 80.3529 | 556.38 | 78.2 |
| 22 | 306.2478 | 84.693222 | 306.6624 | 67.8 |
| 23 | 233.2954 | 83.383533 | 310.002 | 70.5 |
| 24 | 319.9263 | 72.032895 | 362.274 | 71.1 |
| 25 | 318.4065 | 74.943315 | 405.834 | 60.3 |
| 26 | 288.0097 | 77.853735 | 411.642 | 70.7 |
| 27 | 673.302 | 116.73315 | 721.116 | 65 |
| 28 | 775.698 | 20 | 612.018 | 71.8 |
| 29 | 367.4973 | 110.1011886 | 321.99552 | 65.3 |
| 30 | 279.9545 | 100.0602396 | 325.5021 | 55.6 |
Solutions
Expert Solution
From histogram we observed that Sales of meat products in CAD (Meat) and Sales of all fruits and Vegetables in CAD (FRVEG) is positively skewed whereas Sales of beverages in CAD (Bev) and Sales of all dairy products in CAD (dairy) are symmetrically distributed.
From box plots we see that average sale of all fruits and Vegetables is higher than average sales of meat products in CAD. However average sales of beverages and dairy products in CAD are more or less same. Moreover sales of all fruits and Vegetables and sales of meat products in CAD are significantly higher than sales of beverages and dairy products in CAD.
Here we notice that data for sales of dairy product has no outliers, whereas data for other three products have outliers.
From above box plots we see that meat has maximum variation, dairy has smallest variation. However, variation of Bev and dairy are significantly low than meat and FRVEG.
orchestra answered 2 years agoRelated Solutions
The Chesapeake Grocery Store is a small local grocery that only carries fresh produce, poultry, and...
The Chesapeake Grocery Store is a small local grocery that only
carries fresh produce, poultry, and meat that are grown or raised
in the 50-mile radius of the grocery. The store also carries other
typical grocery items (such as packaged and canned goods). The
owner of the grocery, George Lampe, employs about 35–40 people. You
are a local CPA with a small firm in the Chesapeake area, and
George has retained you as his independent auditor. You are
currently reviewing...
Big Red soda is the "Faygo" of Texas. A local Texas grocery chain called H-E-B carries...
Big Red soda is the "Faygo" of Texas. A local Texas grocery
chain called H-E-B carries both name-brand Big Red soda and their
store-brand equivalent called Wild Red soda. It is known that the
sugar content of Big Red 20 ounce bottles is normally distributed
with a mean of 63 g and a standard deviation of 1.1 g. It is also
known that the sugar content of Wild Red 20 ounce bottles is
normally distrbuted with a mean of 68...
Madison Park Co-op, a whole foods grocery and gift shop, has provided the following data to...
Madison Park Co-op, a whole foods grocery and gift shop, has
provided the following data to be used in its service department
cost allocations: Service Departments Operating Departments
Administration Janitorial Groceries Gifts Departmental costs before
allocations $210,000 $60,000 $3,900,000 $350,000 Employee-hours 490
300 2,750 150 Space occupied—square feet 800 1,300 9,400 600
Required: Using the step-down method, allocate the costs of the
service departments to the two operating departments. Allocate
Administration first on the basis of employee-hours and then
Janitorial...
Wait-Times (Raw Data, Software Required): There are three registers at the local grocery store. I suspect...
Wait-Times (Raw Data, Software Required):
There are three registers at the local grocery store. I suspect the
mean wait-times for the registers are different. The sample data is
depicted below. It gives the wait-times in minutes.
Register 1
Register 2
Register 3
2.0
1.8
2.1
2.0
2.0
2.1
1.1
2.2
1.8
2.0
2.6
1.5
1.0
1.8
1.4
2.0
2.1
1.4
1.0
2.2
2.0
1.8
2.2
1.7
The Test: Complete the steps in testing the
claim that there is a difference...
Wait-Times (Raw Data, Software Required): There are three registers at the local grocery store. I suspect...
Wait-Times (Raw Data, Software Required):
There are three registers at the local grocery store. I suspect the
mean wait-times for the registers are different. The sample data is
depicted below. It gives the wait-times in minutes.
Register 1
Register 2
Register 3
2.0
1.8
2.1
2.0
2.0
2.1
1.1
2.2
1.8
2.0
1.9
1.5
1.0
1.8
1.4
2.0
2.1
1.4
1.0
2.2
2.0
1.8
2.1
2.1
The Test: Complete the steps in testing the
claim that there is a difference...
Wait-Times (Raw Data, Software Required): There are three registers at the local grocery store. I suspect...
Wait-Times (Raw Data, Software Required):
There are three registers at the local grocery store. I suspect the
mean wait-times for the registers are different. The sample data is
depicted below. It gives the wait-times in minutes.
Register 1
Register 2
Register 3
2.0
1.8
2.1
2.0
2.0
2.1
1.1
2.2
1.8
2.0
1.9
1.5
1.0
1.8
1.4
2.0
2.1
1.4
1.0
2.2
2.0
1.6
2.0
1.7
The Test: Complete the steps in testing the
claim that there is a difference...
2. Wait-Times (Raw Data, Software Required): There are three registers at the local grocery store. I...
2.
Wait-Times (Raw Data, Software Required):
There are three registers at the local grocery store. I suspect the
mean wait-times for the registers are different. The sample data is
depicted below. It gives the wait-times in minutes.
Register 1
Register 2
Register 3
2.0
1.8
2.1
2.0
2.0
2.1
1.1
2.2
1.8
2.0
1.9
1.5
1.0
1.8
1.4
2.0
2.1
1.4
1.0
2.2
2.0
1.4
2.2
1.8
The Test: Complete the steps in testing the
claim that there is a...
Wait-Times (Raw Data, Software Required): There are three registers at the local grocery store. I suspect...
Wait-Times (Raw Data, Software Required):
There are three registers at the local grocery store. I suspect the
mean wait-times for the registers are different. The sample data is
depicted below. It gives the wait-times in minutes.
Register 1
Register 2
Register 3
2.0
1.8
2.1
2.0
2.0
2.1
1.1
2.2
1.8
2.0
1.9
1.5
1.0
1.8
1.4
2.0
2.1
1.4
1.0
2.2
2.0
1.5
1.7
1.9
The Test: Complete the steps in testing the
claim that there is a difference...
Wait-Times (Raw Data, Software Required): There are three registers at the local grocery store. I suspect...
Wait-Times (Raw Data, Software Required):
There are three registers at the local grocery store. I suspect the
mean wait-times for the registers are different. The sample data is
depicted below. It gives the wait-times in minutes.
Register 1
Register 2
Register 3
2.0
1.8
2.1
2.0
2.0
2.1
1.1
2.2
1.8
2.0
1.9
1.5
1.0
1.8
1.4
2.0
2.1
1.4
1.0
2.2
2.0
1.4
1.8
2.0
The Test: Complete the steps in testing the
claim that there is a difference...
3 ID Limited (ID) has recently been incorporated as a private limited company and carries on...
3 ID Limited (ID) has recently been incorporated as a private
limited company and carries on fashion business. Donald is very
experienced in this field and is employed by ID as an agent to
purchase fashion clothes. Recently Donald has signed a contract
with E Bop Limited (E Bop) for purchase of jewelry which has not
been previously authorized by the company.
Advise the legal position of ID, in particular the rights and
liabilities it may have under the contract...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- In the article from Forbes notes that the goal of a leader is not to clone...
- Many people keep time using a 24 hour clock (11 is 11am and 23 is 11pm,...
- UNIX ONLY -- DIFFICULT LAB ASSIGNMENT This is an extremely difficult subject for me. Could you...
- Do you know why your credit card can be refused even though you are profitable?
- The Following Java expression: S/10 * 10 + 10 – S = C Show that this...
- Year Cash Flow 0 −$9,700 1 5,800 2 2,500 3 3,400 &nb
- In a two – story building, an exterior column is to be designed for a service...
ADVERTISEMENT