Data Analysis of Actual Fill Volume vs. Labeled Fill Volume

        After collecting and recording the filled volume in fluid ounces of the sealed water bottles, the data will be stored and organized in a Microsoft Excel spreadsheet for analysis. Data will be analyzed by spreading the data on the excel sheet and the MS Excel is used to conducting the various analysis in this research study. Two types of the analysis are included in this reach study as descriptive and inferential analysis.

Descriptive analysis of Actual Fill Volume vs. Labeled Fill Volume

    Descriptive analysis is used to measuring the demographics of the sample such as in this study mean mode median, average standard deviation is using in the descriptive analysis of the research study.

        With the successful collection of raw data, it was able to derive various descriptive measures (shown in Table 1). It has found Sample mean for Dasani Bottled Water to be 16.93. Respectively, for Great Value Bottled Water it was 17.17. The median for Dasani Bottled Water was 16.95. It was 17.15 for Great Value Bottled Water. Standard Deviation and Sample Variance for Great Value Bottled Water were also notably higher than that of the Dasani Bottled Water. Interestingly, the Great Value Bottled Water featured a slightly smaller range of 0.20 versus the Dasani Bottled Water’s range of 0.25. However, both of these ranges fall well within our expected range of plus or minus 0.5 fl oz.

        The created Box and Whisker Plots (Figure 1 and Figure 2) do a great job at graphically depicting the various descriptive measures presented in Table 1. The Box and Whisker Plots show the median of the two data sets, and their respective variation. The medians presented in Box and Whisker Plots (Figure 1 and Figure 2) are in perfect congruence with the data presented in Table 1. However, for both data sets (Figure 1 and Figure 2) the positioning of the median reveals that the distributions are skewed. The Great Value Water (Figure 2) features a slightly lower amount of variation than that of the Dasani Water (Figure 1). Furthermore, both Box and Whisker Plots (Figure 1 and Figure 2) show that there are no outliers in either sample set.

        For our second method of graphical representation of our data, we chose a Bar Graph. This Bar Graph does a great job at providing different descriptive view to our data. It cleanly depicts a direct comparison of our full raw data set. It features Volume (fl oz) on the Y-axis and Bottle number (20 bottle sample for both brands). It also features a red line denoting the targeted fill volume of 16.9 fl oz. In comparison of this red line to the graphical bars, it is clear that our hypothesis of that the known or bigger brand (Dasani) is indeed more accurate to the desired 16.9 fl oz than the generic brand (Great Value).