STATISTICS 1 123 Homework Assignment #2 Using Statgraphioa to Summarize Data & Normal Distributions TOTAL = 43 MARKS Due Date: Februa 6, 2022 For this assignment, you will be using Excel to conduct both univarlate and bivariate data analyses. Questions 1I 2 and 3 must be done in MS Excel software. In this statistical investigation, data was collected on 65 Langara students and their interest in drinking coffee was investigated. The following 4 variables were collected on these students: age (in years], gender, city {where a student lives), whether or not they drink coffee. This dataset is available in 'MS Excel' format {lename: Assign ment2_CoffeeDataset.xlsx] and it can be accessed from Conte nt/Assignments mod ule on our course website. The structure of this dataset is su mmarized as follows: StudentlD Age [in years] Gend er DrinkCoffee 1. [15 marks] The objective of this exercise is to summarize and describe data for a single categorical variable [this is an example of a univariate analysis of a categorical variable]. a] Obtain a numerical summary [report both frequency and percentage] for each of the categorical variables in this dataset (hint: gender, city, and drinkcoffee]. [6 marks] b] Obtain a barchart or a piechart (Le. graphical summary] for each of the categorical variables in this dataset. Make sure each of your graphical summaries has a title and the axes of your graphs are clearly labeled. [6 marks] c] Provide an interpretation for each of these three variables based on your results in parts a] and b]. In other words, what do the numerical and graphical summaries tell you about the distributions of each of these variables? [3 marks] 2. [12 marks] The objective of this question is to summarize and describe data for a single quantitative variable [this is an example of univariate analysis of a quantitative variable]. a] Obtain a histogram {showing frequency on the y-axis] for the variable 'age'. Make sure your histogram has a title and the axes are clearly labeled. Make sure you do not over-summarize or under- summarize the histogram use an appropriate number of bins (i.e. classes]. [4 marks]