logo

BUS1BAN Business Analytics

16 Pages2389 Words167 Views
   

Business Analytics (BUS1BAN)

   

Added on  2020-05-11

BUS1BAN Business Analytics

   

Business Analytics (BUS1BAN)

   Added on 2020-05-11

ShareRelated Documents
Cover PageBUS1BAN Major AssignmentTeacher’s NameWorkshop Details(Time, day, room)StudentsID NumberStudents NameStudent contribution*(%)e.g. 50% means thestudent will receive 50%of the marks awardedStudents Signature1
BUS1BAN Business Analytics_1
An insight into student demand for smartphones at La Trobe University.Project Title: AN INSIGHT INTO STUDENT DEMAND FOR SMART PHONES AT LA TROBE UNIVERSITY.Executive SummaryWe use a sample of 150 from the data created by the survey taken by students online. This data is rich in terms of phone usage, bill amount, income of users, gender and the willingness to shift between Apple and Samsung Galaxy. The data is of students only and must be interpreted accordingly. The main points are:Income and bill amount of females are higher than men .Most users use Apple ( 133/ 150) Women are more loyal than men for Apple, as they are less willing to shift to Samsung after discounts are given.No one uses a basic phone- they all use a smart phone- which hints at its mass usage like a necessity item. Average income of Samsung user sis highest.The share of Apple is higher than 4)% in line with results from other countries- the share in our sample is very high at 75%IntroductionThe purpose of this project is to get insights into the student demand for smartphones at LaTrobe University. The study uses data from BUS1BAN students only. The method of choosingand forming a data set is SELF SELECTION. Those who choose to take the survey are part of it.All students may not be part of the data. For our results we use this large and raw data set toderive a sample of size 150 using random sampling. The results must be interpreted on thebasis of sampling procedure used and accordingly may not apply to all students at LaTrobe. We use Excel to answer a variety of questions pertaining to this data. We use concepts like measuresof central tendency, dispersion, correlation, confidence intervals , hypothesis testing, regression. Weuse visual charts that include pie chart, bar chart, scatterplot, and pivot charts to aid in our analysis. Using Excel tools and statistical concepts we can understand the distribution of quantitative data likeincome and monthly bills of users. 2
BUS1BAN Business Analytics_2
I.Data Analysis Section A: Basic Analysis 1.Gender ProportionOur sample has more females as compared to malesGenderSample proportionFemale53.33%Male46.67%This is clear from the pie chart belowThis implies that the sample is not neutral in terms of gender. 2.Average Monthly BillThe average monthly bill of students by gender is shown below in the table as well as inthe bar chart. FemaleMaleAverage Monthly Bill ($)$69.33$61.123
BUS1BAN Business Analytics_3
The average monthly bill is higher for females than males by $8.21. this is also statedas saying that females average bill is 13.4% higher than that of males. 3.Earnings and money spent on mobile phone: The average monthly earning of students by gender is shown below in the table as wellas in the bar chart. FemaleMaleAverage Monthly Earnings ($)$1293.415$1242.969We can derive the following results for the data:4
BUS1BAN Business Analytics_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Mobile Phone Choice and Factors Influencing It: A Study on La Trobe University Students
|18
|1219
|112

BUS1BAN, Business Analytics Assignment
|19
|1711
|97

Insight into Market Share and Usage of Mobile Phones by Students at La Trobe University
|11
|1774
|178

BUS1BAN Business Analytics Report
|12
|1539
|287

Insight into Market Share and Usage of Mobile Phones by Students at La Trobe University
|6
|1038
|471

Cover Page. Research Project-2: BUS1BAN. Teacher’s Name
|16
|2852
|2