Question 1 of the assignment requires you to analyse a given data set, interpret, and draw conclusions from your analysis using EXCEL. Question 1 relates to the data file Smartphone.xls which can be downloaded from the assignment tab on the portal. Analysis of the data for this question requires the use of techniques taught in week 1 and week 2, that is Descriptive Statistics.
Part (ii) (10 marks)
Please provide a descriptive statistics summary of Monthly Bill. (Hint: You should use the Data Analysis tool pack from Excel to perform the necessary analysis. Please attach the Excel output in your answer. In addition, you should provide a relevant chart or graph that will illustrate the important features of the data. Present your answer in a report format of no more than 200 words.
Part (iii)(10marks)
Following the discussion you have carried out in part (i) above, now please provide an analysis of the Monthly Bill by gender using the same data set. Present your answer in a report of no more than 200 words. All answers must be accompanied with the relevant Excel output with necessary charts.