Research Methods & Professional Practice, Week 7, E-Portfolio Activity, Summary Worksheets
E-Portfolio Activity, Summary Worksheets
E-Portfolio Activity, Summary Worksheets
Summary Worksheets
6.1 For this e-portfolio exercise, students were required to partake in the summary hypothesis testing using Excel, in the Unit7 workbooks.
For the first exercise, the instructions were as follows:
Calculate the sample size, sample mean, and sample standard deviation of the weight loss for individuals that undertook Diet A. The result:
The sample mean weight loss for Diet A is 5.341. The average weight loss for those individuals who undertook Diet A is 5 341 kg, so the diet appears to have been effective. The sample standard deviation of the weight loss for Diet A is 2.536 kg. Since the mean weight loss is a little larger than 2s, then a high proportion of those individuals on Diet A had a positive weight loss, again emphasizing the effectiveness of the diet.
Exercise Question:
Obtain the sample size, sample mean weight loss and the sample standard deviation of the weight loss for Diet B. Place these results in the block of cells F23 to F25, using the same format as that employed for the Diet A results in the above example.
The sample mean weight loss for Diet B is 3.710. The average weight loss for those individuals who undertook Diet B is 3 710 kg, so the diet appears to have been less effective. The sample standard deviation of the weight loss for Diet B is 2.769 kg. Since the mean weight loss is a little larger than 2s, then a high proportion of those individuals on Diet B had a slightly less weight loss process.
6.2 For the first exercise, the instructions were to calculate the sample median, sample quartiles, and sample interquartile range of the weight loss for individuals that undertook Diet A. The result:
According to the above result, the sample median weight loss for Diet A is M=5.642 kg, so the diet appears to have been effective. The sample interquartile range of the weight loss for Diet A is 3.285 kg. A high proportion of those individuals on Diet A had a positive weight loss.
Exercise Question:
Obtain the sample median, first and third quartiles and the sample interquartile range of the weight loss for Diet B. Place these results in block cells F26 to F29.
Exercise Answer:
According to the above result, the sample median weight loss for Diet B is M=3.745kg, so the diet appears to have been less effective than Diet A. The sample interquartile range of the weight loss for Diet B is -3.4505 kg. A high proportion of those individuals on Diet B had significantly less positive weight loss.
6.3 For this exercise, students were required to calculate and see a pattern of preferences for various brands of breakfast cereal. Interest was in seeing if the pattern differs between two demographic areas.
Out of the 70 respondents in Area 1, 15.7% preferred Brand A, 24.3% preferred Brand B, and the remaining 60.0% preferred some other brand of breakfast cereal.
Exercise Question:
Obtain the frequencies and percentage frequencies of the variable Brand, but this time for the Area 2 respondents, using the same format as that employed for the Area1 results in the above example.
Exercise Answer:
Out of the 100 respondents in Area 2, 21.1% preferred Brand A, 33.3% preferred Brand B, and the remaining 45.6% preferred some other brand of breakfast cereal.