
Concept explainers
This is an exercise using Excel. (a) Use =RANDBETWEEN(0,99) to create 20
a.

Create 20 samples by choosing two digit random numbers between 00 and 99 of size n=4.
Answer to Problem 94CE
The random numbers are given below:
Explanation of Solution
Calculation:
Answer will vary. One of the possible answers is given below:
Software procedure:
Step-by-step procedure to find the standard deviation using the EXCEL software is given below:
- • Open an EXCEL file.
- • In A1, enter the formula “=RANDBETWEEN(0,99)”.
- • Click Enter.
- • Drag the cells to bottom 4 rows and 20 columns to the right.
b.

Calculate the mean for each sample.
Answer to Problem 94CE
The mean for each sample is given below:
Explanation of Solution
Calculation:
Mean:
The arithmetic mean(also called the average)is the most commonly used measure of central tendency. It is calculated by summing the observed numerical values of a variable in a set of data and then dividing the total by the number of observations involved.
Software procedure:
Step-by-step procedure to find the mean for each sample using the EXCEL software is given below:
- • Open an EXCEL file.
- • In A1, enter the formula “=RANDBETWEEN(0,99)”.
- • Click Enter.
- • Drag the cells to bottom 4 rows and 20 columns to the right.
- • In A5, enter the formula “=AVERAGE(A1:A4)”.
- • Click Enter.
- • Drag the cells for 20 columns to the right.
c.

Make a histogram of 80 individual x-values using bins of 10 units wide and describe the shape of the histogram.
Answer to Problem 94CE
The histogram of 80 individual x-values using 10 units wide is given below:
Explanation of Solution
Calculation
The values are ranging from 0 to 99. The way to arrange the data in a group is, the first class takes values from0-10, and the second class takes 10-20 and so on.
Now, count the frequency (number of values) in each bin that is, 8is in bin 0-10 because 8 values occur in this interval. Similarly for the remaining bins frequencies are obtained.
The frequency table is as follows,
Class | Frequency |
0-10 | 8 |
10-20 | 11 |
20-30 | 4 |
30-40 | 10 |
40-50 | 7 |
50-60 | 10 |
60-70 | 9 |
70-80 | 8 |
80-90 | 6 |
90-100 | 7 |
Total | 80 |
Histogram:
It is bar graph for a quantitative data where the bars have a particular order and specific meaning for the bin widths.
Software procedure:
Step-by-step software procedure to obtain histogram using EXCEL is as follows:
- • Open an EXCEL file.
- • In column A, enter the column of class and in column B enter the column of Frequency.
- • Select the data that is to be displayed.
- • Select Insert > Column
- • Choose Clustered column under 2-D column.
- • Double click on the bars and reduce the Gap Width to 0
- • Click on the chart > select Layout from the Chart Tools.
- • Select Chart Title>Above Chart.
- • Enterin the dialog box.
- • Select Axis Title>Primary Horizontal Axis Title > Title Below Axis.
- • EnterClass in the dialog box.
- • Select Axis Title>Primary Vertical Axis Title > Rotated Title.
- • Enter Frequency in the dialog box.
Symmetric distribution:
The distribution is said to be symmetric when the left half is the mirror image of the right half.
Left skewed distribution:
The distribution is said to be left skewed, if most of the observations are spread out on the left side. That is, the left tail is more elongated than the right tail.
Right skewed distribution:
The distribution is said to be left skewed, if most of the observations are spread out on the right side. That is, the right tail is more elongated than the left tail.
Here, the values are spread out almost equally on both sides. Thus, the histogram is nearly symmetric.
d.

Make a histogram of 20 sample means using bins of 10 units wide and describe the shape of the histogram.
Answer to Problem 94CE
The histogram of 20 sample means using 10 units wide is given below:
Explanation of Solution
Calculation
Here, count the frequency (number of values) in each bin that is, 0 is in bin 0-10 because none of the values of sample means occur in this interval. Similarly for the remaining bins frequencies are obtained.
The frequency table is as follows,
Class | Frequency |
0-10 | 0 |
10-20 | 0 |
20-30 | 2 |
30-40 | 3 |
40-50 | 6 |
50-60 | 6 |
60-70 | 2 |
70-80 | 1 |
80-90 | 0 |
90-100 | 0 |
Total | 20 |
Software procedure:
Step-by-step software procedure to obtain histogram using EXCEL is as follows:
- • Open an EXCEL file.
- • In column A, enter the column of class and in column B enter the column of Frequency.
- • Select the data that is to be displayed.
- • Select Insert > Column
- • Choose Clustered column under 2-D column.
- • Double click on the bars and reduce the Gap Width to 0
- • Click on the chart > select Layout from the Chart Tools.
- • Select Chart Title>Above Chart.
- • Enterin the dialog box.
- • Select Axis Title>Primary Horizontal Axis Title > Title Below Axis.
- • EnterClass in the dialog box.
- • Select Axis Title>Primary Vertical Axis Title > Rotated Title.
- • Enter Frequency in the dialog box.
e.

Describe the shape of the histogram and explain whether the Central Limit Theorem seem to be working or not.
Answer to Problem 94CE
The shape of the histogram is symmetric. The central limit theorem seems to be working in the situation.
Explanation of Solution
For the histogram of sample means, the left half is the mirror image of the right half. Thus, the distribution of sample means is symmetric.
Central limit theorem for a mean:
If a random sample of size n is taken from a population having mean μ and standard deviation σ then, as the sample size increases (n≥30), the sample mean ˉX approaches the normal distribution with mean μ and standard deviation σˉx=σ√n.
The three main points about the sample mean is:
- • If the population is normal, then the sample mean has a normal distribution. The mean of the distribution is μ with a standard error of σ√n.
- • The distribution of the sample mean converges to the population mean as the sample size increases.
- • According to the theorem, even if the population is not normal, the sample means have approximately a normal distribution as the sample size becomes large.
According to the central limit theorem, distribution of the sample means converges to the normal distribution as sample size increases. Thus, the central limit theorem seems to be working in the situation.
f.

Find the mean of the 20 sample means and explain whether it was expected one or not.
Answer to Problem 94CE
- The mean of the 20 sample means is 48.93. The obtained value of mean is close to the expected value.
Explanation of Solution
Calculation:
Software procedure:
Step-by-step procedure to find the mean using the EXCEL software is given below:
- • Open an EXCEL file.
- • Enter the sample mean values from A1 through A20.
- • In B1, enter the formula “=AVERAGE(A1:A20)”.
- • Click Enter.
- Output using EXCEL software is given below:
From the EXCEL output, the mean value is 48.93.
- Since the sample size is large the mean of the 20 sample means is expected to have the population mean. Here, random numbers are generated from 0 to 99, by uniform distribution the mean value is 49.5(=b+a2). Thus, the obtained value of mean is close to the expected value.
g.

Find the standard deviation of the 20 sample means and explain whether it was expected one or not.
Answer to Problem 94CE
- The standard deviation of the 20 sample means is 12.41. The obtained value of mean is close to the expected value.
Explanation of Solution
Calculation:
Software procedure:
Step-by-step procedure to find the mean using the EXCEL software is given below:
- • Open an EXCEL file.
- • Enter the sample mean values from A1 through A20.
- • In B1, enter the formula “=STDEV(A1:A20)”.
- • Click Enter.
- Output using EXCEL software is given below:
From the EXCEL output, the standard deviation is 12.41.
- Since the sample size is large the standard deviation of the 20 sample means is expected to have thestandard deviation σˉx=σ√n. Here, random numbers are generated from 0 to 99, by uniform distribution the standard deviation value of population is 28.57(=b−a√12). The standard deviation of sample means is 14.285(=28.57√4).
- Thus, the obtained standard deviation is close to the expected value.
Want to see more full solutions like this?
Chapter 8 Solutions
APPLIED STAT.IN BUS.+ECONOMICS
Additional Math Textbook Solutions
Introductory Statistics
Elementary Algebra For College Students (10th Edition)
Elementary & Intermediate Algebra
Precalculus: A Unit Circle Approach (3rd Edition)
Elementary Statistics: Picturing the World (7th Edition)
Elementary Statistics ( 3rd International Edition ) Isbn:9781260092561
- Question 1 The data shown in Table 1 are and R values for 24 samples of size n = 5 taken from a process producing bearings. The measurements are made on the inside diameter of the bearing, with only the last three decimals recorded (i.e., 34.5 should be 0.50345). Table 1: Bearing Diameter Data Sample Number I R Sample Number I R 1 34.5 3 13 35.4 8 2 34.2 4 14 34.0 6 3 31.6 4 15 37.1 5 4 31.5 4 16 34.9 7 5 35.0 5 17 33.5 4 6 34.1 6 18 31.7 3 7 32.6 4 19 34.0 8 8 33.8 3 20 35.1 9 34.8 7 21 33.7 2 10 33.6 8 22 32.8 1 11 31.9 3 23 33.5 3 12 38.6 9 24 34.2 2 (a) Set up and R charts on this process. Does the process seem to be in statistical control? If necessary, revise the trial control limits. [15 pts] (b) If specifications on this diameter are 0.5030±0.0010, find the percentage of nonconforming bearings pro- duced by this process. Assume that diameter is normally distributed. [10 pts] 1arrow_forward4. (5 pts) Conduct a chi-square contingency test (test of independence) to assess whether there is an association between the behavior of the elderly person (did not stop to talk, did stop to talk) and their likelihood of falling. Below, please state your null and alternative hypotheses, calculate your expected values and write them in the table, compute the test statistic, test the null by comparing your test statistic to the critical value in Table A (p. 713-714) of your textbook and/or estimating the P-value, and provide your conclusions in written form. Make sure to show your work. Did not stop walking to talk Stopped walking to talk Suffered a fall 12 11 Totals 23 Did not suffer a fall | 2 Totals 35 37 14 46 60 Tarrow_forwardQuestion 2 Parts manufactured by an injection molding process are subjected to a compressive strength test. Twenty samples of five parts each are collected, and the compressive strengths (in psi) are shown in Table 2. Table 2: Strength Data for Question 2 Sample Number x1 x2 23 x4 x5 R 1 83.0 2 88.6 78.3 78.8 3 85.7 75.8 84.3 81.2 78.7 75.7 77.0 71.0 84.2 81.0 79.1 7.3 80.2 17.6 75.2 80.4 10.4 4 80.8 74.4 82.5 74.1 75.7 77.5 8.4 5 83.4 78.4 82.6 78.2 78.9 80.3 5.2 File Preview 6 75.3 79.9 87.3 89.7 81.8 82.8 14.5 7 74.5 78.0 80.8 73.4 79.7 77.3 7.4 8 79.2 84.4 81.5 86.0 74.5 81.1 11.4 9 80.5 86.2 76.2 64.1 80.2 81.4 9.9 10 75.7 75.2 71.1 82.1 74.3 75.7 10.9 11 80.0 81.5 78.4 73.8 78.1 78.4 7.7 12 80.6 81.8 79.3 73.8 81.7 79.4 8.0 13 82.7 81.3 79.1 82.0 79.5 80.9 3.6 14 79.2 74.9 78.6 77.7 75.3 77.1 4.3 15 85.5 82.1 82.8 73.4 71.7 79.1 13.8 16 78.8 79.6 80.2 79.1 80.8 79.7 2.0 17 82.1 78.2 18 84.5 76.9 75.5 83.5 81.2 19 79.0 77.8 20 84.5 73.1 78.2 82.1 79.2 81.1 7.6 81.2 84.4 81.6 80.8…arrow_forward
- Name: Lab Time: Quiz 7 & 8 (Take Home) - due Wednesday, Feb. 26 Contingency Analysis (Ch. 9) In lab 5, part 3, you will create a mosaic plot and conducted a chi-square contingency test to evaluate whether elderly patients who did not stop walking to talk (vs. those who did stop) were more likely to suffer a fall in the next six months. I have tabulated the data below. Answer the questions below. Please show your calculations on this or a separate sheet. Did not stop walking to talk Stopped walking to talk Totals Suffered a fall Did not suffer a fall Totals 12 11 23 2 35 37 14 14 46 60 Quiz 7: 1. (2 pts) Compute the odds of falling for each group. Compute the odds ratio for those who did not stop walking vs. those who did stop walking. Interpret your result verbally.arrow_forwardSolve please and thank you!arrow_forward7. In a 2011 article, M. Radelet and G. Pierce reported a logistic prediction equation for the death penalty verdicts in North Carolina. Let Y denote whether a subject convicted of murder received the death penalty (1=yes), for the defendant's race h (h1, black; h = 2, white), victim's race i (i = 1, black; i = 2, white), and number of additional factors j (j = 0, 1, 2). For the model logit[P(Y = 1)] = a + ß₁₂ + By + B²², they reported = -5.26, D â BD = 0, BD = 0.17, BY = 0, BY = 0.91, B = 0, B = 2.02, B = 3.98. (a) Estimate the probability of receiving the death penalty for the group most likely to receive it. [4 pts] (b) If, instead, parameters used constraints 3D = BY = 35 = 0, report the esti- mates. [3 pts] h (c) If, instead, parameters used constraints Σ₁ = Σ₁ BY = Σ; B = 0, report the estimates. [3 pts] Hint the probabilities, odds and odds ratios do not change with constraints.arrow_forward
- Solve please and thank you!arrow_forwardSolve please and thank you!arrow_forwardQuestion 1:We want to evaluate the impact on the monetary economy for a company of two types of strategy (competitive strategy, cooperative strategy) adopted by buyers.Competitive strategy: strategy characterized by firm behavior aimed at obtaining concessions from the buyer.Cooperative strategy: a strategy based on a problem-solving negotiating attitude, with a high level of trust and cooperation.A random sample of 17 buyers took part in a negotiation experiment in which 9 buyers adopted the competitive strategy, and the other 8 the cooperative strategy. The savings obtained for each group of buyers are presented in the pdf that i sent: For this problem, we assume that the samples are random and come from two normal populations of unknown but equal variances.According to the theory, the average saving of buyers adopting a competitive strategy will be lower than that of buyers adopting a cooperative strategy.a) Specify the population identifications and the hypotheses H0 and H1…arrow_forward
- You assume that the annual incomes for certain workers are normal with a mean of $28,500 and a standard deviation of $2,400. What’s the chance that a randomly selected employee makes more than $30,000?What’s the chance that 36 randomly selected employees make more than $30,000, on average?arrow_forwardWhat’s the chance that a fair coin comes up heads more than 60 times when you toss it 100 times?arrow_forwardSuppose that you have a normal population of quiz scores with mean 40 and standard deviation 10. Select a random sample of 40. What’s the chance that the mean of the quiz scores won’t exceed 45?Select one individual from the population. What’s the chance that his/her quiz score won’t exceed 45?arrow_forward
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGALCollege Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning
- Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt




