Statistics Multiple Choice Questions

/in /by

Question: Statistical process control relies on _____.

A Capability models

B Variance analyses

C Control charts

D Conformance reports

Question: Twenty samples of size 6 were collected for a variable measurement. Determine the upper control limit (UCL) and lower control limit (LCL) for an R-chart if the sum of the sample ranges equals 88.0.

A UCL = 8.8176, LCL = 0.0000

B UCL = 9.3016, LCL = 0.3344

C UCL = 13.2000, LCL = 0.0000

D UCL = 29.3921, LCL = 0.0000

Question: x-charts are used for

A Averages of variables data

B Individual attribute data

C Individual variables data

D Averages of attributes data

Question: In determining whether a process is in statistical control, the _____ is/are generally analyzed first.

A R-chart

B Control limits

C Average range

D Nonconformance

Question: In pre-control, which zone covers the nominal dimension?

A Gray zone

B Yellow zone

C Red zone

D Green zone

Question: Which of the following is not an indication of an out-of-control process?

A Five consecutive points fall on one side of the center line

B Four of five consecutive points fall within the outer two-thirds region between the center line and one of the control limits

C Two of three consecutive points fall in the outer one-third region between the center line and one of the control limits

D A single point falls above the upper control limit

Question: A machined part has a lower tolerance limit of 3.5 inches and an upper tolerance limit of 3.9 inches. The range for the pre-control green zone is

A 3.5 to 3.9 inches

B 3.7 inches to 3.9 inches

C Less than 3.5 inches

D 3.6 inches to 3.8 inches

Question: If the process mean and variance do not change over time, the process is considered to be

A In control

B Symmetric

C Stable

D Capable

Question: Each day, a manufacturing company producing circuit boards will randomly sample 60 circuit boards and then determine and plot the number of defects contained in each of these boards. The appropriate control chart is a

A  -chart

B p-chart

C np-chart

D c-chart

Question: Control limits relate to _____, while specification limits relate to individual measurements.

A Values within the upper and lower control limits

B Total values in the range

C Median values

D Averages of samples

Question: A precision parts manufacturer produces bolts for use in military aircraft. The specifications for bolt length are 37.50 ± 0.25 cm. The company has established an  -chart and an R-chart using samples of size five. The centerlines for the  -chart and R-chart are set at 37.65 cm and 1.03 cm, respectively. What is the value of Cp for this process?

A 0.188

B 1.333

C 0.301

D 0.166

Question: The control chart most appropriate for plotting the daily percentage of students that wait longer than five minutes in line at the undergraduate admissions office is a(n)

A p-chart

B np-chart

C x-chart

D  -chart

Question: The _____ is used to monitor the centering of the process.

A  -chart

B R-chart

C p-chart

D np-chart

Question: If the traditional 3-sigma limits on a control chart are replaced by 2-sigma limits, which of the following is TRUE?

A Type I errors decrease

B Type I errors increase

C Type II errors increase

D The center line moves downward

Question: Five samples of size 3 were collected for a variable measurement. All sample data were greater than or equal to 4.0. The sample means and sample ranges are provided in the following table.
Sample number  1  2  3  4  5
________________________________________
Sample mean  5.0  4.9 5.0 6.0 5.2
Sample range 0.2 0.4 0.1 0.0 0.3

The values of which sample are identical?

A Sample 1

B Sample 2

C Sample 3

D Sample 4

Question: Which of the following charts is used to monitor the total number of defects per unit when a constant subgroup size is employed?

A s-chart

B c-chart

C p-chart

D u-chart

Question: An  -chart is used to monitor the process

A Range

B Median

C Variance

D Mean

Question: Which of the following is a likely cause of the control chart pattern known as a trend?

A Aging equipment

B Change in setup method

C New operator

D A mixture of two materials

Question: Determine the sample standard deviation for the following sample data: 7, 9, 2, 0, 1, and 5.

A 3.347

B 3.266

C 2.993

D 3.578

Question: A p-chart is also called a

A Pre-control chart

B Probability chart

C Fraction defective chart

D Process capability chart

Question: Which of the following pairs of charts are used together?

A  -chart and p-chart

B R-chart and p-chart

C R-chart and s-chart

D  -chart and R-chart

Question: c-charts are based on the _____ probability distribution

A Normal

B Binomial

C Poisson

D Uniform

Question: In an  -chart, the upper control limit is equal to the overall sample mean plus three times the

A Process standard deviation

B Average range

C Standard error of the mean

D Sample variance

Question: A _____ monitors the fraction of nonconforming items.

A p-chart

B x-chart

C s-chart

D c-chart

Question: Which of the following would be used to monitor the number of nonconforming items?

A np-chart

B p-chart

C u-chart

D n-chart

Question: If the sample size in a p-chart increases from 100 to 120, the upper and lower control limits will

A Move farther apart

B Move closer together

C Remain the same distance apart

D Both shift upward

Question: Control limits are often confused with _____.

A Control charts

B Tolerance limits

C Specification limits

D Variance limits

Question: Collecting _____ data is usually easier than collecting _____ data because the assessment can usually be done more quickly by a simple inspection or count.

A Attribute; variable

B Concrete; continuous

C Random; discrete

D Simple; continuous

Question: In the application of control charts, as the sample size is increased

A Type I errors are reduced, and Type II errors are increased

B Type I errors are increased, and Type II errors are reduced

C Both Type I and Type II errors are increased

D Both Type I and Type II errors are reduced

Question: A process is deemed “out of control” when

A Common causes are present

B Special causes are present

C Data varies around the mean

D Random variation is present

Review information about a major rival to coca cola company.

/in /by

Q1. End of Chapter 5 and do Exercise 5B “Should Coca-Cola, Build, Borrow, or Buy in2020 -2021?” Steps 1,and 2(minimum of one page assignment).  (When accessing Coca-Cola’s website, you’ll have to click on “Press Center,”.)

 

5B exercise question :

Step 1 Review material about coca cola and at the coca cola website. Review current news articles about coca cola company.

Step 2 Review information about a major rival to coca cola company.

Determine whether you believe COCA could or should try to acquire. Give the pros and cons of such a horizontal integration strategy. Recall that coca cola recently acquired rival.

 

Q2. End of Chapter 6 and do Exercise 6A “Perform a SWOT Analysis for Coca-Cola” as an individual, one page assignment.

6A Exercise : Develop a SWOT Matrix for coca cola

Company.  Follow all the SWOT guidelines provided in the chapter, including notation (for example, S4, T3) at the end of each strategy.Include two strategies in each of the four (SO,ST, WT, WO) quadrants. Be specific regarding your strategies, avoiding generic terms such as forward integration.

Sheet1

Strengths Weaknesses
1. Coca Cola is the  number one beverages brand in terms of reach and sales 1. The presence of traces of pesticides in the cola beverages have caused damage to the brand image
2. Popular subsidiary brands like Coca Cola, Fanta, Kinley, Limca, Maaza, Minute Maid, etc. 2. Strong competition in the aerated drinks segment from PepsiCo means constant fight over market share for Coca Cola
3. Coca Cola has Global reach with presence in over 200 countries 3. Coca Cola and related soft drinks brands have been linked now with high sugar content and many health concerns are being raised, this becomes a weakness worth looking at
4. More than 500 brands on offer 4. Coca Cola does not have a food business unlike its competitors, it is only limited to beverages as of now
5. Coca Cola has employee strength of around 1,50,000 people globally
6. Strong and efficient supply chain network, ensuring that all the products are available even in the most remote places
7. Strong financial condition
8. Strong brand recall of all Coca Cola products through advertising and marketing by associating with celebrity brand ambassadors
9. CSR activities in the field of water conservation and recycling, education, health etc.
10. Effective and efficient packaging technique giving emphasis on recycling and reusing
11. Coca Cola has long association with international sports events, sponsorships etc
12. Coca Cola has always adapted to changing market conditions e.g. the brand is now moving towards sugar free options, juice, water etc
Opportunities SO strategies WO Strategies
1. Increase its reach in untapped countries and market can boost Coca Cola S6,O1 O4,W4
2. Market and popularise the less known products S8,O2 O1,W2
3. Acquiring other companies can strengthen Coca Cola’s place in the industry further S7,O3
4. Diversify its product portfolio by entering into snacks industry to compete with PepsiCo
Threats ST strategies WT Strategies
1. Health consciousness amongst people avoiding aerated drinks can adversely affect Coca Cola T1,S12 T4,w2
2. Difficulty in complying with different government regulations and norms in different countries T3,S7 T1,w3
3. Inflation, economic slowdown and instability
4. Strong competition can lead to reduced market share

Conch Republic Electronics Is A Mid Sized Electronics Manufacturer Located In Key West, Florida

/in /by
Conch Republic Electronics is a mid sized electronics manufacturer located in Key West, Florida. The company president is Shelley Couts, who inherited the company. When it was founded over 70 years ago, the company originally repaired radios and other household appliances. Over the years, the company expanded into manufacturing and is now a reputable manufacturer of various electronic items. Jay McCanless, a recent MBA graduate, has been hired by the company’s finance department.
One of the major revenue-producing items manufactured by Conch Republic is a personal digital assistant (PDA). Conch Republic currently has one PDA model on the market, and sales have been excellent. The PDA is a unique item in that it comes in a variety of tropical colors and is preprogrammed to play Jimmy Buffett music. However, as with any electronic item, technology changes rapidly, and the current PDA has limited features in comparison with newer models. Conch Republic developed a prototype for a new PDA that has all the features of the existing PDA but adds new features such as cell phone capability. The company has performed a marketing study to determine the expected sales figures for the new PDA.
Conch Republic can manufacture the new PDA for $200 each in variable costs. Fixed costs for the operation are estimated to run $4.5 million per year. The estimated sales volume is 70,000, 80,000, 100,000, 85,000, and 75,000 per each year for the next five years, respectively. The unit price of the new PDA will be $340. The necessary equipment can be purchased for $16.5 million and will be depreciated on a 5 year straight-line schedule.
Net working capital investment for the PDAs will be $6,000,000 the first year of operations. Of course NWC will be recovered at the projects end. Conch Republic has a 35 percent corporate tax rate and a 12 percent required return.
Shelly has asked Jay to prepare a report that answers the following questions:
(A) What is the IRR of the project?
(B) What is the NPV of the project, based on the required rate of return of 12%?

The Red Bluff Golf Course &amp

/in /by

YO19_Excel_CH09_Prepare_Data_Integration_PartB_Instructions.docx

Grader – Instructions Excel 2019 Project

YO19_Excel_CH09_Prepare_Data_Integration_PartB

 

Project Description:

The Red Bluff Golf Course & Pro Shop manager, Aleeta Herriott, has asked you to create a report that analyzes costs and revenues from tournaments hosted over the past year. In the past, her staff had to reenter data manually from different sources to create this report because no one at the resort knew how to import the data. As a result, they rarely completed the report. Aleeta worries about the accuracy of the reports that were compiled because of the manual data entry. However, she did keep all the original files. Recently, a new Golf database was created to track sales and allow for easy export to Excel for analysis. Aleeta wants you to design a spreadsheet that will help her automate the process of gathering and standardizing the data from the past for analysis.

 

Steps to Perform:

Step Instructions Points Possible
1 This exercise begins on page 519 of your text. Start Excel. Download and open the file named Excel_Ch09_Prepare_DataIntegration2of3.xlsx. Grader has automatically added your last name to the beginning of the filename. 0
2 A list of customer information on a tournament golf club giveaway has been provided in the Excel_Ch09_Prepare_DataIntegration2of3.xlsx workbook. The data needs to be cleansed before it can be used for purposes such as analysis or merging to a Word document. On the RegistrationData worksheet in column B, use Flash Fill to separate the first name from the name in column A. 0.4
3 The dates in column C are not stored in date formats that Excel can use. In column D, use Flash Fill to convert the data in column C into a month/day/year date format e.g., 4/13/2022, 3/18/2022, etc. 0.6
4 The phone numbers provided in column E are not in a standard phone number format. In order to include these phone numbers in mail merges or other professional formats they need to be formatted using a hyphen. In column F, use Flash Fill to convert the string of numbers in column E to include a hyphen in between the first 3 digits and the last 4 digits e.g., 555-6199, 555-1953, etc. 0.6
5 The customer names on the CustNames worksheet were imported with non-printable characters, extra spaces, and in inconsistent formats. The data needs to be cleansed to appear as first name, middle initial (if present), and last name. On the CustNames worksheet, in column B, use the appropriate text function to clean all the nonprinting characters from the data in column A. Resize the column as needed to fit the contents. 0.5
6 The names should also be proper cased. In column C, use the appropriate text function to convert the data in column B into proper case. Resize the column as needed to fit the contents. 0.5
7 In cell D2, use the appropriate text function to remove any extra spaces before or after as well as between the names in column C. Resize the column as needed to fit the contents. 0.5
8 In column E, use the appropriate text function to return the position of the space character located in the data in column D. Resize the column as needed to fit the contents. 0.6
9 In column F, use the appropriate text function to extract only the last name from column D. Use the number in column E as the relative starting point for the number of characters needed to extract only the last name from the left side of the data in column D (no extra spaces). Resize the column as needed to fit the contents. 0.6
10 In column G, use the appropriate text functions to extract only the first name and middle initial from column D. Use the value in column E as part of the calculation to determine the number of characters needed to extract only the first name and middle initial from the right side of the data in column D. Resize the column as needed to fit the contents. 0.8
11 In column H, use the ampersand symbol (&) to concatenate the first name and middle initial in column G and the last name in column F with a space in between. Resize the column as needed to fit the contents. 0.5
12 The E-mail worksheet contains the names and email addresses of customers. In order to use the e-mail addresses to communicate with customers, they need to be separated from the rest of the associated text and then joined together so that they can be copied and pasted into an e-mail address field. In column C, use the appropriate text function to return the position of the colon character in column B. Resize the column as needed to fit the contents. 0.5
13 In column D, use the appropriate text function to calculate the total number of characters in each cell of column B. Resize the column as needed to fit the contents. 0.5
14 In column E use the appropriate text function to extract the e-mail address from column B. Use the number in column C as the relative starting point for the number of characters needed to extract only the e-mail address from the left side of the address data in column B (no colon and no angle brackets included). Resize the column as needed to fit the contents. 0.8
15 In cell G2 use the appropriate text function to create an e-mail list that combines the e-mail addresses in column E using a semi-colon and a space (“; “) for a delimiter. Use the appropriate argument to ignore any blank cells. 0.7
16 Additional customer names have been provided on the Members worksheet. They need to be separated into first and last names for communications with those customers. On the Members worksheet, use the Text to Columns Wizard to separate the names in column A so that the first names are in column B and the last names are in column C. 0.7
17 A list customers that received golf lessons is contained on the Lessons worksheet. There are duplicate records in the data that need to be removed. On the Lessons worksheet, use Remove Duplicates to remove any records with the same LastName, ScheduledDate, and Fee. 0.7
18 The Invoices worksheet contains a listing of invoice numbers. Any duplicate records need to be identified in the data. On the Invoices worksheet, use conditional formatting to highlight the data in column A so that duplicate values appear with a Light Red Fill with Dark Red Text. Turn on filtering for the data and sort by cell color. 0.5
19 Save and close Excel_Ch09_Prepare_DataIntegration2of3. Exit Excel. Submit your files as directed. Please note: This project continues in part C which is a separate Grader project. 0
Total Points 10

 

Created On: 12/18/2019 1 YO19_Excel_Ch09_Prepare – Data Integration Part B 1.0

McDonald_Excel_Ch09_Prepare_DataIntegration2of3.xlsx

RegistrationData

First Name & Middle Initial First Name Registration Date Cleansed Registration Date Phone Number Cleansed Phone Number
Carter X 20220413 5556199
Jane 20220318 5551953
Fitzgerald K 20220410 5557584
Arden W 20220312 5558974
Zeph 20220322 5551491
Lilah 20220302 5557887
Bruno L 20220309 5553920
Kiara 20220407 5556312
Yardley Y 20220423 5555604
Maxine 20220419 5556216
Walter M 20220309 5551513
Dexter 20220325 5558772
Asher 20220402 5559808
Ruby I 20220316 5551784
Keaton T 20220321 5551795
Kiona 20220315 5556175
Kermit V 20220325 5556964
Christen 20220301 5557674
Coby 20220305 5553561
Cullen F 20220319 5556467
Desiree J 20220325 5558565
Seth 20220308 5554393
Alden 20220401 5556732
Germaine 20220325 5551342
Maxwell E 20220308 5558603

CustNames

Name Clean Proper Trim Find Last Name First Name & Middle Initial Full Name
��GAINES THOMAS M.
�Stone Jerome�
�� Cannon Simone Z�
��Campbell Reece H.�
��Chase Stafford�
�Mcclain Jack�
�JONES BOBBY J.�
� Davis Tanner�
�Murray Colt Q .�
� GIFFORD MARJORIE�
� HANKINS ELIZA S.�
�Branch Anthony
� Bray Brian�
� JOYCE DAVID J.�
��KRAUS CAROL T.
��LAMB SAMANTHA
� Kirk Jocelyn B.
��LEWIS PATRICK�
�� Gentry David
�� PREWITT HANNAH E.�
��RANGELL JOHN W.
� RUSSO ROBERT
��TATE ANDREA M.�
� THOMPSON SHARON�
�� WOODFORD VERA T.

E-mail

Customer ID Full Address Find Colon Length Email Create an email list separated by semi-colons
1 Charles Barker mailto: <justo.eu@milorem.edu>
2 Missy Malone mailto: <orci.consectetuer@Donecsollicitudin.ca>
3 Susan Winter mailto: <et@nonloremvitae.org>
4 Jose Rodriquez mailto: <Sed@nibhsitamet.ca>
5 Nicole Rodriquez mailto: <lacinia.at.iaculis@gravidamolestie.ca>
6 Brenden Erickson mailto: <diam@Proinnon.ca>
7 Kaseem Castillo mailto: <sed@conubia.org>
8 Courtney Miller mailto: <neque.non.quam@anunc.com>
9 Fiona Britt mailto: <quis@Fuscedolorquam.com>
10 Robert Allen mailto: <amet@Nullamvitaediam.edu>
11 John Trujillo mailto: <Aenean@maurisid.ca>
12 Ian McShane mailto: <urna.Nullam.lobortis@loremDonecelementum.edu>
13 Marge Fresquez mailto: <nec.luctus@inconsequat.com>
14 Marcus Maestas mailto: <vulputate.risus.a@IntegermollisInteger.com>
15 Janice Marquardt mailto: <fringilla.Donec@pellentesque.ca>
16 Keith Marquardt mailto: <augue@molestie.ca>
17 Kate Neidhart mailto: <ipsum@dui.edu>
18 Thomas Reed mailto: <vehicula.risus.Nulla@euaugue.edu>
19 Cynthia Reid mailto: <mollis.dui@tortordictum.org>
20 Joseph McMannon mailto: <pharetra.felis@Sedeu.org>

Members

Names First Name Last Name
Thomas Gaines
Jerome Stone
Simone Cannon
Reece Campbell
Stafford Chase
Jack Mcclain
Bobby Jones
Tanner Davis
Colt Murray
Marjorie Gifford
Eliza Hankins
Anthony Branch
Brian Bray
David Joyce

Lessons

LastName ScheduledDate Fee
Winter 7/22/22 $175.00
Barker 6/8/22 $175.00
Miller 5/27/22 $145.00
Malone 6/8/22 $200.00
Barker 6/17/22 $325.00
Castillo 5/30/22 $75.00
Rodriquez 5/11/22 $200.00
Miller 5/1/22 $175.00
Miller 5/27/22 $145.00
Britt 5/17/22 $125.00
Rodriquez 5/12/22 $200.00
Barker 6/2/22 $100.00
Castillo 5/31/22 $300.00
Winter 7/23/22 $300.00
Barker 6/8/22 $175.00
Allen 6/10/22 $300.00
Rodriquez 5/11/22 $200.00

Invoices

Invoice Numbers
13742
14618
12761
15056
12072
13389
15436
12905
14371
14668
12627
12948
13360
13844
12042
12381
15076
14532
14038
13292
12001
12275
14449
11902
14162
12558
13254
12424
14974
13912
15148
14304
13674
13141
14666
13184
13329
13907
12255
14261
13033
12701
14223
12715
14539
12042
14161
13942
12924
12445
14248
13123
14090
15355
14412
12676
13838
14449
14849
12662
11864
13935
12470
15059
15387
15506
12888
12559
13969
13215
12772
12827
12949
15138
12359
12614
15524
13430
12439
14876
12979
14803
14575
12045
13176
12767
15054
13080
13044
11972
13109
13861
14769
13277
15199
14431
12831
15478
13270
14112
12872
13073
13188
15563
12918
12215
14007
15053
12426
14719
13164
12530
15587
12706
15320
12583
14002
14162
12596
13316
14351
12296
13554
15232
14837
14320
13291
14847
12272
13262
14979
12675
12730
13998
14218
12967
12772
13673
14216
14318
15337
14577
12677
13566
14676
14593
14562
14554
12009
11928
13909
15351
13400
14211
15213
11921
13509
13636
14255
14392
13159
11968
12446
12822
15587
12791
12426
11963
13813
12679
12279
14996
13016
14839
15192
13747
13385
14810
12053
15517
14247
14307
15263
15591
15313
12959
11953
13360
12841
11974
12695
14794
13186
12338
14239
14099
12501
13941
15575
15567
12554
15078
13296
12730
13369
12592
12881
13829
12777
14007
12517
13388
15231
12179
12146
15246
13630
13741
15538
14295
14563
13322
13891
13016
13847
15236
13954
14090
12485
12190
13103
14920
13829
12475
14176
14120
13802
12085
12860
13189
12099
14423
12794
14466
15036
12870
13412
13853
15258
14381
13944
14163
13033
14164
15518
15523
13906
15501
12544
14148
14515
14359
12889
12722
14807
14994
11821
12944
13935
13608
12668
14531
11820
12193
15148
13330