Chapter 5 Problem 084: Kindly fill up the required amounts in the Table on Wiley Plus and for the Blackboard submittal, kindly enter the data for this problem into EXCEL,

follow the required steps listed in the web sites given to you on my Power Point Lecture presentation for Two factor without Replication ( Block Design), Obtain the Output from EXCEL, Type on the top of the page your Name and problem No and use the EXCEL output to perform the followings 2- TESTS: Test 1- A Hypothesis test with the required 5 steps (similar to the handout) to answer the question: Is there any difference in the effects of the four different types of tips in a hardness tester on the observed hardness of a metal? Use a = 0.05 and use ONLY the Standard Rejection Rule for this type of test and provide the required PLOT.Test 2- A Hypothesis test with the required 5 steps (similar to the handout) to answer the question: Is there any difference in the effects of the four different types of tips in a hardness tester on the observed hardness of a metal? Use a = 0.05 and use ONLY the P-value as a rejection Rule for this type of test and provide the required PLOT.