Nemi Mehta is owning 50 Hectares of land near Junagadh. On his Farm, he cultivates Giloy, which is a medicinal plant in Ayurveda. The below-given table shows the sales of ‘Giloy Vati’ that his team is preparing as per one Ayurveda script (book), and the amount they spend on the Advertisement of itNemi’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.
Comments
Leave a comment