In order to control costs, a company wishes to study the amount of money its sales force spends entertaining clients. The following is a random sample of six entertainment expenses (dinner costs for four people) from expense reports submitted by members of the sales force $312 342 $ 331 (X) 1 X 201 (X330) $369 $ 342 $ 326 (a) Use Excel to calculate X, s2, and s for the expense data. (Round the mean and the variance to 2 decimal places and the standard deviation to 3 decimal places.) (b) Assuming that the distribution of entertainment expenses is approximately normally distributed, calculate estimates of tolerance intervals containing 68.26 percent, 95.44 percent, and 99.73 percent of all entertainment expenses by the sales force. (Round intermediate calculations and final answers to 2 decimals.)
In order to control costs, a company wishes to study the amount of money its sales force spends entertaining clients. The following is a random sample of six entertainment expenses (dinner costs for four people) from expense reports submitted by members of the sales force $312 342 $ 331 (X) 1 X 201 (X330) $369 $ 342 $ 326 (a) Use Excel to calculate X, s2, and s for the expense data. (Round the mean and the variance to 2 decimal places and the standard deviation to 3 decimal places.) (b) Assuming that the distribution of entertainment expenses is approximately normally distributed, calculate estimates of tolerance intervals containing 68.26 percent, 95.44 percent, and 99.73 percent of all entertainment expenses by the sales force. (Round intermediate calculations and final answers to 2 decimals.)
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.4: Distributions Of Data
Problem 19PFA
Related questions
Question
Subject:stet
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Step 1: Use EXCEL to obtain the value of mean, standard deviation and sample variance.
VIEWStep 2: determines the values of mean, sample variance and standard deviation.
VIEWStep 3: Obtain the value of one, two and three standard deviations above and below the mean.
VIEWStep 4: Determine whether the expense of $390 is consider to be unusually high or not.
VIEWSolution
VIEWTrending now
This is a popular solution!
Step by step
Solved in 5 steps with 5 images
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill