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
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
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 : )
\$ 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
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?
opulation standard deviation (10) are known . of 10, but the population mean and the population standard deviation are unknown .
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
tion = 10
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
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
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
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
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

#### You've reached the end of your free preview.

Want to read all 209 pages?

• Fall '15
• Work, Threesome