-73%

[Top Answer] MATH225N – Week 7 Assignment Construct Hypothesis Test for Proportions – Excel

$6.99$26.00

Description

Week 7: Hypothesis

 

Week Assignments Due Date
Week 7 Graded Discussion Suggested Due Date—

Initial Post:  Wednesday of Week 7

 

Due Date—

Responses:  Sunday of Week 7 [Have two posts on two different days]

  Knewton Homework Assignments

Developing Hypothesis and Understanding Possible Conclusions for Proportions

Conduct a Hypothesis Test for Proportion – P-Value Approach

Conducting a Hypothesis Test for Mean – Population Standard Deviation Known P Value Approach

Construct Hypothesis Test for Proportions – Excel

Hypothesis Test for the Mean – Population Standard Deviation Known

Sunday of Week 7

—————-

Week 7 Assignment – Construct Hypothesis Test for Proportions – Excel

Activity 1

Question

Steve listens to his favorite streaming music service when he works out. He wonders whether the service’s algorithm does a good job of finding random songs that he will like more often than not. To test this, he listens to 50 songs chosen by the service at random and finds that he likes 32 of them.

Use Excel to test whether Steve will like a randomly selected song more often than not, and then draw a conclusion in the context of the problem. Use α=0.05.

Select the correct answer below:

  • Reject the null hypothesis. There is sufficient evidence to conclude that Steve will like a randomly selected song more often than not.
  • Reject the null hypothesis. There is insufficient evidence to conclude that Steve will like a randomly selected song more often than not.
  • Fail to reject the null hypothesis. There is sufficient evidence to conclude that Steve will like a randomly selected song more often than not.
  • Fail to reject the null hypothesis. There is insufficient evidence to conclude that Steve will like a randomly selected song more often than not.
Answer

Access the entire solutions for this week (top graded solutions) by clicking the ‘Buy’ button.

Activity 2

Question

A magazine regularly tested products and gave the reviews to its customers. In one of its reviews, it tested two types of batteries and claimed that the batteries from Company A outperformed the batteries from Company B. A representative from Company B asked for the exact data from the study. The author of the article told the representative from Company B that in 200 tests, a battery from Company A outperformed a battery from Company B in 108 of the tests. Company B decided to sue the magazine, claiming that the results were not significantly different from 50% and that the magazine was slandering its good name.

Use Excel to test whether the true proportion of times that Company A’s batteries outperformed Company B’s batteries is different from 0.5. Identify the p-value, rounding to three decimal places.

Provide your answer below:

Answer

Access the entire solutions for this week (top graded solutions) by clicking the ‘Buy’ button.

Activity 3

Question

A candidate in an election lost by 5.8% of the vote. The candidate sued the state and said that more than 5.8% of the ballots were defective and not counted by the voting machine, so a full recount would need to be done. His opponent wanted to ask for the case to be dismissed, so she had a government official from the state randomly select 500 ballots and count how many were defective. The official found 45 defective ballots.

Use Excel to test if the candidate’s claim is true and that more than 5.8% of the ballots were defective. Identify the p-value, rounding to three decimal places.

Provide your answer below:

Answer

Access the entire solutions for this week (top graded solutions) by clicking the ‘Buy’ button.

Activity 4

Question

Dmitry suspected that his friend is using a weighted die for board games. To test his theory, he wants to see whether the proportion of odd numbers is different from 50%. He rolled the die 40 times and got an odd number 14 times.

Dmitry conducts a one-proportion hypothesis test at the 5% significance level, to test whether the true proportion of odds is different from 50%.

(a)  Which answer choice shows the correct null and alternative hypotheses for this test?

Select the correct answer below:

  • H0:p=0.35; Ha:p>0.35, which is a right-tailed test.
  • H0:p=0.5; Ha:p<0.5, which is a left-tailed test.
  • H0:p=0.35; Ha:p≠35, which is a two-tailed test.
  • H0:p=0.5; Ha:p≠5, which is a two-tailed test.

Use Excel to test whether the true proportion of odds is different from 50%. Identify the test statistic, z, and p-value from the Excel output, rounding to three decimal places.

Answer

Access the entire solutions for this week (top graded solutions) by clicking the ‘Buy’ button.

Activity 5

Question

Dmitry suspects that his friend is using a weighted die for board games. To test his theory, he wants to see whether the proportion of odd numbers is different from 50%. He rolled the die 40 times and got an odd number 14 times.

Dmitry conducts a one-proportion hypothesis test at the 5% significance level, to test whether the true proportion of odds is different from 50%.

(a)  H0:p=0.5Ha:p≠0.5, which is a two-tailed test.

(b) Use Excel to test whether the true proportion of odds is different from 50%. Identify the test statistic, z, and p-value from the Excel output, rounding to three decimal places.

Answer

Access the entire solutions for this week (top graded solutions) by clicking the ‘Buy’ button.

Activity 6

Question

Dmitry suspects that his friend is using a weighted die for board games. To test his theory, he wants to see whether the proportion of odd numbers is different from 50%. He rolled the die 40 times and got an odd number 14 times.

Dmitry conducts a one-proportion hypothesis test at the 5% significance level, to test whether the true proportion of odds is different from 50%.

(a)  H0:p=0.5; Ha:p≠0.5, which is a two-tailed test.

(b)  z0=−1.897, p-value is = 0.058

(c) Which of the following are appropriate conclusions for this hypothesis test?  Select all that apply.

Select all that apply:

  • We reject H0.
  • We fail to reject H0.
  • At the 5% significance level, the data provide sufficient evidence to conclude the true proportion of odds is different than 50%.
  • At the 5% significance level, the data do not provide sufficient evidence to conclude the true proportion of odds is different than 50%.
Answer

Access the entire solutions for this week (top graded solutions) by clicking the ‘Buy’ button.

Reviews

There are no reviews yet.

Be the first to review “[Top Answer] MATH225N – Week 7 Assignment Construct Hypothesis Test for Proportions – Excel”

Your email address will not be published. Required fields are marked *