Question: Data for Excel analysis: The data below is for week 5. What you will need to do is run the excel data analysis and paste
Data for Excel analysis:
The data below is for week 5. What you will need to do is run the excel data analysis and paste it on the word document, and give an analysis of the excel data table. Describe the definition of a t-test and what it is used for and how to calculate each step in a t-test and what each calculation means. What is the data significance? Do you reject or fail to reject? Describe the definition of an Anova test and what it is used for and how to calculate each step in an Anova test and an excel Anova test, and what each calculation means. What is the data significance? Do you Fail to reject or reject and why?
1.) The excel data Analysis (T-test)
2.) Brief Definition and explanation of test
3.) How to calculate
4.) Include step by step process of how to calculate
5.) explain calculations of excel data
T-test, test one and test two
Test one
-
100
94
80
78
74
70
50
Test two
-
98
90
88
84
80
60
48
1.) The excel data Analysis (ANOVA Test)
2.) Brief Definition and explanation of test
3.) How to calculate
4.) Include step by step process of how to calculate
5.) explain calculations of excel data
ANOVA, Essay test, Multiple Choice test, Fill in the blank test
Essay test
94
89
84
79
77
60
15
Multiple Choice test
100
96
90
86
82
70
26
Fill in the blank test
96
90
86
82
79
66
20
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help