Question

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.

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

What is Rstock? and How do you find it? I' am trying to find it
to enter into my WACC formula. WACC = Wdebt
(1-TC)Rdebt + Wpreferred
stock . RpF + Wcommon stocks
. Rstocks
The very last one that say's Rstock I can't quite
figure that out.

i
am trying to figure out how to find class boundaries

I am very new to coding and I am trying to understand how I can
go about connecting my Java Program to my Java GUI? I built my JAVA
program using eclipse, I created a database using mysql workbench
and connected the two (java program and mysql database). I also
created two GUI interfaces using Netbeans but Im not sure how to
bring these together?

I am trying to figure out the correct formula in statistics that
I need to use for this question.
When you or anyone else attempts to tell me and my
associates that 1223 persons account for our opinions and tastes
here in America, I get mad as hell! How dare you! When you or
anyone else tells me that 1223 people represent America; it is
astounding and unfair and should be outlawed.
The writer then goes on to claim that...

So, I am trying to perform a goodness of fit test on a set of
data. The data consists of one thousand samples with values that
range between 3.9 to 15.5. In the problem it is stated that this
data could have either a gamma or normal distribution and I am
meant to figure out which of these distributions it is closer to
due to the results of two goodness of fit tests (one assuming gamma
distribution and the other...

I am trying to figure out how to find the most common word
length in the british dictionary. I have inputted the text file for
the british dictionary into my program. I tried a tedious way, but
it doesn't seem effective. Can someone help me?
String longestWord = "";
int maxLength =0;
int count1 =0, count2 =0,
count3=0, count4=0, count5=0, count6=0, count7=0, count8=0,
count9=0, count10=0;
Scanner scanFile = new Scanner
(new File("BritishDictionary.txt"));
...

I am struggling to understand how to find what is the reagent
used in a reaction. I have these 4 problems and I must figure out
what "reagent used in reaction". My classmate described the reagent
as the ractant that is entirly consumed when a reaction goes to
completion. It determines how much of a product you can make.
Cu(s) + 4 HNO3 (aq) –> Cu(NO3)2 (aq) + 2NO2 (g) + 2H20
Cu(NO3)2 (aq) + 2NaOH (aq) –>Cu(OH)2 (s) +...

We are using the MegaStat plugin for Excel and I am unsure what
values I need to pull out of the question to input into the plugin
to get to my answer. Any help would be greatly appreciated.
Using data from 50 workers, a researcher estimates Wage =
β0 + β1 Education +
β2Experience +β3Age +
ε, where Wage is the hourly wage rate and Education,
Experience, and Age are the years of higher education, the years of
experience, and...

Looking at my answers, I was am always off buy about range of .1
to .4 from the correct answer that is stated. I am having a really
tough time trying to figure out how to get my number to be exactly
like what is shown as correct so I need a little help with figuring
out what I am doing wrong. Here is an example of a question I just
cant seem to figure out. I'll show all my...

I am having a hard time with working through Weighted Average
Cost of Capital (WACC) on a project and was curious if anyone could
help me better understand it to get through my work. (I am also
doing this with the company's income statement and balance sheet if
that makes a difference).
I need to find:
1. the firm's before-tax and after-tax component cost of
debt.
2. estimate the firms component cost of preferred stock
3. and use CAPM, DCF...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 7 minutes ago

asked 24 minutes ago

asked 29 minutes ago

asked 29 minutes ago

asked 36 minutes ago

asked 37 minutes ago

asked 41 minutes ago

asked 45 minutes ago

asked 47 minutes ago

asked 47 minutes ago

asked 53 minutes ago

asked 1 hour ago