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.

$4.$ Visually present data for the prices of Basic Staple basket 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 measures of location, shape and variability of those distributions. Demonstrate the use of basic statistical concepts such as mean, median, standard deviation and coefficient of variation in business data; 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{.}083\mathrm{.}002\mathrm{.}001\mathrm{.}00$

$87\mathrm{.}993\mathrm{.}002\mathrm{.}001\mathrm{.}00$

$88\mathrm{.}123\mathrm{.}002\mathrm{.}001\mathrm{.}00$

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