# Troy University MSM 6633 Statistical Significance Worksheet

Troy University MSM 6633 Statistical Significance Worksheet ORDER NOW FOR CUSTOMIZED AND ORIGINAL ESSAY PAPERS ON Troy University MSM 6633 Statistical Significance Worksheet I dont understand this Statistics question and need help to study. my stats homework is on a file and i couldnt copy is so im gone post the whole file. msm_6633_excel_homework_2.pdf MSM 6633 Excel Homework 2: Statistical Significance Instructions: For all items, calculate mean, standard deviation, skew, and z-statistic in Microsoft Excel before taking the quiz. Round answers to one decimal place. See page 2 for explanation and guidance. 1. What is the skew of the following distribution, and what is the z-statistic for a score of 1101? 450 563 474 171 662 564 399 670 266 439 2. Lon, a new graduate student in business, took the Team Orientation self-test and scored 150. What is the z-statistic of this score, and what is the skew of the distribution? 116 106 114 111 90 113 95 100 113 120 3. On the Engagement subscale of the Team Orientation self-test, Lon scored 67. What is the zstatistic of this score, and what is the skew of the distribution? 62 55 58 59 48 63 54 55 58 67 4. Lon scored 83 on the Proactivity subscale of the Team Orientation self-test. What is the zstatistic of this score, and what is the skew of the distribution? 54 51 56 52 42 50 41 45 55 53 5. Selena, a CEO, scored 3 on the Neuroticism subscale of the Five-Factor Personality self-test (scale of 39). What is the z-statistic of this score, and what is the skew of the distribution? 5 3 3 3 4 4 3 4 4 5 6. Selena then scored 9 on the Conscientiousness subscale (scale of 39). What is the z-statistic of this score, and what is the skew of the distribution? 8 9 9 9 9 8 8 8 9 8 7. Tom, a top manager, took a self-test for his MBTI profile, scoring 6 on the Feeling (F) subscale (scale of 012). What is this scores z-statistic, and what is the distributions skew? 1 4 1 1 1 6 2 1 7 5 8. Tom then scored 12 on the Judging (J) subscale of the MBTI self-assessment (scale of 012). What is the z-statistic of this score, and what is the skew of the distribution? 11 11 10 11 10 10 9 10 10 11 9. Thùy, an exemplary employee, took the Work Locus of Control self-assessment (scale of 16112) and scored 16. What is this scores z-statistic, and what is the distributions skew? 16 57 16 32 46 33 16 40 16 16 10. Keasha took a class on emotional intelligence for executives. On an initial self-test of EQ, she scored 159. (scale of 33165). What is the z-statistic, and what is the skew of the distribution? 131 137 140 137 152 132 141 159 156 133 Page 1 of 2 MSM 6610 Guidance for Excel Homework 2: Statistical Significance In statistical research, statistical significance is our main measure of meaningfulness. An observed value may differ from some criterion value without being different enough to matter. This distinction can govern our entire conclusion from an analysis: Is this statistical finding worth investigating more closely, or should we conclude that this result is effectively inert, consistent with random error alone? Does this drug actually speed a patients recovery from COVID-19? Does this training design really improve employees accuracy with this software? Is your political candidate winning, or just tied? Do extraverts truly make better leaders? The numbers may say different or better, but how much of a difference do we need to see to be confident that the effect is more than just a statistical accident ? When the analysis involves looking for a difference between numbers (e.g., between mean scores on a leadership ability test taken by introverts versus extraverts), the answer lies in the standard deviation. We must also consider distribution sample size and skew, but for most purposes, values that lie at least two standard deviations from the mean are significant.* * Strictly speaking, the distance is 1.959963985 standard deviations. With a sufficiently large sample size, the odds of an observations landing this far afield of the mean of any normal distribution are no more than one in 20 (hence, p ? .05). In testing theories of organizational behavior, the p < .05 criterion is our common gauge for determining whether an outcome is significant, hence worth investigating further, as opposed to nonsignificant (n.s.), the equivalent of evidencing no difference from the baseline. When we calculate how far a value lies from the mean in a normal distribution and convert that distance into standard deviations, the result is a z-statistic (or z-score). If z = 2.0, the value is two standard deviations above the mean: to the right of the mean in a standard graph of the distribution, like this one. ? If z = 1.5, the observed value is 1.5 standard deviations below the mean (to the left). In this weeks exercises, the sample size (n) of each distribution is actually too small to apply the rule of two standard deviations with confidence. Nevertheless, to keep from having you input too many data points into your spreadsheet, we will ignore that limitation for the purpose of this exercise. Still, for good practice, always check the skew of the distribution. If the skew is too large (whether positive or negative), we would object to using the z-statistic to draw conclusions about the observed value. To calculate a z-statistic, first subtract as follows: observed value minus mean of the distribution. Then divide the result by the standard deviation of the distribution. In other words: z= observed value mean standard deviation Page 2 of 2 Get a 10 % discount on an order above $ 100 Use the following coupon code : NURSING10