Question: The dataset ( attached in table form below ) is a basic items from grocery section of 4 different hypermarkets in Malaysia ( Giant: 1

The dataset (attached in table form below) is a basic items from 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 Ministry of Domestic Trade, Co-operatives and Consumerism - KPDNKK and asked to write the official report based on the collected data.
PLEASE ANSWER THE QUESTIONS WITH EVIDENCES SUCH AS GRAPH/CHARTS/TABLE/BOX/HISTOGRAM/BAR CHART and etc.
5. During the inquiry it was argued that there is a difference in supermarket prices across states due to the different size of markets in each states, transportation costs and other costs. How do you test that there is a significant difference of average pricess across three states? What do you find from your analysis? Demonstrate the use of statistical techniques in Business data; Demonstrate how to conduct hypothesis tests about mean, proportions and difference of means; Demonstrate the use of computer software to get necessary output. Demonstrate the skills of preparation of a managerial report.
DATA
Price name state location
82.051.001.001.00
83.131.001.001.00
83.431.001.001.00
83.611.001.001.00
83.201.001.001.00
81.211.001.002.00
80.291.001.002.00
80.881.001.002.00
81.711.001.002.00
81.921.001.002.00
78.221.002.001.00
78.861.002.001.00
80.491.002.001.00
82.111.002.001.00
82.631.002.001.00
83.891.002.002.00
91.651.002.002.00
79.161.002.002.00
81.161.002.002.00
80.581.002.002.00
81.311.003.001.00
90.301.003.001.00
86.691.003.001.00
83.391.003.001.00
83.831.003.001.00
77.771.003.002.00
87.621.003.002.00
87.931.003.002.00
89.451.003.002.00
90.411.003.002.00
82.642.001.001.00
82.842.001.001.00
80.212.001.001.00
77.002.001.001.00
77.712.001.001.00
81.182.001.002.00
81.182.001.002.00
79.632.001.002.00
84.222.001.002.00
84.312.001.002.00
81.202.002.001.00
86.692.002.001.00
81.052.002.001.00
81.492.002.001.00
81.872.002.001.00
81.252.002.002.00
83.662.002.002.00
84.582.002.002.00
85.022.002.002.00
81.992.002.002.00
84.172.003.001.00
81.452.003.001.00
82.722.003.001.00
88.152.003.001.00
80.922.003.001.00
80.582.003.002.00
81.182.003.002.00
81.382.003.002.00
81.552.003.002.00
81.552.003.002.00
86.053.001.001.00
82.933.001.001.00
85.033.001.001.00
85.693.001.001.00
86.513.001.001.00
83.753.001.002.00
83.083.001.002.00
83.833.001.002.00
82.913.001.002.00
84.823.001.002.00
81.453.002.001.00
86.08

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!