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 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 word in the claim when writing the conclusion. Show all your work please (equations, calculations) . data for excel:
Question 1 Emails
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 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
word in the claim when writing the conclusion.
Show all your work please (equations, calculations) .
data for excel:
| 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 |
Step by step
Solved in 2 steps with 1 images
