 |
Analysis of Data from Designed Experiments |
 |
|
Tests of Significance Based on T - Distribution |
<<Back
Analysis Using MS-EXCEL
- Once the data entry is complete, Choose Tools from the Menu Bar. Now select Tools → Data Analysis…
- In the Data Analysis dialog box select t-Test: Two-Sample Assuming Equal Variance. This selection displays the following screen.
- Click OK. This displays the dialog box for the analysis of t-Test: Two-Sample Assuming Equal Variance.
- For the two groups select the variable Total number of male flowers per plant and select the range for Variable 1 Range: and Variable 2 Range: in the Input box. Now select Output Range: to get the output. This displays the following screen.
- Click OK to get the output at the selected output range.
- Similarly one can perform the analysis for the other variables also.
- For the analysis of t-Test: Two-Sample Assuming Unequal Variances, in the Data Analysis dialog box select t-Test: Two-Sample Assuming Equal Variance.
- For the two groups select the variable Total number of male flowers per plant and select the range for Variable 1 Range: and Variable 2 Range: in the Input box. Now select Output Range:to get the output. This displays the following screen
· Click OK to get the output at the selected output range.
· Similarly one can perform the analysis for the other variables also.
Analysis Using SAS Analysis Using SPSS Analysis Using MS-EXCEL
Home Descriptive Statistics Tests of Significance Correlation and Regression Completely Randomised Design RCB Design
Incomplete Block Design Resolvable Block Design Augmented Design Latin Square Design Factorial RCB Design
Partially Confounded Design Factorial Experiment with Extra Treatments Split Plot Design Strip Plot Design
Response Surface Design Cross Over Design Analysis of Covariance Diagnostics and Remedial Measures
Principal Component Analysis Cluster Analysis Groups of Experiments Non-Linear Models
Copyright Disclaimer How to Quote this page Report Error Comments/suggestions
(Under Development)
For
exposure on SAS, SPSS,
MINITAB, SYSTAT and
MS-EXCEL
for analysis of data from designed experiments:
Please see Module I of Electronic Book II: Advances in Data Analytical Techniques
available at Design Resource Server (www.iasri.res.in/design)