Please see the attached file.
Sixty-four students in an introductory college economics class were asked how many credits they had earned in college, and how certain they were about their choice of major.
Step by step method for testing the hypothesis under 5 step approach is discussed here. Excel template for each problem is also included. This template can be used to obtain the answers of similar problems.