Question: For the Facebook data provided, find the range, variance, standard deviation, and interquartile range for hours online/week and number of friends in the sample using
For the Facebook data provided, find the range, variance, standard deviation, and interquartile range for hours online/week and number of friends in the sample using the appropriate Excel function. Compare these measures of location.
Student Gender Hours online/week Friends 1 female 10 400 2 male 4 90 3 female 2 30 4 male 6 180 5 male 3 200 6 female 4 50 7 female 8 340 8 male 4 50 9 male 10 450 10 female 2 50 11 female 6 240 12 male 15 500 13 female 2 80 14 female 5 70 15 female 2 30 16 male 8 430 17 female 12 110 18 female 9 100 19 male 6 90 20 female 4 280 21 male 4 120
The range for the number of hours online per week is ____
(Type an integer or decimal rounded to two decimal places as needed.)
The variance for the number of hours online per week is_____
(Type an integer or decimal rounded to two decimal places as needed.)
The standard deviation for the number of hours online per week is_____
(Type an integer or decimal rounded to two decimal places as needed.)
The interquartile range for the number of hours online per week is_______
(Type an integer or decimal rounded to two decimal places as needed.)
The range for the number of friends is______
(Type an integer or decimal rounded to two decimal places as needed.)
The variance for the number of friends is _____
(Type an integer or decimal rounded to two decimal places as needed.)
The standard deviation for the number of friends is _______
(Type an integer or decimal rounded to two decimal places as needed.)
The interquartile range for the number of friends is ______
(Type an integer or decimal rounded to two decimal places as needed.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
