Data Analysis Essay
[pic 1][pic 2]Solution for Q1:For this question, one-way ANOVA in combination with Tukey-Kramer Procedure is used to answer from part A to C in order to evaluate the difference in the average price of the baskets of 34 common grocery items at different supermarkets. The independent variable is price of 34 items from there different supermarket chains: (1) Coles, (2) Woolsworth and (3) Others.ANOVA hypothesis testing: First, we key in the data for each of the stores in the excel sheet as follows:[pic 3]We clicked â€śDataâ€ť, followed by â€śData analysisâ€ť, reaching â€śData Analysisâ€ť as shown below,[pic 4]We highlighted the data for â€śInput Rangeâ€ť and we ticked â€śLabels in First Rowâ€ť. Clicked â€śOKâ€ť[pic 5]Result shown as follows,[pic 6]AnalysisNull Hypothesis: HOÂ = There is significant difference in the average price of basket of 34 items at different supermarkets?Alternate Hypothesis: H1Â = There is no significant difference in the average price of basket of 34 items at different supermarketsReject HoÂ if p-value < 0.05Accept Ho if p-value >= 0.05As seen in (a), p-value = 0.00106. Reject Ho.There is no significant difference of grocery prices among supermarkets.No. Significant difference in the average price of the basket at different stores does not mean that larger buying power of those chains makes them cheaper than other supermarket. Â It just means that there is a difference in the average price of the basket at different stores.C) To understand the comparison better, we have done the Tukey Kramer Multiple Comparisons. The output is as follows:Tukey Kramer Multiple ComparisonsÂ SampleSampleÂ GroupMeanSizeÂ 1100.270416748Â 2102.6562548Â 3101.462708348Â Other DataLevel of significance0.05Numerator d.f.3Denominator d.f.141MSW9.499739465Q Statistic3.31Â AbsoluteStd. ErrorCriticalÂ ComparisonDifferenceof DifferenceRangeResultsGroup 1 to Group 22.3858333330.444872161.47252685Means are differentGroup 1 to Group 31.1922916670.444872161.47252685Means are not differentGroup 2 to Group 31.1935416670.444872161.47252685Means are not differentConclusion: There is significant difference in the average price at different stores. But the other supermarkets have the same price as Coles and Woolworths supermarkets since there is no difference between group 1 (Coles) and 2 (Woolworths) with group 3 (other). Hence we canâ€™t agree with first group of analysts, who believe that the largest buying power of Coles and Woolworths supermarket make them cheaper than other supermarkets.