Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak Auditors must make judgments about various aspects of an audit on the basis of their own direct experience, indirect experience, or a combination of the two. In a study, auditors were asked to make judgments about the frequency of errors to be found in an audit. The judgments by the auditors were then compared to the actual results. The data are contained in the Excel Online file below.
| Direct | Indirect | Combination |
| 17.1 | 16.0 | 24.9 |
| 18.3 | 22.3 | 23.1 |
| 14.8 | 20.7 | 20.9 |
| 17.7 | 17.4 | 27.7 |
| 21.1 | 24.9 | 27.5 |
| 15.4 | 20.1 | 24.8 |
| 13.6 | 21.1 | 24.5 |
Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak
Auditors must make judgments about various aspects of an audit on the basis of their own direct experience, indirect experience, or a combination of the two. In a study, auditors were asked to make judgments about the frequency of errors to be found in an audit. The judgments by the auditors were then compared to the actual results. The data are contained in the Excel Online file below. Suppose the data were obtained from a similar study; lower scores indicate better judgments. Construct a spreadsheet to answer the following questions.
Use to test to see whether the basis for the judgment affects the quality of the judgment.
The F-value is (to 2 decimals) .
The exact P-value is (to 4 decimals) .
What is your conclusion?
There is
evidence to conclude that the mean number of errors in an audit is not the same for the different types of auditor experience.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images
