Need help with question 4 only. I did it but I just want to make sure I did it right before submitting it! Thank you in advanceGreek data:August (bacteria per 100 ml water)October (bacteria per 100 ml water)310301299335421232265239391311274238327295300274222293276331375328225252351320510256332260411285349218527319349365375298366236276297339312335302334333333300334335338308340313337315339314331302334303327305316310304314319303294309299307311309 3. To compare the effect of the declining bee population on honey production,independent samples of Hives in Kentucky and Missouri were selected and theamount of honey harvested (in pounds) from each were recorded. Assume thatthe underlying populations are normal. Report the appropriate summarystatistics for each sample. Test the claim that the true mean honey harvest perhive is different in the two states using both a hypothesis test and a confidenceinterval and a = 0.05. Be sure to state which type of test you are using, the nulland alternative hypotheses, the test statistic, p-value, decision and conclusion.Be sure to interpret the Cl in the terms of the problem.4. The Canadian Costal Health Society warned that the East Creek wascontaminated. They took a random sample of locations in the East Creek andrecorded the coliform count (bacteria per 100 ml of water) in early August andthen again in October at the same locations after several rainstorms. Report theappropriate summary statistics for each sample. Test the claim that the truemean coliform is different before and after the rainstorms using both ahypothesis test and a confidence interval and a = 0.05. Be sure to state whichtype of test you are using, the null and alternative hypotheses, the test statistic,p-value, decision and conclusion. Be sure to interpret the Cl in the terms of theproblem.The Remember the goal of any lab is that you learn by doing!Save you file often and do not delete any data!DO NOT SUBMIT the original data.Copy summary statistics, test results into Word.Your decision must be in terms of Ho and your conclusion must be a complete sentencein terms of the claim.

Name: Need help with question 4 only. I did it but I just want to make sure
Uploaded: 2024-03-20T07:07:12.000Z
Channel: Bartleby
Description: Need help with question 4 only. I did it but I just want to make sure I did it right before submitting it! Thank you in advanceGreek data:August (bacteria per 100 ml water)October (bacteria per 100 ml water)3103012993354212322652393913112742383272953

I am using Excel for calculating summary stats for each sample. Before(August) Mean 334.875 Standard Error 9.390542672 Median 333.5 Mode 334 Standard Deviation 59.39100661 Sample Variance 3527.291667 Kurtosis 3.454064558 Skewness 1.272433281 Range 305 Minimum 222 Maximum 527 Sum 13395 Count 40 =========================================== ============================================== After(oct) Mean 296.925 Standard Error 5.139513533 Median 304 Mode 335 Standard Deviation 32.50513766 Sample Variance 1056.583974 Kurtosis 0.328822249 Skewness -0.79581694 Range 147 Minimum 218 Maximum 365 Sum 11877 Count 40 ===================================== Here Paired t- test is applicable , And the summary stats is given as d(Before- after) Mean 37.95 Standard Error 10.7319 Median 26.5 Mode 26 Standard Deviation 67.87467713 Sample Variance 4606.971795 Kurtosis 2.474001976 Skewness 1.480856135 Range 325 Minimum -71 Maximum 254 Sum 1518 Count 40H0:μd=0 (Null ) H1:μd≠0 (Alternative) ============================ Test - statistics(t) = d¯SE= 37.9510.7319 = 3.536 =============================== P-value = T.DIST.RT(3.536,39)---- Excel function = 0.0011 =============================== P- value < α= 0.05 . So, the result is statistically significant Reject Ho ============================== Conclusion: We have enough evidence to conclude that there is a significant difference between the means ======================================= 95% CI= d ¯±TINV(0.05,39) sn; (TINV() is an Excel function) =37.95 ± 2.023*10.7319 = ((37.95-21.71), (37.95 +21.71)) = (16.24 , 59.66 ) ================================== As the interval includes only the positive number we can say there is significant difference between the mean. Excel command : Data > Descriptive stats > select the data > check summary stats > ok

Answered: 4. The Canadian Costal Health Society…

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

August (bacteria per 100 ml water)	October (bacteria per 100 ml water)
310	301
299	335
421	232
265	239
391	311
274	238
327	295
300	274
222	293
276	331
375	328
225	252
351	320
510	256
332	260
411	285
349	218
527	319
349	365
375	298
366	236
276	297
339	312
335	302
334	333
333	300
334	335
338	308
340	313
337	315
339	314
331	302
334	303
327	305
316	310
304	314
319	303
294	309
299	307
311	309