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.

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 #### Earn Coins

Coins can be redeemed for fabulous gifts.

##### Need Online Homework Help?

Most questions answered within 1 hours.

##### Active Questions
• The Blueberry Company is considering a project which will cost \$304 initially. The project will not...
• Sharp Company manufactures a product for which the following standards have been set: Standard Quantity or...
• Case 12.1 Determine what variables are categorical (either nominal or ordinal scales), perform the appropriate descriptive...
• GDebi Enterprises is thinking of building a chemical processing plant to produce 4-hydroxy-3-methoxybenzaldehyde. The firm estimates...
• Suppose you are picking one number from the set of natural numbers from 97 to 4....
• What is the wavelength (in meters) of photons with the following energies? Part A.) 136 kJ/mol...