Stats Excel hw 4/23/13 by 8pm

profileSchoolDaze
hw_stats_excel_5_april_21.xlsx

Sheet1

Number of Minutes Exercised Per Week PART ONE Sample N Sample Mean (M) Sigma (σ) Alpha 95% Confidence Interval (+/-) Lower Limit Upper Limit
89 Freshmen 50 89.14 35.68 0.05 1.96 19.21 159.07
43 25 (-2) No formula utilized for CI (-4) E3-H3, E3+H3 (-2) 12.4.12
47 1. Conclusion in words (fill in the blanks): There is a 95 % chance that the range 19.21 to 159.07 contains the true population mean of 100 .
143 Write the words/numbers that go in the blanks here:
115 2. What is the probability (or chance or risk) that the statement that "the population parameter falls between these limits" is not correct?
136 Answer: 5%
29 3. Does the confidence interval based on this sample contain the true population mean? (we don't always know this, but in this case we do)
44 Answer: yes, the population mean is given as 100 and is covered in this range of 19.21 to 159.07 No (-3)
129 4. What might the answer to number 3 tell us about our sample of Freshmen college students?
98 Answer: This suggests that the sample is a representative of the population
99 5. If you were to construct a 99% CI, would you expect it to be wider or narrower than the 95% CI you just figured?
115 Answer: For 99%, critical value of z is 2.58 the range is -2.92 to 181.20
64 yes, the range is wider than the 95% CI shown above.
90 PART TWO
132 Null Hypothesis (H0)
72 Research Hypothesis (H1)
141 One- or Two-tailed? If one-tailed, which direction, or tail (left or right), are we interested in? Answer: left
26
144 Sample Size (N)
78 Population Mean (μ)
86 Population Standard Dev. (σ)
110 Stand. Error of Mean (σM)
69
37 Sample Mean
42 Alpha
77 Critical Z Value (cut-off score) Be sure your value is in the correct direction(s)!
120 Sample Z
51
56 Critical p-value
87 Sample p-value Part 2 not comlete (-18)
114
123 1. Are the results of your hypothesis test statistically significant? What does this mean?
28 Answer: the hypothesis is not statistically significance since the p value 0.9843 is less than the significance level 5 Significant (-3)
48 2. Decision about null and research hypotheses (write in sentence form):
107 Answer: the null and research hypotheses is rejected due to the low p value
107 3. If the population mean were unknown, what would be the best estimate of this value?
42 Answer: a population mean of 80.14 will be appropriate if the significant value is 1 and none if its 5 Sample mean (-3)
105 4. P-values represent probabilities based on the under the normal curve, and they range from to . Area, 0 to 1 (-2)
135 Write the words/numbers that go in the blanks here: P- values represent probabilities based on the significance value under the normal curve and they range from 0.05 to 1.0
103 5. The particular type of hypothesis test we used here is called the test. We can use this test when the values are known.
57 Write the words/numbers that go in the blanks here: the particular type of hypothesis test used here is called one tailed test. We can use this test when the significance values are known.
89 z, population (-3)
100
142
45
77
133
130
107
96

Sheet2

Sheet3