For the latest version of Excel... The File -> Options is no longer applicable. Click on Tools -> Excel Add-Ins -> and check Analysis ToolPak. This will provide the Data Analysis option.
Nice one sir. Pls can you help me solve these questions; 1a) Show explicitly one experimental unit you would use in the determination of air quality in a hostel room housing ten occupants. (b) If the hostel block had five floors and 200 rooms define two blocking variables you would consider in an air quality assessment. (c) What two responses would you measure in question 1b above. (2) During assessment of level of active ingredient in ampicillin capsules in a batch imported through a port, both spectrophotometric and titrimetric methods were used: i.) Write one experimental objective expressing comparison of treatment effect. ii.) Write another objective reflecting the estimation of parameters involved in the delivery of ethical ampicillin capsules. b.) What statistical model would you use to test your objective in 2a(i) above. 3a.) Why is the method and type of statistical analysis of an experimental objective a primary concern in interpretation of experimental results? b.) In an experiment to determine the optimum inhibitor concentration for a protective paint formula, suggest an expression relating metal corrosion to, inhibitor concentration, level of metal impurity and type of inhibitor vehicle. c.) Define the experimental units you will use to justify your expression in 3b above. 4a) What is the scope in a project topic of factorial design when three objectives are identified. Each objective has four factors at three levels. Assume that each experimental unit will replicate four times. b.) If the cost to perform each observational unit in 4a above is two thousand naira (#2,000), what is the total cost of performing the experimental part of the project. c.) In a completely randomized design factorial experiment, each factor has four levels with each level replicate over eight experimental units. If for statistical analysis each experimental unit has four observational units, how many runs in all will there be. 5a) State two variables you would expect in the determination of pollution in a stream located near a landfill used to dispose municipal waste. b.) Write two objectives which can be used to track the effect of run off from an abattoir waste area into a neighbouring stream. c.) Define two hypothesis which can be tested by the TV distribution for each objective in question 5b above. Use a one sided 0.025 significant level. Please help me solve the above questions ASAP. Thank you sir. You can also reach me @ samuelnwobodo@gmail.com
Dear Bhartendra this is a great video and very well explained in simple language. Please keep making such videos. Please make the video for augmented and alpha lattice design. Thank you.
Sir, as a statistics expert, could you please make a video about the repeat measure ANOVA with two or three factors. Some of the suggested packages could be rstatix, car and base R.
Out of curiousity, where did you get the value for the between groups sum of squares? I don't see any actual equation for it in the excel document? I don't see any equations on your excel sheet actually.
Degrees of freedom is number of independent terms in a equation. For example if x + y + z = 10, and if x=1 and y = 5, then z doesn't have freedom to be any number because we must have z=4. So with 3 unknowns x, y, and z the degrees of freedom is only 2 because only two out of x, y & z have freedom to be any value. Third one totally depends on whatever values other two take.
If F-ratio is greater than FCritical for a variable, that variable is considered statistically significant. Otherwise that variable is not statistically significant and doesn't have much impact on the response.
Most statistics books have f table towards the end of the book. You can use that. However, if you are doing it in Excel as shown in the video, you don't really need it.
I have no words to explain how important your contribution really is. Thankyou Sir
You are very welcome!
This is a another master piece from you. You explain things very easily and interestingly.
Great Tutorial, Thanks for taking the time to prepare this video, you save me a week of reading
Thanks for the feedback!
I must say, it's excellent
Thanks for comments!
Thanks, easy to understand explanation...
You are welcome!
Great explanation of how to use ANOVA. Thank you!
Thanks for comments!
Excellent video! You really made things very simple to understand.
Thanks for comments!
WOW, I did not know ANOVA could be done with Excel! I have tried SPSS... thank you for this video.
Very nice explanation with simplicity in transferring knowledge
Thanks for comments!
Great Tutorial for taking preparation please add more like this
You can try this link for more:
czcams.com/play/PL34t5iLfZddt6PPFUOTvOV3yvaRTM6VVs.html
Thank you very much for this video
You are welcome!
Very helpful video! Thanks for uploading!!
Glad it was helpful!
Well explained thanks
You are welcome!
For the latest version of Excel... The File -> Options is no longer applicable.
Click on Tools -> Excel Add-Ins -> and check Analysis ToolPak. This will provide the Data Analysis option.
Thanks for the update!
thank you so much Sir.. you've been of great help.. appreciate it....
Thanks for comments!
very nice introduction for DOE. Thank you.
If you have more DOE video for pharmaceutical product development, kindly post it.
Thanks for the feedback, I'll keep it in mind for future.
Thanks Mr. Rai for the information given, very helpful and well explained..
Nice one sir.
Pls can you help me solve these questions;
1a) Show explicitly one experimental unit you would use in the determination of air quality in a hostel room housing ten occupants.
(b) If the hostel block had five floors and 200 rooms define two blocking variables you would consider in an air quality assessment.
(c) What two responses would you measure in question 1b above.
(2) During assessment of level of active ingredient in ampicillin capsules in a batch imported through a port, both spectrophotometric and titrimetric methods were used:
i.) Write one experimental objective expressing comparison of treatment effect.
ii.) Write another objective reflecting the estimation of parameters involved in the delivery of ethical ampicillin capsules.
b.) What statistical model would you use to test your objective in 2a(i) above.
3a.) Why is the method and type of statistical analysis of an experimental objective a primary concern in interpretation of experimental results?
b.) In an experiment to determine the optimum inhibitor concentration for a protective paint formula, suggest an expression relating metal corrosion to, inhibitor concentration, level of metal impurity and type of inhibitor vehicle.
c.) Define the experimental units you will use to justify your expression in 3b above.
4a) What is the scope in a project topic of factorial design when three objectives are identified. Each objective has four factors at three levels. Assume that each experimental unit will replicate four times.
b.) If the cost to perform each observational unit in 4a above is two thousand naira (#2,000), what is the total cost of performing the experimental part of the project.
c.) In a completely randomized design factorial experiment, each factor has four levels with each level replicate over eight experimental units. If for statistical analysis each experimental unit has four observational units, how many runs in all will there be.
5a) State two variables you would expect in the determination of pollution in a stream located near a landfill used to dispose municipal waste.
b.) Write two objectives which can be used to track the effect of run off from an abattoir waste area into a neighbouring stream.
c.) Define two hypothesis which can be tested by the TV distribution for each objective in question 5b above. Use a one sided 0.025 significant level.
Please help me solve the above questions ASAP.
Thank you sir.
You can also reach me @
samuelnwobodo@gmail.com
Unfortunately preoccupied with several important stuff, I'll have some time in later half of May.
@@bkrai OK sir.
What is the name of your textbook?
Very useful and well explained. Thanks Mr Rai for sharing this
GREAT TUTORIAL DESIGN EXPERIMENTAL DESIGN AND KEEP GOING FORWARD GREAT MAN.
Thanks for the feedback!
Dear Bhartendra this is a great video and very well explained in simple language. Please keep making such videos. Please make the video for augmented and alpha lattice design. Thank you.
nice
Thanks!
Great job thanks a lot
You are very Welcome!
Thank you so much. This tutorial helped me so much for the final
Thanks for for feedback!
I wonder if you have any tutorial about regression model
You can try following:
czcams.com/video/iXviEYy_DGg/video.html
czcams.com/play/PL34t5iLfZddtKNwFNic3HWNV2qMsQ9AjD.html
Thanks doc for sharing us your knowledge ..........does this types of data analysis used for variety trial? if yes how? methods of data arrangement
The factors could be from any field as shown using different examples. You can setup the problem similarly and use the method.
Excellent
thx
Very Helpful
Thanks for comments!
Sir, as a statistics expert, could you please make a video about the repeat measure ANOVA with two or three factors. Some of the suggested packages could be rstatix, car and base R.
Out of curiousity, where did you get the value for the between groups sum of squares? I don't see any actual equation for it in the excel document? I don't see any equations on your excel sheet actually.
Nevermind, I found the Data Analysis Button. Its kind of depressing I was hoping to actually understand how this was found
Thanks for the update!
Great video sir ,can you make video on response surface methodology (RSM)
Thanks for the suggestion, I've added it to my list.
very good tutorial... Thank you Sir. By any chance do you conduct virtual online classes?
Thanks for comments! Regarding virtual classes, I'll announce it in advance when I plan one.
@@bkrai Thank you sir. I will look fwd. vinayak.shanbhag@gmail.com
thanks sir for such a nice informative lecture...
+Ankit Kumar Thanks for your feedback 👍
Thank you Sir, very useful
Thanks for feedback!
Excellent. Very helpful
+Karim Suleman thanks for the feedback 👍
Thank you
Welcome!
What exactly is use of degree of freedom or meaning of dof and level of significance
Degrees of freedom is number of independent terms in a equation. For example if x + y + z = 10, and if x=1 and y = 5, then z doesn't have freedom to be any number because we must have z=4. So with 3 unknowns x, y, and z the degrees of freedom is only 2 because only two out of x, y & z have freedom to be any value. Third one totally depends on whatever values other two take.
why are we substracting 1 for degree of freedom?
You can refer to this where n-1 is used in standard deviation:
czcams.com/video/TQXlVa6iMsk/video.html
very nice!!
great tutorial. thank you!
+Shailendra Naithani good to hear your feedback 👍
Thanks for the video. Sir, what it the use of FCritical in the last column?
If F-ratio is greater than FCritical for a variable, that variable is considered statistically significant. Otherwise that variable is not statistically significant and doesn't have much impact on the response.
Sir is there any video available on full factorial design
The examples in this video are full factorial.
A shortcut to what F-value ?
Which point in the video are you referring to?
@@bkrai in ANOVA table
How can we get p-value
p-value column is available in the ANOVA table.
will you please refer a text containing more examples ? thanks
Here is one book that you may use:
www.amazon.com/Business-Statistics-Contemporary-Decision-Making/dp/1118024117
Wawwwwwwe
Thanks!
too many ads :(
Yes, I too don't like too many ads. They should do limited ones.
How to find f tabulated value
Most statistics books have f table towards the end of the book. You can use that. However, if you are doing it in Excel as shown in the video, you don't really need it.
Yours voice is too low
Thanks for the feedback!
Hindi me
will try