Excel File Edit View Insert Format Tools Data Window Help 0 -)) 42% D Fri 12:01
ID: 3259939 • Letter: E
Question
Excel File Edit View Insert Format Tools Data Window Help 0 -)) 42% D Fri 12:01 PM a Project 3-SAMS data Q Search Sheet Home Insert Page Layout Formulas Data Review View + Share A Calibri {Body) ,111 , A Av- = = 1 , Wrap Text Fill Merge & Center, $ , % , .00+0 conditional Format Cell insert Delete Format Sort & Filter ,, Format Formatting as Table Styles Clear 0.854 1.023 1.005 1.03 1.219 0.977 1.044 0.778 1.122 1.114 1.091 1.086 1.141 0.931 0.723 0.934 1.06 1.047 Data from upload speeds measured 50 times Data from 30 subscribers (15 to each system) email interface Email Interface 1 Email Interface 2 4.13 3.75 3.93 3.74 3.36 3.85 3.26 3.73 4.06 3.33 3.96 3.57 3.13 3.68 3.63 3.71 3.89 4.22 4.57 4.24 3.90 4.09 4.05 4.07 3.80 4.36 4.38 3.49 3.57 4.74 12 13 15 16 0.889 1.012 0.695 0.869 0.734 1.131 0.993 0.762 0.814 25 SAMS data+ Ready H 140% 30Explanation / Answer
5]
n = 50 , Xbar = 0.9587, sigma = 0.16
using MINITAB
Choose Stat > Basic Statistics > 1-Sample Z.
In Samples in columns, enter X.
In Standard deviation, enter 0.16.
Check Perform hypothesis test. In Hypothesized mean, enter 0.97.
Click Options. In Confidence level, enter 95. Click OK.
Outout ==>
MTB > OneZ 'X';
SUBC> Sigma 0.16;
SUBC> Test 0.97;
SUBC> Alternative -1.
One-Sample Z: X
Test of mu = 0.97 vs < 0.97
The assumed standard deviation = 0.16
95% Upper
Variable N Mean StDev SE Mean Bound Z P
X 50 0.9587 0.1560 0.0226 0.9959 -0.50 0.309
here absolute value of test statistic ( Z) = 0.5
and absolute value of Z_critical = 1.64485
by graph #4 we do not reject Ho at alpha = 0.05.
At alpha = 0.05, we have sufficient evidence that the population mean is 0.97
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.