Question

1 Approved Answer

Posted on Jul 16, 2024

3)Given data in table below: 1. Identify Basis variables 2. Identify Descriptors 3. Copy/paste data into MINITAB and perform the following clustering analysis: Use Single

3)Given data in table below: 1. Identify Basis variables 2. Identify Descriptors 3. Copy/paste data into MINITAB and perform the following clustering analysis: Use Single linkage, Complete linkage, average linkage, and Ward's method to create dendograms. For each method show: 3 segments 5 segments Discuss use of linkage method. Discuss size of obtained segments 4. For the 3-segments' results above; use MINITAB to identify cluster membership and perform Discriminant analysis. Identify discriminant functions Discuss in general use of discriminant function in the STP approach For the 3-segments' results above; use MINITAB to identify cluster membership and 5. Given three new customers with the following Income and Age, use discriminant functions to calculate probability of being member of each of the obtained segments Customer Income Age A 850 1000 30 1200 25 B 55 Choice Install 5 Prob Solv 7 Age 25 22 35 65 OOS 18 Cust No 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Income 2500 2200 1500 1200 800 1500 1400 2000 1800 1500 1500 1600 2000 1600 1300 1400 1100 44 35 59 31 22 21 38 33 20 29 62 22 31 56 45 35 29 66 19 Price Energy loss 6 6 6 6 6 5 5 5 3 4 3 4 4 5 4 5 6 6 5 6 5 6 6 5 6 6 5 5 4 4 4 4 4 4 3 4 5 5 2 3 5 4 5 6 4 6 3 5 Spr Pets 6 9 3 8 4 7 5 4 6 5 5 2 0 0 0 0 1 1 0 0 0 0 0 0 1 0 0 1 0 0 1 0 0 Maintenance Warrante 7 6 6 7 7 5 6 7 5 4 5 4 5 5 6 5 7 7 7 7 7 5 5 4 5 5 6 5 5 4 6 7 6 8 6 6 4 5 6 4 5 4 6 7 6 7 7 8 9 4 2 5 3 7 5 7 6 8 8 5 6 7 8 1 4 5 2 7 4 5 6 7 7 6 6 5 6 5 7 8 6 6 5 7 5 7 5 5 6 5 6 7 6 6 Quality 5 5 6 5 4 5 4 6 6 6 5 5 5 5 3 5 4 3 4 3 5 5 5 4 16 900 17 18 19 20 21 22 23 24 4 6 7 7 3 6 4 6 9 7 1500 700 1600 1400 2000 1400 5 25 26 27 1600 1500 1300 44 46 30 0 0 0 6 5 4 6 5 5 7 6 7 6 9 7 3 7 5 5 6 6 8 6 6 5 6 al 6 5 4 5 3 6 6 5 5 6 7 6 7 7 5 6 4 3 7 5 6 3 5 3 4 7 7 7 6 8 6 6 3 7 5 5 5 6 6 4 4 5 7 4 6 4 4 1600 1500 1300 1400 300 1000 900 1500 1900 1400 1800 1500 1500 1600 800 700 1600 1600 1400 900 1400 2000 2000 1900 1100 900 1700 900 1300 1500 1600 2000 1800 1500 600 1200 900 4 5 5 6 5 6 5 5 5 5 4 5 5 5 3 6 5 6 5 5 5 5 5 3 5 5 5 6 8 4 2 3 8 2. 3 5 7 7 5 4 5 5 4 6 4 2 7 5 6 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 8 6 7 6 5 5 5 7 3 6 9 7 7 1 5 2 5 5 5 5 9 6 6 1 2 5 4 5 1 5 7 4 9 9 5 7 4 4 4 6 5 2 6 6 5 3 2 7 9 6 8 9 7 8 1 6 7 44 46 30 49 19 65 55 35 45 41 28 40 18 32 33 20 41 39 44 21 22 54 43 54 21 26 37 49 49 22 38 31 66 32 33 55 46 19 18 31 29 21 45 42 29 48 35 32 56 68 64 6 0 0 1 0 0 0 1 0 0 0 1 0 1 0 0 1 0 0 0 0 0 o 1 1 0 0 0 0 0 1 0 0 1 0 0 0 1 0 0 0 1 0 0 0 0 1 0 0 1 0 6 4 4 5 5 6 5 4 4 6 5 6 6 4 5 4 5 6 4 6 6 5 5 5 5 5 5 4 3 5 6 6 6 5 5 6 5 5 5 7 4 6 5 5 4 4 3 4 2 3 4 5 4 6 5 5 3 5 5 5 7 6 7 7 7 5 7 4 7 7 8 6 4 7 5 4 4 5 5 7 6 7 7 7 5 5 6 7 5 4 6 7 7 9 8 5 7 4 5 9 6 5 6 6 5 5 5 5 4 4 5 5 4 4 5 5 6 4 7 7 4 6 5 6 5 6 5 6 6 5 6 5 6 7 6 4 4 4 3 4 4 5 5 6 8 5 5 5 5 2 2 1 2 3 9 5 8 7 3 8 5 5 8 2 5 5 5 7 4 7 4 4 6 5 4 3 6 6 6 4 5 5 6 5 5 600 3 6 6 9 6 5 4 5 2 7 3 7 1 6 7 6 3 5 6 5 8 4 5 4 500 1400 1100 1800 800 1500 1800 900 1500 4 5 5 5 70 5 5 5 5 4 5 5 3 5 5 4 7 6 5 5 6 5 7 3 6 6 5 300 71 72 73 74 75 1 7 5 4 3 5 6 3 1600 1600 1000 5 6 4 00 m 6 4 4 6 76 77 78 79 80 81 82 Oolol 4 3 4 5 3 5 6 4 1700 1500 1800 1600 700 1700 1800 1400 1600 1300 1800 1500 1300 31 26 54 65 12 32 45 62 24 35 19 38 28 6 6 6 6 4 4 5 5 4 5 7 6 5 5 6 5 6 0 1 0 0 0 0 1 0 0 5 5 6 5 5 8 7 6 5 6 7 6 8 8 5 5 6 5 3 7 7 8 4 9 7 9 5 5 6 7 6 3 6 8 6 6 5 83 5 5 7 5 5 7 6 5 5 7 8 6 7 1 6 5 6 5 9 7 3 9 5 4 4 4 4 6 5 6 6 6 6 5 5 84 85 86 87 88 6 5 5 3)Given data in table below: 1. Identify Basis variables 2. Identify Descriptors 3. Copy/paste data into MINITAB and perform the following clustering analysis: Use Single linkage, Complete linkage, average linkage, and Ward's method to create dendograms. For each method show: 3 segments 5 segments Discuss use of linkage method. Discuss size of obtained segments 4. For the 3-segments' results above; use MINITAB to identify cluster membership and perform Discriminant analysis. Identify discriminant functions Discuss in general use of discriminant function in the STP approach For the 3-segments' results above; use MINITAB to identify cluster membership and 5. Given three new customers with the following Income and Age, use discriminant functions to calculate probability of being member of each of the obtained segments Customer Income Age A 850 1000 30 1200 25 B 55 Choice Install 5 Prob Solv 7 Age 25 22 35 65 OOS 18 Cust No 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Income 2500 2200 1500 1200 800 1500 1400 2000 1800 1500 1500 1600 2000 1600 1300 1400 1100 44 35 59 31 22 21 38 33 20 29 62 22 31 56 45 35 29 66 19 Price Energy loss 6 6 6 6 6 5 5 5 3 4 3 4 4 5 4 5 6 6 5 6 5 6 6 5 6 6 5 5 4 4 4 4 4 4 3 4 5 5 2 3 5 4 5 6 4 6 3 5 Spr Pets 6 9 3 8 4 7 5 4 6 5 5 2 0 0 0 0 1 1 0 0 0 0 0 0 1 0 0 1 0 0 1 0 0 Maintenance Warrante 7 6 6 7 7 5 6 7 5 4 5 4 5 5 6 5 7 7 7 7 7 5 5 4 5 5 6 5 5 4 6 7 6 8 6 6 4 5 6 4 5 4 6 7 6 7 7 8 9 4 2 5 3 7 5 7 6 8 8 5 6 7 8 1 4 5 2 7 4 5 6 7 7 6 6 5 6 5 7 8 6 6 5 7 5 7 5 5 6 5 6 7 6 6 Quality 5 5 6 5 4 5 4 6 6 6 5 5 5 5 3 5 4 3 4 3 5 5 5 4 16 900 17 18 19 20 21 22 23 24 4 6 7 7 3 6 4 6 9 7 1500 700 1600 1400 2000 1400 5 25 26 27 1600 1500 1300 44 46 30 0 0 0 6 5 4 6 5 5 7 6 7 6 9 7 3 7 5 5 6 6 8 6 6 5 6 al 6 5 4 5 3 6 6 5 5 6 7 6 7 7 5 6 4 3 7 5 6 3 5 3 4 7 7 7 6 8 6 6 3 7 5 5 5 6 6 4 4 5 7 4 6 4 4 1600 1500 1300 1400 300 1000 900 1500 1900 1400 1800 1500 1500 1600 800 700 1600 1600 1400 900 1400 2000 2000 1900 1100 900 1700 900 1300 1500 1600 2000 1800 1500 600 1200 900 4 5 5 6 5 6 5 5 5 5 4 5 5 5 3 6 5 6 5 5 5 5 5 3 5 5 5 6 8 4 2 3 8 2. 3 5 7 7 5 4 5 5 4 6 4 2 7 5 6 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 8 6 7 6 5 5 5 7 3 6 9 7 7 1 5 2 5 5 5 5 9 6 6 1 2 5 4 5 1 5 7 4 9 9 5 7 4 4 4 6 5 2 6 6 5 3 2 7 9 6 8 9 7 8 1 6 7 44 46 30 49 19 65 55 35 45 41 28 40 18 32 33 20 41 39 44 21 22 54 43 54 21 26 37 49 49 22 38 31 66 32 33 55 46 19 18 31 29 21 45 42 29 48 35 32 56 68 64 6 0 0 1 0 0 0 1 0 0 0 1 0 1 0 0 1 0 0 0 0 0 o 1 1 0 0 0 0 0 1 0 0 1 0 0 0 1 0 0 0 1 0 0 0 0 1 0 0 1 0 6 4 4 5 5 6 5 4 4 6 5 6 6 4 5 4 5 6 4 6 6 5 5 5 5 5 5 4 3 5 6 6 6 5 5 6 5 5 5 7 4 6 5 5 4 4 3 4 2 3 4 5 4 6 5 5 3 5 5 5 7 6 7 7 7 5 7 4 7 7 8 6 4 7 5 4 4 5 5 7 6 7 7 7 5 5 6 7 5 4 6 7 7 9 8 5 7 4 5 9 6 5 6 6 5 5 5 5 4 4 5 5 4 4 5 5 6 4 7 7 4 6 5 6 5 6 5 6 6 5 6 5 6 7 6 4 4 4 3 4 4 5 5 6 8 5 5 5 5 2 2 1 2 3 9 5 8 7 3 8 5 5 8 2 5 5 5 7 4 7 4 4 6 5 4 3 6 6 6 4 5 5 6 5 5 600 3 6 6 9 6 5 4 5 2 7 3 7 1 6 7 6 3 5 6 5 8 4 5 4 500 1400 1100 1800 800 1500 1800 900 1500 4 5 5 5 70 5 5 5 5 4 5 5 3 5 5 4 7 6 5 5 6 5 7 3 6 6 5 300 71 72 73 74 75 1 7 5 4 3 5 6 3 1600 1600 1000 5 6 4 00 m 6 4 4 6 76 77 78 79 80 81 82 Oolol 4 3 4 5 3 5 6 4 1700 1500 1800 1600 700 1700 1800 1400 1600 1300 1800 1500 1300 31 26 54 65 12 32 45 62 24 35 19 38 28 6 6 6 6 4 4 5 5 4 5 7 6 5 5 6 5 6 0 1 0 0 0 0 1 0 0 5 5 6 5 5 8 7 6 5 6 7 6 8 8 5 5 6 5 3 7 7 8 4 9 7 9 5 5 6 7 6 3 6 8 6 6 5 83 5 5 7 5 5 7 6 5 5 7 8 6 7 1 6 5 6 5 9 7 3 9 5 4 4 4 4 6 5 6 6 6 6 5 5 84 85 86 87 88 6 5 5