Question
Perform a t-test on the data in the Excel tab labeled 'Problem 6' based on the given hypotheses and significance level and provide your answers
Perform a t-test on the data in the Excel tab labeled 'Problem 6' based on the given hypotheses and significance level and provide your answers below.
Ho: = 3.5
HA : 3.5
= 0.05
Sample Mean=
Standard Deviation=
t=
p=
Decision=
Data here:
1.09
1.04
2.57
3.02
1.5
2.1
1.93
3.57
2.32
1.89
3.26
3.99
2.04
0.99
2.96
1.5
2.43
2.97
1.42
3.6
4.48
1.36
2.11
0.41
2.02
3.27
4.95
1
1.55
1.41
1.05
1.31
2.5
2.35
3.69
3.61
1.49
1.36
1.73
0.94
1.33
2.62
1.25
0.26
4.41
3.22
1.86
1.76
2.83
2.74
4.63
1.7
3.29
1.22
3.2
3.09
2.58
1.67
0.85
1.52
1.37
1.32
1.04
3.68
4.43
2.98
6.3
1.46
8.82
9.62
4.41
2.73
9.31
3.59
5.36
1.47
7.06
2.52
1.75
5.64
1.93
6.46
6.72
5.76
9.72
0.16
5.52
11.92
4.68
4.76
7.85
2.9
2.87
5.09
3.17
2.4
13.2
2.07
4
4.27
1.87
8.13
3.51
4.21
3.34
0.77
1.14
1.45
6.54
0.92
5.14
4.59
2.94
9.96
10.44
3
5.91
16.81
5.01
0.86
3.46
4.52
4.92
6.31
2.49
0.51
5.81
1.96
17.67
3.21
4.94
3.1
1.39
5.21
2.03
1.74
3.99
6.26
3.52
2.01
2.21
0.25
0.09
6.85
2.33
5.45
2.04
4.98
3.54
1.06
2.7
1.14
12.24
5.67
2.43
4.02
6.45
1.89
1.78
2.93
1.82
2.89
0.99
1.93
3.61
2.53
3.76
1.32
2.64
12.33
1.79
3.99
4.44
9.25
4.02
1.38
1.59
0.85
8.87
0.27
1.41
2.19
2.83
2.19
1.81
0.85
3.05
3.42
2.1
2.93
2.44
2.17
1.41
2
0.93
2.97
2.04
0.65
2.13
0.63
1.53
4.69
0.15
1.45
2.68
3.53
1.49
2.31
0.92
0.89
0.8
0.72
2.66
4.37
0.92
1.4
1.45
1.68
1.53
1.44
1.44
1.36
0.38
1.74
2.35
2.3
1.14
2.88
2.13
5.28
1.48
3.36
2.83
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
