Solve the problem described below using Excel. In order to do the calculations, follow the Excel example on the next page (the Excel example is from a different problem). Include all your comments and the answer to part b (see below) on the same spreadsheet. Save the spreadsheet and upload it in Canvas.
Problem
A survey of nonprofit organizations showed the online fundraising has increased in the past year. Based on a random sample of 45 nonprofit organizations, the mean one-time donation in the past year was $68, with a standard deviation of $12.
- If you test the null hypothesis at the 0.01 level of significance, is there evidence that the mean one-time donation is greater than $60? (Hint: use the p-value approach for a right-tail test.)
- Interpret the meaning of the p-value in this problem.
