3 Describe the function NORMDIST Provide an example in H28 Additional examples

3 describe the function normdist provide an example

This preview shows page 63 - 83 out of 209 pages.

3 Describe the function NORM.DIST. Provide an example in H28. Additional examples 4 Describe the function NORM.S.DIST. Provide an example in H43. Additional examples
Image of page 63
5 Describe the function NORM.INV. Provide an example in H52. Additional examples 6 Describe the function NORM.S.INV. Provide an example in H66. Additional examples 7 What is a confidence interval and how does it relate to the normal distribution? 8 9 Calculate a 95% confidence interval for a sample size=30 when the population mean (50) and the po Calculate a 99% confidence interval for a sample size=30 with mean of 50 and a standard deviation o
Image of page 64
10a What is a controlling factor in the range of the confidence interval? 10b Compute the up for the followin N=30 11 Define the Central Limit Theorem See the followi 12 Explain the rationale for testing the difference between means. 13 Compute a z-test. Prices $ 45.23 Sample Mean $ 35.48 $ 36.57 $ 43.22 $ 42.94 $ 37.11 p-value $ 44.05 z of p-value $ 44.96 $ 42.99 $ 40.23 $ 50.93 $ 36.26 Null hypothesis (H 0 :) Alternative hypothesis (H a : )
Image of page 65
$ 51.91 $ 37.03 $ 40.12 $ 41.59 $ 40.18 $ 61.40 $ 40.51 $ 40.17 $ 49.93 $ 61.61 $ 36.93 $ 45.39 $ 41.56 $ 40.93 $ 50.49 $ 43.03 $ 40.13 $ 52.97 $ 42.10 $ 30.31 $ 54.16 $ 46.67 $ 43.32 $ 31.88 $ 64.60 $ 45.71 $ 58.27 $ 31.94 14 Compute a t-test comparing the two samples. State 1 State 2 283 229 254 267 328 326 292 309 315 231 336 283 378 344 314 310 312 258 328 316 272 241 307 281 348 218 233 284 354 311 400 254
Image of page 66
341 217 313 267 309 299 308 266 340 264 300 264 316 290 268 312 259 298 276 305 271 244 362 303 340 299 339 285 300 308 333 260 204 291 242 329 315 246 322 293 15 What is the decision rule? 16 What is statistical power?
Image of page 67
Image of page 68
opulation standard deviation (10) are known . of 10, but the population mean and the population standard deviation are unknown .
Image of page 69
pper and lower confidence interval limits for a sample with a mean =50 and a sample standard deviati ng two sample sizes. N=100 Upper limit Lower limit ing video for an explanation of the Central Limit Theorem. outube.com/watch?v=JNm3M9cqWyc
Image of page 70
Image of page 71
Image of page 72
Image of page 73
Image of page 74
tion = 10
Image of page 75
Image of page 76
Image of page 77
1 What's the difference in directional (one-tailed) and non-directional (two-tailed) hypo 2 Compute a t-test comparing the two samples. State 1 State 2 283 229 254 267 328 326 292 309 315 231 336 283 378 344 314 310 312 258 328 316 272 241 307 281 348 218 233 284
Image of page 78
354 311 400 254 341 217 313 267 309 299 308 266 340 264 300 264 316 290 268 312 259 298 276 305 271 244 362 303 340 299 339 285 300 308 333 260 204 291 242 329 315 246 322 293 3 Discuss the impact of unequal group (sample) sizes on hypothesis tests. 4 Use the Data Analysis t-test tool to compare the mean for Males vs. Females. Male Female 4.80 4.86 Specify the null and alternate hypotheses. 3.70 2.89 3.50 4.50 3.20 3.60 3.80 3.70 4.00 4.00
Image of page 79
4.40 3.80 Are the Male and Female means 3.40 4.20 significantly different? 4.20 2.70 3.90 2.90 3.80 3.50 4.20 3.78 3.90 3.90 4.00 4.75 3.38 3.90 4.00 3.70 3.30 3.20 3.50 2.80 3.40 4.00 3.60 3.70 3.50 3.89 3.70 3.80 4.00 4.30 3.00 2.60 4.30 4.20 4.00 3.70 2.60 4.60 3.30 4.60 4.10 3.00 3.00 4.40 3.90 2.70 4.30 3.50 3.50 4.30 3.80 3.60 3.60 3.80 3.90 4.30 4.30 4.00 3.70 3.50 A for Yes B for No
Image of page 80
3.80 4.30 3.60 4.10 4.20 3.90 3.70 3.00 3.50 3.20 3.90 2.90 3.60 3.70 3.50 4.30 4.00 4.11 4.30 2.10 4.20 3.60 3.00 3.50 3.50 3.60 4.10 3.40 4.20 3.50 3.60 3.60 3.50 4.10 2.90 3.00 4.20 4.30 4.20 3.90 3.70 5 What is multiple regression versus single regression? Single regression uses one predictor (independent, x) variable to predict a single criteri multiple regression two or more predictor variables are used to predict the criterion va
Image of page 81
sex org ini indi inf prwe preq prwd 1 4.92 4.50 5.00 4.75 4.67 5.00 4.56 1 3.67 4.00 3.67 2.00 4.33 4.25 3.22 1 3.25 3.00 3.50 2.75 4.33 4.50 2.38 1 3.17 3.00 3.00 2.25 4.00 4.00 3.56 1 3.67 3.50 3.83 2.75 4.00 3.75 3.44 1 3.75 3.50 3.33 3.75 3.33 2.75 3.56 1 4.42 4.00 4.00 3.33 4.67 3.75 3.11 1 3.67 4.00 3.83 3.75 4.00 4.00 3.11 1 4.67 3.50 4.00 2.75 4.00 3.25 3.67 1 3.75 4.00 3.83 4.00 4.00 3.75 3.00 1 4.08 3.00 4.50 3.75 4.00 3.75 2.78 1 3.83 4.00 3.67 2.75 4.00 4.00 3.67 1 4.00 2.50 2.50 3.50 3.33 4.00 2.33 1 4.00 3.50 3.17 3.00 4.00 4.00 3.33 1 2.92 3.00 3.00 3.00 4.00 3.50 2.67 1 3.92 2.50 3.33 3.75 3.67 3.75 2.89 1 3.17 3.00 3.67 2.25 4.00 3.25 3.11 1 4.08 4.50 4.00 3.50 4.00 4.00 3.67 1 3.75 4.00
Image of page 82
Image of page 83

You've reached the end of your free preview.

Want to read all 209 pages?

  • Fall '15
  • Work, Threesome

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture