0:00
Hello everyone.
00:01
So in this question, the data of number of calories per serving and number of grams of sugar per serving are random of random sample of high fiber cereals is given.
00:10
Okay.
00:10
So in the first segment of this question, it is said, we need to draw a scatter diagram of data which is treating calories as explanatory variable and to give relation that appears to exist between the calories and sugar contained.
00:24
So first of all, to obtain the relationship, we use the excel software.
00:28
And by using excel software, we first, enter the data in the spreadsheet and then insert charts option we click on then we click on the scatter plot option then we say the display value of residual r square value on the chart and then click okay so we are going to obtain a scatter plot like this so the scatter plot which is going to obtain is going to look like this so this is the scatter plot which is obtained now this is a plot of sugar versus calories contained so plot of sugar versus calories content so here we have the sugar and on the x -axis we have the calories value okay so from this we say that in this we get a linear positive trend line it is very much clear that we got a line which is in this we got a line which is straight line this includes that we get a linear positive we get a linear positive trend line, which gives the values, which gives the value for r square.
01:52
That is coefficient of determination value as 0 .4 to 14 .14 and y intercept as, we got this as 0 .0933, 0 .093 x plus 1 .2878.
02:11
It.
02:15
From this, we can obtain relationship between calories and sugar and we say that it is a weak positive relationship.
02:21
It has a weak positive relationship.
02:30
So this is the first segment of the answer.
02:33
Now, moving forward to the second segment of this question, it is said we need to determine correlation between calories and sugar content.
02:40
So correlation, when we talk about, and we talk about co -relationship.
02:45
It is the type of relationship in which one variable is related to, is related to another by some kind of relationship, by some kind of relationship.
03:10
So this is the meaning of correlation and we need to find the correlation between calories and sugar content.
03:16
So the correlation coefficient value, or you can say the correlation coefficient value given by r is equal to summation of xy minus summation of x y minus summation of x multiplied by summation of y whole divided by the summation we have to take the square root now we'll have to take the square root of this of n summation x square minus summation x the whole square square bracket close then again black we will have next term that is the y term so we will have n summation y square minus summation of y the whole square so this is the value for correlation coefficient now we will use excel again to obtain correlation coefficient value so by entering the data in the spreadsheet then insert charts clicking on the scattered option scattered chart option and we will enter the enter the value as coral okay a2, so where the data we have entered.
04:33
So the address of the cells, a2 to a13, we will type, then comma on the b part b2 to b13.
04:45
So this will give us the correlation coefficient value that is equal to r is equal to 0 .260985.
04:54
We get the correlation coefficient value as 0 .260985.
04:59
Since correlation coefficient value is not about the critical value, since the correlation coefficient value is not above the critical value.
05:12
The critical value which we have is 0 .567.
05:18
Since it is not about this, we say that the relationship between the relationship between calories and sugar obtained is not linear...