当前位置:文档之家› 用Excel图表画心形线

用Excel图表画心形线

用Excel图表画心形线
用Excel图表画心形线

步长θ(nθ)/2x=cos((nθ)/2) 0-6.283185307-95.32710.471900776

1-6.220353454-94.37390.992062495

2-6.157521601-93.42060.676945395

3-6.094689748-92.4673-0.208133935

4-6.031857895-91.514-0.917972421

5-5.969026042-90.5608-0.854913107

6-5.906194189-89.6075-0.072049532

7-5.843362336-88.65420.771477004

8-5.780530483-87.7010.965449299

9-5.71769863-86.74770.346550071

10-5.654866776-85.7944-0.564131111

11-5.592034923-84.8411-0.999835394

12-5.52920307-83.8879-0.593716372

13-5.466371217-82.93460.312289212

14-5.403539364-81.98130.955359179

15-5.340707511-81.02810.79405312

16-5.277875658-80.0748-0.03581541

17-5.215043805-79.1215-0.835528729

18-5.152211952-78.1682-0.931758695

19-5.089380099-77.215-0.243483343

20-5.026548246-76.26170.649795706

21-4.963716393-75.30840.99597153

22-4.90088454-74.35520.503577276

23-4.838052687-73.4019-0.412809856

24-4.775220833-72.4486-0.98162682

25-4.71238898-71.4953-0.723951404

26-4.649557127-70.54210.143263508

27-4.586725274-69.58880.889856006

28-4.523893421-68.63550.887223653

29-4.461061568-67.68230.137582791

30-4.398229715-66.729-0.727897539

31-4.335397862-65.7757-0.980515876

32-4.272566009-64.8224-0.407577207

33-4.209734156-63.86920.50852594

34-4.146902303-62.91590.996469623

35-4.08407045-61.96260.645423852

36-4.021238597-61.0094-0.249044209

37-3.958406744-60.0561-0.933826535

38-3.89557489-59.1028-0.832362501

39-3.832743037-58.1495-0.030080957

40-3.769911184-57.19630.797527607

41-3.707079331-56.2430.953648315

42-3.644247478-55.28970.306833479

43-3.581415625-54.3365-0.598323454

44-3.518583772-53.3832-0.999714837

45-3.455751919-52.4299-0.55938442 46-3.392920066-51.47670.351926364 47-3.330088213-50.52340.96692856 48-3.26725636-49.57010.767813751 49-3.204424507-48.6168-0.077770979 50-3.141592654-47.6636-0.857875509 51-3.078760801-46.7103-0.915681548 52-3.015928947-45.757-0.202518615 53-2.953097094-44.80380.681157275 54-2.890265241-43.85050.991324694 55-2.827433388-42.89720.466834494 56-2.764601535-41.9439-0.450712563 57-2.701769682-40.9907-0.988776815 58-2.638937829-40.0374-0.694328665 59-2.576105976-39.08410.184717764 60-2.513274123-38.13090.908238874 61-2.45044227-37.17760.86705746 62-2.387610417-36.22430.095846702 63-2.324778564-35.271-0.756063327 64-2.261946711-34.3178-0.971396843 65-2.199114858-33.3645-0.368851231 66-2.136283004-32.41120.544253063 67-2.073451151-31.4580.999117016 68-2.010619298-30.50470.612762512 69-1.947787445-29.5514-0.289514679 70-1.884955592-28.5981-0.948031541 71-1.822123739-27.6449-0.808341969 72-1.759291886-26.69160.01194074 73-1.696460033-25.73830.822169801 74-1.63362818-24.78510.940163218 75-1.570796327-23.83180.266575028 76-1.507964474-22.8785-0.631459177 77-1.445132621-21.9252-0.997828817 78-1.382300768-20.972-0.524064613 79-1.319468915-20.01870.390942026 80-1.256637061-19.06540.976790375 81-1.193805208-18.11220.740218448 82-1.130973355-17.1589-0.119589207 83-1.068141502-16.2056-0.878707307 84-1.005309649-15.2523-0.897987336 85-0.942477796-14.2991-0.161196245 86-0.879645943-13.34580.711315942 87-0.81681409-12.39250.98492721 88-0.753982237-11.43930.429267296 89-0.691150384-10.486-0.487819325 90-0.628318531-9.53271-0.994180661 91-0.565486678-8.57944-0.663479763

92-0.502654825-7.626170.225845815 93-0.439822972-6.67290.925017822 94-0.376991118-5.719630.84536007 95-0.314159265-4.766360.05394135 96-0.251327412-3.81309-0.782893931 97-0.188495559-2.85981-0.960562354 98-0.125663706-1.90654-0.329473875 99-0.062831853-0.953270.579019052 100001 1010.0628318530.9532710.579019052 1020.1256637061.906543-0.329473875 1030.1884955592.859814-0.960562354 1040.2513274123.813085-0.782893931 1050.3141592654.7663570.05394135 1060.3769911185.7196280.84536007 1070.4398229726.6728990.925017822 1080.5026548257.626170.225845815 1090.5654866788.579442-0.663479763 1100.6283185319.532713-0.994180661 1110.69115038410.48598-0.487819325 1120.75398223711.439260.429267296 1130.8168140912.392530.98492721 1140.87964594313.34580.711315942 1150.94247779614.29907-0.161196245 116 1.00530964915.25234-0.897987336 117 1.06814150216.20561-0.878707307 118 1.130********.15888-0.119589207 119 1.19380520818.112150.740218448 120 1.25663706119.065430.976790375 121 1.31946891520.01870.390942026 122 1.38230076820.97197-0.524064613 123 1.44513262121.92524-0.997828817 124 1.50796447422.87851-0.631459177 125 1.57079632723.831780.266575028 126 1.6336281824.785050.940163218 127 1.69646003325.738330.822169801 128 1.75929188626.69160.01194074 129 1.82212373927.64487-0.808341969 130 1.88495559228.59814-0.948031541 131 1.94778744529.55141-0.289514679 132 2.010********.504680.612762512 133 2.0734*******.457950.999117016 134 2.136********.411220.544253063 135 2.199********.3645-0.368851231 136 2.26194671134.31777-0.971396843 137 2.32477856435.27104-0.756063327 138 2.38761041736.224310.095846702

139 2.4504422737.177580.86705746 140 2.51327412338.130850.908238874 141 2.57610597639.084120.184717764 142 2.63893782940.03739-0.694328665 143 2.70176968240.99067-0.988776815 144 2.76460153541.94394-0.450712563 145 2.82743338842.897210.466834494 146 2.89026524143.850480.991324694 147 2.95309709444.803750.681157275 148 3.01592894745.75702-0.202518615 149 3.07876080146.71029-0.915681548 150 3.14159265447.66357-0.857875509 151 3.20442450748.61684-0.077770979 152 3.2672563649.570110.767813751 153 3.33008821350.523380.96692856 154 3.39292006651.476650.351926364 155 3.45575191952.42992-0.55938442 156 3.51858377253.38319-0.999714837 157 3.58141562554.33646-0.598323454 158 3.64424747855.289740.306833479 159 3.70707933156.243010.953648315 160 3.76991118457.196280.797527607 161 3.83274303758.14955-0.030080957 162 3.8955748959.10282-0.832362501 163 3.95840674460.05609-0.933826535 164 4.021********.00936-0.249044209 165 4.0840704561.962630.645423852 166 4.14690230362.915910.996469623 167 4.20973415663.869180.50852594 168 4.27256600964.82245-0.407577207 169 4.33539786265.77572-0.980515876 170 4.39822971566.72899-0.727897539 171 4.46106156867.682260.137582791 172 4.52389342168.635530.887223653 173 4.58672527469.588810.889856006 174 4.64955712770.542080.143263508 175 4.7123889871.49535-0.723951404 176 4.77522083372.44862-0.98162682 177 4.83805268773.40189-0.412809856 178 4.9008845474.355160.503577276 179 4.96371639375.308430.99597153 180 5.02654824676.26170.649795706 181 5.0893*******.21498-0.243483343 182 5.152********.16825-0.931758695 183 5.21504380579.12152-0.835528729 184 5.27787565880.07479-0.03581541 185 5.34070751181.028060.79405312

186 5.40353936481.981330.955359179 187 5.46637121782.93460.312289212 188 5.5292030783.88787-0.593716372 189 5.59203492384.84115-0.999835394 190 5.65486677685.79442-0.564131111 191 5.7176986386.747690.346550071 192 5.78053048387.700960.965449299 193 5.84336233688.654230.771477004 194 5.90619418989.6075-0.072049532 195 5.96902604290.56077-0.854913107 196 6.0318*******.51405-0.917972421 197 6.09468974892.46732-0.208133935 198 6.157********.420590.676945395 199 6.22035345494.373860.992062495 200 6.28318530795.327130.471900776

y=sin((nθ)/2)+(cos((n

θ)/2))^(2/3)30.34357 -0.275519783

0.868955509

1.507000187

1.329306337

1.341182914

0.382000308

-0.82425174

0.204909335

1.237422448

1.43140669

1.508422111

1.018033736

-0.098271146

-0.489690244

0.674566672

1.465346217

1.108012647

1.43655019

0.59089388

-0.579981494

-0.009895948

1.086982556

1.496911865

1.465230186

1.178524263

0.116404997

-0.715890709

0.468910658

1.384666288

1.256997755

1.49486907

0.790528179

-0.363452791

-0.223945004

0.913690926

1.510668812

1.364330252

1.313109077

0.330629299

-0.902824909

0.256714972

1.269778501

1.406683353

1.511307535

0.975930105

-0.150006638 -0.437562843

0.722781658

1.479174772 1.179169855 1.416708779 0.541062002 -0.634418036

0.042024431

1.125643796 1.486130536 1.480519027 1.14190398 0.064451479 -0.658447679

0.519397934

1.407490134 1.204832162 1.484423344 0.743377208 -0.415167562 -0.172318109

0.957397108

1.511698096 1.394810265 1.283223493 0.279041031 -0.947686583

0.308380043

1.300424432 1.378016918 1.511441388 0.93269116 -0.20166374 -0.385758737

0.770268951

1.490655247 1.235555994 1.39476958 0.490758197 -0.690732677

0.093974745

1.162895395 1.472229383 1.49263202 1.103842303 0.012514596

-0.603304737

0.569441687

1.428245576 1.141306736 1.471600239 0.695467643 -0.467132901 -0.120617312

1 1.51001071

2 1.42119648

3 1.251596999 0.227289839 -0.855781475

0.359851731

1.329289116 1.345021384 1.508903053 0.888391034 -0.253257217 -0.334125608

0.816956723

1.499719572 1.28311207 1.370800796 0.440047697 -0.750090924

0.145922338

1.198663922 1.455071872 1.501693276 1.06441288 -0.039376857 -0.549611422

0.618975609

1.446864681 1.052170831 1.45646748 0.646870771 -0.519536883 -0.068836123 1.041425406 1.505524081 1.443809328 1.21830109 0.175426406 -0.785960052

0.411073832

1.356302102 1.30713554 1.503767573 0.843103642 -0.304819245 -0.282558872

0.86277234

1.506298676 1.32413879 1.34487119 0.388993621 -0.814772647

0.197828537

1.232876396 1.434492535 1.507810084 1.02368966 -0.091201802 -0.496843076

0.667931702

1.463279875 1.096270022 1.439092499 0.597656767 -0.572653983 -0.01698043 1.08159913 1.498148336 1.462888711 1.183407888 0.123497241 -0.723982786

0.461987168

1.38139362 1.26347845 1.496106942 0.796902528 -0.35640427 -0.23098851

0.907642538

1.510321853 1.359828663 1.317050156 0.337656669 -0.890704198 0.249649474

1.265460366 1.410283912 1.511077629 0.981746783 -0.142948337 -0.44465626

0.716240515

1.477423749 1.17055037 1.419542748 0.547894483 -0.626894333

0.034933704

1.120447101 1.487783546

相关主题
文本预览
相关文档 最新文档