Please see my data below and show me how solve this questions on Excel only Polling is done to determine whether respondents are more interested in the game or the commercials, and whether the answer to this differs by gender We wanted to determine if there is a difference in proportion between Females and Males who watch super bowl for commercial reason Use alpha 0 05 a)State the null and alternate hypothesisb) b) Conduct HT using 0 05 What's your decision c)Interpret the z value and the p value What do these values mean in terms of evidence in favor or against the null hypothesis Female Male Commercials Commercials Game Game Game Game Commercials Game Game Game Commercials Game Game Game Game Commercials Commercials Game Game Commercials Game Game Commercials Commercials Commercials Game Commercials Game Commercials Game Commercials Commercials Game Game Commercials Game Game Commercials Commercials Game Commercials Game Commercials Commercials Game Game Game Game Game Game Game Game Game Commercials Commercials Commercials Commercials Game Commercials Game Game Commercials Game Commercials Game Game Game Game Game Game Commercials Commercials Commercials Game Game Game Game Game Game Game Game Commercials Commercials Game Game Commercials Game Commercials Commercials Game Commercials Game Commercials Game Commercials Game Game Game Game Game Commercials Game Commercials Game Commercials Game Commercials Commercials Commercials Game Commercials Game Game Game Commercials Game Commercials Game Game Game Commercials Commercials Commercials Game Game Commercials Game Game Game Game Commercials Game Commercials Game Commercials Commercials Game Game Game Commercials Game Commercials Game Game Game Game Commercials Game Commercials Game Game Game Commercials Game Game Commercials Commercials Game Game Game Commercials Game Game Game Commercials Commercials Game Game Commercials Game Commercials Commercials Game Commercials Game Game Commercials Game Game Game Game Game Commercials Commercials Commercials Game Commercials Game Game Game Commercials Game Game Game Game Commercials Commercials Commercials Commercials Game Game Game Commercials Game Game Game Game Game Game Commercials Game Game Game Game Commercials Game Commercials Game Game Game Commercials Commercials Game Game Commercials Game Game Commercials Game Commercials Game Game Game Game Game Commercials Game Game Game Game Commercials Game Game Commercials Commercials Game Commercials Game Commercials Game Commercials Commercials Game Game Commercials Game Game Game Game Game Game Commercials Commercials Game Commercials Game Game Commercials Game Game Game Game Commercials Game Game Game Commercials Game Commercials Commercials Game Commercials Commercials Game Game Game Commercials Game Commercials Game Game Game Commercials Game Commercials Commercials Game Commercials Game Game Commercials Game Commercials Game Game Game Commercials Game Game Game Game Game Game Commercials Game Game Game Commercials Commercials Game Game Game Game Game Game Commercials Game Game Commercials Game Commercials Game Game Game Commercials Game Commercials Game Commercials Game Commercials Commercials Commercials Game Game Game Game Game Commercials Game Commercials Game Game Game Game Game Game Commercials Commercials Game Commercials Game Game Game Commercials Commercials Game Game Commercials Game Game Game Game Game Game Game Commercials Game Commercials Game Game Game Game Commercials Game Game Game Commercials Game Game Game Game Game Game Commercials Game Game Game Game Game Game Game Game Game Game Commercials Game Game Game Game Game Game Game Commercials Commercials Commercials Game Game Game Game Game Game Commercials Commercials Game Commercials Game Game Commercials Game Game Game Game Game Commercials Game Game Game Game Game Game Game Game Commercials Game Commercials Game Game Commercials Commercials Commercials Game Commercials Game Game Game Commercials Game Commercials Game Commercials Game Game Game Commercials Game Game Game Game Commercials Commercials Game Commercials Game Game Commercials Game Game Commercials Game Commercials Game Game Game Game Commercials Commercials Game Commercials Commercials Game Game Commercials Game Game Game Commercials Game Game Game Game Game Game Game Commercials Game Game Game Commercials Commercials Game Commercials Commercials Commercials Game Game Commercials Game Commercials Game Game Game Commercials Game Game Commercials Game Game Game Game Game Commercials Game Game Commercials Game Commercials Game Commercials Game Game Game Game Game Commercials Game Game Game Game Game Commercials Game Game Game Game Game Game Commercials Commercials Game Game Game Game Game Commercials Game Commercials Game Game Game Game Game Commercials Commercials Game Game Commercials Game Commercials Game Commercials Game Game Game Game Game Commercials Game Game Game Game Game Game Game Commercials Game Commercials Game Commercials Game Game Game Game Game Game Game Commercials Game Commercials Game Commercials Game Game Game Game Commercials Commercials Game Game Game Game Game Game Commercials Game Game Game Game Commercials Game Commercials Commercials Commercials Game Game Game Game Game Commercials Game Game Game Commercials Commercials Commercials Game Commercials Commercials Game Game Game Commercials Game Game Commercials Game Game Commercials Commercials Game Game Game Game Game Commercials Commercials Game Game Game Game Game Commercials Commercials Game Commercials Game Commercials Game Game Game Commercials Game Game Game Commercials Game Game Game Game Commercials Commercials Game Commercials Commercials Game Game Game Game Game Game Game Game Game Game Game Game Game Game

The Answer is in the image, click to view ...

Question: Please see my data below and show me how solve this questions on Excel only Polling is done to determine whether respondents are more interested

Please see my data below and show me how solve this questions on Excel only

Polling is done to determine whether respondents are more interested in the game or the commercials, and whether the answer to this differs by gender.

We wanted to determine if there is a difference in proportion between Females and Males who watch super bowl for commercial reason. Use alpha=0.05

a)State the null and alternate hypothesisb)

b) Conduct HT using =0.05. What's your decision?

c)Interpret the z-value and the p-value. What do these values mean in terms of evidence in favor or against the null hypothesis?

Female	Male
Commercials	Commercials
Game	Game
Game	Game
Commercials	Game
Game	Game
Commercials	Game
Game	Game
Game	Commercials
Commercials	Game
Game	Commercials
Game	Game
Commercials	Commercials
Commercials	Game
Commercials	Game
Commercials	Game
Commercials	Commercials
Game	Game
Commercials	Game
Game	Commercials
Commercials	Game
Commercials	Game
Commercials	Commercials
Game	Game
Game	Game
Game	Game
Game	Game
Game	Commercials
Commercials	Commercials
Commercials	Game
Commercials	Game
Game	Commercials
Game	Commercials
Game	Game
Game	Game
Game	Game
Commercials	Commercials
Commercials	Game
Game	Game
Game	Game
Game	Game
Game	Commercials
Commercials	Game
Game	Commercials
Game	Commercials
Commercials	Game
Commercials	Game
Commercials	Game
Commercials	Game
Game	Game
Game	Game
Commercials	Game
Commercials	Game
Commercials	Game
Commercials	Commercials
Commercials	Game
Commercials	Game
Game	Game
Commercials	Game
Commercials	Game
Game	Game
Commercials	Commercials
Commercials	Game
Game	Commercials
Game	Game
Game	Game
Commercials	Game
Commercials	Game
Commercials	Commercials
Game	Game
Game	Commercials
Game	Commercials
Game	Game
Game	Game
Commercials	Game
Commercials	Game
Game	Game
Commercials	Game
Game	Commercials
Commercials	Game
Game	Game
Commercials	Game
Game	Game
Commercials	Commercials
Game	Game
Commercials	Game
Commercials	Commercials
Game	Commercials
Game	Game
Commercials	Game
Game	Game
Game	Game
Commercials	Commercials
Commercials	Game
Commercials	Game
Game	Game
Commercials	Game
Game	Game
Game	Commercials
Commercials	Commercials
Commercials	Game
Game	Game
Commercials	Game
Game	Game
Game	Game
Game	Commercials
Game	Game
Game	Game
Commercials	Game
Commercials	Game
Game	Game
Commercials	Commercials
Game	Game
Commercials	Game
Game	Commercials
Game	Commercials
Game	Game
Game	Game
Game	Commercials
Game	Game
Game	Game
Commercials	Game
Game	Commercials
Commercials	Game
Commercials	Game
Commercials	Game
Commercials	Commercials
Game	Game
Commercials	Game
Game	Game
Game	Game
Game	Commercials
Commercials	Game
Commercials	Game
Game	Commercials
Game	Game
Game	Game
Commercials	Game
Game	Game
Commercials	Game
Commercials	Commercials
Game	Commercials
Commercials	Game
Game	Game
Commercials	Game
Commercials	Game
Game	Game
Commercials	Game
Commercials	Commercials
Game	Commercials
Game	Game
Commercials	Game
Commercials	Game
Game	Game
Commercials	Game
Game	Game
Game	Game
Game	Commercials
Game	Game
Game	Commercials
Commercials	Game
Game	Game
Game	Game
Game	Commercials
Game	Game
Commercials	Game
Commercials	Game
Game	Game
Commercials	Game
Commercials	Game
Commercials	Game
Commercials	Commercials
Commercials	Game
Game	Game
Game	Game
Commercials	Game
Commercials	Game
Game	Game
Game	Game
Game	Commercials
Commercials	Game
Commercials	Game
Game	Game
Commercials	Commercials
Game	Game
Commercials	Game
Game	Game
Game	Game
Game	Game
Commercials	Game
Commercials	Game
Game	Game
Game	Commercials
Game	Game
Game	Commercials
Game	Game
Game	Game
Game	Game
Commercials	Game
Game	Game
Game	Game
Game	Game
Game	Game
Game	Commercials
Game	Game
Game	Game
Game	Game
Game	Commercials
Commercials	Commercials
Game	Game
Game	Game
Game	Game
Commercials	Commercials
Game	Commercials
Game	Game
Commercials	Game
Game	Game
Game	Game
Commercials	Game
Game	Game
Game	Game
Game	Game
Game	Commercials
Game	Commercials
Game	Game
Commercials	Commercials
Commercials	Game
Commercials	Game
Game	Game
Commercials	Game
Commercials	Game
Commercials	Game
Game	Game
Commercials	Game
Game	Game
Game	Commercials
Commercials	Game
Commercials	Game
Game	Commercials
Game	Game
Commercials	Game
Commercials	Game
Game	Game
Game	Commercials
Commercials	Game
Commercials	Commercials
Game	Game
Commercials	Game
Game	Game
Commercials	Game
Game	Game
Game	Game
Game	Game
Commercials	Game
Game	Game
Commercials	Commercials
Game	Commercials
Commercials	Commercials
Game	Game
Commercials	Game
Commercials	Game
Game	Game
Commercials	Game
Game	Commercials
Game	Game
Game	Game
Game	Commercials
Game	Game
Commercials	Game
Commercials	Game
Commercials	Game
Game	Game
Game	Game
Commercials	Game
Game	Game
Game	Game
Commercials	Game
Game	Game
Game	Game
Game	Commercials
Commercials	Game
Game	Game
Game	Game
Commercials	Game
Commercials	Game
Game	Game
Game	Game
Commercials	Commercials
Game	Game
Commercials	Game
Commercials	Game
Commercials	Game
Game	Game
Game	Game
Commercials	Game
Game	Game
Game	Game
Game	Game
Commercials	Game
Commercials	Game
Commercials	Game
Game	Game
Game	Game
Game	Game
Commercials	Game
Commercials	Game
Commercials	Game
Game	Game
Game	Commercials
Commercials	Game
Game	Game
Game	Game
Game	Commercials
Game	Game
Game	Game
Commercials	Game
Commercials	Commercials
Commercials	Game
Game	Game
Game	Game
Commercials	Game
Game	Game
Commercials	Commercials
Commercials	Game
Commercials	Commercials
Game	Game
Game	Commercials
Game	Game
Commercials	Game
Game	Commercials
Commercials	Game
Game	Game
Game	Game
Commercials	Commercials
Game	Game
Game	Game
Game	Commercials
Commercials	Game
Commercials	Game
Commercials	Game
Game	Game
Commercials	Game
Game	Game
Commercials	Game
Game	Game
Game	Commercials
Commercials	Game
Commercials	Commercials
Game	Game
Game	Game
Game	Game
Game	Game
Game	Game
	Game
	Game
	Game
	Game

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Abstract Lamar Letts, an undergraduate student at Northeastern University in Boston, had developed a vitamin water drink in response to his needs as a high school student athlete in Brooklyn, NY. Due...

Simplify each expression. Assume that all variables represent nonzero real numbers. 52

Prepare the adjusting journal entries that Del Gato Clinic must record as a result of preparing the bank reconciliation in Exercise 8- 10. In Exercise 8- 10, Del Gato Clinic deposits all cash...

Looking at the charts presented earlier in this chapter, select a product that members of a particular nation consume heavily. Research the countrys culture and geographic location and describe why...

6.30 Loading Grain A grain loader can be set to discharge grain in amounts that are normally distributed, with mean kg and standard deviation equal to 700 kg. If a company wishes to use the loader to...

The partnership of Folly and Frill is in the process of liquidation. On January 1, 2011, the ledger shows account balances as follows: On January 10, 2011, the lumber inventory is sold for $25,000,...

Venus Chocolate Company processes chocolate into candy bars. The process begins by placing direct materials (raw chocolate, milk, and sugar) into the Blending Department. All materials are placed...

You have been hired by Gnomeo, Inc., a company that buys and resells miniature garden gnomes. The company started business on January 1, 2019. The chief accountant has asked you to compile a set of...

The Town of McHenry has $17,000,000 in general obligation bonds outstanding and maintains a single debt service fund for all debt service transactions. On July 1, 2020, a current refunding took place...

Comparison of APPLE and MICROSOFT corporate governance. To what extent the corporate governances are similar and to what extent they are different, how they reflect good governance principles such as...

Victor and George are friends who have recently graduated from Greenstreet University with a degree in fashion design. They discuss an idea of setting up a fashion design business in London. Having...

research at least 2 of the following codes of ethics: (ISC)2 Code of Ethics The International Council of Electronic Commerce Consultant (EC-Council) System Administration, Networking, and Security...

Problem 1 (20 points). In a warehouse, it is required to locate a temporary storage area for 5 shelves operations that are located in the following coordinates (1, 4), (1, 8), (1, 12), (4, 4) and (4,...

Game Z Ltd has 3 sources of capitals - Common shares, Preferred shares and corporate bonds. The market value of its common shares is $50 per share while its Preferred shares are valued at $45 per...

Elden Company Work Sheet For Year Ended June 30, 20-- TRIAL BALANCE ADJUSTMENTS ADJUSTED TRIAL BALANCE INCOME STATEMENT BALANCE SHEET ACCOUNT NAME DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT...

In each of the following independent cases, document the system using whatever technique(s) your instructor specifies. a. Dreambox Creations (www.dreamboxcreations.com/) in Diamond Bar, California,...

18. When we convert our data into a score from a probability distribution, what do we call the value we obtain? (a) Significant (b) Not significant (c) The test statistic (d) The power of the study

20. If you find in a study that your p-value is 0.05, what is the probability of the alternative hypothesis being true? (a) 0.05 (b) 1 minus 0.05 (c) We cannot work out the probability of the...

19. Imagine we conduct two studies. In study A we have 1000 participants and obtain a p-value of 0.01, whereas in study B we have only 20 participants and a p-value of 0.05. In which of these two...