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 satellite describes an elliptic orbit about a planet of mass M. Denoting by r0 and r1 , respectively, the minimum and maximum values of the distance r from the satellite to the center of the...
-
A sample of size n = 32 is drawn from a population whose standard deviation is = 12.1. a. Find the margin of error for a 99% confidence interval for . b. If the confidence level were 90%, would the...
-
In a set of 12 matched pairs, the mean difference was d = 18 and the standard deviation of the differences was sd = 4. Find the value of the test statistic for testing H0: d = 15 versus H1: d > 15....
-
Sanlucas, Inc., provides home inspection services to its clients. The following is the company's trial balance dated June 1, current year. Sanlucas engaged in the following transactions in June. June...
-
7 7 Retirement of common shares, S Comparative Statements of Shareholders' Equity for Locke Intertechnology Corporation were reported as follows for the fiscal years ending December 31, 2022, 2023,...
-
A parent company acquired 70% of the stock of a subsidiary company on January 1, 2017, for $610,000. On this date, the balances of the subsidiarys stockholders equity accounts were Common Stock,...
-
a. Write a function called rotateForward that accepts a list as a parameter and uses a list comprehension to move the last element of the list into the first position. i. rotateForward([1,2,3,4])...
-
When should RMA be addressed on a project?
-
What is a material weakness?
-
The open-loop transfer function of a unity feedback control system is given by: \[ G(s)=\frac{K}{s(1+\tau s)} \] (a) By what factor the gain be multiplied so that damping ratio is increased from 0.2...
-
Why are RMA addressed as a set?
-
Explain response time, settling time and delay time.
-
Find two use cases (Applications) of the priority queue and explain how the use cases (Applications) apply to the priority queue using Heap. explanation should include the following. * Operations...
-
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...
-
Derive the equations of motion of the system shown in Fig. 6.29 using Lagrange's equations. k k k3 k4 000 m 000 m2 000 m3 000 FIGURE 6.29 Spring-mass system.
-
When an airplane (see Fig. 6.37(a)) undergoes symmetric vibrations, the fuselage can be idealized as a concentrated central mass \(M_{0}\) and the wings can be modeled as rigid bars carrying end...
-
Use Lagrange's equations to derive the equations of motion of each of the systems shown in Figs. 6.20. 000 k Free -21- -31- Rigid bar, mass 2m A G T x(1) F(t) X3(1) F3(1) 5m x2(1) F(1) FIGURE 6.20...
Study smarter with the SolutionInn App