Hello,
I am a student using R-Studio. I would like to run a wilcox.test() using:
A binomial data (example: People > 180 and people <180) as 1 vs. 0
About 80 observation regarding Group 1 and 0
My data is imported from excel. I am able to run wilcox.test() for 1 vs. 0 using for example observation 1. After that, I am running the same wilcox.test() for 1 vs. 0 using observation 2. My main problem is, that my simple method is very slow.
How can i run the wilcox.test() using 1 vs. 0 für all the 80 observations with only one code and have the same output as follows:
Wilcoxon rank sum test with continuity correction
data: Observation 1 by OnevsZero
W = 143.5, p-value = 0.01125
alternative hypothesis: true location shift is not equal to 0
95 percent confidence interval:
-0.18002023 -0.01998433
sample estimates:
difference in location
-0.1100015
Thank you very very much,
Alexandru
See the FAQ: How to do a minimal reproducible example reprex
for beginners for a better way to attract more directly useful answers.
An analogous problem would be to apply some function to the rows of the mtcars
dataset of its first column variable, mpg to each of the remaining 10 column variables in turn. Although it is a nonsense calculation, let that be addition.
add_cols <- function(x) mtcars[1] + mtcars[x]
lapply(2:11,add_cols)
#> [[1]]
#> mpg
#> Mazda RX4 27.0
#> Mazda RX4 Wag 27.0
#> Datsun 710 26.8
#> Hornet 4 Drive 27.4
#> Hornet Sportabout 26.7
#> Valiant 24.1
#> Duster 360 22.3
#> Merc 240D 28.4
#> Merc 230 26.8
#> Merc 280 25.2
#> Merc 280C 23.8
#> Merc 450SE 24.4
#> Merc 450SL 25.3
#> Merc 450SLC 23.2
#> Cadillac Fleetwood 18.4
#> Lincoln Continental 18.4
#> Chrysler Imperial 22.7
#> Fiat 128 36.4
#> Honda Civic 34.4
#> Toyota Corolla 37.9
#> Toyota Corona 25.5
#> Dodge Challenger 23.5
#> AMC Javelin 23.2
#> Camaro Z28 21.3
#> Pontiac Firebird 27.2
#> Fiat X1-9 31.3
#> Porsche 914-2 30.0
#> Lotus Europa 34.4
#> Ford Pantera L 23.8
#> Ferrari Dino 25.7
#> Maserati Bora 23.0
#> Volvo 142E 25.4
#>
#> [[2]]
#> mpg
#> Mazda RX4 181.0
#> Mazda RX4 Wag 181.0
#> Datsun 710 130.8
#> Hornet 4 Drive 279.4
#> Hornet Sportabout 378.7
#> Valiant 243.1
#> Duster 360 374.3
#> Merc 240D 171.1
#> Merc 230 163.6
#> Merc 280 186.8
#> Merc 280C 185.4
#> Merc 450SE 292.2
#> Merc 450SL 293.1
#> Merc 450SLC 291.0
#> Cadillac Fleetwood 482.4
#> Lincoln Continental 470.4
#> Chrysler Imperial 454.7
#> Fiat 128 111.1
#> Honda Civic 106.1
#> Toyota Corolla 105.0
#> Toyota Corona 141.6
#> Dodge Challenger 333.5
#> AMC Javelin 319.2
#> Camaro Z28 363.3
#> Pontiac Firebird 419.2
#> Fiat X1-9 106.3
#> Porsche 914-2 146.3
#> Lotus Europa 125.5
#> Ford Pantera L 366.8
#> Ferrari Dino 164.7
#> Maserati Bora 316.0
#> Volvo 142E 142.4
#>
#> [[3]]
#> mpg
#> Mazda RX4 131.0
#> Mazda RX4 Wag 131.0
#> Datsun 710 115.8
#> Hornet 4 Drive 131.4
#> Hornet Sportabout 193.7
#> Valiant 123.1
#> Duster 360 259.3
#> Merc 240D 86.4
#> Merc 230 117.8
#> Merc 280 142.2
#> Merc 280C 140.8
#> Merc 450SE 196.4
#> Merc 450SL 197.3
#> Merc 450SLC 195.2
#> Cadillac Fleetwood 215.4
#> Lincoln Continental 225.4
#> Chrysler Imperial 244.7
#> Fiat 128 98.4
#> Honda Civic 82.4
#> Toyota Corolla 98.9
#> Toyota Corona 118.5
#> Dodge Challenger 165.5
#> AMC Javelin 165.2
#> Camaro Z28 258.3
#> Pontiac Firebird 194.2
#> Fiat X1-9 93.3
#> Porsche 914-2 117.0
#> Lotus Europa 143.4
#> Ford Pantera L 279.8
#> Ferrari Dino 194.7
#> Maserati Bora 350.0
#> Volvo 142E 130.4
#>
#> [[4]]
#> mpg
#> Mazda RX4 24.90
#> Mazda RX4 Wag 24.90
#> Datsun 710 26.65
#> Hornet 4 Drive 24.48
#> Hornet Sportabout 21.85
#> Valiant 20.86
#> Duster 360 17.51
#> Merc 240D 28.09
#> Merc 230 26.72
#> Merc 280 23.12
#> Merc 280C 21.72
#> Merc 450SE 19.47
#> Merc 450SL 20.37
#> Merc 450SLC 18.27
#> Cadillac Fleetwood 13.33
#> Lincoln Continental 13.40
#> Chrysler Imperial 17.93
#> Fiat 128 36.48
#> Honda Civic 35.33
#> Toyota Corolla 38.12
#> Toyota Corona 25.20
#> Dodge Challenger 18.26
#> AMC Javelin 18.35
#> Camaro Z28 17.03
#> Pontiac Firebird 22.28
#> Fiat X1-9 31.38
#> Porsche 914-2 30.43
#> Lotus Europa 34.17
#> Ford Pantera L 20.02
#> Ferrari Dino 23.32
#> Maserati Bora 18.54
#> Volvo 142E 25.51
#>
#> [[5]]
#> mpg
#> Mazda RX4 23.620
#> Mazda RX4 Wag 23.875
#> Datsun 710 25.120
#> Hornet 4 Drive 24.615
#> Hornet Sportabout 22.140
#> Valiant 21.560
#> Duster 360 17.870
#> Merc 240D 27.590
#> Merc 230 25.950
#> Merc 280 22.640
#> Merc 280C 21.240
#> Merc 450SE 20.470
#> Merc 450SL 21.030
#> Merc 450SLC 18.980
#> Cadillac Fleetwood 15.650
#> Lincoln Continental 15.824
#> Chrysler Imperial 20.045
#> Fiat 128 34.600
#> Honda Civic 32.015
#> Toyota Corolla 35.735
#> Toyota Corona 23.965
#> Dodge Challenger 19.020
#> AMC Javelin 18.635
#> Camaro Z28 17.140
#> Pontiac Firebird 23.045
#> Fiat X1-9 29.235
#> Porsche 914-2 28.140
#> Lotus Europa 31.913
#> Ford Pantera L 18.970
#> Ferrari Dino 22.470
#> Maserati Bora 18.570
#> Volvo 142E 24.180
#>
#> [[6]]
#> mpg
#> Mazda RX4 37.46
#> Mazda RX4 Wag 38.02
#> Datsun 710 41.41
#> Hornet 4 Drive 40.84
#> Hornet Sportabout 35.72
#> Valiant 38.32
#> Duster 360 30.14
#> Merc 240D 44.40
#> Merc 230 45.70
#> Merc 280 37.50
#> Merc 280C 36.70
#> Merc 450SE 33.80
#> Merc 450SL 34.90
#> Merc 450SLC 33.20
#> Cadillac Fleetwood 28.38
#> Lincoln Continental 28.22
#> Chrysler Imperial 32.12
#> Fiat 128 51.87
#> Honda Civic 48.92
#> Toyota Corolla 53.80
#> Toyota Corona 41.51
#> Dodge Challenger 32.37
#> AMC Javelin 32.50
#> Camaro Z28 28.71
#> Pontiac Firebird 36.25
#> Fiat X1-9 46.20
#> Porsche 914-2 42.70
#> Lotus Europa 47.30
#> Ford Pantera L 30.30
#> Ferrari Dino 35.20
#> Maserati Bora 29.60
#> Volvo 142E 40.00
#>
#> [[7]]
#> mpg
#> Mazda RX4 21.0
#> Mazda RX4 Wag 21.0
#> Datsun 710 23.8
#> Hornet 4 Drive 22.4
#> Hornet Sportabout 18.7
#> Valiant 19.1
#> Duster 360 14.3
#> Merc 240D 25.4
#> Merc 230 23.8
#> Merc 280 20.2
#> Merc 280C 18.8
#> Merc 450SE 16.4
#> Merc 450SL 17.3
#> Merc 450SLC 15.2
#> Cadillac Fleetwood 10.4
#> Lincoln Continental 10.4
#> Chrysler Imperial 14.7
#> Fiat 128 33.4
#> Honda Civic 31.4
#> Toyota Corolla 34.9
#> Toyota Corona 22.5
#> Dodge Challenger 15.5
#> AMC Javelin 15.2
#> Camaro Z28 13.3
#> Pontiac Firebird 19.2
#> Fiat X1-9 28.3
#> Porsche 914-2 26.0
#> Lotus Europa 31.4
#> Ford Pantera L 15.8
#> Ferrari Dino 19.7
#> Maserati Bora 15.0
#> Volvo 142E 22.4
#>
#> [[8]]
#> mpg
#> Mazda RX4 22.0
#> Mazda RX4 Wag 22.0
#> Datsun 710 23.8
#> Hornet 4 Drive 21.4
#> Hornet Sportabout 18.7
#> Valiant 18.1
#> Duster 360 14.3
#> Merc 240D 24.4
#> Merc 230 22.8
#> Merc 280 19.2
#> Merc 280C 17.8
#> Merc 450SE 16.4
#> Merc 450SL 17.3
#> Merc 450SLC 15.2
#> Cadillac Fleetwood 10.4
#> Lincoln Continental 10.4
#> Chrysler Imperial 14.7
#> Fiat 128 33.4
#> Honda Civic 31.4
#> Toyota Corolla 34.9
#> Toyota Corona 21.5
#> Dodge Challenger 15.5
#> AMC Javelin 15.2
#> Camaro Z28 13.3
#> Pontiac Firebird 19.2
#> Fiat X1-9 28.3
#> Porsche 914-2 27.0
#> Lotus Europa 31.4
#> Ford Pantera L 16.8
#> Ferrari Dino 20.7
#> Maserati Bora 16.0
#> Volvo 142E 22.4
#>
#> [[9]]
#> mpg
#> Mazda RX4 25.0
#> Mazda RX4 Wag 25.0
#> Datsun 710 26.8
#> Hornet 4 Drive 24.4
#> Hornet Sportabout 21.7
#> Valiant 21.1
#> Duster 360 17.3
#> Merc 240D 28.4
#> Merc 230 26.8
#> Merc 280 23.2
#> Merc 280C 21.8
#> Merc 450SE 19.4
#> Merc 450SL 20.3
#> Merc 450SLC 18.2
#> Cadillac Fleetwood 13.4
#> Lincoln Continental 13.4
#> Chrysler Imperial 17.7
#> Fiat 128 36.4
#> Honda Civic 34.4
#> Toyota Corolla 37.9
#> Toyota Corona 24.5
#> Dodge Challenger 18.5
#> AMC Javelin 18.2
#> Camaro Z28 16.3
#> Pontiac Firebird 22.2
#> Fiat X1-9 31.3
#> Porsche 914-2 31.0
#> Lotus Europa 35.4
#> Ford Pantera L 20.8
#> Ferrari Dino 24.7
#> Maserati Bora 20.0
#> Volvo 142E 25.4
#>
#> [[10]]
#> mpg
#> Mazda RX4 25.0
#> Mazda RX4 Wag 25.0
#> Datsun 710 23.8
#> Hornet 4 Drive 22.4
#> Hornet Sportabout 20.7
#> Valiant 19.1
#> Duster 360 18.3
#> Merc 240D 26.4
#> Merc 230 24.8
#> Merc 280 23.2
#> Merc 280C 21.8
#> Merc 450SE 19.4
#> Merc 450SL 20.3
#> Merc 450SLC 18.2
#> Cadillac Fleetwood 14.4
#> Lincoln Continental 14.4
#> Chrysler Imperial 18.7
#> Fiat 128 33.4
#> Honda Civic 32.4
#> Toyota Corolla 34.9
#> Toyota Corona 22.5
#> Dodge Challenger 17.5
#> AMC Javelin 17.2
#> Camaro Z28 17.3
#> Pontiac Firebird 21.2
#> Fiat X1-9 28.3
#> Porsche 914-2 28.0
#> Lotus Europa 32.4
#> Ford Pantera L 19.8
#> Ferrari Dino 25.7
#> Maserati Bora 23.0
#> Volvo 142E 23.4
system
Closed
June 12, 2021, 7:50pm
3
This topic was automatically closed 21 days after the last reply. New replies are no longer allowed. If you have a query related to it or one of the replies, start a new topic and refer back with a link.