Question

In: Statistics and Probability

***Using excel to solve the below*** A business manager wanted to know if there was a...

***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

Solutions

Expert Solution

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


Related Solutions

****Using excel*** A business manager wanted to know if there was a relationship between daily temperature...
****Using excel*** 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 a. Using excel Find the value of the correlation coefficient (r) for Daily Temperature and # Called-in Sick....
I would like to know how to solve this problem using POM or Excel Alan Resnik,...
I would like to know how to solve this problem using POM or Excel Alan Resnik, a friend of Ray Cahnman, bet Ray $5 that Ray’s car would not start 5 days from now (see Problem 14-8). What is the probability that it will not start 5 days from now if it started today? What is the probability that it will not start 5 days from now if it did not start today? What is the probability that it will...
(PLEASE READ ) :) Use the data below to solve the following problem using excel: (...
(PLEASE READ ) :) Use the data below to solve the following problem using excel: ( I would like to know how do you input the formula for each category, so please explain the process) I will RATE and comment your answer accordingly 1 a) Import the data into an Excel file. Done! b) Create a new column in the spreadsheet to assign the category of each car according to the engine horsepower. For this exercise use IF statements in...
Use the data below to solve the following problem using excel: 1 a) Import the data...
Use the data below to solve the following problem using excel: 1 a) Import the data into an Excel file. Done! b) Create a new column in the spreadsheet to assign the category of each car according to the engine horsepower. For this exercise use IF statements in each cell to determine the class for each vehicle. i. Class 1 if the vehicle horsepower is less than 80 HP. ii. Class 2 if the vehicle horsepower is between 81 and...
*****SOLVE USING EXCEL AND PLEASE SHOW THE EXCEL COMMANDS THAT ARE USED******** A company is considering...
*****SOLVE USING EXCEL AND PLEASE SHOW THE EXCEL COMMANDS THAT ARE USED******** A company is considering the purchase of a new machine that will enable it to increase its expected sales. The machine will have a price of $100,000.  In addition, the machine must be installed and tested.  The costs of installation and testing will amount to $10,000.  The machine will be depreciated using 3-years MACRS. (Use MACRS table from class excel exercise by copying the table and pasting it)          The equipment will...
Solve the following question using EXCEL Assume that three business owners each own an identical storage...
Solve the following question using EXCEL Assume that three business owners each own an identical storage building valued at $120,000. Assume that there is a 1% chance in any year each building will be destroyed by a peril (fire), and that a loss to any of the buildings is an independent event. Assuming that: (first case ) Fire events are independent of each other (second case) Each building faces the same types of risks and environmental conditions. Given that, solve...
Use EXCEL to format this and solve using solve and explain. Biggest problem is once have...
Use EXCEL to format this and solve using solve and explain. Biggest problem is once have variables (which i have half done) is setting up in Excel. A farmer in the Midwst haas 1,000 acres of land on which she intends to plant corn, wheat, and soybeans. Each acre of corn costs $100 for preparation, requires 7 worker-days of labor, and yields a profit of $30. An acre of wheat costs $120 to prepare, requires 10 worker-days, and yields $40...
Solve the problems below using well-formatted Excel solutions. Do not hardcode numbers in the formulas…..only use...
Solve the problems below using well-formatted Excel solutions. Do not hardcode numbers in the formulas…..only use cell references to the input data. I will change the input data in your problem to check alternate solutions. You will turn in a complete working Excel spreadsheet with your solution. 1)     What is the price of a semiannual $1,000 par value bond with four years left until maturity that pays a coupon of 3.75% and is yielding 5.25%? What would it be yielding...
A dean of a business school wanted to know whether the graduates of her school used...
A dean of a business school wanted to know whether the graduates of her school used the statistic skills that they learn in university during their first year of employment after graduation. As of today there are 34,050 graduates in total from the business school. The Dean is committed to allocate more funding to the development of the school’s statistics course if at least 17% of its graduates use statistics skills during their first year of employment. She surveyed 500...
A dean of a business school wanted to know whether the graduates of her school used...
A dean of a business school wanted to know whether the graduates of her school used the statistic skills that they learn in university during their first year of employment after graduation. As of today there are 34,050 graduates in total from the business school.   The Dean is committed to allocate more funding to the development of the school’s statistics course if at least 17% of its graduates use statistics skills during their first year of employment. She surveyed 500...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT