Assignment: Experimental Research
Title: Comparison between Five Mineral Water Brands.
Author: Mr. Saurabh Rajendra Jadhav.(MMS) Kohinoor Business School. Roll no:58
Introduction: Mineral water is water from a mineral spring that contains various minerals, such as salts and sulfur compounds. Mineral water may usually be still or sparkling (carbonated/effervescent) according to the presence or absence of added gases.
Today, it is far more common for mineral water to be bottled at the source for distributed consumption. Travelling to the mineral water site for direct access to the water is now uncommon, and in many cases not possible because of exclusive commercial ownership rights. There are more than 4,000 brands of mineral water commercially available worldwide.
The mineral water brands were compared in this research study are,
1) Bisleri 2) Kinley 3) AquaFina 4) Evian 5) Rajhans
OBJECTIVE OF THE STUDY: To compare five mineral brands by one way ANOVA.
HYPOTHESIS: H0: All brands are same (Bisleri=Kinley=AquaFina=Evian=Rajhans)
H1: Anyone among them is different.
DATA COLLECTION: The data was collected by the survey conducted through Google form, and asked people to rank these brands from the scale 1 to 10 as per their past experience.
DATA ANALYSIS: The data were analyzed by the ANOVA method based on the data collected by the survey.
Anova :Single Factor
SUMMARY
Groups Count Sum Average Variance
Bisleri 49 451 9.204082 0.62415
Kinley 49 416 8.489796 1.255102
AquaFina 49 339 6.918367 2.534864
Evian 49 314 6.408163 4.704932
Rajhans 49 277 5.653061 2.356293

ANOVA
Source of Variation SS df MS F P-value F crit
Between Groups 425.7388 4 106.4347 46.3754 7.66E-29 2.409257
Within Groups 550.8163 240 2.295068

Total 976.5551 244

Anova: Two-Factor without Replication.
Kinley 49 416 8.489796 1.255102
AquaFina 49 339 6.918367 2.534864
Evian 49 314 6.408163 4.704932
Rajhans 49 277 5.653061 2.356293

ANOVA
Source of Variation SS df MS F P-value F crit
Rows 289.051 48 6.021896 3.740855 5.52E-10 1.445925
Columns 211.6939 3 70.56463 43.83537 3.46E-20 2.667443
Error 231.8061 144 1.609765

Total 732.551 195

CONCLUSION: The calculated F(3.74) is more than Crit F(1.445), We accept H1 and reject H0. Which means at least one of the five brands is different.