![](http://tb2.bdstatic.com/tb/editor/images/face/i_f09.png?t=20140803)
![](http://tb2.bdstatic.com/tb/editor/images/face/i_f09.png?t=20140803)
a = Import["G:\\数据1.xlsx"]
b = Flatten[a, 1] // MatrixForm;
Spectrogram[a]
数据a是
{{{0., -1.87263}, {0.1, -2.56467}, {0.2, -1.93113}, {0.3, -0.676355}, \
{0.4, -1.59893}, {0.5, -1.54251}, {0.6, -2.2234}, {0.7, -1.21546}, \
{0.8, -1.20337}, {0.9, -2.22171}, {1., -2.25407}, {1.1, -2.14149}, \
{1.2, -0.947266}, {1.3, -1.9474}, {1.4, -2.19203}, {1.5, -2.48965}, \
{1.6, -1.65535}, {1.7, -0.719426}, {1.8, -2.10306}, {1.9, -2.10702}, \
{2., -2.50027}, {2.1, -1.36191}, {2.2, -1.6648}, {2.3, -2.12242}, \
{2.4, -2.44937}, {2.5, -1.94663}, {2.6, -0.749762}, {2.7, -1.66102}, \
{2.8, -1.53223}, {2.9, -1.95159}, {3., -1.43103}, {3.1, -1.55963}, \
{3.2, -1.65277}, {3.3, -2.20292}, {3.4, -2.0434}, {3.5, -0.983541}, \
{3.6, -1.59322}, {3.7, -0.810972}, {3.8, -2.07766}, {3.9, -1.50827}, \
{4., -1.10496}, {4.1, -1.00805}, {4.2, -1.61363}, {4.3, -1.82015}, \
{4.4, -0.937036}, {4.5, -1.38722}, {4.6, -0.59138}, {4.7, -2.02192}, \
{4.8, -1.58684}, {4.9, -1.38794}, {5., -0.885307}, {5.1, -0.267584}, \
{5.2, -1.37086}, {5.3, -0.620554}, {5.4, -1.38274}, {5.5, -0.506777}, \
{5.6, -1.55149}, {5.7, -1.77389}, {5.8, -0.59695}, {5.9, -1.25641}, \
{6., -0.243381}, {6.1, -1.62208}, {6.2, -1.21118}, {6.3, -0.65094}, \
{6.4, -0.377845}, {6.5,
0.0677413}, {6.6, -1.55784}, {6.7, -0.709455}, {6.8, -1.50825}, \
{6.9, -0.28469}, {7., -0.466091}, {7.1, -1.10067}, {7.2, -0.324845}, \
{7.3, -1.06221}, {7.4,
0.17459}, {7.5, -0.902194}, {7.6, -0.15603}, {7.7, -0.540326}, \
{7.8, -0.0275218}, {7.9, -0.192439}, {8., -1.27993}, {8.1, \
-0.231759}, {8.2, -1.38282}, {8.3, -0.0607186}, {8.4, -0.435941}, \
{8.5, -0.480303}, {8.6, -0.340983}, {8.7, -0.146869}, {8.8,
0.330614}, {8.9, -0.524998}, {9.,
0.100357}, {9.1, -0.895349}, {9.2, -0.440578}, {9.3,
0.00848575}, {9.4, -0.243955}, {9.5, -0.360036}, {9.6, -0.791326}, \
{9.7, -0.0343773}, {9.8, 0.522486}, {9.9,
0.356357}, {10., -0.530603}, {10.1, -0.438181}, {10.2, \
-0.0271358}, {10.3, -0.175132}, {10.4,
0.0128027}, {10.5, -0.71773}, {10.6, -0.255084}, {10.7,
0.433358}, {10.8, -0.136286}, {10.9, -0.492353}, {11., -0.405882}, \
{11.1, 0.305037}, {11.2, 0.428606}, {11.3,
0.336121}, {11.4, -0.712874}, {11.5, -0.891261}, {11.6,
0.028804}, {11.7,
0.267972}, {11.8, -0.237162}, {11.9, -0.925249}, {12., -0.507723}, \
{12.1, 0.254736}, {12.2,
0.178577}, {12.3, -1.43964}, {12.4, -0.398198}, {12.5, -0.160852}, \
{12.6, -0.00789465}, {12.7, -0.858421}, {12.8, -1.71906}, {12.9, \
-1.28039}, {13., -0.104042}, {13.1,
0.329743}, {13.2, -0.975115}, {13.3, -0.688925}, {13.4, \
-0.825777}, {13.5,
0.151137}, {13.6, -0.593151}, {13.7, -0.92803}, {13.8, -2.37649}, \
{13.9, -1.13688}, {14.,
0.0437644}, {14.1, -1.43316}, {14.2, -0.843178}, {14.3, -1.51647}, \
{14.4, -0.619558}, {14.5, -0.363685}, {14.6, -1.14267}, {14.7, \
-0.762158}, {14.8, -1.39843}, {14.9, -0.15309}, {15., -0.913887}, \
{15.1, -1.3298}, {15.2, -1.85081}, {15.3, -1.31153}, {15.4, \
-0.00490636}, {15.5, -1.64778}, {15.6, -1.09145}, {15.7, -1.42018}, \
{15.8, -0.73966}, {15.9, -0.398431}, {16., -1.35511}, {16.1, \
-1.50349}, {16.2, -2.59513}, {16.3, -0.676377}, {16.4, -1.33087}, \
{16.5, -1.48073}, {16.6, -1.61745}, {16.7, -1.79383}, {16.8, \
-0.250595}, {16.9, -2.05225}, {17., -1.29492}, {17.1, -2.03951}, \
{17.2, -0.943714}, {17.3, -0.971284}, {17.4, -2.15913}, {17.5, \
-2.00136}, {17.6, -2.9423}, {17.7, -0.25998}, {17.8, -1.58537}, \
{17.9, -1.78542}, {18., -2.00524}, {18.1, -1.93091}, {18.2, \
-0.60364}, {18.3, -1.71332}, {18.4, -1.77733}, {18.5, -2.87349}, \
{18.6, -0.900886}, {18.7, -1.50162}, {18.8, -2.66974}, {18.9, \
-2.2092}, {19., -2.4531}, {19.1, -0.647163}, {19.2, -1.5023}, {19.3, \
-1.92237}, {19.4, -2.32861}, {19.5, -1.94655}, {19.6, -1.04937}, \
{19.7, -2.32685}, {19.8, -2.28253}, {19.9, -2.72791}, {20., \
-0.972615}, {20.1, -1.28563}, {20.2, -2.43159}, {20.3, -1.82423}, \
{20.4, -2.09827}, {20.5, -0.796341}, {20.6, -1.66689}, {20.7, \
-1.93603}, {20.8, -2.76262}, {20.9, -1.59449}, {21., -1.22475}, \
{21.1, -2.06428}, {21.2, -1.85299}, {21.3, -2.22865}, {21.4, \
-1.11991}, {21.5, -1.30246}, {21.6, -1.56332}, {21.7, -2.09359}, \
{21.8, -1.72567}, {21.9, -0.975184}, {22., -1.5235}, {22.1, \
-2.26084}, {22.2, -2.10461}, {22.3, -1.65757}, {22.4, -1.64724}, \
{22.5, -1.16835}, {22.6, -1.59611}, {22.7, -1.02725}, {22.8, \
-1.33713}, {22.9, -0.698324}, {23., -0.865294}, {23.1, -1.83181}, \
{23.2, -0.979491}, {23.3, -1.62058}, {23.4, -0.999096}, {23.5, \
-1.60784}, {23.6, -1.63756}, {23.7, -1.22832}, {23.8, -0.741535}, \
{23.9, -0.431717}, {24., -1.71876}, {24.1, -1.32409}, {24.2, \
-1.38546}, {24.3, -0.823337}, {24.4, -0.378629}, {24.5, -1.31047}, \
{24.6, -0.988359}, {24.7, -1.2455}, {24.8, -0.514438}, {24.9, \
-1.13862}, {25., -0.77094}, {25.1, -0.433882}, {25.2, -2.30463}, \
{25.3, -2.08047}, {25.4, -1.40826}, {25.5, -0.893917}, {25.6, \
-0.793675}, {25.7, -0.391313}, {25.8, -0.511713}, {25.9, -1.04829}, \
{26., -0.541131}, {26.1, -0.82043}, {26.2,
0.600589}, {26.3, -0.377675}, {26.4, -0.061813}, {26.5, \
-0.486962}, {26.6, -0.414118}, {26.7,
0.105646}, {26.8, -0.644548}, {26.9, -0.343485}, {27., -0.981936}, \
{27.1, -0.0407037}, {27.2, -0.234423}, {27.3,
0.286568}, {27.4, -0.146889}, {27.5, -0.730523}, {27.6,
0.103514}, {27.7, -0.209111}, {27.8,
0.152199}, {27.9, -0.522043}, {28., -0.0343532}, {28.1, \
-0.0489895}, {28.2, -0.112836}, {28.3, -0.333288}, {28.4, -0.87406}, \
{28.5, 0.305708}, {28.6, 0.194438}, {28.7,
0.384442}, {28.8, -0.415754}, {28.9, -0.728163}, {29.,
0.0816142}, {29.1, 0.634605}, {29.2,
0.168486}, {29.3, -1.27841}, {29.4, -1.11329}, {29.5, -0.181558}, \
{29.6, 0.204415}, {29.7, 0.32038}, {29.8, -0.682622}, {29.9,
0.428077}, {30.,
0.237584}, {30.1, -0.0408261}, {30.2, -1.00279}, {30.3, -0.71878}, \
{30.4, -0.024101}, {30.5,
0.354297}, {30.6, -0.918769}, {30.7, -1.56772}, {30.8, -0.464402}, \
{30.9, -0.446924}, {31.,
0.512678}, {31.1, -0.459341}, {31.2, -0.94312}, {31.3, -0.732189}, \
{31.4, 0.156304}, {31.5, -0.500125}, {31.6, -1.36575}, {31.7, \
-0.767106}, {31.8, -0.873288}, {31.9,
0.0836546}, {32., -1.01527}, {32.1, -1.21197}, {32.2, -0.910866}, \
{32.3, 0.116672}, {32.4,
0.159472}, {32.5, -3.04366}, {32.6, -1.07693}, {32.7, -1.26142}, \
{32.8, -0.386083}, {32.9, -1.12385}, {33., -2.03219}, {33.1, \
-1.1842}, {33.2, -0.772988}, {33.3, -0.115476}, {33.4, -0.946136}, \
{33.5, -1.35476}, {33.6, -1.65757}, {33.7, -1.69945}, {33.8, \
-0.533412}, {33.9, -1.78886}, {34., -1.4043}, {34.1, -1.9347}, {34.2, \
-1.00131}, {34.3, -0.698062}, {34.4, -1.82262}, {34.5, -2.09736}, \
{34.6, -1.17495}, {34.7, -0.280006}, {34.8, -2.03044}, {34.9, \
-1.57087}, {35., -2.06502}, {35.1, -1.24699}, {35.2, -0.715318}, \
{35.3, -2.10473}, {35.4, -1.89691}, {35.5, -2.50675}, {35.6, \
-0.497778}, {35.7, -0.965232}, {35.8, -1.33906}, {35.9, -2.05886}, \
{36., -1.74712}, {36.1, -0.742929}, {36.2, -2.50036}, {36.3, -1.755}, \
{36.4, -7.654}, {36.5, -1.70825}, {36.6, -1.27011}, {36.7, -2.05871}, \
{36.8, -2.34348}, {36.9, -1.88737}, {37., -0.280514}, {37.1, \
-1.56489}, {37.2, -2.13481}, {37.3, -2.36587}, {37.4, -1.96937}, \
{37.5, -1.12344}, {37.6, -1.98843}, {37.7, -2.22396}, {37.8, \
-2.21861}, {37.9, -0.927686}, {38., -1.69275}, {38.1, -2.28129}, \
{38.2, -2.24542}, {38.3, -2.01357}, {38.4, -0.825055}, {38.5, \
-1.84442}, {38.6, -2.13998}, {38.7, -2.22663}, {38.8, -1.8498}, \
{38.9, -1.57392}, {39., -1.88684}, {39.1, -2.05878}, {39.2, \
-2.30895}, {39.3, -0.496777}, {39.4, -1.47468}, {39.5, -2.0257}, \
{39.6, -2.20302}, {39.7, -1.698}, {39.8, -1.5003}, {39.9, -1.62089}, \
{40., -1.94323}, {40.1, -2.03294}, {40.2, -1.12493}, {40.3, \
-1.37093}, {40.4, -1.05747}, {40.5, -1.95879}, {40.6, -1.29792}, \
{40.7, -1.60942}, {40.8, -1.36897}, {40.9, -1.37646}, {41., \
-2.12263}, {41.1, -1.10889}, {41.2, -1.39355}, {41.3, -0.422873}, \
{41.4, -2.04664}, {41.5, -1.68238}, {41.6, -0.815515}, {41.7, \
-1.0104}, {41.8, -0.535681}, {41.9, -1.65516}, {42., -1.13655}, \
{42.1, -1.87871}, {42.2, -0.627101}, {42.3, -0.947985}, {42.4, \
-1.67003}, {42.5, -0.615653}, {42.6, -1.352}, {42.7, -0.377247}, \
{42.8, -1.27368}, {42.9, -0.902311}, {43., -0.353911}, {43.1, \
-0.552368}, {43.2, -0.144297}, {43.3, -1.87974}, {43.4, -1.10437}, \
{43.5, -1.39499}, {43.6, -0.169467}, {43.7,
0.10789}, {43.8, -1.25057}, {43.9, -0.0106244}, {44., -1.15238}, \
{44.1, 0.157374}, {44.2, -0.754672}, {44.3, -0.557962}, {44.4, \
-1.22324}, {44.5, -0.675886}, {44.6, -0.0797495}, {44.7, -1.58134}, \
{44.8, 0.0919991}, {44.9, -1.17274}, {45., -0.056119}, {45.1, \
-2.76715}, {45.2, -0.275937}, {45.3, -0.224785}, {45.4, -0.790307}, \
{45.5, 0.399444}, {45.6, -0.550316}, {45.7, -0.0209886}, {45.8, \
-0.959948}, {45.9, -0.360362}, {46.,
0.331637}, {46.1, -0.397114}, {46.2,
0.126575}, {46.3, -0.447225}, {46.4, 0.257987}, {46.5,
0.361125}, {46.6,
0.255336}, {46.7, -0.497678}, {46.8, -1.04764}, {46.9,
0.119159}, {47., 0.0471352}, {47.1,
0.464781}, {47.2, -0.369961}, {47.3, -0.379865}, {47.4,
0.366095}, {47.5, 0.117017}, {47.6,
0.0846869}, {47.7, -0.582086}, {47.8, 0.166499}}}
![](http://hiphotos.baidu.com/lomo95/pic/item/643519c8a20fcf287e3e6fac.jpg?v=tbs)