# Do some Excel Work, QUALITY ASSURANCE PROJECT ASSEMBLY LINE SAMPLING

I have done part 1 and 2 and need you to check them if they are correct. If so, want you to do part 3. Need the project done in 8 hours or less

Using the Matlab Simulink software, design an assembly line operation to produce cans with a mean of 13.5 oz and a variance of 0.5. The cans are going to be produced at a rate of 1 can per minute and the operation will run for a full 8 hour day. Each day, samples of size 5 are to be taken every hour. For example, the first sample will occur at time 60, 61, 62, 63, and 64 minutes. The second sample should occur at time 120, 121, 122, 123, 124 and so on. Repeat the sampling pattern for five days (a full week).

Note that by changing the seed value in the random number generator, a different set of normal random numbers are going to be generated and this will simulate a different production output for each day. To make it more credible, choose a different mean and a variance for each day along with a different seed number. Pick a mean value for each day that is different but must lie in the range

of 12 oz to 14 oz and pick a variance that will range from 0.5 to 0.75.

Part I) Transfer the output to an excel chart and label each sample properly (day and time collected). For every production day, construct statistical process controls (SPC) charts: a X-Bar, a R (Range) and a S- Charts. (Determine if the processes are within control). X-Bar measures the central tendencies of the data. R and S charts measures the tendencies to deviate from the mean.

Part 2) Perform an Analysis of Variance (ANOVA) on the five days of production. Use as representative sample for the entire day, the full 8 samples (@5 values each) = 40 values.

Using the full 40 values sampled for each day, determine the 95% confidence interval for the mean of the production for each day.

Part 3) Modify the existing Simulink model to simulate the production of chemical C in a chemical reactor. The reactor operates for eight hours each day and each hour, it is required to select three samples of the chemical (a minute apart). These samples are analyzed separately in the lab for the content of chemical C and the average value is obtained as the representative concentration of chemical C for that hour. The reactor company recognizes that the production of chemical C depends on pressure and temperature of the reactor but does not know exactly at what temperature and pressure the reactor should be set to maximize production of chemical C. In front of the reactor panel, assume that there are two buttons. One controls temperature and one controls pressure. The temperature setting has only two options: 80°C and 120°C. The pressure settings options are: 35 psia, 75 psia and 100 psia.

For simulation purposes, the past lab results have generated the following parameters:

T °C P (psia) Production Follows a Normal with

80 35 μ = 120 grams/cc σ= 10 grams/cc

80 75 μ = 100 grams/cc σ= 15 grams/cc

80 100 μ = 125 grams/cc σ= 12 grams/cc

120 35 μ = 135 grams/cc σ= 25 grams/cc

120 75 μ = 120 grams/cc σ= 5 grams/cc

120 100 μ = 125 grams/cc σ= 18grams/cc

For each scenario generate eight data concentration points (average of three samples is one data point) and perform a full factorial design to determine which factors are significant in the production of chemical C. Determine the predicted model for the production of chemical factor as a function of the significant values found. At what T and P should the reactor be set to maximize production of chemical C?

Write a formal report on this project and incorporate all three

( 9 comentários ) highland heights, Saudi Arabia

ID do Projeto: #6775731

## Concedido a:

karanrajput1112

As a Post Graduate in Statistics and graduate in mathematics, i have a lot of experience in handling statistical data, especially in Time Series Modelling & Forecasting, Regression analysis,correlation , ANOVA, statist Mais

\$33 USD em 1 dia
(2 Comentários)
1.0

## 14 freelancers estão ofertando em média \$36 para esse trabalho

muzammil21

A proposal has not yet been provided

\$24 USD em 1 dia
(34 Comentários)
5.3
gitapodder1989

I am a top ranking freelancer of statistics and mathematics in freelancer.com and excellent in both the subjects. I am M.Sc. in mathematics. I have done a lot of similar jobs before. Please, check employer's feedback o Mais

\$150 USD in 3 dias
(25 Comentários)
5.0
MasterExcel

I am Data Entry, MS Word and MS Excel Expert. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high Mais

\$24 USD em 1 dia
(12 Comentários)
3.2
hotline69

A proposal has not yet been provided

\$25 USD em 1 dia
(3 Comentários)
2.9
Gkiprop

Dear client, I am writing to apply for your job .I have a Bachelor of Science in Applied Statistics with computing and has the expertise in data analysis and statistics in general using SPPS ,R and R .I am competent ,s Mais

\$25 USD em 1 dia
(1 Comentário)
0.8
KamauWamara

A proposal has not yet been provided

\$55 USD em 1 dia
(0 Comentários)
0.0
amolsatdive

A proposal has not yet been provided

\$30 USD em 1 dia
(0 Comentários)
0.0
sambabrat

VERY FAST IT SPECIALIST. WHO IS WILLING TO COMPLETE WORK AS SOON AS POSSIBLE AND TO THE BEST OF YOUR SATISFACTION WHICH WILL PROMPT YOU TO GIVE ME MORE PROJECT BECAUSE I STRONGLY BELIEVE IN MYSELF TO COMPLETE ANY TASK Mais

\$25 USD em 1 dia
(0 Comentários)
0.0
erapei

A proposal has not yet been provided

\$15 USD em 1 dia
(0 Comentários)
0.0
ihello12

As a team we are always available for such jobs .We also have 24 hours internet service which always keep as online to help jobs goes on till we finish .we will be glad if you invite as to help you build your business Mais

\$25 USD em 1 dia
(0 Comentários)
0.0
roshansimt

Hello There, Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have mentioned to Read with all your requirement ,send your project work detail. Please give me a chance fo Mais

\$25 USD em 1 dia
(0 Comentários)
0.0
vikrant5676

As i have done projects like this earlier also! So I believe I can do it in the better way . I am well versed with spread sheets!

\$25 USD em 1 dia
(0 Comentários)
0.0
milroy17

A proposal has not yet been provided

\$25 USD em 1 dia
(0 Comentários)
0.0
evans1717

A proposal has not yet been provided

\$25 USD em 1 dia
(0 Comentários)
0.0