BUS1BAN ANALYSING BUSINESS DATA

1902 BUS1BAN

BU/BE/MI/SH/C3

LA TROBE UNIVERSITY

BUS1BAN ANALYSING BUSINESS DATA

Semester 2, 2019

Research Project One
Due Date: 5pm 15th September

Member No. Student ID Student Name Contribution (%)1 Student Signature
1        
2        
3        

Subject tutor name:

Workshop time and day:

Instructions

1. Fill in your name, student ID, contribution (100% should be specified for each group member in most cases) in the table above on the cover page.

2. Each group member must sign on the cover page to show your agreement on the version of your group work to be submitted.

3. Record your subject tutor’s name and workshop details under your group member information.

4. Research Project 1 carries 24 marks and will represent 12% of your final grade.

An insight into market share and usage of mobile phones by
students studying BUS1BAN at La Trobe University

Use a random sample of 100 observations and answer Questions 1-8 in Part A to Part C.

Part A: Sampling

Q1. What sampling plan did you employ to select your sample of 100 observations? [1 mark]

Q2. Apart from the sampling plan you employed to select your random sample, use your own words to briefly describe two other commonly used sampling plans? [1 mark]

Part B: Descriptive Statistics

Q3. Analysis on gender proportion:

a. In the following table, report proportion of the students based on gender in your sample. [1 mark]

Gender Sample Proportion (in percentage form)
Female  
Male  

b. Use an appropriate chart (properly labelled) to display information in Q3-a above, and provide brief interpretation on the chart. [1 mark]

Q4. Investigating the relationship between mobile phone brands and student gender:

a. Complete the following cross classification table of gender by mobile phone brand. [2 marks]



Brand

  Apple Samsung LG Basic
mobile
phone
Other
smart
phone
Do not
use mobile
phone
Total
Gender Male              
Female              
Total              

b. Derive a relative frequency cross classification table based on row totals using the table in Q4-a above. [2 mark]



Brand

  Apple Samsung LG Basic
mobile
phone
Other
smart
phone
Do not
use mobile
phone
Total
Gender Male              
Female              
Total              

c. Use an appropriate graph to display the information contained in the cross-classification table of row relative frequencies above. Decide whether there is a relationship between mobile phone brands and the gender. [2 marks]

Q5. Investigating the relationship between earnings and money spent on mobile phone by gender:

a. In the following table, report average monthly earnings and mobile bill of students by gender in your sample. [2 marks]

  Female Male
Average Monthly Earnings ($)    
Average Monthly Bill ($)    

b. Produce a scatter plot (showing trend line, linear equation and R square) using Excel, to show the relationship between earnings and money spent on mobile phone for each gender. (Hint: Graphs for female and male should be shown separately.) [2 marks]

Q6. Descriptive statistics on the relationship between average monthly earning and average monthly mobile bill by gender:

a. Use Excel and fill in the table. Provide the following statistical measures to examine the relationship between average monthly earning and average monthly mobile bill. [4 marks]

  Female Male
Covariance    
Coefficient of Correlation    
Coefficient of Determination    
Y-intercept    
Slope    
Least Squares Line    

b. Interpret each of the statistics in the table above in Q6-a for both genders. [2 marks]

Part C: Summary and Discussion

Q7. Briefly discuss how to determine the relationship between two nominal variables, and how to determine the relationship between two numerical variables. [2 marks]

Q8. What are your main findings based on the analysis in Q3-Q6 of Part B. [2 marks]

1 50% means the student will receive 50% of the marks awarded. All group members are to exert an equal amount of effort on all questions of the assignment. Students should not divide sections. If a student has contributed to only some sections, the contribution of the student should be equal to the marks it carries. A student with less than 100% contribution will receive marks proportional to their contribution.

Leave a Reply

Your email address will not be published. Required fields are marked *