Tutor Quora

BAC21 Group Research Project

Academic Anxiety?

Get an original paper within hours and nail the task

156 experts online

Free Samples

BAC21 Group Research Project

.cms-body-content table{width:100%!important;} #subhidecontent{ position: relative;
overflow-x: auto;
width: 100%;}

BAC21 Group Research Project

0 Download6 Pages / 1,445 Words

Course Code: BAC21
University: The Pennsylvania State University

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: United States

Question:
This section must answer to the following specific questions1. What proportions of the students in your sample are local and what proportion are international?2. What is the relationship between price and average quantity consumed by students?3. What are the most popular and least popular soft drinks among students?4. How loyal are students to their brand? (Do students change their preference when they receive a 25% or 40% discount on their preferred drink?)5. How does the demand (price-quantity relationship) of international students differ from that of local students?6. What are the most and least popular drinks among local students? How does this compare with the preferences of the international student?7. How likely is it that the student will choose soft drink (Pepsi, Coke etc.) as their first preference? Provide 95% confident interval estimates and interpret your results.
Answer:

Introduction
The purpose of this report is to provide a detailed analysis on the survey data based on the beverages consumption between domestic students and international students of USC University to understand the preference of beverages among thousands of students of the university. The analysis is performed after selecting a random sample of 90 students. The consumption of beverages is measured with reference to 375ml cans. In this paper, the most preferred beverages have been chosen for total students and for local and international students separately.
Data Analysis
All the given requirements are addressed in the course of this study. The dataset is given in the Excel sheet with 200 responses. The random numbers were already calculated using RAND() function in Excel (Mélard 2014). Firstly, the random sample of size 90 is drawn by doing customised sorting of the random numbers.
Response to Question 1.
The proportions of both local and international students are shown in the tabular form below:

Proportion of local students

0.911111

Proportion of international students

0.088889

Response to Question 2.
The relationship between the price and the average consumed quantity can be evaluated by the correlation coefficient. It is a statistical measure that helps to find out the degree of strength of relationship between two variables. If the coefficient is positive then it represents that for one unit increase in one variable interprets the increase in another variable (Cohen et al. 2013). On the other hand, if there is negative correlation between two variables then it shows that if one variable increases one unit then the other variable will decrease. The Pearson’s correlation coefficient is calculated for this problem using the inbuilt function CORREL() in MS Excel (Carlberg 2014). Before calculating the correlation coefficient, the dataset is processed. The total consumption is calculated by taking sum of the quantity of the consumptions for Soft drinks, Fruit juice, Tea/coffee, Energy drinks, and other drinks. Then the total price is calculated using the SUMPRODUCT() function for multiplying individual price with the demand and finally for summing them (Bluttman 2013).
The value of the correlation coefficient is 0.093 which shows that the relationship between these two variables is positive but very negligible (Cohen et al. 2013).
Response to Question 3.
The most popular and the least popular soft drinks among students can be calculated by counting the preferences for each of the beverages. “1” denotes the first preference and “5” represents last preference. The values of the counts for both the first and last preferences are calculated in Excel using the COUNTIF() function (Carlberg 2014). Then, these values of the counts are tallied to evaluate the most preferred and the least preferred beverages. The following table shows the count of the preferences. The highest preferences for all the drinks are displayed using the yellow color and the least preferences are shown by blue color for easy checking.

count of highest preference of soft drinks=

15

count of lowest preference of soft drinks=

13

count of highest preference of Fruit Juice

8

count of lowest preference of Fruit Juice

4

count of highest preference of Tea /coffee

16

count of lowest preference of Tea /coffee

20

count of highest preference of Energy drinks

2

count of lowest preference of Energy drinks

46

count of highest preference of Other

49

count of lowest preference of Other

7

From the values of most preferred counts, it can be seen that other drinks (milk, water and many more) is the most preferred drinks among the students and the least preferred drinks among students is Energy drinks.
Response to Question 4.
The problem is to find the level of loyalty of the students to their preferred brand. The “Yes” response regarding the change of preference is represented by 1 and the “No” responses are represented by 0. To find out how loyal the students are, it is enough to show the proportion of the counts of “No” responses.
The counts and proportion of “No” responses are shown in the following table:

 

Count of “No” when the second preference was cheaper than the most preferred beverage of the students

Proportion of “No” when the second preference was cheaper than the most preferred beverage of the students

25% cheaper

69

0.766666667

40% cheaper

43

0.477777778

Thus, it can be concluded that students are loyal with probability 0.7667 when the second preference is 25% cheaper and they are loyal with the probability 0.4778 when the second preference is 40% cheaper.
Response to Question 5.
The problem can be addressed by calculating the z-test to check the difference of demands between the international students and the local students (Bubenik 2015). First, the students are grouped on the basis of international students and the local students. Then, the difference between the means of these two groups and the variances for the values of these two groups are calculated (Davis and Pecar 2013). The purpose of this test is to check whether the mean values differ for the two groups. The null hypothesis is that there is no difference between the mean values of the two groups and the alternative hypothesis is that mean values of these two groups differ. The following table shows the calculation of the z-test (Myers, Well and Lorch 2013). This is a two-tailed test. The z-test is obtained using the Data Analysis Tool Pak in Excel.

z-Test: Two Sample for Means

Demand for local students

Mean

98.67073

75

Known Variance

15823

5353.143

Observations

82

8

Hypothesized Mean Difference

23.67

 

z

2.49E-05

 

P(Z<=z) one-tail 0.49999   z Critical one-tail 1.644854   P(Z<=z) two-tail 0.99998   z Critical two-tail 1.959964   From the following table, it can be seen that the observed test statistic for the two-tailed test is 0.9998 and the critical value of the test statistic at 5% level of significance is 1.959964. Clearly, absolute value of the observed value of two tailed test < critical value of the test statistic. Therefore, the null hypothesis is accepted and there is no difference between the demand of local and international students (Park 2015). Thus, the demands are same for both the groups. Response to Question 6. First, the responses are grouped on the basis of local students and the international students. Then, the preferences are counted for the two groups of students. Finally, the respective proportions are calculated since the number of observations between two groups are not same. The following table shows the proportions of preferences.     Highest pref. for Soft drinks Lowest pref. for Soft drinks Highest pref. for Fruit juice Lowest pref. for Fruit juice Highest pref. for Tea/coffee Lowest pref. for Tea/coffee Highest pref. for Energy drinks Lowest pref. for Energy drinks Highest pref. for other Lowest pref. for other Local Students 0.170732 0.134146 0.097561 0.04878 0.158537 0.243902 0.02439 0.5 0.54878 0.073171 International Students 0.125 0.25 0 0 0.375 0 0 0.625 0.5 0.125 The following grouped bar chart represents the preferences for the soft drinks. Figure 1: Group Bar Chart for preference of local & international students Response to Question 7. The proportion that the student will choose soft drinks as their first preference is p= 0.166666667. Now, the problem requires finding out the 95% confidence interval of this proportion which can be evaluated using the formula p ± z*Ö(p(1-p)/n) ; z = confidence coefficient which is 1.96 at 5% level of significance (Lang and Altman 2013), n = sample size (Cumming 2013). Thus, the lower bound and the upper bound are respectively 0.089670595 and 0.243662738. Therefore the confidence interval is (0.089670595, 0.243662738). Summary From the above data analysis, it can be concluded that the purpose of this analysis has been well addressed by providing the information about the most preferred beverages and the least preferred beverages among the total students and also among the local and international students.  The analysis also provides analysis on the proportion of preferred soft drinks and its confidence interval that will interpret the proportion value will lie between the two ranges, namely, the lower bound and the upper bound. References Bluttman, K., 2013. Excel formulas and functions for dummies. John Wiley & Sons. Bubenik, P., 2015. Statistical topological data analysis using persistence landscapes. The Journal of Machine Learning Research, 16(1), pp.77-102. Carlberg, C., 2014. Statistical analysis: microsoft excel 2013. Que Publishing. Cohen, J., Cohen, P., West, S.G. and Aiken, L.S., 2013. Applied multiple regression/correlation analysis for the behavioral sciences. Routledge. Cumming, G., 2013. Understanding the new statistics: Effect sizes, confidence intervals, and meta-analysis. Routledge. Davis, G. and Pecar, B., 2013. Business statistics using Excel. Oxford University Press. Lang, T.A. and Altman, D.G., 2013. Basic statistical reporting for articles published in biomedical journals: the "Statistical Analyses and Methods in the Published Literature" or the SAMPL Guidelines". Handbook, European Association of Science Editors, 256, p.256. Mélard, G., 2014. On the accuracy of statistical procedures in Microsoft Excel 2010. Computational statistics, 29(5), pp.1095-1128. Myers, J.L., Well, A.D. and Lorch Jr, R.F., 2013. Research design and statistical analysis. Routledge. Park, H.M., 2015. Hypothesis testing and statistical power of a test. Free Membership to World's Largest Sample Bank To View this & another 50000+ free samples. Please put your valid email id. E-mail Yes, alert me for offers and important updates Submit  Download Sample Now Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days. UploadUnique Document DocumentUnder Evaluation Get Moneyinto Your Wallet Total 6 pages PAY 4 USD TO DOWNLOAD *The content must not be available online or in our existing Database to qualify as unique. Cite This Work To export a reference to this article please select a referencing stye below: APA MLA Harvard OSCOLA Vancouver My Assignment Help. (2020). Group Research Project. Retrieved from https://myassignmenthelp.com/free-samples/bac21-group-research-project/market-for-soft-drinks-at-usc.html. "Group Research Project." My Assignment Help, 2020, https://myassignmenthelp.com/free-samples/bac21-group-research-project/market-for-soft-drinks-at-usc.html. My Assignment Help (2020) Group Research Project [Online]. Available from: https://myassignmenthelp.com/free-samples/bac21-group-research-project/market-for-soft-drinks-at-usc.html[Accessed 18 December 2021]. My Assignment Help. 'Group Research Project' (My Assignment Help, 2020) accessed 18 December 2021.

My Assignment Help. Group Research Project [Internet]. My Assignment Help. 2020 [cited 18 December 2021]. Available from: https://myassignmenthelp.com/free-samples/bac21-group-research-project/market-for-soft-drinks-at-usc.html.

×
.close{position: absolute;right: 5px;z-index: 999;opacity: 1;color: #ff8b00;}

×

Thank you for your interest
The respective sample has been mail to your register email id

×

CONGRATS!
$20 Credited
successfully in your wallet.
* $5 to be used on order value more than $50. Valid for
only 1
month.

Account created successfully!
We have sent login details on your registered email.

User:

Password:

For years, MyAssignmenthelp.com has been operating as one of the cheap assignment help providers in the USA. We are one of the best college paper writing services that keep service price minimal. We do not let the affordability of our service to hamper the standard of our work. We have separate teams of experts to provide report writing help . At MyAssigenmnthelp.com, we believe in earning credibility, so students can pay for assignments only after getting satisfied solutions. Tough assignments bother you? Trust us with your project. You will not regret paying us to write assignments for you.

Latest Management Samples

div#loaddata .card img {max-width: 100%;
}

MPM755 Building Success In Commerce
Download :
0 | Pages :
9

Course Code: MPM755
University: Deakin University

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Answers:
Introduction
The process of developing a successful business entity requires a multidimensional analysis of several factors that relate to the internal and external environment in commerce. The areas covered in this current unit are essential in transforming the business perspective regarding the key commerce factors such as ethics, technology, culture, entrepreneurship, leadership, culture, and globalization (Nzelibe, 1996; Barza, 2…
Read
More

SNM660 Evidence Based Practice
Download :
0 | Pages :
8

Course Code: SNM660
University: The University Of Sheffield

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: United Kingdom

Answers:
Critical reflection on the objective, design, methodology and outcome of the research undertaken Assessment-I
Smoking and tobacco addiction is one of the few among the most basic general restorative issues, particularly to developed nations such as the UK. It has been represented that among all risk segments smoking is the fourth driving purpose behind infections and other several ailments like asthma, breathing and problems in the l…
Read
More
Tags:
Australia Maidstone Management Business management with marketing University of New South Wales Masters in Business Administration 

BSBHRM513 Manage Workforce Planning
Download :
0 | Pages :
20

Course Code: BSBHRM513
University: Tafe NSW

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Answer:
Task 1
1.0 Data on staff turnover and demographics
That includes the staffing information of JKL industries for the fiscal year of 2014-15, it can be said that the company is having problems related to employee turnover. For the role of Senior Manager in Sydney, the organization needs 4 managers; however, one manager is exiting. It will make one empty position which might hurt the decision making process. On the other hand, In Brisba…
Read
More

MKT2031 Issues In Small Business And Entrepreneurship
Download :
0 | Pages :
5

Course Code: MKT2031
University: University Of Northampton

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: United Kingdom

Answer:
Entrepreneurial ventures
Entrepreneurship is the capacity and willingness to develop, manage, and put in order operations of any business venture with an intention to make profits despite the risks that may be involved in such venture. Small and large businesses have a vital role to play in the overall performance of the economy. It is, therefore, necessary to consider the difference between entrepreneurial ventures, individual, and c…
Read
More
Tags:
Turkey Istanbul Management University of Employee Masters in Business Administration 

MN506 System Management
Download :
0 | Pages :
7

Course Code: MN506
University: Melbourne Institute Of Technology

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Answer:
Introduction
An operating system (OS) is defined as a system software that is installed in the systems for the management of the hardware along with the other software resources. Every computer system and mobile device requires an operating system for functioning and execution of operations. There is a great use of mobile devices such as tablets and Smartphones that has increased. One of the widely used and implemented operating syste…
Read
More
Tags:
Australia Cheltenham Computer Science Litigation and Dispute Management University of New South Wales Information Technology 

Next

Need an essay written specifically to meet your requirements?

Choose skilled experts on your subject and get an original paper within your deadline

156 experts online

Your time is important. Let us write you an essay from scratch

Tips and Tricks from our Blog

11174 Introduction To Management

Free Samples 11174 Introduction To Management .cms-body-content table{width:100%!important;} #subhidecontent{ position: relative; overflow-x: auto; width: 100%;} 11174 Introduction

Read More »