Question 1 a) Using simple random sample select 10 samples. Explain the sample s
ID: 3318225 • Letter: Q
Question
Question 1
a) Using simple random sample select 10 samples. Explain the sample selection process in detail.
b) Determine student marks (0-100) into five interval width (1, 2, 3, 4 and 5), and replace the interval width with sample's raw value of assignment 1, 2 and 3, mid-term, final and total mark. (Provide the calculation process and explanation)
c) Using the interval width determines the sample means of assignment 1, 2 and 3, mid-term and final. (Provide the calculating process and explanation)
d) Using the interval width determines the sample median of assignment 1, 2 and 3, mid-term and final. (Provide the calculating process and explanation)
e) Using the interval width determines the sample mode of assignment 1, 2 and 3, mid-term and final. (Provide the calculating process and explanation)
f) Report Sample Variance and Sample Standard Deviation using interval width (Provide the calculating process and explanation)
g) Using the interval width, report mean, median and mode of sample total mark.
h) Using the interval width, report frequency and relative frequency of sample's total mark.
*This question was prepared by lecturer, you may just skip any question that might not enough info.
*You can use papers and snap the answer instead of typing it here.
Explanation / Answer
This problem can be solved using Excel. Steps are mentioned as follows:
The remaining metrics can be calculated using functions AVERAGE, MEDIAN, MODE, VAR.S, STDEV.S. The results are as follows:
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.