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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!