excel - A spreadsheet software

A binomial probability experient is conducted with the given parameters. Compute the probability of

A binomial probability experient is conducted with the given parameters. Compute the probability of x successes in the n independent trials of the experiment.
n = 40, p = 0.05, x = 2
P(2) =
Answer is [B]0.2777[/B]. Using Excel formula of =BINOMDIST(2,40,0.05,FALSE) or using our [URL='http://www.mathcelebrity.combinomial.php?n=+40&p=0.05&k=2&t=+5&pl=P%28X+%3D+k%29']binomial probability calculator[/URL]

A financial analyst computed the ROI for all companies listed on the NYSE. She found that the mean o

A financial analyst computed the ROI for all companies listed on the NYSE. She found that the mean of this distribution was 10% with standard deviation of 5%. She is interested in examining further those companies whose ROI is between 14% and 16% of the approximately 1,500 companies listed on the exchange, how many are of interest of her?
First, use our [URL='http://www.mathcelebrity.com/zscore.php?z=p%280.14%3Cz%3C0.16%29&pl=Calculate+Probability']z-score calculator[/URL] to get P(0.14 < z < 0.16) = 0.007889
Divide that by 2 for two-tail test to get0.003944729
Use the NORMSINV(0.003944729) in Excel to get the Z value of 2.66
Therefore, the companies of interest are 2.66 * 1500 * 0.10 = [B]399[/B]

A used bookstore sells paperback fiction books in excellent condition for $2.50 and in fair conditio

A used bookstore sells paperback fiction books in excellent condition for $2.50 and in fair condition for $0.50. Write an expression for the cost of buying x excellent-condition paperbacks and f fair-condition paperbacks.
Cost = Price * Quantity, so we have:
[B]2.50x + 0.50f[/B]

Chi-Square Critical Values

Given a probability, this calculates the critical value for the right-tailed and left-tailed tests for the Chi-Square Distribution. CHIINV from Excel is used as well.

Critical Z-values

Given a probability from a normal distribution, this will generate the z-score critical value. Uses the NORMSINV Excel function.

Facebook provides a variety of statistics on its Web site that detail the growth and popularity of t

Facebook provides a variety of statistics on its Web site that detail the growth and popularity of the site.
On average, 28 percent of 18 to 34 year olds check their Facebook profiles before getting out of bed in the morning. Suppose this percentage follows a normal distribution with a standard deviation of five percent.
a. Find the probability that the percent of 18 to 34-year-olds who check Facebook before getting out of bed in the morning is at least 30.
b. Find the 95th percentile, and express it in a sentence.
a. P(X >=0.30), calculate the [URL='http://www.mathcelebrity.com/probnormdist.php?xone=+0.30&mean=+0.28&stdev=+0.05&n=+1&pl=P%28X+%3E+Z%29']z-score[/URL] which is:
Z = 0.4
P(x>0.4) = [B]0.344578 or 34.46%[/B]
b. Inverse Normal (0.95) [URL='http://www.mathcelebrity.com/zcritical.php?a=0.95&pl=Calculate+Critical+Z+Value']calculator[/URL] = 1.644853627
Use NORMSINV(0.95) on Excel
0.28 + 0.05(1.644853627) = [B]0.362242681 or 36.22%[/B]

Imagine that a researcher wanted to know the average weight of 5th grade boys in a high school. He r

Imagine that a researcher wanted to know the average weight of 5th grade boys in a high school. He randomly sampled 5 boys from that high school. Their weights were: 120 lbs., 99 lbs, 101 lbs, 87 lbs, 140 lbs. What's the sample [U][B]standard deviation[/B][/U]?
[B]20.79182532[/B] using stdev.s in excel or also found on our [URL='http://www.mathcelebrity.com/statbasic.php?num1=120%2C99%2C101%2C87%2C140&num2=+0.2%2C0.4%2C0.6%2C0.8%2C0.9&pl=Number+Set+Basics#standard_deviation']statistics calculator[/URL]

Standard Normal Distribution

Givena normal distribution z-score critical value, this will generate the probability. Uses the NORMSDIST Excel function.

The first significant digit in any number must be 1, 2, 3, 4, 5, 6, 7, 8, or 9. It was discovered t

The first significant digit in any number must be 1, 2, 3, 4, 5, 6, 7, 8, or 9. It was discovered that first digits do not occur with equal frequency. Probabilities of occurrence to the first digit in a number are shown in the accompanying table. The probability distribution is now known as Benford's Law. For example, the following distribution represents the first digits in 231 allegedly fraudulent checks written to a bogus company by an employee attempting to embezzle funds from his employer.
Digit, Probability
1, 0.301
2, 0.176
3, 0.125
4, 0.097
5, 0.079
6, 0.067
7, 0.058
8, 0.051
9, 0.046
[B][U]Fradulent Checks[/U][/B]
Digit, Frequency
1, 36
2, 32
3, 45
4, 20
5, 24
6, 36
7, 15
8, 16
9, 7
Complete parts (a) and (b).
(a) Using the level of significance α = 0.05, test whether the first digits in the allegedly fraudulent checks obey Benford's Law. Do the first digits obey the Benford's Law?

Yes or No Based on the results of part (a), could one think that the employe is guilty of embezzlement? Yes or No Show frequency percentages Digit Fraud Probability Benford Probability 1 0.156 0.301 2 0.139 0.176 3 0.195 0.125 4 0.087 0.097 5 0.104 0.079 6 0.156 0.067 7 0.065 0.058 8 0.069 0.051 9 0.03 0.046 Take the difference between the 2 values, divide it by the Benford's Value. Sum up the squares to get the Test Stat of 2.725281277 Critical Value Excel: =CHIINV(0.95,8) = 2.733 Since test stat is less than critical value, we cannot reject, so [B]YES[/B], it does obey Benford's Law and [B]NO[/B], there is not enough evidence to suggest the employee is guilty of embezzlement.

Yes or No Based on the results of part (a), could one think that the employe is guilty of embezzlement? Yes or No Show frequency percentages Digit Fraud Probability Benford Probability 1 0.156 0.301 2 0.139 0.176 3 0.195 0.125 4 0.087 0.097 5 0.104 0.079 6 0.156 0.067 7 0.065 0.058 8 0.069 0.051 9 0.03 0.046 Take the difference between the 2 values, divide it by the Benford's Value. Sum up the squares to get the Test Stat of 2.725281277 Critical Value Excel: =CHIINV(0.95,8) = 2.733 Since test stat is less than critical value, we cannot reject, so [B]YES[/B], it does obey Benford's Law and [B]NO[/B], there is not enough evidence to suggest the employee is guilty of embezzlement.

The IQ scores are normally distributed with a mean of 100 and a standard deviation of 15. a) What i

The IQ scores are normally distributed with a mean of 100 and a standard deviation of 15.
a) What is the probability that a randomly person has an IQ between 85 and 115?
b) Find the 90th percentile of the IQ distribution
c) If a random sample of 100 people is selected, what is the standard deviation of the sample mean?
a) [B]68%[/B] from the [URL='http://www.mathcelebrity.com/probnormdist.php?xone=50&mean=100&stdev=15&n=1&pl=Empirical+Rule']empirical rule calculator[/URL]
b) P(z) = 0.90. so z = 1.28152 using Excel NORMSINV(0.9)

(X - 100)/10 = 1.21852 X = [B]113[/B] rounded up c) Sample standard deviation is the population standard deviation divided by the square root of the sample size 15/sqrt(100) = 15/10 =[B] 1.5[/B]

(X - 100)/10 = 1.21852 X = [B]113[/B] rounded up c) Sample standard deviation is the population standard deviation divided by the square root of the sample size 15/sqrt(100) = 15/10 =[B] 1.5[/B]