This video will walk you step by step how to perform a paired t-test in Excel and also briefly explain the reason. Please subscribe to be updated for future topics. Thanks for watching
Hello I am having airborne dust concentrations data for >1 micron size, >3 micron, 5 micron and >10 micron size. (> means greater than) These data was taken before and during dust producing work in field study. N=5 How can i compare these before and during operations data ? It seems that there is relative percent variation in dust concentrations in atmosphere between before and during operation data. (Taking >1) micron as 100 %) Before operation: The relative percent variation of concentration with different particle size is as below. For example Concentration of >1 micron size particle is 100%. >3 micron: 80% >5 micron : 60% >10 micron: 40%. During operation: Concentration of >1 micron size particle is 100%. >3 micron: 90% >5 micron : 80% >10 micron: 70%. It seems that >10 micron particle share is increased due to that machine operation...? Which test is suitable for analysing these type similar data for discussion ? How to use statistics? Any comparison among these concentrations of different particle sizes ? thank u.
Grear video! But does it make sense to use unpaired as opposed to paired? You're looking at difference within the same individuals, so I assume it would be paired (?)
How did you determine that p-value of 0.047 is significant? is there a threshold value that says if its above or below "said number" than that means the diet was effective?
by default everyone assumes that 0.05 is the treshhold value, or in another word more than 95% of the time as long as the value is above 0.05, it will be inside of the data. thus not significantly different, and since the value is 0.047 only it is significantly (different)