On Sat, 3 May 2014, Rolando Valdez wrote:
Hello,
I'm working with a matrix weights, I want to know if I can export the output, to handle with excel.
This is a part what I have:
zm <- readOGR(".", "zmdis?)
OGR data source with driver: ESRI Shapefile
Source: ".", layer: "zmdis"
with 56 features and 8 fields
Feature type: wkbPolygon with 2 dimensions
mapaxy = coordinates(zm)
wdist100 = dnearneigh(mapaxy, d1=0, d2=100000)
l100 = nb2listw(wdist100, style="W", zero.policy=T)
summary(l100, zero.policy=T)
Characteristics of weights list object:
Neighbour list object:
Number of regions: 56
Number of nonzero links: 86
Percentage nonzero weights: 2.742347
Average number of links: 1.535714
21 regions with no links:
3 6 11 13 14 15 16 24 25 27 28 35 36 38 41 47 48 51 52 53 54
Link number distribution:
0 1 2 3 4 5 8
21 12 11 2 7 2 1
12 least connected regions:
1 5 7 17 19 20 21 30 33 34 45 55 with 1 link
1 most connected region:
37 with 8 links
Weights style: W
Weights constants summary:
n nn S0 S1 S2
W 35 1225 35 39.26667 147.3
I want to get a matrix [56 x 56] to work in excel with it.
?listw2mat should help, then write the matrix in a form that Excel can read. But note that your distance criterion leaves 21 of 56 observations with no neighbours.
Hope this helps,
Roger
Thank you in advance.
Rolando Valdez