Question

You may use Microsoft Excel or any other technology to complete the question as long as the explanation is clear and the file is included.

Please complete the following problems:

1. Consider a sample with data values of 53, 55, 70, 58, 64, 57, 53, 69, 57, 68, and 53. Compute the mean, median,mode.

2. The results of a national survey showed that on average, adults sleep 6.9 hours per night. Suppose that the standard deviation is 1.2 hours and that the number of hours of sleep follows a bell-shaped distribution.

     a. Use the empirical rule to calculate the percentage of individuals who sleep between 4.5 and 9.3 hours per night.

     b. What is the percentage of individuals that sleep more than 8.1 hours per night.

     c. What is the z-value for an adult who sleeps 8 hours per night?

3. The owner of an auto repair shop studied the waiting times for customers who arrive at the shop for an oil change.The following data with waiting times in minutes were collected over 1-month.

                            2; 5; 10; 12; 4; 4; 5; 17; 11; 8; 9; 8; 12; 21; 6; 8; 7; 13; 18; 3

     Using classes of 0-4, 5-9, and so on, construct:

     a. The frequency distribution.

     b. The relative frequency distribution.

     c. The cumulative frequency distribution.

     d. The proportion of customers needing an oil change who wait 9 minutes or less.

PLEASE INCLUDE AN EXCEL ATTACHMENT IN YOUR EXPERT ANSWER

NO SCREENSHOTS

Answer 1