Consider the dataset Bro Dude, which produces a random sampling of the number of times California surfers said the words Bro and Dude in a 30 minute conversation. We want to know if this particular sample is, on average, more partial to Bro or Dude.(i) Calculate the mean and standard deviation. Which one is more common?(ii) Can we be certain they are significantly different from each other? Set up a test of= 0.05 to figure out if we can be confident these surfers say Bro or Dude more often or whether they essentially use them the same.

Please answer using Excel to show how statistical problems can be analyzed with a computer program

.

1 BRO DUDE 2 3 4 17 5 6 LO 8 9 10 11 12 1 0 24 1 0 15 11 29 4 14 15 1 16 10 15 11 12 10 0 4 10 11 25 3 21 0 5 Nm 17 27 11 17 11 1 12 12 4 3 + 28 BE 68 10 23 1 98 B in 999 4 Cow 11 2. - 23 27 ina 9 im om U Cow 9 o 20 9 1 27 I 0 O in som +999 299m 2 00 14 LD 19 13 im . N 8 60 11 22 0 5 O 2 A | B 2 16 B 853 7 112 113 114 115 116 117 118 ws598 5 29 19 16 65 9 B5 121 18 15 7 14 7 9 1 4 11 20 8 0 25 12 9 wu wonym 18 13 2 14 cologuags a no E 7 26 14 La 4 12 11 21 13 145 146 w 5 30 15 8 19 lo 8 21 ms58 1 10 1 2 2 162 A 00 B 60 8 8 8 6 6 6 6 10 178 179 co o N 6 w co 6 8 0 2 12 4 4 28 2 21 24 2 1 11 8 4 1 8 21 22 23 7 25 9 9 9 9 23 9 90 206 2017 207 208 209 210 211 212 213 214 215 216 UNO un W A2 2 9 1 0 OS A A B 17 4 225 226 227 228 229 9999999999 WS 235 236 237 238 239 240 241 242 243 244 245 WRONCO Suun 256 11 259 260 263 264 265 266 267 268 269 270 8 N O 6 S 6 & 6 Cou A B 271 12 19 272 16 17 273 13 2 274 9 16 275 18 19 276 11 9 277 19 24 278 13 26 279 17 24 280 29 3 281 1 11 282 9 16 283 18 16 284 7 21 285 25 19 286 19 25 287 16 4 288 4 28 289 3 0 290 12 5 29 4 10 292 12 12 293 15 2 294 29 15 295 24 6 296 11 19 297 5 7 298 27 3 299 24 17 300 6 13 1 BRO DUDE 2 3 4 17 5 6 LO 8 9 10 11 12 1 0 24 1 0 15 11 29 4 14 15 1 16 10 15 11 12 10 0 4 10 11 25 3 21 0 5 Nm 17 27 11 17 11 1 12 12 4 3 + 28 BE 68 10 23 1 98 B in 999 4 Cow 11 2. - 23 27 ina 9 im om U Cow 9 o 20 9 1 27 I 0 O in som +999 299m 2 00 14 LD 19 13 im . N 8 60 11 22 0 5 O 2 A | B 2 16 B 853 7 112 113 114 115 116 117 118 ws598 5 29 19 16 65 9 B5 121 18 15 7 14 7 9 1 4 11 20 8 0 25 12 9 wu wonym 18 13 2 14 cologuags a no E 7 26 14 La 4 12 11 21 13 145 146 w 5 30 15 8 19 lo 8 21 ms58 1 10 1 2 2 162 A 00 B 60 8 8 8 6 6 6 6 10 178 179 co o N 6 w co 6 8 0 2 12 4 4 28 2 21 24 2 1 11 8 4 1 8 21 22 23 7 25 9 9 9 9 23 9 90 206 2017 207 208 209 210 211 212 213 214 215 216 UNO un W A2 2 9 1 0 OS A A B 17 4 225 226 227 228 229 9999999999 WS 235 236 237 238 239 240 241 242 243 244 245 WRONCO Suun 256 11 259 260 263 264 265 266 267 268 269 270 8 N O 6 S 6 & 6 Cou A B 271 12 19 272 16 17 273 13 2 274 9 16 275 18 19 276 11 9 277 19 24 278 13 26 279 17 24 280 29 3 281 1 11 282 9 16 283 18 16 284 7 21 285 25 19 286 19 25 287 16 4 288 4 28 289 3 0 290 12 5 29 4 10 292 12 12 293 15 2 294 29 15 295 24 6 296 11 19 297 5 7 298 27 3 299 24 17 300 6 13