In: Math
Two Way ANOVA
A mechanical engineer is studying the thrust force developed by a drill press. He suspects that the drilling speed and the feed rate of the material are the most important factors. He selects four feed rates and uses a high and low drill speed chosen to represent the extreme operating conditions. He obtains the following results.
| 
 (A)  | 
 Feed  | 
 Rate (B)  | 
||
| 
 Drill Speed  | 
 0.015  | 
 0.030  | 
 0.045  | 
 0.060  | 
| 
 125  | 
 2.70  | 
 2.45  | 
 2.60  | 
 2.75  | 
| 
 2.78  | 
 2.49  | 
 2.72  | 
 2.86  | 
|
| 
 200  | 
 2.83  | 
 2.85  | 
 2.86  | 
 2.94  | 
| 
 2.86  | 
 2.80  | 
 2.87  | 
 2.88  | 
Analyze the data (TWO WAY ANOVA) and draw conclusions. Use a = 0.05.
DO HYPOTHESIS TESTING and show steps how to insert data into EXCEL.