Statistics and Decision Analysis Report, APU, Malaysia The current dataset is related to the basic items from grocery section of 4 different hypermarkets in Malaysia

Case Study

The current dataset is related to the basic items from the grocery section of 4 different hypermarkets in Malaysia (Giant: 1, Tesco: 2, Aeon :3, Mydin: 4). Data were collected from three different states (Selangor: 1, Penang: 2, Pahang: 3) and from Metropolitans (1) and other places (2). You are appointed as a senior consultant of the Ministry of Domestic Trade, Co-operatives, and Consumerism – KPDNKK and asked to write the official report based on the collected data.

Task:

1. Visually present data for the prices of Basic Staple baskets at different supermarkets. Calculate descriptive statistics for the prices of Basic Staple baskets at different supermarkets. Comments on the location, shape, and variability of those distributions.
2. Visually present data for the prices of Basic Staple baskets across three States among the supermarkets. Calculate descriptive statistics for the prices of Basic Staple baskets across three States among the supermarkets. Comments on the location, shape, and variability of those distributions.
3. Visually present data for the prices of Basic Staple baskets at different locations among the supermarkets. Calculate descriptive statistics for the prices of Basic Staple baskets at different locations among the supermarkets. Comments on the location, shape, and variability of those distributions.
4. Visually present data for the prices of Basic Staple baskets of Giant stores in three states. Calculate descriptive statistics for the prices of Basic Staple baskets of Giant stores in three states. Comments on the location, shape, and variability of those distributions.

Part Two 

You are required to demonstrate the following knowledge and skills in this part two

1. Demonstrate the use of statistical techniques in Business data;
2. Demonstrate how to conduct hypothesis tests about mean, proportions, and difference of means;
3. Demonstrate the use of computer software to get necessary output.
4. Demonstrate the skills of preparation of a managerial report

Task:

1. During the inquiry, it was argued that there are differences in supermarket prices at different locations. How do you test that there is a significant difference in average prices at different locations for supermarkets? What do you find from your analysis?
2. Giant claims that they have a national pricing policy; the policy excludes fresh fruit, vegetables, and regional bakery lines. How do you test whether there is a significant difference in average prices of Giant stores in different locations? What do you find from your analysis?
3. Test the claim that the average price of Basic Staple basket in Penang is significantly different compared to the in Selangor.
4. Two larger supermarket chains, Aeon and Tesco control nearly 70% of the grocery market. During the inquiry, it argued that the larger buying power of those chains makes them cheaper than other supermarkets. On the other hand, another group argued that there is no significant difference in grocery prices among supermarkets. Using the data collected, how do you test the claim that there is no significant difference in the average prices for the Basic Staple basket at different supermarkets? What do you find from your analysis?
5. During the inquiry, it was argued that there is a difference in supermarket prices across States due to the different sizes of the markets in each State, transportation costs, and other costs. How do you test that there is a significant difference in average prices across three States? What do you find from your analysis?

Answer

Request Answer of this Assignment