Question 1 Gekok Inc. produces and sells home appliance. To better understand its operations, Gekok collects 60 months of inventory turnover and marketing spending data (January 2016 to December 2020) for analysis. The marketing spending data are the total amount (in $000) the firm spent in marketing its finished goods in a month, and the inventory turnover data are calculated as the cost of goods sold in a month divided by the average on-hand inventory in that month. Data are included in Excel spreadsheet. (a) Analyse the inventory turnover and marketing spending data. Provide a visualisation and a numerical description of the two variables according to the following requirements: (i) Select an appropriate chart type to visualise and present data. Provide a brief justification of your choice. What observations and conclusions can you make from the data visualisation? (20 marks) Present descriptive statistics of the two variables. Provide a brief explanation of the key statistics. What can you observe and conclude from the descriptive statistics? Are these observations and conclusions consistent with those from (a)(i)? (20 marks) (b) Inventory is critical asset in a manufacturing company. Increasing inventory turnover can increase the return on asset. It is hypothesised that marketing efforts can help increase inventory turnover. Gekok's management team wants to find out if the hypothesis can be supported by the collected data. You are tasked to perform an association analysis according to the following requirements. (i) (11) (111) Use an appropriate chart type to examine the relationship between the two variables, inventory turnover and marketing spending. Provide a brief justification of your choice. What can you observe and conclude from the chart? (20 marks) Use an appropriate statistical tool to examine the relationship between the two variables. Clearly present the steps and components of the tool (if any), as well as the result of analysis. What can be concluded from the analysis? Is the conclusion consistent with the observations and conclusions in (b)(i)? (30 marks) Is it possible to establish a causality between marketing spending and inventory turnover, i.e. marketing spending drives the firm's inventory turnover, based on the conclusion in (b)(i) and (b)(ii)? (10 marks)