osumFcn = @(x)(sum(x,'omitnan'));
powerLosses.totalCustomers = splitapply(osumFcn,T.Customers,G);
powerLosses(1:15,:)
ans=15×4 table
Region
Cause
maxLoss
totalCustomers
_________
________________
_______
______________
MidWest
attack
0
0
MidWest
energy emergency
2378.7
6.3363e+05
MidWest
equipment fault
903.28
1.7822e+05
MidWest
severe storm
6808.7
1.3511e+07
MidWest
thunder storm
15128
4.2563e+06
MidWest
unknown
23141
3.9505e+06
MidWest
wind
2053.8
1.8796e+06
MidWest
winter storm
669.25
4.8887e+06
NorthEast
attack
405.62
2181.8
NorthEast
earthquake
0
0
NorthEast
energy emergency
11638
1.4391e+05
NorthEast
equipment fault
794.36
3.9961e+05
NorthEast
fire
872.96
6.1292e+05
NorthEast
severe storm
6002.4
2.7905e+07
NorthEast
thunder storm
23418
2.1885e+07
Calculate Mean Durations of Power Outages
Determine the mean durations of all U.S. power outages in hours. Add the mean durations of power
outages to powerLosses. Because T.RestorationTime has NaT values, omit the resulting NaN
values when calculating the mean durations.
D = T.RestorationTime - T.OutageTime;
H = hours(D);
omeanFcn = @(x)(mean(x,'omitnan'));
powerLosses.meanOutage = splitapply(omeanFcn,H,G);
powerLosses(1:15,:)
ans=15×5 table
Region
Cause
maxLoss
totalCustomers
meanOutage
_________
________________
_______
______________
__________
MidWest
attack
0
0
335.02
MidWest
energy emergency
2378.7
6.3363e+05
5339.3
MidWest
equipment fault
903.28
1.7822e+05
17.863
MidWest
severe storm
6808.7
1.3511e+07
78.906
MidWest
thunder storm
15128
4.2563e+06
51.245
MidWest
unknown
23141
3.9505e+06
30.892
MidWest
wind
2053.8
1.8796e+06
73.761
MidWest
winter storm
669.25
4.8887e+06
127.58
NorthEast
attack
405.62
2181.8
5.5117
NorthEast
earthquake
0
0
0
NorthEast
energy emergency
11638
1.4391e+05
77.345
NorthEast
equipment fault
794.36
3.9961e+05
87.204
NorthEast
fire
872.96
6.1292e+05
4.0267
NorthEast
severe storm
6002.4
2.7905e+07
2163.5
9 Tables
9-54