Visual Learner: Statistics

Visual Learner: Statistics

Refer to the “Visual Learner: Statistics” for examples to help complete the problems in the “Topic 4: ANOVA Excel Worksheet.” Also, to aide in the Excel calculations, view the appropriate section of the Excel tutorials. Answer each question completely in the Excel worksheet provided.

HLT362.M4.ANOVA_Student_12-2-13.xlsx

Group 1 Group 2 Group 3 [Place your Anova table here]
104 97 123
106 116 107 Anova: Single Factor
104 98 127
92 95 133 SUMMARY
112 108 114 Groups Count Sum Average Variance
107 106 93 Group 1
102 113 Group 2
108 114 Group 3
94 116
100 155
101 105 ANOVA
119 Source of Variation SS df MS F P-value F crit
89 Between Groups
113 Within Groups
99
93 Total
107
125
104
110
124
181
118

Name ___________________      Week 4 Excel Worksheet
100 (5) Excellent
100.00%
  1.00
  30.00
ANOVA Table Used the Single Factor ANOVA Excel Analyses correctly and the answers on the table were correct based on the data given.
  30.00
Statistical Conclusion The statistical conclusion was stated in terms of rejection or failure to reject the null hypothesis.  The conclusion was supported by stating the rule upon which it was based and providing the appropriate values from the table.
  30.00
Experimental Conclusion The experimental conclusion follows from the statistical conclusion stating the support for or lack of support for the claim.
100 %Total Weight  90points 90

Name ______________

Tell what the #  means (a – d)  and where the number comes from (b,c)

  1. 619

 

  1. 1

 

 

  1. 22

 

  1. 005

 

 

 

 

  1. State the null …
  2. Should the null …

 

 

  1. Provide a rationale …

 

  1. Was this result …

 

 

  1. … If so at what …

 

 

  1. If the researchers …

 

 

  1. Provide a rationale …

 

 

 

 

  1. If … , is the results …

 

 

 

  1. Provide a rationale …

 

 

  1. Would the null …

 

  1. Can ANOVA …

 

 

  1. Provide a rationale …

 

 

 

  1. … how many …

 

 

  1. … and what was the …

 

 

 

 

This question implies that there are several. Do not limit your response to only one strength or weakness.

 

 

Support your opinion with references to the study.

 

 

 

This question implies that there is more than one possible problem or limitation.

Is this the question you were looking for? If so, place your order here to get started!