Question: Obtain the correlation matrix for all six variables and list the variables that have strong correlation with Demand. High correlation is r > 0.50. Explain

Obtain the correlation matrix for all six variables and list the variables that have strong correlation with Demand. High correlation is r > 0.50. Explain your findings in plain language.

	*PERIOD*	*PRICE*	*AIP*	*DIFF*	*ADV*	*DEMAND*
PERIOD	1
PRICE	0.62894	1
AIP	-0.06482	-0.25346	1
DIFF	-0.49387	-0.86362	0.706569	1
ADV	0.94196	0.53131	-0.04854	-0.41397	1
DEMAND	0.876232	0.453989	0.026498	-0.3183	0.9022	1

Month/Yr. Jan. 2016 Jan. 2017 | PERIOD PRICE AIP | DIFF I ADV 1 6.1 5.9 -0.2 5.3 2 6.3 6. 61 0.3 16.8 3 6.0 6.4 10.4 7.3 4 6.1 6.1 0.0 17.3 5 5.9 6.4 0.5 7.2 6 5.9 6. 31 0.4 16.5 7 5.9 6.0 10.1 6.8 8 6.8 6. 01 -0.8 6.9 96.8 5.8 -1.0 5.8 10 16.4 6. 31 -0.1 15.5 11 6.5 6.3 | -0.2 6.5 12 6.3 6.2 -0.1 6.3 13 6.1 6.5 0.4 7.0 14 6.1 6.6 0.5 6.9 15 I 6.0 6.3 10.3 16.8 16 6.4 6.7 0.3 6.8 17 6.2 6.5 0.3 7.1 1 18 16.0 16. 81 0.8 17. 01 191 6.1 6.6 0.5 l 7.2 20 6.4 6.1 -0,3 7,5 21 6.0 6.1 0.1 7.8 22 6.2 6.2 0.0 8.2 23 6.1 6.0 -0.1 8.3 24 6.0 6.2 0.2 - 8.4 25 6.1 6.7 0.6 8.9 26 5.9 6. 9 1 1.0 | 9.1 27 16.0 5.8 -0.2 9.3 28 6.3 5. 81 -0.5 9.4 29 6.0 6.0 0.0 9.3 30 5.7 6.7 1.0 9.4 31 1 5. 61 6.4 | 0.8 9.5 32 6.2 7.0 | 0.8 9.6 33 6.4 7.2 0.8 9.7 | 34 6.5 5.9 -0.6 9.9 35 6.2 6. 01 -0.2 9.8 36 6.7 6.2 -0.5 9.9 37 6.9 6.0 -0.9 10.1 38 6.9 6.3 | -0.6 10.2 39 6.7 6.5 -0. 21 10.5 40 7.0 6.0 -1.0 10.3 41 7.1 6.1 -1.0 9.9 42 7.2 6.3 | -0.9 10.5 43 7.2 6.4 -0.8 10.6 44 7.3 6.5 -0.8 10.5 45 7.2 6.0 -1.2 11.6 46 7.1 6.2 -0. 91 10.1 47 6.9 5.9 | -1.0 10.3 48 7.2 6.0 -1. 21 10.7 Jan. 2018 Jan. 2019 1 Month/Yr. Jan. 2016 Jan. 2017 | PERIOD PRICE AIP | DIFF I ADV 1 6.1 5.9 -0.2 5.3 2 6.3 6. 61 0.3 16.8 3 6.0 6.4 10.4 7.3 4 6.1 6.1 0.0 17.3 5 5.9 6.4 0.5 7.2 6 5.9 6. 31 0.4 16.5 7 5.9 6.0 10.1 6.8 8 6.8 6. 01 -0.8 6.9 96.8 5.8 -1.0 5.8 10 16.4 6. 31 -0.1 15.5 11 6.5 6.3 | -0.2 6.5 12 6.3 6.2 -0.1 6.3 13 6.1 6.5 0.4 7.0 14 6.1 6.6 0.5 6.9 15 I 6.0 6.3 10.3 16.8 16 6.4 6.7 0.3 6.8 17 6.2 6.5 0.3 7.1 1 18 16.0 16. 81 0.8 17. 01 191 6.1 6.6 0.5 l 7.2 20 6.4 6.1 -0,3 7,5 21 6.0 6.1 0.1 7.8 22 6.2 6.2 0.0 8.2 23 6.1 6.0 -0.1 8.3 24 6.0 6.2 0.2 - 8.4 25 6.1 6.7 0.6 8.9 26 5.9 6. 9 1 1.0 | 9.1 27 16.0 5.8 -0.2 9.3 28 6.3 5. 81 -0.5 9.4 29 6.0 6.0 0.0 9.3 30 5.7 6.7 1.0 9.4 31 1 5. 61 6.4 | 0.8 9.5 32 6.2 7.0 | 0.8 9.6 33 6.4 7.2 0.8 9.7 | 34 6.5 5.9 -0.6 9.9 35 6.2 6. 01 -0.2 9.8 36 6.7 6.2 -0.5 9.9 37 6.9 6.0 -0.9 10.1 38 6.9 6.3 | -0.6 10.2 39 6.7 6.5 -0. 21 10.5 40 7.0 6.0 -1.0 10.3 41 7.1 6.1 -1.0 9.9 42 7.2 6.3 | -0.9 10.5 43 7.2 6.4 -0.8 10.6 44 7.3 6.5 -0.8 10.5 45 7.2 6.0 -1.2 11.6 46 7.1 6.2 -0. 91 10.1 47 6.9 5.9 | -1.0 10.3 48 7.2 6.0 -1. 21 10.7 Jan. 2018 Jan. 2019 1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

The Fresb Detergent Case. Enterprise Industrves produces Fresh, a brand of liquid detergent. In.srder. Io more effectrvely manage its inventory, the company would fike to better prediet demand for...

ENTERPRISE INDUSTRIES Enterprise Industries produces Fresh, a brand of liquid detergent. In order to more effectively manage its inventory, the company would like to better predict demand for Fresh....

9 17 4. 10 12 13 14 15 16 Enterprise Industries produces Fresh, a brand of liquid detergent. In order to more effectively manage its inventory, the company would like to better predict demand for...

Month/Yr. Jan. 2016 PERIOD PRICE AIP 1 5.4 5.9 2 5.5 6.6 3 6.0 6.4 4 6.1 6.1 5 5.9 6.4 6 5.9 6.3 7 5.9 6.0 8 6.8 6.0 9 6.8 5.8 10 6.4 6.3 11 6.5 6.3 12 6.3 6.2 13 6.1 6.5 14 6.1 6.6 15 6.0 6.3 16 6.4...

Please answer each question on a new spreadsheet and show all the formulas on the excel sheet. Thank you! ENTERPRISE INDUSTRIES Enterprise Industries produces Fresh, a brand of liquid detergent. In...

I NEED HELP WITH G, H, I !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ENTERPRISE INDUSTRIES Enterprise Industries produces Fresh, a brand of liquid detergent. In...

NEED HELP WITH QUESTIONS G, H, I ENTERPRISE INDUSTRIES Enterprise Industries produces Fresh, a brand of liquid detergent. In order to more effectively manage its inventory, the company would like to...

NEED HELP WITH E AND F!!!!!!!!!! ENTERPRISE INDUSTRIES Enterprise Industries produces Fresh, a brand of liquid detergent. In order to more effectively manage its inventory, the company would like to...

Record Journal Entries: A. The insurance policy in effect at the beginning of 2011 expired on 4/1/ 14. At that time, a new one year policy costing $ 35000 was purchased B. Rent paid for special...

Working capital policy involves The level of current assets. The financing of current assets. Current maturities of long-term debt. All of these. Only answers 1 and 2.

Questions 1 - 1 0 are based on the following information: You are considering buying a company using leveraged buyout. The company is projected to have sales of 5 0 0 million each year in the three...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...