3: Suppose your class of Management got the following results in Spring 2020 (one record for each student): [10 marks] Table 3: Result of marketing students Student Id Communication Skills Punctuality Class Participation Final 1 25 19.4 10.4 4.2 2 23 2.3 2.2 2.4 3 10.5 1.9 7.1 6.1 4 7.2 1.4 4.3 8.2 5 3.7 7.9 8.5 2.2 6 5.1 7.6 10.6 9.9 7 7.2 2.3 8.8 6.4 8 10.1 3.2 6.9 4.8 a. Using k-means clustering, divide the data into twi groups. Show your calculations up to two iterations. b. What analysis do you make after performing this descriptive data mining step? Discuss the basic characteristics of each of these two groups of students Question 4: Table shows the data of Modern Computers advertising expense and corresponding sales for the past 6 years: [10 marks] Table 4: Data of advertising expense Yr. Advertising (Rs. Millions) Sales (Rs. Millions) 1 19.5 27 2 118 47 3 715 53 4 68 84 5 95 76 6 43 32 a) Develop a scatter chart for the data with advertising expense as the independent variable. What does the scatter chart indicate about the relationship between advertising expense and sales? b) Develop an estimated regression equation showing how advertising expense is related to sales. Also plot this equation on the scatter chart? c) Calculate correlation coefficient and coefficient of determination. Interpret the results obtained. d) Suppose the company is planning to spend 40 million rupees on advertising. Use the estimated regression equation developed in part b to predict sales. In your opinion should we use the result obtained. Why or why not