In: Statistics and Probability
***Using excel to solve the below***
A business manager wanted to know if there was a relationship between daily temperature measured in degrees Fahrenheit and number of employees who called-in sick each day. He collected the following data over 10 days: Daily Temperature: 54 70 67 57 54 63 72 72 54 71 # Called-in Sick: 33 32 30 37 34 28 31 27 31 26 1.
A. Obtain the mode, median, and mean for Daily Temperature only.
B. Obtain the range for Daily temperature.
C. Find the standard deviation for Daily temperature.
D. Provide an interpretation for your answer to part C.
E. What is the z-score for the daily temperature of 54?
F. Provide an interpretation of the z-score obtained in part E.
G. What percentage of temperatures are expected to be in the range z = -2.1 to z = +.7?
H. Obtain a histogram with four intervals for the Daily Temperature data only
Solution:
The excel steps are:
Enter the Daily Temperature in excel as:
Click on Data > Data Analysis > Descriptive Statistics > OK
Input range: Select all the data range including the Label
Mark the Labels in the first row
Choose the output range
Mark the Summary Statistics and click OK
The output is given below:
Daily Temperature | |
Mean | 63.4 |
Standard Error | 2.51307691 |
Median | 65 |
Mode | 54 |
Standard Deviation | 7.947046971 |
Sample Variance | 63.15555556 |
Kurtosis | -2.071614585 |
Skewness | -0.19612134 |
Range | 18 |
Minimum | 54 |
Maximum | 72 |
Sum | 634 |
Count | 10 |
A. Obtain the mode, median, and mean for Daily Temperature only.
Answer: Mode = 54, Median = 65, Mean = 63.4
B. Obtain the range for Daily temperature.
Answer: Range = 18
C. Find the standard deviation for Daily temperature.
Answer: The standard deviation is 7.9470
D. Provide an interpretation for your answer to part C.
Answer: The average deviation of data from the mean is 7.9470
E. What is the z-score for the daily temperature of 54?
F. Provide an interpretation of the z-score obtained in part E.
Answer: The z-score = -1.18 means, the value 54 is 1.18 standard deviations below the mean value.
G. What percentage of temperatures are expected to be in the range z = -2.1 to z = +.7?
Answer: According to the normal distribution the percentage of temperatures that are expected to be in the range z = -2.1 to z = +.7 is:
Using the standard normal table, we have:
H. Obtain a histogram with four intervals for the Daily Temperature data only
Answer: The frequency distribution for the given data is:
Class Interval | Frequency |
54 - 58 | 4 |
59 - 63 | 1 |
64 - 68 | 1 |
69 - 73 | 4 |