Sample hypothesis test

Sample hypothesis test

there are 3 parts in the presentation which is you need to do 1 sample hypothesis test (1SHT ) using an excel file, you need to do this test for the 3 parts, i will attach a word document file with the 3 part. Also, I will attach the excel file that have a formal will help you to do the three parts
when you complete each sample test, make sure you save it in different sheet in excel as labeled in excel for each part. and send me the excel file along with the presentation. then print-screen for each test include in power point slide.

Part 1:
It looks like women outperform in terms of their rate of service (what reference value is appropriate?). Prepare a visual to assist you with a 1SHT for the proportion to evaluate this claim.( http://web.wilkes.edu/jennifer.edmonds/BA_319/volunteers2010.xls )

Part 2:
In the Northeast, 10.9 million volunteers contributed 1.4 billion hours of service in 2010How does the Northeast compare to the nation? Show supporting visuals and prepare a 1SHT for the proportion to supplement your discussion.

Part 3:
2,701,950 Pennsylvania residents volunteered 398.7 million hours of service through or for a nonprofit or community organization in 2010. How does Pennsylvania compare to the nation? Show supporting visuals and prepare a 1SHT for the proportion to supplement your discussion.