Question 1 Emails ( Show work on Excel and provide the formulas)

I swear I get so much junk email! I suspect 50% of my emails are junk emails. The results of selected 75 emails, classified as "work," "personal," or "junk," are found in the Excel sheet labeled Emails. Perform a z test for proportion to test my claim at 0.05 significance level.

Show your work on the Excel sheet labeled Emails, and provide your final answers on the yellow highlighted cells properly.

a)What is the value of the test statistic of this test? (Keep 4 or more decimal places)

b)What is the value of p-value of this test? (Keep 4 or more decimal places)

c)Based on your p-value, write the conclusion to answer my claim. Make sure to use the given the word in the claim when writing the conclusion.

d)Show your work.

Data: Types of Emails Junk Work Junk Work Work Work Work Work Work Work Junk Personal Personal Personal Personal Personal Work Work Work Work Junk Junk Junk Work Junk Personal Junk Personal Work Personal Personal Work Junk Work Work Junk Junk Junk Personal Junk Junk Junk Work Personal Junk Work Work Work Work Personal Work Personal Junk Work Junk Work Work Personal Personal Work Junk Work Junk Junk Junk Personal Personal Work Junk Personal Work Junk Work Work Junk