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\mathrm{.}051\mathrm{.}001\mathrm{.}001\mathrm{.}00$

$83\mathrm{.}131\mathrm{.}001\mathrm{.}001\mathrm{.}00$

$83\mathrm{.}431\mathrm{.}001\mathrm{.}001\mathrm{.}00$

$83\mathrm{.}611\mathrm{.}001\mathrm{.}001\mathrm{.}00$

$83\mathrm{.}201\mathrm{.}001\mathrm{.}001\mathrm{.}00$

$81\mathrm{.}211\mathrm{.}001\mathrm{.}002\mathrm{.}00$

$80\mathrm{.}291\mathrm{.}001\mathrm{.}002\mathrm{.}00$

$80\mathrm{.}881\mathrm{.}001\mathrm{.}002\mathrm{.}00$

$81\mathrm{.}711\mathrm{.}001\mathrm{.}002\mathrm{.}00$

$81\mathrm{.}921\mathrm{.}001\mathrm{.}002\mathrm{.}00$

$78\mathrm{.}221\mathrm{.}002\mathrm{.}001\mathrm{.}00$

$78\mathrm{.}861\mathrm{.}002\mathrm{.}001\mathrm{.}00$

$80\mathrm{.}491\mathrm{.}002\mathrm{.}001\mathrm{.}00$

$82\mathrm{.}111\mathrm{.}002\mathrm{.}001\mathrm{.}00$

$82\mathrm{.}631\mathrm{.}002\mathrm{.}001\mathrm{.}00$

$83\mathrm{.}891\mathrm{.}002\mathrm{.}002\mathrm{.}00$

$91\mathrm{.}651\mathrm{.}002\mathrm{.}002\mathrm{.}00$

$79\mathrm{.}161\mathrm{.}002\mathrm{.}002\mathrm{.}00$

$81\mathrm{.}161\mathrm{.}002\mathrm{.}002\mathrm{.}00$

$80\mathrm{.}581\mathrm{.}002\mathrm{.}002\mathrm{.}00$

$81\mathrm{.}311\mathrm{.}003\mathrm{.}001\mathrm{.}00$

$90\mathrm{.}301\mathrm{.}003\mathrm{.}001\mathrm{.}00$

$86\mathrm{.}691\mathrm{.}003\mathrm{.}001\mathrm{.}00$

$83\mathrm{.}391\mathrm{.}003\mathrm{.}001\mathrm{.}00$

$83\mathrm{.}831\mathrm{.}003\mathrm{.}001\mathrm{.}00$

$77\mathrm{.}771\mathrm{.}003\mathrm{.}002\mathrm{.}00$

$87\mathrm{.}621\mathrm{.}003\mathrm{.}002\mathrm{.}00$

$87\mathrm{.}931\mathrm{.}003\mathrm{.}002\mathrm{.}00$

$89\mathrm{.}451\mathrm{.}003\mathrm{.}002\mathrm{.}00$

$90\mathrm{.}411\mathrm{.}003\mathrm{.}002\mathrm{.}00$

$82\mathrm{.}642\mathrm{.}001\mathrm{.}001\mathrm{.}00$

$82\mathrm{.}842\mathrm{.}001\mathrm{.}001\mathrm{.}00$

$80\mathrm{.}212\mathrm{.}001\mathrm{.}001\mathrm{.}00$

$77\mathrm{.}002\mathrm{.}001\mathrm{.}001\mathrm{.}00$

$77\mathrm{.}712\mathrm{.}001\mathrm{.}001\mathrm{.}00$

$81\mathrm{.}182\mathrm{.}001\mathrm{.}002\mathrm{.}00$

$81\mathrm{.}182\mathrm{.}001\mathrm{.}002\mathrm{.}00$

$79\mathrm{.}632\mathrm{.}001\mathrm{.}002\mathrm{.}00$

$84\mathrm{.}222\mathrm{.}001\mathrm{.}002\mathrm{.}00$

$84\mathrm{.}312\mathrm{.}001\mathrm{.}002\mathrm{.}00$

$81\mathrm{.}202\mathrm{.}002\mathrm{.}001\mathrm{.}00$

$86\mathrm{.}692\mathrm{.}002\mathrm{.}001\mathrm{.}00$

$81\mathrm{.}052\mathrm{.}002\mathrm{.}001\mathrm{.}00$

$81\mathrm{.}492\mathrm{.}002\mathrm{.}001\mathrm{.}00$

$81\mathrm{.}872\mathrm{.}002\mathrm{.}001\mathrm{.}00$

$81\mathrm{.}252\mathrm{.}002\mathrm{.}002\mathrm{.}00$

$83\mathrm{.}662\mathrm{.}002\mathrm{.}002\mathrm{.}00$

$84\mathrm{.}582\mathrm{.}002\mathrm{.}002\mathrm{.}00$

$85\mathrm{.}022\mathrm{.}002\mathrm{.}002\mathrm{.}00$

$81\mathrm{.}992\mathrm{.}002\mathrm{.}002\mathrm{.}00$

$84\mathrm{.}172\mathrm{.}003\mathrm{.}001\mathrm{.}00$

$81\mathrm{.}452\mathrm{.}003\mathrm{.}001\mathrm{.}00$

$82\mathrm{.}722\mathrm{.}003\mathrm{.}001\mathrm{.}00$

$88\mathrm{.}152\mathrm{.}003\mathrm{.}001\mathrm{.}00$

$80\mathrm{.}922\mathrm{.}003\mathrm{.}001\mathrm{.}00$

$80\mathrm{.}582\mathrm{.}003\mathrm{.}002\mathrm{.}00$

$81\mathrm{.}182\mathrm{.}003\mathrm{.}002\mathrm{.}00$

$81\mathrm{.}382\mathrm{.}003\mathrm{.}002\mathrm{.}00$

$81\mathrm{.}552\mathrm{.}003\mathrm{.}002\mathrm{.}00$

$81\mathrm{.}552\mathrm{.}003\mathrm{.}002\mathrm{.}00$

$86\mathrm{.}053\mathrm{.}001\mathrm{.}001\mathrm{.}00$

$82\mathrm{.}933\mathrm{.}001\mathrm{.}001\mathrm{.}00$

$85\mathrm{.}033\mathrm{.}001\mathrm{.}001\mathrm{.}00$

$85\mathrm{.}693\mathrm{.}001\mathrm{.}001\mathrm{.}00$

$86\mathrm{.}513\mathrm{.}001\mathrm{.}001\mathrm{.}00$

$83\mathrm{.}753\mathrm{.}001\mathrm{.}002\mathrm{.}00$

$83\mathrm{.}083\mathrm{.}001\mathrm{.}002\mathrm{.}00$

$83\mathrm{.}833\mathrm{.}001\mathrm{.}002\mathrm{.}00$

$82\mathrm{.}913\mathrm{.}001\mathrm{.}002\mathrm{.}00$

$84\mathrm{.}823\mathrm{.}001\mathrm{.}002\mathrm{.}00$

$81\mathrm{.}453\mathrm{.}002\mathrm{.}001\mathrm{.}00$

$86\mathrm{.}08$