OPRE 505 BOOK: Statistics for Managers Using Microsoft Excel (Pearson+) - 9TH 21 by: Levine, David M. Chapter:3 Numerical Descriptive Measures Problems

For this discussion topic each student is required to have at least 2 postings: One answering at least one of the questions and a second responding to another student's posting. Please select a question that has not been answered by the time you post your response. You can select any question to answer once all questions are answered. Please do not copy another student's post.

This discussion will close at midnight on Sunday, February 9th.

1. Solve the following problem by doing hand calculations as well as using Excel.

The following set of data is from a sample of n = 5: 8 5 10 9 3

a. Compute the mean, median, and mode. b. Compute the range, variance, standard deviation, and coefficient of variation.

2. The following set of data is from a sample of n = 5: 8 5 10 9 3

a. Compute the Z scores. Are there any outliers? b. Describe the shape of the data set.

3. The following set of data is from a sample of n = 5: 8 5 10 9 3

a. Compute the first quartile (Q1), the third quartile (Q3), and the interquartile range. b. List the five-number summary.

4. The following set of data is from a sample of n = 5: 8 5 10 9 3 a. Construct a boxplot and describe its shape. b. Compare your answer in (c) with that from Question 2b as given above. Discuss.

5. A study of 1,649 college students suggests a link between Facebook use and grade point average. Freshmen reporting a higher use of Facebook had lower grade point averages than freshmen reporting lower use of Facebook. (Data extracted from R. Junco, "Student class standing, Facebook use, and academic performance," Journal of Applied Developmental Psychology, 2015.)

a. Does the study suggest that the use of Facebook and grade point average are positively correlated or negatively correlated? b. Do you think that there might be a cause-and-effect relationship between use of Facebook and grade point average? Explain.

Need all answer without AI helping. But from human expert