Quantitative Analysis of Soft Drinks Market at USC - BAC21 Project

This report investigates the soft drinks market at USC, analyzing data collected from a sample of students to understand their preferences and consumption patterns. The study considers various factors such as drink types (soft drinks, tea/coffee, energy drinks, fruit juices, and others), price levels, and the impact of discounts on brand preference. The analysis reveals that 'other' drinks (water and milk) are the most popular among students. It also explores differences in consumption between domestic and international students, finding that demand decreases as price increases for both groups. Furthermore, the report examines the proportion of students willing to switch brands based on discount levels, indicating a higher likelihood of change with a 40% discount compared to a 25% discount. The findings offer valuable insights into the dynamics of the soft drinks market at USC.

Running head: QUANTITATIVE METHODS
QUANTITATIVE METHODS
Name of the student:
Name of the University:
Author’s note:

1
QUANTITATIVE METHODS
Executive summary
It is being said that drinks are circulated in colleges and the college want to investigate about the
popularity of the drinks. There are four varieties of the drinks and different price levels. . So, the
analysis is being made here with dataset collected from national students and international
students. The analysis is being made in excel and results are depicted below.

2
QUANTITATIVE METHODS
Table of Contents
Introduction......................................................................................................................................2
Analysis...........................................................................................................................................2
Conclusion.......................................................................................................................................4
References........................................................................................................................................5

3
QUANTITATIVE METHODS
Introduction
It is being said that drinks are circulated in colleges and the college want to investigate
about the popularity of the drinks. The analysis can help them to choose and keep backup of the
required drinks. There are four varieties of the drinks and different price levels. Discounts are
also being offered at certain drinks. So, the analysis is being made here with dataset collected
from national students and international students.
Analysis
Purpose of this report is to understand student’s soft drinks market in the university. The drinks
market is measured in terms of 375ml cans. Data are being collected from domestic and
international students. There are different variety of drinks like soft drinks, tea/coffee, energy
drinks, fruit juices and other (Ward et al. 2016). The others part include water and milk drinks.
There are different price level of the drinks as well like $0.50, $1, $1.50, $2, $2.50, 43, $3.50,
$4, $4.50 and $5. Drinks were also ranked on the basis of first preference, second preference,
third preference and fourth preference. Each of the variety of drink are being ranked in the said
way and recorded. Again, there is another column in the data set on whether the students will
change their preferences if being offered a discount. There are answers for 25 % discount and 40
% discount. The data set are tallie4d and calculated in excel and the results are written below.
Required answers are:
1. A sample of 80 students is being collected randomly from the college. They were being
collected irrespective of domestic and international students. Proportion of national

4
QUANTITATIVE METHODS
students in the sample is 0.92 and proportion of international students in the sample is
0.075.
2. It can be seen from the dataset that with an increase in price, there is a decrease in the
average quantity of drinks consumed (Rahayu and Wahyudi 2017). It can be seen here
that when the price was lowest that is $0.50; quantity of drinks consumed was the
maximum that is 2360. Prices have raised from $0.50 to $5 gradually and the quantity
consumed has decreased gradually. At price $5, the quantity consumed is 150.
3. Given are the result of consumption of soft drinks, fruit juice, Tea/Coffee, Energy drinks
and others(water, milk drinks etc), it can be seen that among the four varieties, the most
popular one is others (water, milk, drinks etc) as it is the first preference of the maximum
number of people (Chuosavasdi et al. 2016). The rest of the drinks are being consumed
at a much lower quantity.
4. In case of 25% reduction in cost, a proportion of 0.175 students are expected to change
their brand and a proportion of 0.825 students are expected not to change their brand
(Jackson et al. 2016). Again in case of 40% reduction in cost, a proportion of 0.50
student are expected to change their brand preference. Simultaneously, a proportion of
0.50 students are expected not to change their brand.
5. There is no difference between demands of international students and that of national
students (Xiao and Jiang 2017). In case of domestic students, consumption goes down
as price goes up. Again in the case in international students, demand goes down as
consumption goes up. Therefore, both are the same.
6. It can be said here that international students mostly prefer fruit juice and others like
water and milk drinks. Again, domestic students are said to prefer other drinks the most

5
QUANTITATIVE METHODS
that is water and milk drinks. Soft drinks can be taken to be preferred in the second
position.
7. It is likely that a proportion of 0.2125 students will choose soft drinks as their first
preferences (Von Mises 2016). An upper and a lower interval can be calculated here
based on the preferences. The lower interval is -0.128 and the higher interval is 0.553.
The average preferences range in expected to vary within this interval.
Conclusion
It can be concluded from the report that the other category that is the water and milk drinks
category is the most popular one among the students. There are divisions in domestic students
and international students. Demand of the drinks goes up with the decrease in price and demand
goes up for increase in price. The fact is same for both the category. There are students who are
willing to change their preferences if being offered and discount. The proportion varies with
variation in discount levels. With a discount of 25%, the change in preferences will be less but
within the increase in discount till 40%, the rate of change in preferences will go up.

6
QUANTITATIVE METHODS
References
Ward, K., Spurr, L., Goldman, N.R., Margaritopoulos, G.A., Kokosi, M., Renzoni, E., Chua, F.,
Maher, T.M., Ward, S. and Wells, A.U., 2016. Patient eligibility for anti-fibrotic therapy in
idiopathic pulmonary fibrosis can be altered by use of different sets of reference values for
calculation of FVC percent predicted. Respiratory medicine, 120, pp.131-133.
Rahayu, W. and Wahyudi, E., 2017. CLASSICAL TEST THEORY OF INNAPROPRIATE
INDEX SCORE’S ACCURACY COMPARISON USING CONFUSION MATRIX
ACCURACY PROPORTION IN EDUCATIONAL MEASUREMENT. IJER-INDONESIAN
JOURNAL OF EDUCATIONAL REVIEW, 4(1), pp.84-92.
Jackson, M., Hood, C., Johnson, C. and Johnson, K., 2016. Calculation of Urban Morphology
Parameterisations for London for use with the ADMS-Urban Dispersion Model. International
Journal of Advanced Remote Sensing and GIS, pp.pp-1678.
Von Mises, L., 2016. Economic calculation in the socialist commonwealth. Lulu Press, Inc.
Xiao, L. and Jiang, D., 2017, September. The study of pervious concrete mix proportion by the
method of specific surface area of aggregate. In IOP Conference Series: Materials Science and
Engineering (Vol. 231, No. 1, p. 012094). IOP Publishing.
Chuosavasdi, T., Stitmannaithum, B., Sumranwanich, T., Saengsoy, W. and Tangtermsirikul, S.,
2016. Degree of hydration and mass balance equations for determination of mix proportion of
hardened OPC concrete. Engineering Journal (Eng. J.), 20(2), pp.211-219.