The following data give the numbers of television sets owned by 40 randomly sele
ID: 3043571 • Letter: T
Question
The following data give the numbers of television sets owned by 40 randomly selected households.
Q4-1: Prepare a complete frequency distribution table for these data using single-valued classes. Include the frequency, relative frequency (as a percentage), cumulative frequency, and cumulative frequency as a percentage in the table. [1 point]
Q4-2: Calculate the mean number of television sets per household. [0.5 points] Q4-3: Calculate the median number of television sets per household. [0.5 points]
Q4-4: Calculate the standard deviation for the number of television sets per household. [1 point]
Q4-5: What percentage of the households own two or more television sets? [0.5 point]
The following data give the numbers of television sets owned by 40 randomly selected households. 1 123241321 1 Q4-1: Prepare a complete frequency distribution table for these data using single-valued classes. Include the frequency, relative frequency (as a percentage), cumulative frequency, and cumulative frequency as a percentage in the table. [1 point] 1%) cf(%)Explanation / Answer
Let X: The number of Television sets owned by an household
Q4-1: We prepared a complete frequency distribution table for these data with single-valued classes using Ms-excel (as below).
Q4-2: We calculate the mean number of Television sets owned by an household using the excel command-
=AVERAGE(x)
where, x is the data range of x to be selected in Ms excel
Q4-3: We calculate the Median number of Television sets owned by an household using the excel command-
=MEDIAN(x)
where, x is the data range of x to be selected in Ms excel
And, the mean number of Television sets owned by an household = 2 (Answer)
Q4-4: We find the Standard Deviation for the number of Television sets owned by an household using the excel command-
=STDEV(x)
where, x is the data range of x to be selected in Ms-excel
And, the Standard Deviation for the number of Television sets owned by an household = 0.99 (Answer)
Q4-5: We want to find the percentage of the households owning 2 or more television sets. We can find this by using the relative frequency table in Q4_1.
To get the desired thlis percentage, we will add the rf(%) for values 2,3 & 4
= 35.0% + 20.0 % +7.5%
=62.5% (Answer)
X f rf(%) cf cf(%) 0 1 2.5% 1 2.5% 1 14 35.0% 15 37.5% 2 14 35.0% 29 72.5% 3 8 20.0% 37 92.5% 4 3 7.5% 40 100.0% Total 40 100.0%Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.