Question

10. All of this was based on data collected regarding the Quantity and Price. Find the Correlation value (r) between the Quantity (x) and Price (y). From the original data set. Record that value here.

11. Summarize your findings from the above problem. Explain what you see in a way that would make sense to someone who does not like math :)

Actual Data
Year	Quantity	Price	Cost
2015	6.54	21.5	63.23
2016	7.33	20.43	67.33
2017	8.12	20.33	69.55
2018	11.5	19.5	71.3
2019	10.34	19.66	70.53
2020	9.88	19.88	71

Predicted Data
x	P (x) 35x+23.35	C(x)= 23.35- 0.35x	R (x) -0.35x^2 + 23.3x	Profit(x) = 35x+23.7x-23.35
0	23.35	23.35	0	-23.35
1	58.35	23	58.35	35.35
2	93.35	22.65	186.7	164.05
3	128.35	22.3	385.05	362.75
4	163.35	21.95	653.05	631.45
5	198.35	21.6	991.75	970.15
6	233.35	21.25	1400.1	1378.85
7	268.35	20.9	1878.45	1857.55
8	303.35	20.55	2426.8	2406.25
9	338.35	20.2	3045.15	3024.95
10	373.35	19.85	3733.5	3713.65
11	408.35	19.5	4491.85	4472.35
12	443.35	19.15	5320.2	5301.05
13	478.35	18.8	6218.55	6199.75
14	513.35	18.45	7186.9	7168.45
15	548.35	18.1	8225.25	8207.15

Many thanks for all you help in my last class.

Answer 1