Please help me so I can complete the following:
Perform hypothesis testing on one variable's data. (Choose either the intrinsic or extrinsic column.) Perform a t-test by formulating a null and an alternative statement, choosing an acceptable significance value, determining the appropriate critical value, selecting the test statistic and determining its value from the sample data, comparing the observed value to the critical value obtained and determining whether to reject or fail to reject the null hypothesis.
I would like to test a claim that American workers have an overall job satisfaction mean level of 5.0
Compute mean, median, mode for a set of data.
Formulate null and alternative hypotheses for applications involving a single population mean, proportion, or variance.
Use effective communication techniques
This solution conducts a hypothesis test on survey results of American workers and job satisfaction. A null and alternative hypothesis are created and tested by comparing the test statistics from a t-test to a p-value, where then a conclusion is made. All calculations are shown in an Excel file.