Answered: Using Excel, conduct a t-test (at the…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

Download the dataset HT_3436.xls. Using Excel, conduct a t-test (at the alpha = 0.10 significance level) on whether the mean of X2 is equal to 100. What do you conclude from this sample data? Is the population mean equal to 100?

Group of answer choices

You cannot reject the null hypothesis. You conclude that the population mean is equal to 100.

You reject the null hypothesis. You conclude that the population mean is not equal to 100.

You cannot reject the null hypothesis. You conclude that the population mean is not equal to 100.

You reject the null hypothesis. You conclude that the population mean is equal to 100

X1 X2
101.74 100.03
106.08 91.07
97.05 103.32
98.41 102.91
101.26 103.13
100.70 101.09
106.74 106.48
98.75 97.86
101.65 105.39
92.74 107.50
97.78 101.20
98.24 102.54
100.13 100.10
98.31 108.27
98.53 102.07
100.51 107.33
96.97 96.81
102.00 103.40
101.94 98.61
106.10 105.08
101.97 97.82
96.74 97.26
101.17 106.40
102.46 102.98
101.01 98.74
104.28 104.27
91.15 99.90
98.47 106.38
98.78 99.23
105.34 98.30
100.24 97.79
101.58 99.60
100.43 97.18
96.28 107.15
101.56
99.24

Expert Solution

Step 1

Given data set of X2 as

X2
100.03
91.07
103.32
102.91
103.13
101.09
106.48
97.86
105.39
107.5
101.2
102.54
100.1
108.27
102.07
107.33
96.81
103.4
98.61
105.08
97.82
97.26
106.4
102.98
98.74
104.27
99.9
106.38
99.23
98.3
97.79
99.6
97.18
107.15