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 vis actual sales figures.
Correlation
Correlation defines a relationship between two independent variables. It tells the degree to which variables move in relation to each other. When two sets of data are related to each other, there is a correlation between them.
Linear Correlation
A correlation is used to determine the relationships between numerical and categorical variables. In other words, it is an indicator of how things are connected to one another. The correlation analysis is the study of how variables are related.
Regression Analysis
Regression analysis is a statistical method in which it estimates the relationship between a dependent variable and one or more independent variable. In simple terms dependent variable is called as outcome variable and independent variable is called as predictors. Regression analysis is one of the methods to find the trends in data. The independent variable used in Regression analysis is named Predictor variable. It offers data of an associated dependent variable regarding a particular outcome.
![1. 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 it.
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 an 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
• Regresion Analysis
Graph that shows predicted vis actual sales figures.
Advertising
(TV spots per
month) (in INR. 000s)
5.
Sales
(INR 000s)
Region code
260.3
286.1
279.4
3.
6.
410.8
438.2
12
315.3
7.
565.1
11
8
570.0
16
9
426.1
13
10
315.0
7.
11
403.6
10
12
220.5
13
343.6
9
14
644.6
17
15
520.4
329.5
19
16
426.0
17
18
11
343.2
8.
19
450.4
13
20
421.8
14](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F907ca8ad-1dfb-4110-b0ad-75ea583fa467%2Fef54b85f-eabd-4e91-a54b-50ea86c26a29%2F9cd3cs8n_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 6 steps with 6 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![Elementary Statistics: Picturing the World (7th E…](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
![The Basic Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
![Introduction to the Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)