Question

# I am trying to figure out how to find the test statistic using Excel. I understand...

I am trying to figure out how to find the test statistic using Excel. I understand the formula- that I need to use parameter 'p' and 'normal distribution' ….z= sample proportion and minus the 'population portion' then we divide p*q and divide n -sample size. I understand how to populate the data in the formula. I just can't figure out how to solve this using Excel. (my only option with my class) I need step by step directions if possible. Visual aid would be even better...but whatever you could do to help would be GREATLY appreciated. Thank you.

#### Homework Answers

Answer #1

we know that the formula for the z statistic is given as

to solve this formula in excel sheet

let us assume that sample proportion p(hat) is entered in cell A1, p in cell A2, q= 1 - p in cell A3 and n value in cell A4

we want to find the z statistic value in cell B6

so, we will write the formula

z = (A1-A2)/sqrt((A2*A3)/A4)

this will give us the required z statistic value

Know the answer?
Your Answer:

#### Post as a guest

Your Name:

What's your source?

#### Earn Coins

Coins can be redeemed for fabulous gifts.

##### Not the answer you're looking for?
Ask your own homework help question
ADVERTISEMENT
##### Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

ADVERTISEMENT
##### Active Questions
• The Blueberry Company is considering a project which will cost \$304 initially. The project will not...
asked 7 minutes ago
• Sharp Company manufactures a product for which the following standards have been set: Standard Quantity or...
asked 24 minutes ago
• Case 12.1 Determine what variables are categorical (either nominal or ordinal scales), perform the appropriate descriptive...
asked 29 minutes ago
• GDebi Enterprises is thinking of building a chemical processing plant to produce 4-hydroxy-3-methoxybenzaldehyde. The firm estimates...
asked 29 minutes ago
• Suppose you are picking one number from the set of natural numbers from 97 to 4....
asked 36 minutes ago
• What is the wavelength (in meters) of photons with the following energies? Part A.) 136 kJ/mol...
asked 37 minutes ago
• In your own words, define nonverbal communication and explain three differences between verbal and nonverbal communication...
asked 41 minutes ago
• A new fuel injection system has been engineered for pickup trucks. The new system and the...
asked 45 minutes ago
• Robots can be trained to do dangerous, stinky, montonous work that human may not want to...
asked 47 minutes ago
• Steam at 250oC and 1 MPa enters a compressor at a steady rate of 2 m3...
asked 47 minutes ago
• What is the Cost of Equity? Provide a definition, and suggest least one way that we...
asked 53 minutes ago
• The scores of fourth grade students on a mathematics achievement test follow a normal distribution with...
asked 1 hour ago