Nemi's problem is to analyze the effect of Advertisement on sales. Firstly, He wants to understand the presence of a linear relationship between the sales and 'amount spent in advertisement'. He also wants to run a correlation and regression to know whether he should keep spending money on Advertisements or not. If sales figures are not affected by advertisement, he should not spend money on it. So, take the EXCEL output of the following and write the interpretation. Appropriate type of Graph which can exhibit the linear relation b/w variables. Karl Pearson's Correlation Coefficient Regression Analysis Graph that shows predicted v/s actual sales figures. Region code Sales (INR 000s) Advertising (TV spots per month) (in INR, 000s) 1 260.3 5 2 286.1 7 3 279.4 6 4 410.8 9 5 438.2 12 6 315.3 8 7 565.1 11 8 570.0 16 9 426.1 13 10 315.0 7 11 403.6 10 12 220.5 4 13 343.6 9 14 644.6 17 15 520.4 19 16 329.5 9 17 426.0 11 18 343.2 8 19 450.4 13 20 421.8 14