This assignment focuses on assessing the quality of your learning and its application in real world business research at an introductory level.
The assignment requires you to apply the analytical techniques taught in this subject to data collected through a survey. Lectures, tutorials and quizzes will provide you with the opportunity to learn the analytical techniques to successfully complete this assignment.
Project Title: Understanding the market for beverages
La Trobe is a large university attended by thousands of students every day on week days. The purpose of this project is to understand the students' beverages market at the university. This type of project requires the students to demonstrate their ability to select a sample, analyse the data collected and prepare a written report of their analysis. For convenience, the subject coordinator designed a survey questionnaire which was to be used by all students last semester. Moreover, since it was impossible to interview every student visiting the university last semester, the subject coordinator proposed that only BUS1BAN students should be interviewed. And, to make life easier for all, last semester all BUS1BAN students were required to respond to the survey online on the subject web page.
Report Format
Your report must include a cover page followed by answers to the following:
1. Introduction:
Provide a brief introduction to what this assignment is about and how your sample was selected.
2. Data Analysis:
This section must answer to the following specific questions Section A: Basic Analysis
1. What proportions of the students in your sample are local and what proportion are international?
2. What is the relationship between price and estimated average quantity consumed by students in your sample?
3. Summarise the beverage preferences for your sample of students. What are the most popular and least popular beverages?
4. Will price affect preference? (Do students in your sample indicate that they would change to their second preference if this beverage was 25%, 40% or 60% cheaper than their first preference?)
Section B: The behavior of local students vis-à-vis International Students
5. How does the demand (price-quantity relationship) of international students differ from that of local students in your sample?
6. Compare the distribution of beverage preferences for local and international students. What are the most and least popular beverages for each group?
7. Does price influence the choice of beverage for local students more than for international students? (8 marks)
Section C: Advance scenarios
8. Suppose, you randomly selected a student from last semester's BUS1BAN classes.
a. How likely is it that the student will be a local student and how likely is it that the student will be an international student? Provide interval estimates and interpret your results.
b. How likely is it that the student will choose soft drink (Coke, Pepsi etc) as their first preference? Provide interval estimates and interpret your results.
c. What is the probability that the student will choose tea/coffee as their second preference if he/she selected soft drink (Coke, Pepsi etc.) as the first preference? Once again, provide interval estimates and interpret your results.
9. It is claimed that more than 25% of the students at La Trobe prefer soft drinks (Coke, Pepsi etc.) over any other beverage. Use your sample data to test this claim at 1%, 5% and 10% levels of significance.
10. Suppose a total of 20,000 students (10000 local and 10000 international) attend La Trobe University every week. The university expects this number to increase to 25,000 next year (comprising of 10,000 local and 15,000 International students). Using your survey results, calculate the impact of this change on aggregate consumption of beverages at La Trobe.
3. Summary:
Provide a quick summary of the MAIN RESULTS from your analysis of the data (response to sections A, B and C). Use this section to comment on the validity of your inferences -comment on the sampling technique and whether your sample is representative of the entire LTU student population. Comment on ways in which errors (if any) could be improved
Attachment:- Data for the Assignment.xlsx