Reference no: EM132372520
Assignment - BUSINESS DATA
Research Project One
Part A: Sampling
Q1. What sampling plan did you employ to select your sample of 100 observations?
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?
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.
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.
Q4. Investigating the relationship between mobile phone brands and student gender:
a. Complete the following cross classification table of gender by mobile phone brand.
|
|
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.
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.
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.
|
Female
|
Male
|
Average Monthly Earnings ($)
|
|
|
Average Monthly Bill ($)
|
|
|
b. Produce a scatter plot (showing trend line, linear equation and R square) using Excel, toshow the relationship between earnings and money spent on mobile phone for each gender.(Hint: Graphs for female and male should be shown separately.)
Q6. Descriptive statistics on the relationship between average monthly earning and average monthly mobile bill by gender:
a. UseExcel and fill in the table.Provide the following statistical measures to examine the relationship between average monthly earning and average monthly mobile bill.
|
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.
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.
Q8. What are your main findings based on the analysis in Q3-Q6 of Part B.
Attachment:- Data File.rar