Question

This dataset contains consumer responses indicating the number of times they had to send their product for repair and their satisfaction with the repair process. Create a graph which can be used to visually demonstrate the relationship between the two columns of data. Ensure that the chart is professional with appropriate titles, axis labels, etc. Note any observations you see in your visualization (type these as sentences directly into an Excel cell(s)).

Sample	Satisfaction Rating	Repair Requests
1	63%	13
2	71%	1
3	44%	11
4	68%	10
5	58%	1
6	64%	10
7	66%	6
8	88%	3
9	46%	14
10	62%	8
11	80%	0
12	59%	6
13	47%	8
14	86%	4
15	71%	6
16	70%	9
17	70%	5
18	35%	10
19	32%	18
20	87%	1
21	93%	0
22	42%	12
23	67%	10
24	44%	16
25	84%	0
26	15%	19
27	78%	2
28	55%	6
29	82%	2
30	67%	7
31	41%	12
32	84%	4
33	47%	5
34	47%	8
35	36%	11
36	21%	12
37	82%	10
38	85%	0
39	49%	11
40	65%	4
41	48%	10
42	48%	14
43	59%	10
44	48%	12
45	78%	8
46	40%	15
47	51%	9
48	48%	7
49	52%	12
50	68%	6
51	73%	4
52	48%	10
53	41%	9
54	73%	9
55	79%	4
56	36%	11
57	40%	14
58	46%	10
59	65%	1
60	68%	11
61	51%	8
62	60%	3
63	21%	14
64	44%	16
65	72%	6
66	96%	0
67	53%	7
68	90%	0
69	13%	20
70	44%	11
71	61%	14
72	61%	8
73	93%	0
74	96%	4
75	49%	8
76	59%	5
77	45%	12
78	98%	0
79	42%	8
80	78%	6
81	62%	14
82	46%	3
83	70%	7
84	72%	7
85	85%	3
86	79%	0
87	60%	9
88	32%	16
89	91%	5
90	78%	2
91	80%	6
92	61%	10
93	65%	13
94	49%	10
95	34%	10
96	46%	7
97	69%	5
98	37%	9
99	97%	0
100	79%	6

Answer 1

Solution:

In excel go to

Insert>Chart>Scatter

Select the data

Go to + symbol

Mark on axis titles>primary horizontal

Name it as Satisfaction Rating

Then again go to

axis titles>primary vertical

Go to Repair Requests

Click on chart titles

Go to Scatterplot

You will get

Intrepretation:

From scatterplot we observe a negative relationship between satisfaction rating and repair requests.

as satisfaction rating is high there are less number of repair requests.
And as  satisfaction rating is low there are high number of repair requests.