Excel Graph Worksheet
I need somebody to do me a favor and draw these 2 graphs in excel. please make sure you exactly make it like these graphs. I have uploaded my excel file here. I’m struggling with this because I’m not good at e3xcel and I did sth and suddenly my 2 graphs became one. please separate them and fix them. Thank you
Buret Reading (mL) Vol NaOH added(mL) PH
0
0
2.1
2.1
4.1
4.1
6.2
6.2
8.1
8.1
10.1
10.1
12
12
14.1
14.1
16
16
18.1
18.1
20
20
22.1
22.1
24.1
24.1
26.1
26.1
28.1
28.1
30.1
30.1
32
32
34
34
36
36
38.1
38.1
40
40
42.1
42.1
44
44
46
46
2.95
3.13
3.33
3.48
3.6
3.73
3.83
3.93
4.03
4.13
4.23
4.33
4.47
4.6
4.79
5.05
5.69
11.07
11.52
11.72
11.84
11.94
12.01
12.07
Buret Reading(mL) Vol NaOH added(mL)PH PH
0
0
2.93
2
2
3.1
4
4
3.28
6.1
6.1
3.45
8
8
3.58
10.1
10.1
3.72
12
12
3.83
14
14
3.93
16
16
4.03
18
18
4.13
20
20
4.23
22.1
22.1
4.35
24
24
4.48
26
26
4.62
28
28
4.82
30
30
5.1
30.05
30.05
5.12
30.1
30.1
5.14
30.15
30.15
5.15
30.2
30.2
5.17
30.3
30.3
5.19
30.35
30.35
5.2
30.4
30.4
5.22
30.5
30.5
5.24
30.6
30.6
5.27
30.7
30.7
5.29
30.8
30.8
5.32
30.9
30.9
5.34
31
31
5.39
31.1
31.1
5.4
31.2
31.2
5.45
31.3
31.3
5.5
31.4
31.4
5.57
31.5
31.5
5.6
31.6
31.6
5.67
31.7
31.7
5.74
31.8
31.8
5.81
31.9
31.9
5.89
32
32
6.06
32.1
32.1
6.21
32.2
32.2
6.34
32.3
32.3
6.81
32.4
32.4
7.53
32.5
32.5
9.25
32.55
32.55
9.75
32.6
32.6
9.93
32.65
32.75
32.8
32.85
32.9
32.95
33
33.1
32.65
32.75
32.8
32.85
32.9
32.95
33
33.1
10.17
10.32
10.38
10.45
10.5
10.55
10.62
10.67
1.0M Acedic Acid Titration wth 0.5M NaOH
50
Equivalence point PH=8.20
45
40
35
30
1/2 Equivalence point PH=4.20
PH
25
20
15
10
1/2 Equivalence Point Volume=16.20 (mL)
5
0
0
5
10
15
20Volume of25NaOH(mL)30
Average Volume (pH2-pH1)/(V2-V1)
0.085
0.09
0.080952381
0.068421053
0.066666667
0.057894737
0.05
0.05
0.05
0.05
0.057142857
0.068421053
0.07
0.1
0.14
0.4
0.4
0.2
0.4
0.2
0.2
0.4
0.2
0.3
0.2
0.3
0.2
0.5
0.1
0.5
0.5
0.7
0.3
0.7
0.7
0.7
0.8
1.7
1.5
1.3
4.7
7.2
17.2
10
3.6
20
18
Change in PH/Change in Volume
1
3
5.05
7.05
9.05
11.05
13
15
17
19
21.05
23.05
25
27
29
30.025
30.075
30.125
30.175
30.25
30.325
30.375
30.45
30.55
30.65
30.75
30.85
30.95
31.05
31.15
31.25
31.35
31.45
31.55
31.65
31.75
31.85
31.95
32.05
32.15
32.25
32.35
32.45
32.525
32.575
16
14
12
10
8
6
4
2
0
30
30.5
31
32.625
32.7
32.775
32.825
32.875
32.925
32.975
33.05
4.8
1.5
1.2
1.4
1
1
1.4
0.5
on wth 0.5M NaOH
PH
Series1
Equivalence point
Buret Reading (mL)
Vol NaOH added(mL)
PH
Buret Reading(mL)
Equivalence Point Volume=32.5 mL
PH
Average Volume
lume=16.20 (mL)
NaOH(mL)30
Vol NaOH added(mL)PH
(pH2-pH1)/(V2-V1)
35
40
45
50
1st Derivative Graph
V1=32.45
Equivalence Point Volume=( 32.45+32.53)/2=32.49 mL
V2=32.525
31.5
Average Volume (mL)
32
32.5
33
.53)/2=32.49 mL
33.5