Use dataset "HT_4143.xls" and conduct a two-sample t-test using Excel.
You'd like to test the null hypothesis that the means of the two samples (column A and column B) are the same. The alternative hypothesis is that they are not the same. You have no reason to believe that the standard deviations of the two samples are equal. Test at the alpha = 0.10 level.
After using Excel, what do you conclude? Are the means the same?
Group of answer choices
You reject the null hypothesis. Therefore, you conclude that the means of the two populations are different.
You reject the null hypothesis. Therefore, you conclude that the means of the two populations are the same.
You cannot reject the null hypothesis. Therefore, you conclude that the means of the two populations are different.
You cannot reject the null hypothesis. Therefore, you conclude that the means of the two populations are the same.
HT_ 4143.xls:
X1 X2
99.73 98.69
95.93 98.94
94.92 96.63
100.52 99.16
101.28 94.93
99.79 101.97
97.92 98.75
97.71 100.72
100.82 102.75
99.78 101.34
95.87 99.16
100.21 98.96
105.68 102.69
100.32 94.37
101.22 96.88
98.74 104.39
102.65 105.40
101.73 92.90
101.39 94.82
95.42 101.30
98.94 92.52
99.71 102.13
101.63 100.54
100.34 96.12
98.11 106.75
103.37 106.21
102.47 107.57
95.41 104.52
97.05 105.75
99.97 103.88
94.06 105.75
101.14 100.95
99.73 97.73
100.53 101.23
104.39 101.01
104.09 92.38
104.29 102.55
97.81 97.22
100.83 101.19
104.12 104.25
97.69 106.09
100.55
104.76
Step by stepSolved in 4 steps with 2 images
- Seven acute schizophrenics and 10 chronic schizophrenics have been measured on a clarity of thinking scale. The mean for the acute sample was 52, with s = 12, and the mean for the chronic sample was 44, with s = 11. Perform a pooled-variance t test with alpha = .05 (two-tailed), and state your statistical conclusion.arrow_forwardOur environment is very sensitive to the amount of ozone in the upper atmosphere. The level of ozone normally found is 7.6 parts/million (ppm). A researcher believes that the current ozone level is not at a normal level. The mean of 1313 samples is 7.2 ppm with a variance of 0.49 Assume the population is normally distributed. A level of significance of 0.02 will be used. Make the decision to reject or fail to reject the null hypothesis.arrow_forwardThe fan blades on commercial jet engines must be replaced when wear on these parts indicates too much variability to pass inspection. If a single fan blade broke during operation, it could severely endanger a flight. A large engine contains thousands of fan blades, and safety regulations require that variability measurements on the population of all blades not exceed ?2 = 0.18 mm2. An engine inspector took a random sample of 81 fan blades from an engine. She measured each blade and found a sample variance of 0.28 mm2. Using a 0.01 level of significance, is the inspector justified in claiming that all the engine fan blades must be replaced? (b) Find the value of the chi-square statistic for the sample. (Round your answer to two decimal places.) Find or estimate the P-value of the sample test statistic. P-value > 0.1000.050 < P-value < 0.100 0.025 < P-value < 0.0500.010 < P-value < 0.0250.005 < P-value < 0.010P-value < 0.00 Find a 90% confidence interval…arrow_forward
- A social psychologist is interested in knowing whether people are more aggressive if they are in the presence of a weapon, such as a gun Treatment Condition- T1, as compared to when they are in a room with an innocuous item such as a tennis racket Control Condition-T2. The study used one sample of 17 college students and had all of the students in the sample participate in both treatment conditions. The mean of the difference scores was 18.0 and the variance (s2) was 612. An alpha level of .01 was set. Calculate the t. A 3.000 B 2.780 C 2.152 D 1.765arrow_forwardExplain whether homogeneity of variance is satisfied for this analysis, and be clear on how you decided this.arrow_forwardA simple random sample of 95 basketball players is taken from different teams and their mean weight is found to be 226 pounds and the standard deviation of the population is 20 pounds. Using 0.05 level of significance, test the claim that the average weight for all basketball players is 231 pounds. Complete the following steps: Step # 1: Write the null hypothesis Ho [ Select ] and the alternative hypothesis H1 [ Select ] and identify the claim [Select] Step # 2: Indicate what type of test has to be used [Select ] and find the critical value(s). ( Select ] Step # 3: Find the test value. [ Select ] Step # 4: Make the decision about the null hypothesis. [ Select ] Step # 5: Summarize the result. (Select Jarrow_forward
- chester butchery supplies vienna sausages in the entire kzn province. a meat packer is investigating the marked mass shown on vienna sausages. a pilot study showed a mean of 11.8kg per pack and a variance of 0.49kg. how many packs should be sampled in order to be 92% confident that the sample mean will differ by at most 0.2kg.arrow_forwardA researcher decides to measure anxiety in group of bullies and a group of bystanders using a 23-item, 3 point anxiety scale. Assume scores on the anxiety scales are normally distributed and the variance among the group of bullies and bystanders are the same. A group of 30 bullies scores an average of 21.5 with a sample standard deviation of 10 on the anxiety scale. A group of 27 bystanders scored an average of 25.8 with a sample standard deviation of 8 on the anxiety scale. You do not have any presupposed assumptions whether bullies or bystanders will be more anxious so you formulate the null and alternative hypothesis based on that.arrow_forwardPlease use ANOVAarrow_forward
- A professor claims that the final exam grades are more widely dispersed in Principles classes compared to upper-level classes. In a sample of 101 Principles final exams, the standard deviation is 16 while in a sample of 30 upper-level class final exams the standard deviation is 13. Test the hypothesis at the 10% level of significance that the 2 variances are different. Write all formulas and hypothesis.arrow_forwardThe blood pressure and weight of Jellystone Park bears are correlated and .5 is the correlation coefficient of blood pressure with weight. The average blood pressure is 150 with variance 36, for Jellystone Park bears. For a randomly selected bear with average weight if we predict its blood pressure is 150 after weighing it, using SLR, what is our expected squared error?arrow_forward
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman