Design Of Experiments

Objectives: 

- Complete a full and fractional data analysis on a case study.

(Skills from this blog: Ranking of factors based on significance, Identifying presence of Interaction between factors, Drawing Conclusions from graphical analysis)
---------------------------------------------------------------------------------------------------------------

As the CEO of the group, I will be doing Case Study 1. 

Scenario and Data - Case Study 1:



We are blessed that our lecturers made a template for the DOE for us and all we have to do is just input in the necessary values. However in this case as the table above shows a different configuration of runs and the levels for each run compared to what is found in the template our lecturers made for us it means that either I modify the template or make my own excel sheet. I decided that it would be easier to make my own even though I am not as proficient in excel and that I would not be able to use shortcuts like inputting in formulas however it means that i would be less confused and get the job done!

---------------------------------------------------------------------------------------------------------------




---------------------------------------------------------------------------------------------------------------
Steps taken to perform the FULL factorial design data analysis:

1) Firstly, with the data provided, I calculated the significance of each factor on the bullets remained by calculating the mean of each factor on its low and high levels, as shown below:

Figure 1

2) Plot a graph using the mean values of each factors to find out the significance of a factor on the bullets remaining, by comparing the gradient of the lines plotted.

What does it mean to compare the gradient of the lines plotted?                                                                                                       -> A steeper gradient indicates that the factor is more significant in affecting the remaining bullets as the change between the high and low levels are greater while the other factors remain constant.

Figure 2

From the graph above, the effect of every Factor can be determined as well as the rankings of the significance of the factors can be identified.


4) Make conclusion on the effect of Factors 

When A (Bowl Diameter) increases from 10cm to 15cm, the bullets remaining decreases from 1.48g to 1.43g.

When B (Microwaving Time) increases from 4 minutes to 6 minutes, the bullets remaining decreases from 2.00g to 0.90g.

When C (Power) increases from 75% to 100%, the bullets remaining decreases from 2.35g to 0.55g.


5) Rank the significance of the factors

Most Significant: C (Power)

Significant: B (Microwaving Time)

Least Significant: A (Bowl Diameter)


6) Explanation

As mentioned earlier, The way I analysed the results were based on the Calculations in the Full Factorial Excel, (See figure 1) I plotted the average values of the grams of bullets remaining for every High and Low factor into line graphs (See figure 2) and compared their gradients.

The difference between the average values of the grams of bullets remaining for every High and Low level of each factor shows the effect of the factor on the grams of bullets remaining which is also reflected by the slope of the graphs for each factor (Figure 2). I.e. If the difference between the average value of the grams of bullets remaining during the High level of a factor and the average value of the grams of bullets remaining during the Low level of a factor is large i.e. hence a steeper gradient for that factor’s graph, it can be deduced that the factor has a significant impact on the grams of bullets remaining.

Hence, based on Figure 1, the difference (effect) between the average value for the grams of bullets remaining at low Power and high Power is the largest -> [1.80 absolute value]. This can be seen also when the gradient of the graph for the grams of bullets remaining based on varying levels of Power (grey graph in Figure 2) is the steepest. Therefore, Power i.e. Factor C has the most significant impact on the grams of bullets remaining. When C (Power) increases from 75% to 100%, the bullets remaining decreases from 2.35g to 0.55g.

Followed by Microwaving time which has a lower impact than Power but more significant impact than Bowl Diameter which has the least significant impact on the grams of bullets remaining. This can be concluded because from Figure 1 the difference (effect) between the average value for the grams of bullets remaining at low level and high level Microwaving time is [1.10 absolute value], higher than that of the effect of the Bowl Diameter on the grams of bullets remaining [0.05 absolute value] but lesser than that of the Power’s effect. The gradient of the graph for the grams of bullets remaining based on varying levels of Microwaving time (orange graph in Figure 2) is more steeper than that of the Bowl Diameter graph but less steep compared to the Power graph. When B (Microwaving Time) increases from 4 minutes to 6 minutes, the bullets remaining decreases from 2.00g to 0.90g. When A (Bowl Diameter) increases from 10cm to 15cm, the bullets remaining decreases from 1.48g to 1.43g.

7) Determine the interaction effects of the factors 

Summary:

(A) First, determine the effect of AxB by:

From the table above, the average of low A and high A, for both high B and low B,  is calculated from which the total effects of the factor can be determined. Hence, a graph can be plotted to find out if there is any interaction between A & B by comparing the gradients of the 2 lines plotted.


Conclusion from Graph: 

The gradients of the 2 lines are of different signs (one is positive -> sloping upwards while the other is negative -> sloping downwards). Hence, there is significant interaction between A and B.

To determine the effect of AxC and BxC repeat step 7A.

(B) Determine the effect of AxC



Conclusion from graph:

The gradient of the 2 lines are different minimally i.e. only by a small margin this can be seen because the gradient of the blue - At Low C line is 0 since it is horizontal while the gradient of the orange - At High C line is barely a small negative value. Hence, there is a little interaction between factors A and C.

(C) Determine the effect of BxC



Conclusion from the graph:

Gradient of the 2 lines are both negative and are clearly distinct, as compared to the graph for A x C. Hence, there is a significant interaction between B and C.


8) Full Factorial Conclusion

In conclusion, Factor C :Power is the most significant factor affecting the number of bullets remaining followed by Factor B: Microwaving Time then Factor A :Bowl Diameter, the least significant. The similarity being all 3 factors were effective in reducing the bullets remaining when their levels increased from low to high although the extent of effectiveness differs across. In terms of interactions between the factors, there are significant interactions for B x C and A x B, while there is very little interaction for A x C.


---------------------------------------------------------------------------------------------------------------
Steps taken to perform the FRACTIONAL factorial design data analysis:

1) Select 50% of the number of runs done for full factorial 

In this case, the fractional factorial is done by reducing the number of runs used from 8 to 4. With the data, then determine the most significant factor.

Below shows the 4 runs I have selected to ensure that the design is balanced and it will achieve statistical orthogonality. Thus, yielding good statistical properties and results. 

Figure 1
(Highlighted in blue are the ones chosen i.e. run order 1,2,3,6)

2) After identifying the 4 runs, calculate the average values as shown below

Figure 2


3) Plot a graph using the mean values 

This is to determine the significance of a factor on the bullets remaining, by comparing the gradient of the lines plotted. A steeper gradient indicates that the factor is more significant in affecting the remaining bullets as the change between the high and low levels are greater while the other factors remain constant.

Figure 3


4) Conclude the effect of every factor from the graph


When A (Bowl Diameter) increases from 10cm to 15cm, the bullets remaining increases from 1.15g to 1.90g.

When B (Microwaving Time) increases from 4 minutes to 6 minutes, the bullets remaining decreases from 2.10g to 0.95g.

When C (Power) increases from 75% to 100%, the bullets remaining decreases from 2.55g to 0.5g.


5) Conclude the ranking of the factors from the graph


Most Significant: C (Power)

Significant: B (Microwaving Time)

Least Significant: A (Bowl Diameter)


Explanation:

The way I analysed the results was the same as how I did for FULL factorial except that now, I had to modify the Full Factorial Excel to ensure it is applicable for a Fractional Factorial Excel i.e. I deleted the 4 runs I wasn’t doing such that only the 4 runs I selected from Task 1 were being examined -> Run 1, 2,3, 6. For the Calculation formulas I changed the average of 4 to 2 since now there would only be 2 runs for each level of every factor i.e. 2 runs for when the factor is at a high level and similarly for when the factor is at a low.

Based on the Calculations in the Excel, (See figure 2) I plotted the average values of the time taken for dissolution to happen for every High and Low factor into line graphs (See figure 3) and compared their gradients.

The difference between the average values of the grams of bullets remaining for every High and Low level of each factor shows the effect of the factor on the grams of bullets remaining which is also reflected by the slope of the graphs for each factor (Figure 3).

Hence, based on Figure 2 and Figure 3, the difference (effect) between the average value for the grams of bullets remaining at low level temperature and high level Power is the largest -> [2.05 absolute value]. This can be seen also when the gradient of the graph for the grams of bullets remaining based on varying levels of Power (Grey graph in Figure 3) is the steepest. Therefore, Power i.e. Factor C has the most significant impact on the grams of bullets remainingWhen C (Power) increases from 75% to 100%, the bullets remaining decreases from 2.55g to 0.5g.

Followed by Microwaving time which has a lower impact than Power but more significant impact than Bowl Diameter which has the least significant impact on the grams of bullets remaining. This can be concluded because from Figure 3 the difference (effect) between the average value for the grams of bullets remaining at low and high level Microwaving time is [1.15 absolute value], higher than that of the effect of the Bowl Diameter on the grams of bullets remaining [0.75 absolute value] but lesser than that of the Power’s effect. The gradient of the graph for the time taken for grams of bullets remaining based on varying levels of Microwaving time (orange graph in Figure 3) is more steeper than that of the Bowl Diameter graph but less steep compared to the Power graph. When A (Bowl Diameter) increases from 10cm to 15cm, the bullets remaining increases from 1.15g to 1.90g. When B (Microwaving Time) increases from 4 minutes to 6 minutes, the bullets remaining decreases from 2.10g to 0.95g.


6) Fractional Factorial Analysis Conclusion

In conclusion, the most significant factor remains to be C (Power) as it has the steepest gradient, indicating the most change in Bullets remaining when level is adjusted from low to high, followed by B (Microwaving Time), then A (Bowl Diameter) least significant. However, an observation made is that there is a change in gradient for A. Initially, gradient of A was of a very small negative value. Then, it became positive slope.

---------------------------------------------------------------------------------------------------------------

Overall Conclusion

Comparing the full factorial design and fractional factorial design, there isn't much difference as the results remained relatively similar.




Comments

Popular Posts