Chat with us, powered by LiveChat I need Q3, Q4 and Q5 file in a report file of around 1200 words. You will see the Instruction in Instructions pdf file. For Q3, you will do data analytics in ora - EssayAbode

I need Q3, Q4 and Q5 file in a report file of around 1200 words. You will see the Instruction in Instructions pdf file. For Q3, you will do data analytics in ora

I need Q3, Q4 and Q5 file in a report file of around 1200 words. You will see the Instruction in Instructions pdf file. For Q3, you will do data analytics in orange. I have attached my work of previous question in My work file. Data excel file, header fil are also attached. 

Need in 30 hours. 

Header description The data in the data file appear in the order shown below. Therefore, the first data column is the ID and the last column in the data file is the Spending Score. Attribute: Attribute Type and Descriptions —————— ———————————————– 1. CustomerID Numerical Instance or record ID of customer, from 1 to 1000 2. Age Numerical Age for the customer ID, Maximum = 70, Minimum = 18 3. Gender Categorical F refers to female customer, M refers to male customer 4. Annual Income Numerical Annual income of in $K dollar for the customer ID, Maximum = 137K, Minimum = 15K 5. Subscription Binary 1 refers to customer has subscribed to promotional email, 0 refers to customer hasn’t subscribed to promotional email 6. Satisfaction Categorical L refers to low level of customer satisfaction towards the service provided at the store, M refers to medium level of customer satisfaction towards the service provided at the store, H refers to high level of customer satisfaction towards the service provided at the store 7. Spending Score Numerical Score (from 1 to 100) given to the customer ID based on the money spent and the behaviour of the customer. The more the customer spends, the higher the score. Maximum = 99, Minimum = 1

,

Customers

Related Tags

AcademicAPAAssignmentBusinessCapstoneCollegeConclusionCourseDayDiscussionDouble SpacedEssayEnglishFinanceGeneralGraduateHistoryInformationJustifyLiteratureManagementMarketMastersMathMinimumMLANursingOrganizationalOutlinePagesPaperPresentationQuestionsQuestionnaireReferenceResponseResponseSchoolSubjectSlidesSourcesStudentSupportTimes New RomanTitleTopicsWordWriteWriting

CustomerID Age Gender Annual Income Subscription Satisfaction Spending Score
1 19 M 15 1 L 39
2 21 M 15 1 H 81
3 20 F 16 1 L 6
4 23 F 16 1 M 77
5 31 F 17 1 L 40
6 22 F 17 1 M 76
7 35 F 18 1 L 6
8 23 F 18 1 H 94
9 64 M 19 1 L 3
10 30 F 19 1 M 72
11 67 M 19 1 L 14
12 ? F 19 1 H 99
13 58 F 20 1 L 15
14 24 F 20 1 M 77
15 37 M 20 1 L 13
16 22 M 20 1 H 79
17 35 F 21 1 L 35
18 20 M 21 1 M 66
19 52 M 23 1 L 29
20 35 F 23 1 H 98
21 35 M 24 1 L 35
22 25 M 24 1 M 73
23 46 F 25 1 L 5
24 31 M 25 0 M 73
25 54 F ? 0 L 14
26 29 M 28 0 H 82
27 45 F 28 0 L 32
28 35 M 28 0 M 61
29 40 F 29 0 L 31
30 23 F 29 0 H 87
31 60 M 30 0 L 4
32 21 F 30 0 M 73
33 53 M 33 0 L 4
34 18 M 33 0 H 92
35 49 F 33 1 L 14
36 21 F 33 1 H 81
37 42 F 34 1 L 17
38 30 F 34 1 M 73
39 36 F 37 1 L 26
40 20 F 37 M 75
41 65 F 38 1 L 35
42 24 M 38 1 H ?
43 48 M 39 1 L 36
44 31 F 39 1 M 61
45 49 F 39 ? L 28
46 24 F 39 1 M 65
47 50 F 40 1 M 55
48 ? F 40 1 L 47
49 29 F 40 1 L 42
50 31 F 40 1 L 42
51 49 F 42 1 M 52
52 33 M 42 1 M 60
53 31 F 43 1 M 54
54 59 M 43 1 M 60
55 50 F 43 1 L 45
56 47 M 43 1 L 41
57 51 F 44 0 M 50
58 69 M 44 0 L 46
59 27 F 46 0 M 51
60 53 M 46 0 L 46
61 ? M 46 0 M 56
62 19 M 46 0 M 55
63 67 F 47 0 M 52
64 54 F 47 0 H ?
65 63 M 48 0 M 51
66 18 M 48 0 M 59
67 43 F ? 0 M 50
68 68 F ? 0 L 48
69 19 M ? 0 M 59
70 32 F 48 0 L 47
71 70 M 49 0 M 55
72 47 F 49 0 L 42
73 60 F 50 0 L 49
74 60 F 50 0 M 56
75 59 M 54 0 L 47
76 26 M 54 0 M 54
77 45 F 54 0 M 53
78 40 M 54 0 L 48
79 23 F 54 0 M 52
80 ? F 54 0 L 42
81 57 M 54 0 M 51
82 38 M 54 0 M 55
83 ? M 54 0 L 41
84 46 F 54 0 L 44
85 21 F 54 0 M 57
86 48 M 54 0 L 46
87 55 F 57 1 M 58
88 22 F 57 1 M 55
89 34 F 58 1 M 60
90 50 F 58 1 L 46
91 68 F 59 1 M 55
92 18 M 59 1 L 41
93 48 M 60 1 L 49
94 40 F 60 1 L 40
95 32 F 60 1 L 42
96 24 M 60 1 M 52
97 47 F 60 1 L 47
98 27 F 60 1 H ?
99 48 M 61 ? L 42
100 20 M 61 1 L 49
101 23 F 62 1 L 41
102 49 F 62 1 L 48
103 67 M 62 1 M 59
104 26 M 62 1 M 55
105 49 M 62 1 M 56
106 21 F 62 1 L 42
107 66 F 63 1 M 50
108 54 M 63 1 L 46
109 68 M 63 1 L 43
110 66 M 63 0 L 48
111 65 M 63 0 M 52
112 19 F 63 0 M 54
113 38 F 64 0 L 42
114 19 M 64 0 L 46
115 18 F 65 0 L 48
116 19 F 65 0 M 50
117 63 F 65 0 L 43
118 49 F 65 0 M 59
119 51 F 67 0 L 43
120 50 F 67 0 M 57
121 27 M 67 1 M 56
122 38 F 67 1 L 40
123 40 F 69 1 M 58
124 39 M 69 1 H 91
125 23 F 70 1 L 29
126 31 F ? 1 M 77
127 43 M 71 1 L 35
128 40 M 71 1 H 95
129 59 M 71 1 L 11
130 38 M 71 1 M 75
131 47 M 71 1 L 9
132 39 M 71 1 M 75
133 25 F 72 1 L 34
134 31 F 72 1 M 71
135 20 M 73 1 L 5
136 29 F ? 1 H 88
137 44 F 73 1 L 7
138 32 M 73 1 M 73
139 19 M 74 1 L 10
140 35 F 74 1 M 72
141 57 F 75 1 L 5
142 32 M 75 1 H 93
143 28 F 76 1 L 40
144 32 F 76 0 H 87
145 25 M 77 0 L 12
146 28 M 77 0 H 97
147 48 M 77 0 L 36
148 32 F 77 0 M 74
149 34 F 78 0 L 22
150 34 M 78 0 H 90
151 43 M 78 0 L 17
152 39 M 78 0 H 88
153 44 F 78 0 L 20
154 38 F 78 0 M 76
155 47 F 78 0 L 16
156 27 F 78 0 H 89
157 37 M 78 0 L 1
158 30 F 78 0 H 78
159 34 M 78 0 L 1
160 30 F 78 0 M 73
161 56 F 79 0 L 35
162 29 F 79 0 H 83
163 19 M 81 0 L 5
164 31 F 81 0 H 93
165 50 M 85 0 L 26
166 36 F 85 0 M 75
167 42 M 86 0 L 20
168 33 F 86 0 H 95
169 36 F 87 0 L 27
170 32 M 87 0 M 63
171 40 M 87 0 L 13
172 28 M 87 0 M 75
173 36 M 87 0 L 10
174 36 M 87 0 H 92
175 52 F 88 0 L 13
176 30 F 88 0 H 86
177 58 M 88 0 L 15
178 ? M 88 0 M 69
179 59 M 93 0 L 14
180 35 M 93 0 H 90
181 37 F 97 0 L 32
182 32 F 97 0 H 86
183 46 M 98 0 L 15
184 29 F 98 0 H 88
185 41 F 99 1 L 39
186 30 M 99 1 H 97
187 54 F 101 1 L 24
188 28 F 101 1 M 68
189 41 F 103 1 L 17
190 36 F 103 1 H 85
191 34 F 103 1 L 23
192 32 F 103 1 M 69
193 33 M 113 1 L 8
194 38 F 113 1 H 91
195 47 F 120 1 L 16
196 35 F 120 1 H 79
197 45 F 126 1 L 28
198 32 M 126 1 M 74
199 32 M 137 1 L 18
200 30 M 137 1 H 83
201 30 F 88 1 H 86
202 58 M 88 1 L 15
203 27 M 88 1 M 69
204 59 M 93 1 L 14
205 35 M 93 1 H 90
206 37 F 97 1 L 32
207 32 F 97 0 H 86
208 46 M 98 0 L 15
209 29 F 98 0 H 88
210 41 F 99 0 L 39
211 30 M 99 0 H 97
212 54 F 101 0 L 24
213 28 M 101 0 M 68
214 41 F 103 0 L 17
215 36 F 103 0 H 85
216 40 M 71 0 H 95
217 59 M 71 0 L 11
218 38 M 71 0 M 75
219 47 M 71 0 L 9
220 39 M 71 0 M 75
221 25 F 72 0 L 34
222 31 F 72 0 M 71
223 20 M 73 0 L 5
224 29 F 73 0 H 88
225 44 F 73 0 L 7
226 32 M 73 0 M 73
227 19 M 74 0 L 10
228 35 F 74 0 M 72
229 57 F 75 0 L 5
230 32 M 75 0 H 93
231 28 F 76 0 L 40
232 32 F 76 0 H 87
233 25 M 77 0 L 12
234 28 M 77 0 H 97
235 48 M 77 0 L 36
236 32 F 77 0 M 74
237 34 F 78 0 L 22
238 34 M 78 0 H 90
239 43 M 78 0 L 17
240 39 M 78 0 H 88
241 44 F 78 0 L 20
242 38 F 78 0 M 76
243 28 M 101 0 M 68
244 41 F 103 0 L 17
245 36 F 103 0 H 85
246 36 F 37 0 L 26
247 20 F 37 0 M 75
248 65 F 38 0 L 35
249 24 M 38 0 H 92
250 48 M 39 0 L 36
251 31 F 39 0 M 61
252 49 F 39 1 L 28
253 24 F 39 1 M 65
254 50 F 40 1 M 55
255 27 F 40 1 L 47
256 29 F 40 1 L 42
257 31 F 40 1 L 42
258 49 F 42 1 M 52
259 33 M 42 1 M 60
260 31 F 43 1 M 54
261 59 M 43 1 M 60
262 50 F 43 1 L 45
263 47 M 43 1 L 41
264 51 F 44 1 M 50
265 69 M 44 1 L 46
266 27 F 46 1 M 51
267 53 M 46 1 L 46
268 70 M 46 1 M 56
269 19 M 46 1 M 55
270 67 F 47 1 M 52
271 ? F 47 1 M 59
272 ? M 48 1 M 51
273 ? M 101 1 M 68
274 41 F 103 0 L 17
275 36 F 103 0 H 85
276 25 M 100 0 H 85
277 30 F 88 0 H 86
278 58 M 88 0 L 15
279 27 M 88 0 M 69
280 59 M 93 0 L 14
281 35 M 93 0 H 90
282 37 F 97 0 L 32
283 32 F 97 0 H 86
284 46 M 98 0 L 15
285 29 F 98 0 H ?
286 41 F 99 0 H ?
287 30 M 99 0 H ?
288 54 F 101 0 L 24
289 28 M 101 0 M 68
290 41 F 103 0 L 17
291 36 F 103 0 H 85
292 25 M 67 0 L 19
293 35 M 100 0 H 85
294 38 F 105 0 L 35
295 30 M 88 0 H 86
296 58 M 88 0 L 15
297 27 M 88 0 M 69
298 59 M 93 0 L 14
299 35 M 93 0 H 90
300 37 F 97 0 L 32
301 32 F 97 0 H 86
302 46 M 98 0 L 15
303 29 F 98 0 H 88
304 41 F 99 0 L 39
305 30 M 99 0 H 97
306 54 F 101 0 L 24
307 28 M 101 0 M 68
308 41 F 103 0 L 17
309 36 F 103 0 H 85
310 63 M 48 0 M 51
311 28 M 101 0 M 68
312 41 F 103 0 L 17
313 36 F 103 0 H 85
314 25 M 100 0 H 85
315 30 F 88 0 H 86
316 58 M 88 0 L 15
317 27 M 88 0 M 69
318 59 M 93 0 L 14
319 35 M 93 1 H 90
320 37 F 97 1 L 32
321 32 F 97 1 H 86
322 46 M 98 1 L 15
323 29 F 98 1 H 88
324 41 F 99 1 L 39
325 30 M 99 1 H 97
326 54 F 101 1 L 24
327 59 M 93 1 L 14
328 35 M 93 1 H 90
329 37 F 97 1 L 32
330 32 F 97 1 H 86
331 46 M 98 1 L 15
332 29 F 98 1 H 88
333 41 F 99 1 L 39
334 30 M 99 1 H 97
335 54 F 101 1 L 24
336 28 M 101