Book Information: Statistics for Managers Using Microsoft Excel 9TH 21 Author: Levine, David ISBN-13: 978-0-13-596985-4 ISBN-10: 0-13-596985-9 Edition/Copyright: 9TH 21 Publisher: Pearson Rental

Urgent Support Request:

Need Manual support step by step by a human expert without AI and Chat GPT, Using Excel and as per instructions given.

Numerical Descriptive Measures Problems (1-5)

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.