i need complete solution

1 2 4 5 6 7 2007 212 .145 -061 -049 099 - 050 -061 -027 - 166 - 016 175 330 110 - 091 104 182 .050 .085 .028 - 544 - 119 -004 .015 132 - 332 - 087 .063 .095 221 - 186 .061 -035 -040 109 .048 .144 048 -023 .017 028 .088 .067 .045 -.022 .002 165 - 030 .033 .093 .045 826 - 106 .010 X20 - Likely to .811 203 Recommend X21 - Likely to Purchase .799 .162 X19 - Satisfaction .756 391 X24 - Consider Strategic .720 255 Alliance X6 - Product Quality .665 -.084 X1 - Customer Type 656 448 X23 - Purchase Level .629 561 X18 - Delivery Speed .311 .905 X9 - Complaint 294 .872 Resolution X16 - Order & Billing .187 .827 X4 - Region - 143 -.016 X3 - Firm Size .398 -.041 X17-Price Flexibility - 131 .534 X13 - Competitive Pricing - 231 -046 X11 - Product Line 447 .489 X5 - Distribution System 316 .098 X12 - Salesforce Image .226 111 X7 - E-Commerce 151 X10 - Advertising .121 X8 - Technical Support 132 .043 X14 - Warranty & Claims 090 .106 X2 - Industry Type .010 .015 X15 - New Products .142 .139 ID -122 - 200 Extraction Method: Principal Component Analysis. -080 - 132 - 101 .718 .714 .242 073 .106 .134 -.034 .002 .028 .695 - 039 197 - 034 .039 081 - 596 - 480 .271 456 171 - 261 -053 .004 - 147 .007 -062 .848 .081 -037 095 .842 2018 133 079 .203 .682 -038 ..050 091 - 018 945 .000 - 044 075 -.015 .159 -002 - 091 .019 .014 - 204 942 -003 .023 .049 - 073 .851 -066 939 - 151 .247 .025 344 - 052 457 24 25 26 27 28 29 30 $53 $96 $155 $77 $123 $90 $119 $75 $123 $75 $156 $110 $104 31 32 33 34 35 36 37 IL vermilion East North Centr MI clinton East North Centr MI Joakland East North Centr Wi grant East North Centr WI brown East North Centr OH lorain East North Centr IL kendall East North Centri OH ashtabula East North Centr WI columbia East North Centr OH darke East North Centr MI livingston East North Centr WI winnebago East North Centr WI rock East North Centr IL winnebago East North Centr IL coles East North Centr IL rock island East North Centr MI st.joseph East North Centri IL sangamon East North Centr OH Jhamilton East North Centri MI ingham East North Centr IL macoupin East North Centr OH tuscarawas East North Centr OH lake East North Centr OH portage East North Centr IL peoria East North Centr MI bay East North Centr MI berrien East North Centr $79,950 $191,360 $350,050 $142,500 $311,950 $182,700 $265,050 $129,950 $259,950 $109,950 $299,050 $204,950 $188,500 $110,050 $79,950 $127,550 $192,000 $151,664 $227,500 $149,000 $88,050 $139,950 $159,950 $194,950 $133,000 $87,750 $309,050 $62 1,587 1,993 2,282 1,784 2,152 1,889 2,100 1,550 2,027 1,525 1,933 1,733 1,783 1,728 1,564 1,384 1,847 1,837 1,447 1,592 1,440 1,509 1,521 1,800 1,799 1,410 2,031 38 39 40 41 42 43 44 45 $59 $97 $101 $83 $100 $94 $58 $85 $96 $102 $74 $67 $144 46 47 48 49 50 use ratio to moving average method form the following data the data to find the seasonal indicies .use multiplcate model Result 163 148 ($000) 94.1 69.4 81.7 72.1 90.1 84.4 77.5 124 71.2 72.1 75.7 79.8 142 173 168 155 N=0) 0 1 0 0 0 1 0 1 0 0 163 0 76.7 1 0 0 1 1 0 0 Number 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 65.1 83.8 85.8 70.6 93.3 80.1 80.8 85.5 62.1 88.5 88.2 110.3 124.6 97.6 82.4 58.2 75.5 75.1 70.5 83.9 95.5 150.2 84.4 88.7 135.4 GPA 3.07 2.82 3.02 2.98 3.02 3.35 2.9 2.96 2.67 2.95 3.45 2.71 3.07 3.37 3.01 3.03 3.3 3.19 3.12 2.89 2.86 2.91 3.08 3.15 3.13 2.88 4 3.32 2.4 2.88 2.76 3.1 2.91 3.25 3.61 3.26 3.12 3.84 2.63 2.46 3.2 3.62 2.75 194 119 124 149 171 160 104 165 154 122 160 148 138 158 112 189 163 203 165 176 152 74 129 166 134 124 169 187 163 172 195 Age 21 30 26 31 29 39 29 28 25 24 29 26 34 23 34 32 32 27 34 28 32 24 28 30 25 41 33 30 26 25 35 32 25 32 54 22 28 29 26 27 30 28 34 1 0 0 0 0 1 0 0 Gender F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F 1 0 0 0 0 0 0 1 0 0 1 1 0 0 0 1 1 72.3 149 65.5 80.3 136.8 75.8 107 156 183 133 1 2 4 5 6 7 2007 212 .145 -061 -049 099 - 050 -061 -027 - 166 - 016 175 330 110 - 091 104 182 .050 .085 .028 - 544 - 119 -004 .015 132 - 332 - 087 .063 .095 221 - 186 .061 -035 -040 109 .048 .144 048 -023 .017 028 .088 .067 .045 -.022 .002 165 - 030 .033 .093 .045 826 - 106 .010 X20 - Likely to .811 203 Recommend X21 - Likely to Purchase .799 .162 X19 - Satisfaction .756 391 X24 - Consider Strategic .720 255 Alliance X6 - Product Quality .665 -.084 X1 - Customer Type 656 448 X23 - Purchase Level .629 561 X18 - Delivery Speed .311 .905 X9 - Complaint 294 .872 Resolution X16 - Order & Billing .187 .827 X4 - Region - 143 -.016 X3 - Firm Size .398 -.041 X17-Price Flexibility - 131 .534 X13 - Competitive Pricing - 231 -046 X11 - Product Line 447 .489 X5 - Distribution System 316 .098 X12 - Salesforce Image .226 111 X7 - E-Commerce 151 X10 - Advertising .121 X8 - Technical Support 132 .043 X14 - Warranty & Claims 090 .106 X2 - Industry Type .010 .015 X15 - New Products .142 .139 ID -122 - 200 Extraction Method: Principal Component Analysis. -080 - 132 - 101 .718 .714 .242 073 .106 .134 -.034 .002 .028 .695 - 039 197 - 034 .039 081 - 596 - 480 .271 456 171 - 261 -053 .004 - 147 .007 -062 .848 .081 -037 095 .842 2018 133 079 .203 .682 -038 ..050 091 - 018 945 .000 - 044 075 -.015 .159 -002 - 091 .019 .014 - 204 942 -003 .023 .049 - 073 .851 -066 939 - 151 .247 .025 344 - 052 457 24 25 26 27 28 29 30 $53 $96 $155 $77 $123 $90 $119 $75 $123 $75 $156 $110 $104 31 32 33 34 35 36 37 IL vermilion East North Centr MI clinton East North Centr MI Joakland East North Centr Wi grant East North Centr WI brown East North Centr OH lorain East North Centr IL kendall East North Centri OH ashtabula East North Centr WI columbia East North Centr OH darke East North Centr MI livingston East North Centr WI winnebago East North Centr WI rock East North Centr IL winnebago East North Centr IL coles East North Centr IL rock island East North Centr MI st.joseph East North Centri IL sangamon East North Centr OH Jhamilton East North Centri MI ingham East North Centr IL macoupin East North Centr OH tuscarawas East North Centr OH lake East North Centr OH portage East North Centr IL peoria East North Centr MI bay East North Centr MI berrien East North Centr $79,950 $191,360 $350,050 $142,500 $311,950 $182,700 $265,050 $129,950 $259,950 $109,950 $299,050 $204,950 $188,500 $110,050 $79,950 $127,550 $192,000 $151,664 $227,500 $149,000 $88,050 $139,950 $159,950 $194,950 $133,000 $87,750 $309,050 $62 1,587 1,993 2,282 1,784 2,152 1,889 2,100 1,550 2,027 1,525 1,933 1,733 1,783 1,728 1,564 1,384 1,847 1,837 1,447 1,592 1,440 1,509 1,521 1,800 1,799 1,410 2,031 38 39 40 41 42 43 44 45 $59 $97 $101 $83 $100 $94 $58 $85 $96 $102 $74 $67 $144 46 47 48 49 50 use ratio to moving average method form the following data the data to find the seasonal indicies .use multiplcate model Result 163 148 ($000) 94.1 69.4 81.7 72.1 90.1 84.4 77.5 124 71.2 72.1 75.7 79.8 142 173 168 155 N=0) 0 1 0 0 0 1 0 1 0 0 163 0 76.7 1 0 0 1 1 0 0 Number 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 65.1 83.8 85.8 70.6 93.3 80.1 80.8 85.5 62.1 88.5 88.2 110.3 124.6 97.6 82.4 58.2 75.5 75.1 70.5 83.9 95.5 150.2 84.4 88.7 135.4 GPA 3.07 2.82 3.02 2.98 3.02 3.35 2.9 2.96 2.67 2.95 3.45 2.71 3.07 3.37 3.01 3.03 3.3 3.19 3.12 2.89 2.86 2.91 3.08 3.15 3.13 2.88 4 3.32 2.4 2.88 2.76 3.1 2.91 3.25 3.61 3.26 3.12 3.84 2.63 2.46 3.2 3.62 2.75 194 119 124 149 171 160 104 165 154 122 160 148 138 158 112 189 163 203 165 176 152 74 129 166 134 124 169 187 163 172 195 Age 21 30 26 31 29 39 29 28 25 24 29 26 34 23 34 32 32 27 34 28 32 24 28 30 25 41 33 30 26 25 35 32 25 32 54 22 28 29 26 27 30 28 34 1 0 0 0 0 1 0 0 Gender F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F 1 0 0 0 0 0 0 1 0 0 1 1 0 0 0 1 1 72.3 149 65.5 80.3 136.8 75.8 107 156 183 133