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

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

i want all the question answer 1 to 5 , but i humbly request for human expert. AI or chat Gpt will not be acceptable.

Here also mentioned about using Excel ..so please complete support me