We want to use excel to generate a frequency distribution


Use the following information to answer questions 1. through 4.

The number of small electric motors which were rejected due to for poor quality, per batch of 250, were recorded for recent batches. The results were as follows:

3 2 7 5 1 3 1 7 0 6 2 3 4 1 2 25 2 4 5 0 5 3 5 3 1 2 3 1 3 0 1 6 3 5 41 1 0 6 4 1 3

1. If we treat these data as a sample, the mean and standard deviation number of rejects are

A. 3 and 7.1 respectively.
B. 4.4 and 7.0 respectively.
C. 4.5 and 7.1 respectively.
D. 4.4 and 50.1 respectively.
E. 4.4 and 7.1 respectively.

2. The median and modal number of defects is

A. 3 and the data set is bimodal with modes of both 1 and 3.
B. 3 and 3 respectively.
C. 3.5 and 3 respectively.
D. 3.5 and the data set is bimodal with modes of both 1 and 3.
E. 5 and 3 respectively.

3. We want to use Excel to generate a frequency distribution and histogram for these data. The most appropriate bin values for generating these would be

A. 0 6 12 18 24 30 36
B. 5 10 15 20 25 30 35 40 45
C. 7 14 21 28 35 42
D. 5 11 17 23 29 35 41
E. 10 20 30 40 50



4. Following is a boxplot showing the distribution of the number of rejected motors.


Choose that statement which most correctly describes the data in the boxplot.

A. There are no outliers in the data set.
B. The data are positively skewed.
C. The data are approximately symmetric.
D. The data are negatively skewed.
E. 50 % of the data lie between 3 and 7.

5. The annual income for 200 recently graduated business graduates is summarised in the frequency distribution which follows.

 

The mean and standard deviation salary would be

A. approximately $27.98 and $4.11 respectively.
B. approximately $27.98 and $4.10 respectively.
C. exactly $27 975 and $4 106 respectively.
D. approximately $27 975 and $4 106 respectively.
E. exactly $27 975 and $4 096 respectively.


6. Following is an ogive showing the time in days to complete the year-end audit for a sample of 20 customers from a large public accounting firm.


Select the frequency distribution, which accurately represents the data in this ogive.

A. B.

C. D.

E.



7. A management consultant conducts seminars for individuals who are interested in starting a new business. Each seminar is limited to six participants who, because of the nature of the seminars, often become clients for the management consultant. Based on the long-term experience of the management consultant, the probability distribution for x, the number of participants from each seminar who become clients is given in the following table.

 

The expected value and variance of this distribution would be

 

A.
B.
C.
D.
E.

8. If P(A) = 0.3, P(B) = 0.6, and P(A|B) = 0.2, then P(A and B) is

A. 0.06
B. 0.90
C. 0.12
D. 0.18
E. 0.33

9. Data relating to the years of experience for employees of a large accountancy firm would be classified as

A. qualitative and nominal.
B. quantitative and ordinal.
C. qualitative and ratio.
D. quantitative and interval.
E. quantitative and ratio.


Use the information following to answer questions 10. and 11.

A study concerning the relative influence of husbands and wives in consumer purchasing, reported that the husband exerts the primary influence in selecting the make of a new car in about 70% of all new-car purchases by families. Suppose 10 families have decided to buy a new car.

10. What is the probability that in exactly eight of the ten families, the husband will exert the primary influence in choosing the make of car?

A. 0.058
B. 0.148
C. 0.851
D. 0.234
E. 0.617

11. What is the probability that the husband will exert the primary influence in choosing the make of car in more than half of the ten families?

A. 0.103
B. 0.200
C. 0.150
D. 0.850
E. 0.953

12. On average, five people per day enter the intensive care unit of a local hospital on any given day. If the people arrive randomly and independently, what is the probability that the number of people entering the intensive care unit on a particular day is between six and ten?

A. 0.206
B. 0.233
C. 0.352
D. 0.379
E. 0.794

13. If Z is the standard normal random variable, then is

A. 0.1423
B. 0.6423
C. 0.9554
D. 0.8577
E. 0.3577


14. If Z is the standard normal random variable, then is

A. 0.1394
B. 0.9257
C. 0.0593
D. 0.9407
E. 0.0793

Use the following information to answer questions 15. and 16.

From past experience, the management of a well known fast food restaurant estimates that the number of weekly customers at a particular location is normally distributed, with a mean of 5000 and a standard deviation of 500 customers.

15. What is the probability that on a given week the number of customers exceeds 6500?

A. 0.4987
B. 0.9987
C. 0.0013
D. 0.0010
E. 0.4990

16. For 95% of the weeks, the number of customers should exceed what amount?

A. 4525
B. 4975
C. 5472
D. 4177.5
E. 5822.5

17. The average weekly expenditure on entertainment for a population in a given region is $19.50, and the population standard deviation is $5.30. What is the probability that a random sample of 100 will yield a sample mean greater than $20.00?

A. 0.1736
B. 0.3264
C. 0.8264
D. 0.0359
E. 0.4641


Use the following information for questions 18. and 19.

A sample of 100 chocolate bars selected was found to have a mean weight of 99.5gm with a standard deviation of 2gm.

18. The 95 % confidence interval estimate of the true mean weight of all chocolate bars produced would be calculated by

A.
B.
C.
D.
E.

19. What size sample would have to be taken in order to estimate the true mean weight of chocolate bars to within 0.2gm with 90% confidence?

A. 165
B. 164
C. 1083
D. 1082
E. 271

20. A firm's management is contemplating modifying one of its products. To help in making the decision, management representatives plan to conduct a market survey that will enable them to estimate the proportion of potential customers who would buy the new modified product. From a random sample of 100 customers selected, 40 indicated that they would buy the new modified product. The 99% confidence interval for the true proportion of all customers who would buy the new modified product would be calculated by

A.
B.
C.
D.
E. unable to be determined since are not both greater than 5.


Attachment:- mcexs02.zip

Solution Preview :

Prepared by a verified Expert
Basic Statistics: We want to use excel to generate a frequency distribution
Reference No:- TGS01350057

Now Priced at $25 (50% Discount)

Recommended (95%)

Rated (4.7/5)