maabadi
Well-known Member
- Joined
- Oct 22, 2012
- Messages
- 2,681
- Office Version
- 2019
- 2016
- Platform
- Windows
Hi
I have statistical data on text file and import to excel with import text wizard and split to column.
I have multiple criteria on this file and want to spli to multiple sheet per criteria.
this is one example file:
1. I want to split data based of "dependent variable"?
2. I want to create tables on each sheet based on "source" and "contrast" and "R-Square" words?
Please help if it is possible?
Thanks.
I have statistical data on text file and import to excel with import text wizard and split to column.
I have multiple criteria on this file and want to spli to multiple sheet per criteria.
this is one example file:
Code:
Number of Observations Read 102
Number of Observations Used 102
10:36 Thursday, January 24, 2016 2
The GLM Procedure
Dependent Variable: BY_t_ha_ BY(t/ha)
Sum of
Source DF Squares Mean Square F Value Pr > F
Model 37 17840.57368 482.17767 5.52 <.0001
Error 64 5591.72725 87.37074
Corrected Total 101 23432.30093
R-Square Coeff Var Root MSE BY_t_ha_ Mean
0.761367 14.89547 9.347232 62.75216
Source DF Type I SS Mean Square F Value Pr > F
Year 1 89.90174 89.90174 1.03 0.3142
Treat 16 5031.79693 314.48731 3.60 0.0001
Rep 2 11446.79551 5723.39776 65.51 <.0001
Year*Rep 2 920.41591 460.20795 5.27 0.0076
Year*Treat 16 351.66359 21.97897 0.25 0.9982
Source DF Type III SS Mean Square F Value Pr > F
Year 1 89.90174 89.90174 1.03 0.3142
Treat 16 5031.79693 314.48731 3.60 0.0001
Rep 2 11446.79551 5723.39776 65.51 <.0001
Year*Rep 2 920.41591 460.20795 5.27 0.0076
Year*Treat 16 351.66359 21.97897 0.25 0.9982
Contrast DF Contrast SS Mean Square F Value
new herbicide vs Ordinal Herbicide 1 1305.808550 1305.808550 14.95
ordinal herbicide vs control 1 377.791053 377.791053 4.32
new herbicide vs control 1 1203.043251 1203.043251 13.77
new herbicide vs weeding 1 0.000073 0.000073 0.00
ordinal herbicide vs weeding 1 0.096333 0.096333 0.00
Contrast Pr > F
new herbicide vs Ordinal Herbicide 0.0003
ordinal herbicide vs control 0.0416
new herbicide vs control 0.0004
new herbicide vs weeding 0.9993
ordinal herbicide vs weeding 0.9736
10:36 Thursday, January 24, 2016 3
The GLM Procedure
Dependent Variable: BY_t_ha_ BY(t/ha)
Contrast DF Contrast SS Mean Square F Value
new herbicide high dosage vs new herbicide low dosage 1 250.436033 250.436033 2.87
new herbicide one treat vs new herbicide two treat 1 384.653633 384.653633 4.40
arrat low dosage vs arrat high dosage 1 11.097600 11.097600 0.13
Contrast Pr > F
new herbicide high dosage vs new herbicide low dosage 0.0953
new herbicide one treat vs new herbicide two treat 0.0398
arrat low dosage vs arrat high dosage 0.7227
10:36 Thursday, January 24, 2016 4
The GLM Procedure
Dependent Variable: EarW EarW
Sum of
Source DF Squares Mean Square F Value Pr > F
Model 37 432.4429843 11.6876482 4.18 <.0001
Error 64 179.0903529 2.7982868
Corrected Total 101 611.5333373
R-Square Coeff Var Root MSE EarW Mean
0.707145 13.55878 1.672808 12.33745
Source DF Type I SS Mean Square F Value Pr > F
Year 1 114.3105922 114.3105922 40.85 <.0001
Treat 16 95.3276706 5.9579794 2.13 0.0173
Rep 2 129.4206431 64.7103216 23.12 <.0001
Year*Rep 2 59.5039373 29.7519686 10.63 0.0001
Year*Treat 16 33.8801412 2.1175088 0.76 0.7260
Source DF Type III SS Mean Square F Value Pr > F
Year 1 114.3105922 114.3105922 40.85 <.0001
Treat 16 95.3276706 5.9579794 2.13 0.0173
Rep 2 129.4206431 64.7103216 23.12 <.0001
Year*Rep 2 59.5039373 29.7519686 10.63 0.0001
Year*Treat 16 33.8801412 2.1175088 0.76 0.7260
Contrast DF Contrast SS Mean Square F Value
new herbicide vs Ordinal Herbicide 1 35.43232190 35.43232190 12.66
ordinal herbicide vs control 1 13.57441333 13.57441333 4.85
new herbicide vs control 1 40.80915202 40.80915202 14.58
new herbicide vs weeding 1 2.42448535 2.42448535 0.87
ordinal herbicide vs weeding 1 0.18881333 0.18881333 0.07
Contrast Pr > F
new herbicide vs Ordinal Herbicide 0.0007
ordinal herbicide vs control 0.0312
new herbicide vs control 0.0003
new herbicide vs weeding 0.3554
ordinal herbicide vs weeding 0.7959
10:36 Thursday, January 24, 2016 5
The GLM Procedure
Dependent Variable: EarW EarW
Contrast DF Contrast SS Mean Square F Value
new herbicide high dosage vs new herbicide low dosage 1 1.20967500 1.20967500 0.43
new herbicide one treat vs new herbicide two treat 1 0.99187500 0.99187500 0.35
arrat low dosage vs arrat high dosage 1 0.00166667 0.00166667 0.00
Contrast Pr > F
new herbicide high dosage vs new herbicide low dosage 0.5132
new herbicide one treat vs new herbicide two treat 0.5537
arrat low dosage vs arrat high dosage 0.9806
10:36 Thursday, January 24, 2016 6
The GLM Procedure
Dependent Variable: SPW SPW
Sum of
Source DF Squares Mean Square F Value Pr > F
Model 37 1716.194483 46.383635 3.26 <.0001
Error 64 911.986675 14.249792
Corrected Total 101 2628.181158
R-Square Coeff Var Root MSE SPW Mean
0.652997 10.43740 3.774890 36.16696
Source DF Type I SS Mean Square F Value Pr > F
Year 1 179.2858127 179.2858127 12.58 0.0007
Treat 16 581.2501412 36.3281338 2.55 0.0042
Rep 2 926.2533902 463.1266951 32.50 <.0001
Year*Rep 2 13.3688020 6.6844010 0.47 0.6277
Year*Treat 16 16.0363373 1.0022711 0.07 1.0000
Source DF Type III SS Mean Square F Value Pr > F
Year 1 179.2858127 179.2858127 12.58 0.0007
Treat 16 581.2501412 36.3281338 2.55 0.0042
Rep 2 926.2533902 463.1266951 32.50 <.0001
Year*Rep 2 13.3688020 6.6844010 0.47 0.6277
Year*Treat 16 16.0363373 1.0022711 0.07 1.0000
Contrast DF Contrast SS Mean Square F Value
new herbicide vs Ordinal Herbicide 1 133.9923096 133.9923096 9.40
ordinal herbicide vs control 1 26.3578133 26.3578133 1.85
new herbicide vs control 1 86.0377293 86.0377293 6.04
new herbicide vs weeding 1 0.4214557 0.4214557 0.03
ordinal herbicide vs weeding 1 3.3466800 3.3466800 0.23
Contrast Pr > F
new herbicide vs Ordinal Herbicide 0.0032
ordinal herbicide vs control 0.1786
new herbicide vs control 0.0167
new herbicide vs weeding 0.8640
ordinal herbicide vs weeding 0.6296
10:36 Thursday, January 24, 2016 7
The GLM Procedure
Dependent Variable: SPW SPW
Contrast DF Contrast SS Mean Square F Value
new herbicide high dosage vs new herbicide low dosage 1 4.2781021 4.2781021 0.30
new herbicide one treat vs new herbicide two treat 1 19.4438021 19.4438021 1.36
arrat low dosage vs arrat high dosage 1 5.4530667 5.4530667 0.38
Contrast Pr > F
new herbicide high dosage vs new herbicide low dosage 0.5856
new herbicide one treat vs new herbicide two treat 0.2471
arrat low dosage vs arrat high dosage 0.5384
10:36 Thursday, January 24, 2016 81. I want to split data based of "dependent variable"?
2. I want to create tables on each sheet based on "source" and "contrast" and "R-Square" words?
Please help if it is possible?
Thanks.
