EBK BUSINESS ANALYTICS
3rd Edition
ISBN: 9780135231906
Author: Evans
Publisher: VST
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 2, Problem 2PE
The Excel file Syringe Samples provides data for
Expert Solution & Answer
To determine
To define the range names for each of these samples and then use the range names in formulas to find the average values of each samples.
Explanation of Solution
Given:
The Syringe samples data for the fifteen samples in the excel file is as follows:
| Sample | Sample Observations | ||||
| S1 | 4.9600 | 4.9460 | 4.9500 | 4.9560 | 4.9580 |
| S2 | 4.9580 | 4.9270 | 4.9350 | 4.9400 | 4.9500 |
| S3 | 4.9710 | 4.9290 | 4.9650 | 4.9520 | 4.9380 |
| S4 | 4.9400 | 4.9820 | 4.9700 | 4.9530 | 4.9600 |
| S5 | 4.9640 | 4.9500 | 4.9530 | 4.9620 | 4.9560 |
| S6 | 4.9690 | 4.9510 | 4.9550 | 4.9660 | 4.9540 |
| S7 | 4.9600 | 4.9440 | 4.9570 | 4.9480 | 4.9510 |
| S8 | 4.9690 | 4.9490 | 4.9630 | 4.9520 | 4.9620 |
| S9 | 4.9840 | 4.9280 | 4.9600 | 4.9430 | 4.9550 |
| S10 | 4.9700 | 4.9340 | 4.9610 | 4.9400 | 4.9650 |
| S11 | 4.9750 | 4.9590 | 4.9620 | 4.9710 | 4.9680 |
| S12 | 4.9450 | 4.9770 | 4.9500 | 4.9690 | 4.9540 |
| S13 | 4.9760 | 4.9640 | 4.9700 | 4.9680 | 4.9720 |
| S14 | 4.9700 | 4.9540 | 4.9640 | 4.9590 | 4.9680 |
| S15 | 4.9820 | 4.9620 | 4.9680 | 4.9750 | 4.9630 |
Formulas used:
Let the range names be
| S1 | S2 | S3 | S4 | S5 | S6 | S7 | S8 | S9 | S10 | S11 | S12 | S13 | S14 | S15 |
And the formulas used for the average is:
=AVERAGE(S1), =AVERAGE(S2), and so on for fifteen samples.
Calculation:
We will apply the formula of the average in each of the samples to find out the result.
Thus, the outcome of the result is as follows:
| Sample | Sample Observations | Average | ||||
| 1 | 4.9600 | 4.9460 | 4.9500 | 4.9560 | 4.9580 | 4.9540 |
| 2 | 4.9580 | 4.9270 | 4.9350 | 4.9400 | 4.9500 | 4.9420 |
| 3 | 4.9710 | 4.9290 | 4.9650 | 4.9520 | 4.9380 | 4.9510 |
| 4 | 4.9400 | 4.9820 | 4.9700 | 4.9530 | 4.9600 | 4.9610 |
| 5 | 4.9640 | 4.9500 | 4.9530 | 4.9620 | 4.9560 | 4.9570 |
| 6 | 4.9690 | 4.9510 | 4.9550 | 4.9660 | 4.9540 | 4.9590 |
| 7 | 4.9600 | 4.9440 | 4.9570 | 4.9480 | 4.9510 | 4.9520 |
| 8 | 4.9690 | 4.9490 | 4.9630 | 4.9520 | 4.9620 | 4.9590 |
| 9 | 4.9840 | 4.9280 | 4.9600 | 4.9430 | 4.9550 | 4.9540 |
| 10 | 4.9700 | 4.9340 | 4.9610 | 4.9400 | 4.9650 | 4.9540 |
| 11 | 4.9750 | 4.9590 | 4.9620 | 4.9710 | 4.9680 | 4.9670 |
| 12 | 4.9450 | 4.9770 | 4.9500 | 4.9690 | 4.9540 | 4.9590 |
| 13 | 4.9760 | 4.9640 | 4.9700 | 4.9680 | 4.9720 | 4.9700 |
| 14 | 4.9700 | 4.9540 | 4.9640 | 4.9590 | 4.9680 | 4.9630 |
| 15 | 4.9820 | 4.9620 | 4.9680 | 4.9750 | 4.9630 | 4.9700 |
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
A component part for a motorcycle is manufactured by an investment casting process. The air vent opening on this casting is an important functional parameter of the part. The results for five samples are given in the table. The values given have been coded using the last two digits of the dimension
Sample
Air vent opening diameter (in mm
1
58
61
54
60
2
61
55
58
62
3
66
60
59
55
4
53
57
58
64
5
65
63
79
61
The sample data for a subsequent week had the values: 64, 69, 62, and 78. What conclusion can be reached about the state of the process?
Arana is a company that produces homemade Rotini pasta. They use statistical process control to monitor the
manufacturing process. The company collects five samples, each containing six packs of pasta. Below is the sample
data, but the standard deviation of the process output is unknown. If an R chart is created using three-sigma limits
(i.e., z = 3) to monitor the variability of products, what would be the upper control limit for this R chart?
Sample 1
Sample 2
Sample 3
Pack 1
452.3
451.6
448.6
Sample 4
454.7
Sample 5 448.9
7.614
9.328
11.653
13.427
Pack 2
452.8
451.2
455.6
451.7
453.4
Pack 3
456
454.6
456.5
451
456.7
Pack 4
457.2
455.3
451.9
452.6
456.3
Pack 5
457.8
452.2
455.6
454.7
452.4
Pack 6
451.8
451.9
448.3
458.4
456
Resistors for electronic circuits are manufactured on a high-speed automated machine. The machine is set up to produce a large run of resistors of 1,000 Ohms each. To set up the machine and to create a control chart to be used throughout the run, 15 samples and their measured values are as follows:
Sample Number
Readings (in Ohms)
1
1010
991
985
986
2
995
996
1009
994
3
990
1003
1015
1008
4
1015
1020
1009
998
5
1013
1019
1005
993
6
994
1001
994
1005
7
989
992
982
1020
8
1001
986
996
996
9
1006
989
1005
1007
10
992
1007
1006
979
11
996
1006
997
989
12
1019
996
991
1011
13
981
991
989
1003
14
999
993
988
984
15
1013
1002
1005
992
Develop three-sigma appropriate control chart(s) from the chart(s) what comments can you make about the process?
Explain and show work
Chapter 2 Solutions
EBK BUSINESS ANALYTICS
Ch. 2 - The Excel file Syringe Samples provides data for...Ch. 2 - Convert the Store and Regional Sales database to...Ch. 2 - Convert the Purchase Orders database to an Excel...Ch. 2 - Prob. 6PECh. 2 - Prob. 8PECh. 2 - In the Excel file Automobile Quality, search for...Ch. 2 - Prob. 10PECh. 2 - Conduct a Pareto analysis for the number of...Ch. 2 - Use Excels filtering capability in the Purchase...Ch. 2 - In the Sales Transactions database, use Excels...
Ch. 2 - Filter the data in the Bicycle Inventory database...Ch. 2 - Use the Excel file Credit Risk Data that was...Ch. 2 - Apply the Advanced Filter to the Credit Risk Data...Ch. 2 - Prob. 17PECh. 2 - For the Bicycle Inventory database, use database...Ch. 2 - For the Bicycle Inventory database, write a...Ch. 2 - The Excel file SP500 provides open, high, low, and...Ch. 2 - In the Purchase Orders database, we need to find...Ch. 2 - An auditor found an expense receipt for 179.24...Ch. 2 - Use PivotTables to find the number of sales...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, subject and related others by exploring similar questions and additional content below.Similar questions
- Auto pistons at Wemming Chung's plant in Shanghai are produced in a forging process, and the diameter is a critical factor that must be controlled. From sample sizes of 5 pistons produced each day, the mean and the range of this diameter have been as follows: Day Mean (mm) Range R (mm) 158 4.3 151.2 4.4 155.7 4.2 153.5 4.8 156.6 4.5 What is the UCL using 3-sigma?(round your response to two decimal places). 1. 2. 4.arrow_forwardRefer to Table S6.1 - Factors for Computing Control Chart Limits (3 sigma) for this problem. Twelve samples, each containing five parts, were taken from a process that produces steel rods at Emmanual Kodzi's factory. The length of each rod in the samples was determined. The results were tabulated and sample means and ranges were computed. The results were: Sample Mean (in.) Range (in.) Sample Sample Sample Mean (in.) Range (in.) 1 9.404 0.044 7 9.403 0.021 2 9.402 0.051 8 9.405 0.058 3 9.393 0.042 9.395 0.039 4 9.404 0.037 10 9.401 0.038 9.399 0.048 11 9.401 0.054 9.397 0.053 12 9.404 0.061 For the given data, the x = inches (round your response to four decimal places). Based on the sampling done, the control limits for 3-sigma x chart are: Upper Control Limit (UCL;) = inches (round your response to four decimal places). Lower Control Limit (LCL;) = inches (round your response to four decimal places).arrow_forwardPlease do not give solution in image formate thanku. The specification for a plastic liner for concrete highway projects calls for a thickness of 6.0 mm ± 0.1 mm. The standard deviation of the process is estimated to be 0.02 mm. The process is known to operate at a mean thickness of 6.03 mm. What is the Cp and Cpk for this process? Determine whether this process meet 3-sigma requirements, 6-sigma requirements, or doesn’t meet any requirements.arrow_forward
- A component part for a motorcycle is manufactured by an investment casting process. The air vent opening on this casting is an important functional parameter of the part. The results for five samples are given in the table. The values given have been coded using the last two digits of the dimension Sample Air vent opening diameter (in mm 1 58 61 54 60 2 61 55 58 62 3 66 60 59 55 4 53 57 58 64 5 65 63 79 61 Determine the central line and control limits for the range and mean charts, and discuss whether or not the process is in statistical control.arrow_forwardBottles for room spray are supposed to weigh exactly 16 oz. Inspectors want to develop process control charts. They take five (05) boxes of four (04) bottles each and weigh them. They obtain the following data. The mean weights of each of the 05 samples are 15.2, 14.6,16.5,18.1, and 13.2 respectively. Likewise, the range values for the each of 05 samples are 0.4, 0.2, 0.4, 0.5, and 0.9 respectively. For the X-bar charts and R-charts, the Parameters, A2, D3 and D4 are respectively. Select one: a. 0.48, 0.00, 2.00 b. 0.25, 0.31, 1.69 c. 0.73, 0.00, 2.28 d. 0.37, 0.14, 1.86arrow_forwardBottles for room spray are supposed to weigh exactly 16 oz. Inspectors want to develop process control charts. They take six boxes of five bottles each and weigh them. They obtain the following data. The mean weights of each of the 6 samples are 15.43, 14.47, 18.07, 17.34 12.74and 15.58 respectively. Likewise , the range values for the each of 6 samples are 1.63.0.66 6, 0.47, 0.40, 0.20 , and 0.90 respectivelyFind out Grand Mean double bar), and mean range (R bar) aligned 16.53,0.71\\ 15.82,.0.65 aligned a. b. Oc 16.538, 0.86 e. 0.0arrow_forward
- A quality control manager in an Omani bottling company takes 5 samples for quality control purposes. These sample mean (X- bar) are; 8.51, 8.18, 11.07, 10.03, and 10.23 respectively. Additionally, the range values for these 5 samples are; 3.33, 2.61, 3.39, 4.39, and 6.49. If the lower control limit for X- bar chart is 7.664, what should be the most appropriate sample size? O a. 3 O b. None is correct O C. 4 O d. 6 O e. 5arrow_forwardA metal fabricator produces connecting rods with an outer diameter that has a 1± 0.02 inch specification. A machine operator takes several sample measurements over time and determines the sample mean outer diameter to be 1.005 inches with a standard deviation of 0.003 inch. Calculate the process capability index for this example. Note: Round your answer to 3 decimal places. Process capability indexarrow_forwardA column chart can sometimes be used instead of a line chart for time series data. Select one: True Falsearrow_forward
- A quality control manager in an Omani bottling company takes 5 samples for quality control purposes. These sample mean (X-bar) are; 8.51,8.18, 11.07, 10.03, and 10.23 respectively. Additionally, the range values for these 5 samples are; 3.33, 2.61, 3.39,4.39, and 6.49. If the lower control limit for X-bar chart is 6.65, what should be the most appropriate sample size? O a. 3 O b. 5 O c. Od. None is correct O e. 4arrow_forwardWhich of the following graphical presentations is not appropriate for numerical data? histogram pie chart time-series plot scatter plotarrow_forwardSample size (n) is 16, mean of the sample means ( ) is 15, mean of the sample ranges ( ) is 6, and population standard deviation ( ) is not known. Calculate the UCL and LCL of the mean chart (x-Chart) for this process. Group of answer choices Cannot be calculated UCL=33.0, LCL=-3.0 UCL=13.73, LCL=16.27 UCL=16.27, LCL=13.73 UCL=33.0, LCL=0arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
BUSN 11 Introduction to Business Student EditionBusinessISBN:9781337407137Author:KellyPublisher:Cengage Learning
Essentials of Business Communication (MindTap Cou...BusinessISBN:9781337386494Author:Mary Ellen Guffey, Dana LoewyPublisher:Cengage Learning
Accounting Information Systems (14th Edition)BusinessISBN:9780134474021Author:Marshall B. Romney, Paul J. SteinbartPublisher:PEARSON
International Business: Competing in the Global M...BusinessISBN:9781259929441Author:Charles W. L. Hill Dr, G. Tomas M. HultPublisher:McGraw-Hill Education
BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education
Hypothesis Testing using Confidence Interval Approach; Author: BUM2413 Applied Statistics UMP;https://www.youtube.com/watch?v=Hq1l3e9pLyY;License: Standard YouTube License, CC-BY
Hypothesis Testing - Difference of Two Means - Student's -Distribution & Normal Distribution; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=UcZwyzwWU7o;License: Standard Youtube License