The production manager at Cape Marine Engines is investigating a new process which makes a 36-inch...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The production manager at Cape Marine Engines is investigating a new process which makes a 36-inch shaft used in outboard motors. Since this is a new process, she wants to get descriptive statistics that can be used in later studies to determine the capability of the process to perform within specification limits. 100 shafts taken from the process were measured (See the information in the table below). a) Determine the mean, median, mode, variance, standard deviation, skewness and kurtosis, etc. of distribution for the process, based on the Data Analysis add-ins in Excel. (8) b) Plot a histogram of the data. (18.5) Note: Show the table of cell intervals and frequencies. Set up your "bins" or cell intervals of 0.2 units; starting with the smallest cell interval of 35.05- 35.25 units, 35.25-35.45 units, until all the recorded data is contained. c) What conclusions can you draw from the analysis of the data? 36.17 36.83 36.25 35.89 35.45 35.72 36.03 35.96 36.11 36.26 35.58 35.77 37.08 36.22 35.44 35.28 35.70 36.65 35.41 35.32 36.20 36.21 35.80 36.46 36.40 36.21 36.11 36.27 36.18 35.23 36.56 35.75 36.43 35.89 35.91 35.59 35.64 36.19 36.55 36.05 35.94 36.68 35.09 36.78 35.63 35.20 35.92 36.13 35.42 36.60 35.39 36.15 35.51 36.34 36.05 35.48 36.32 36.49 36.16 36.12 35.98 35.87 36.00 35.70 36.11 36.46 36.04 36.30 35.78 36.36 36.29 35.65 36.44 36.40 36.62 35.91 35.75 35.72 36.50 36.50 36.14 36.07 36.56 35.43 36.10 36.49 36.15 35.78 36.77 35.81 35.81 36.43 35.87 35.46 35.91 36.54 36.15 35.91 35.61 36.73 QUESTION 3 (151 GA1 (15 Analyse evaluate & select solution) (4) The production manager at Cape Marine Engines is investigating a new process which makes a 36-inch shaft used in outboard motors. Since this is a new process, she wants to get descriptive statistics that can be used in later studies to determine the capability of the process to perform within specification limits. 100 shafts taken from the process were measured (See the information in the table below). a) Determine the mean, median, mode, variance, standard deviation, skewness and kurtosis, etc. of distribution for the process, based on the Data Analysis add-ins in Excel. (8) b) Plot a histogram of the data. (18.5) Note: Show the table of cell intervals and frequencies. Set up your "bins" or cell intervals of 0.2 units; starting with the smallest cell interval of 35.05- 35.25 units, 35.25-35.45 units, until all the recorded data is contained. c) What conclusions can you draw from the analysis of the data? 36.17 36.83 36.25 35.89 35.45 35.72 36.03 35.96 36.11 36.26 35.58 35.77 37.08 36.22 35.44 35.28 35.70 36.65 35.41 35.32 36.20 36.21 35.80 36.46 36.40 36.21 36.11 36.27 36.18 35.23 36.56 35.75 36.43 35.89 35.91 35.59 35.64 36.19 36.55 36.05 35.94 36.68 35.09 36.78 35.63 35.20 35.92 36.13 35.42 36.60 35.39 36.15 35.51 36.34 36.05 35.48 36.32 36.49 36.16 36.12 35.98 35.87 36.00 35.70 36.11 36.46 36.04 36.30 35.78 36.36 36.29 35.65 36.44 36.40 36.62 35.91 35.75 35.72 36.50 36.50 36.14 36.07 36.56 35.43 36.10 36.49 36.15 35.78 36.77 35.81 35.81 36.43 35.87 35.46 35.91 36.54 36.15 35.91 35.61 36.73 QUESTION 3 (151 GA1 (15 Analyse evaluate & select solution) (4)
Expert Answer:
Answer rating: 100% (QA)
Im unable to directly process images or execute software functions such as those provided by the Data Analysis addin in Excel However I can guide you ... View the full answer
Related Book For
Fundamentals of Cost Accounting
ISBN: 978-0077398194
3rd Edition
Authors: William Lanen, Shannon Anderson, Michael Maher
Posted Date:
Students also viewed these general management questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
You recently graduated from college, and your job search led you to East Coast Yachts. Since you felt the companys business was seaworthy, you accepted a job offer. The first day on the job, while...
-
P (A) = 0.10, P (B | A) = 0.39, and P(B | A) = 0.39. Find the following: P(A ), P(B | A), P (B |A ), P (B), P (B ), P (A | B), P (A | B), P (A | B), P (A | B )
-
A farad is a very large unit of capacitance. Calculate the length of one side of a square, air-filled capacitor that has a capacitance of 1 F and a plate separation of 1 m.
-
A certain commercial mass spectrometer (see Sample Problem 28-3) is used to separate uranium ions of mass 3.92 x 10-25 kg and charge 3.20 x 10-19 C from related species. The ions are accelerated...
-
Some corporate executives have reportedly attempted to manage their firms operating revenues through such actions as front-end loading or rear-end loading of operating revenues. Explain the concepts...
-
Jones, wishing to retire from a business enterprise that he had been conducting for a number of years, sold all of the assets of the business to Jackson Corp. Included in the assets were a number of...
-
Que. 4 From the following details you are require to make an assessment of the average amount of working capital requirement of Hindustan Ltd. Particulars Av. Period of Credit Purchase of Materials 6...
-
The phone at Mermans Costume Rentals rings, and Annie Oaklea, head of costume inventory, picks it up and answers a query by saying, Let me take a look at my inventory cards. Sorry, it looks as if...
-
Please link the article you used (Will upvote if article is published in 2021) Prepare an analysis of a current (published after 1 January 2021) Australian newspaper/media article. ( pick an article...
-
A boy throws a 0.19 kg stone into a river from a 15.0 m high bridge. If the initial speed of the stones is 12.0 m / s vertical downward, what is the stone kinetic energy and momentum of the stone as...
-
Blossom Company's income statement for the year ended December 31, 2025, contained the following condensed information. Service revenue $848,000 Operating expenses (excluding depreciation) $618,000...
-
7. Calculate the equivalent and total resistance as well as the current in the circuit. Calculate the current and voltage drop across each individual resistor (6 marks) 6.0 V V V = 6.0 V = 6.0 V R =...
-
Taylor suffered a ruptured disc during an automobile accident. On October 26, 1994, he underwent surgery at Louisiana State University Medical Center (LSUMC). After surgery, Taylor began to...
-
A person is driving along a straight highway at a speed of 2 2 . 0 m / s when the traffic light which is 4 0 . 0 m ahead turns yellow. Because of his \"reaction time\", there is a delay of 0 . 1 2 s...
-
Esfandairi Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.31 million. The fixed asset will be depreciated straight- line to zero...
-
Which provision could best be justified as encouraging small business? a. Ordinary loss allowed on $ 1244 stuck. b. Percentage depletion. c. Domestic production activates deductions. d. Interest...
-
Refer to Problem 9-46. Jean Sharpe decides to gather additional data to identify the cause of overhead costs and figure out which products are most profitable. She notices that $30,000 of the...
-
The following T-accounts represent November activity. Additional Data Materials of $113,600 were purchased during the month, and the balance in the Materials Inventory account increased by $11,000. ...
-
Sanjana's Sweet Shoppe operates on the boardwalk of a New England coastal town. The store only opens for the summer season and the business is heavily dependent on the weather and the economy in...
-
Presented below are summary financial data from the General Electric Company 2015 annual report. Using the ratio definitions from Exhibit 4.6, calculate the following liquidity and solvency ratios:...
-
Presented below are summary financial data from the The Coca-Cola Company 2015 annual report. Using the ratio definitions from Exhibit 4.6, calculate the following liquidity and solvency ratios: cash...
-
Presented below are summary financial data from The Boeing Company 2015 annual report. Using the ratio definitions from Exhibit 4.6, calculate the following liquidity and solvency ratios: cash and...
Study smarter with the SolutionInn App