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


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. ETT Click the icon to view the data. 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.) Compare the measures of location for each data set. The vary in a related way since one can be calculated from the other. The is always greater than the since the values it uses are always farther apart.Facebook Data Facebook Survey Student Gender Hours online/week Friends female 70 female 80 female 100 female 12 380 male 3 200 male 120 male 430 250 female female 80 male 15 500 female 340 male 180 female 280 15 male 150 16 female 50 17 male 10 450 18 female 12 110 male 20 female 60 21 female 280
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
