Question: please help The above Excel file has a table summarizing the annual donations for a church. The summary table shows different brackets of donations and
The above Excel file has a table summarizing the annual donations for a church. The summary table shows different brackets of donations and the number of church members who donated in each bracket. The summary table reports the donations of members with and without children in the parish school separately. Using this file, answer the following questions: Hint: Since the summary data given in brackets, use the midpoint of each bracket as its representative value. a) Estimate the total annual donations made by the church members without children in the parish school. Submit your answer using the drop-down menus given below. b) Estimate the mean of the annual donations made by the church members without children in the parish school. Submit your answer using the drop-down menus given below. c) Estimate the total annual donations made by the church members with children in the parish school. Submit your answer using the drop-down menus given below. d) Estimate the mean of the annual donations made by the church members with children in the parish school. Submit your answer using the drop-down menus given below. e) Estimate the standard deviation of the annual donations made by the church members without children in the parish school. Submit your answer using the drop-down menu given below
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
