Question

Can someone please help with this question?

The international candy association wants to identify the correlation between the following variables; Size, Price Energy, Protein and Carbohydrates.

Sample	Size	Price	Energy	Protein	Carbo
1	50	0.88	1970	3.1	53.2
2	50	0.88	2003	4.6	59
3	40	1.15	2057	9.9	60.9
4	80	1.54	1920	5.1	67.5
5	45	1.15	2250	7.2	59.4
6	78	1.4	2186	7	59.7
7	55	1.28	1930	3.5	56.4
8	60	0.97	1980	10.2	59.9
9	60	0.97	1890	4.7	67.9
10	50	1.28	2030	5.6	67.4
11	40	1.1	2180	5.5	67.3
12	55	1.28	1623	2.2	73.3
13	44.5	0.97	1640	3.7	77.9
14	75	1.58	2210	8.2	57
15	60	1.55	1980	8.5	63.3
16	42.5	1.18	1970	5	69

Plot the data and identify the relationships between variables. Produce the correlation matrix (using excel) and explain your findings.

Answer 1

Runegve ssRon and cowelalion commonds,we these esulls: Regresston Equalion Cat scdiymm i9hghpiC313ti s to.ool139 6n e price 2 gSe t o.ool3g creyt covelation, puce ,Size /ene"JJ, potein, calo. o. 62H o olO 0221 ene 0.112 o 679 prote:n 2 7 0 348 0.583 0.020 o 346 0 o.6HO o Oo8 o 760

2 cell conentsesson cowe latio) P value. HS 2200 voken fut Sgh aud eguation s give as shzun 4bcve so, price f poduct -285to.oll귀(15)to.ool139 A= . (.243リ from the queston hasfollaun desexplcon: podac en fal easbo Sodiun 60 IKoO 2 Regreten equairons s gien i' +ο.cj9 6 caxbo.

podaci f* 60 3soo 280o 9 ken igh aud sodium lowe have fblloumg Regne SKneyuauian Ace a p oduct being neadwe means 와 v19