BUS1BAN Analysing Business Data - Individual Research Project

Questions

Part B: Descriptive Statistics

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

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

b. Estimate the 95% confidence interval of the average monthly bill for female students, and interpret your answer. [1.5 marks]

c. Produce a scatter plot (showing trend line, linear equation and R-squared) using Excel, to show the relationship between earnings and money spent on mobile phone for female students. Then interpret the linear equation and R-squared in the scatter plot for female students. [2 marks]