Question

In: Statistics and Probability

​Perform three post hoc tests, comparing the three pairs of means from the previous question. Are there significant differences between:

5. [Using both Excel (show your work) and SPSS]

​Perform three post hoc tests, comparing the three pairs of means from the previous question. Are there significant differences between:

A. Baseline and one minute?

B. Baseline and two minutes?

C. One minute and two minutes?

Use a = .05 / 3 = .017 for each test.

i only need excel version no need for Spss. Thank you



4. [Using both Excel (show your work) and SPSS]
In a study of embarrassment, Harris (2001) asked participants to sing the Star Spangled Banner in front of a video camera while she recorded their heart rate for two minutes. The following are data similar to the research results.
​Participant​Baseline​1 minute​2 minutes
​1​​​ 74​​ 88​​ 75
​2​​​ 76​​ 90​​ 77
​3​​​ 78​​ 89​​ 76
​4​​​ 76​​ 85​​ 76
Do the data show significant changes in heart rate over time?
Also, calculate the appropriate effect size for this test.
(Note: you do not need to show the calculations for SSError in Excel – you can just fill it in from SPSS.)
5. [Using both Excel (show your work) and SPSS]
​Perform three post hoc tests, comparing the three pairs of means from the previous question. Are there significant differences between:
A. Baseline and one minute?
B. Baseline and two minutes?
C. One minute and two minutes?
Use a = .05 / 3 = .017 for each test.


need help with only number5, can u do only excel of number5, i have done the spss part.

Solutions

Expert Solution

Step-1: perform one-way ANOVA

step-2: obtain least significant difference by using the given formula

LSD=t(α,error df)*sqrt(2*EMS/r)

Step-3: obtain the pairwise mean differences and compare with LSD

S stands for significant and NS stands for non-significant

Final Answer:

A. Baseline and one minute- Significant difference

B. Baseline and two minutes- Non significant difference

C. One minute and two minutes- Significant difference


Related Solutions

Assignment #5: Analysis of Variance and Post Hoc Tests Directions: Using the information from the following...
Assignment #5: Analysis of Variance and Post Hoc Tests Directions: Using the information from the following scenario, conduct a one-way ANOVA and specify the LSD post hoc test. The superintendent is continuing to examine the data that has been reported for the district. Another question concerned the differences in performance on high stakes tests. To examine this issue, the superintendent obtained the average scale scores for schools that participated in the high stakes testing for the district and two comparison...
Assignment #5: Analysis of Variance and Post Hoc Tests Directions: Using the information from the following...
Assignment #5: Analysis of Variance and Post Hoc Tests Directions: Using the information from the following scenario, conduct a one-way ANOVA and specify the LSD post hoc test. The superintendent is continuing to examine the data that has been reported for the district. Another question concerned the differences in performance on high stakes tests. To examine this issue, the superintendent obtained the average scale scores for schools that participated in the high stakes testing for the district and two comparison...
For the previous problem, you should have found that there are significant differences among the three...
For the previous problem, you should have found that there are significant differences among the three treatments. The primary reason for the significance is that the mean for treatment I is substantially smaller than the means for the other two treatments. To create the following data, we started with the values from problem 6 and added 3 points to each score in treatment I. Recall that adding a constant causes the mean to change but has no influence on the...
Question 1 Tests comparing 2 population means can be: surveys experiments both surveys and experiments Question...
Question 1 Tests comparing 2 population means can be: surveys experiments both surveys and experiments Question 2 If all the experimental units are identical (ex: clones), you will set up the study as: CRD Block Design Question 3 a 2 sample t-test still has which normality assumption(s)? The population is normal or n is greater than 30 both populations are normal or both sample sizes are greater than 30 Question 4 When you block by some variable in a block...
Introduction to T-tests Correlation looks for relationships between variables. T-tests compare means to look for differences...
Introduction to T-tests Correlation looks for relationships between variables. T-tests compare means to look for differences between the means of two groups. STATISTICAL GUIDE:  The t-test is used to see if the difference between two means is statistically significant. There are multiple kinds of t-tests. In this exercise, we will focus on the t-test for independent groups (used to compare the mean scores of 2 different groups of participants in the same study) This t-test is used if the two means...
Explain Null and Alternative Hypotheses Hypothesis Tests for Differences between Population Means Hypothesis Test for Equal...
Explain Null and Alternative Hypotheses Hypothesis Tests for Differences between Population Means Hypothesis Test for Equal Population Variances Hypothesis Tests for Differences between Population Proportions Please don't send the screenshot of written document, either type it or send the pdf screenshots.
Explain Null and Alternative Hypotheses Hypothesis Tests for Differences between Population Means Hypothesis Test for Equal...
Explain Null and Alternative Hypotheses Hypothesis Tests for Differences between Population Means Hypothesis Test for Equal Population Variances Hypothesis Tests for Differences between Population Proportions
14-E1. Below are some (fictitious) correlations between all pairs of three variables. The means and standard...
14-E1. Below are some (fictitious) correlations between all pairs of three variables. The means and standard deviations are also give. Imagine that they were obtained from a sample of 35 randomly chosen individuals. Income Education Age Income ($1000) 1.0 0.43 0.22 Education (years) 0.43 1.00 -0.58 Age (years) 0.22 -0.58 1.00 Mean 45.2 11.3 47 Stdev 8.5 3 12 Which, if any, of these correlations are significantly different from zero? What does "significantly different from zero" mean in simple words?...
please don't copy from previous post and answer all Chapter 4 - Discussion Question (DQ) #...
please don't copy from previous post and answer all Chapter 4 - Discussion Question (DQ) # 2, 7, 11, 13, 21, 25, 30, 34 (DQ2) What is the difference between purchasing and strategic sourcing? (DQ7) In what ways is corporate social responsibility different from business ethics? (DQ11) What are the benefits of sustainable sourcing? Can firms actually make money from sustainable sourcing? Do you think it is a good practice? Why ? (DQ13) How could you apply sustainability to a...
This is a three part question: a) What are some major differences between making transgenic mice...
This is a three part question: a) What are some major differences between making transgenic mice by microinjection and creating knockout mice by homologous recombination (before the advent of CRISPR/Cas9 technology)? b) Explain how negative and positive selection work when creating a knockout mouse. Why are both types of selection useful? c) Why is the creation of knockout mice so much easier when using CRISPR/Cas 9 genome editing?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT