Question

Use Excel to compute the table with columns for (1) N=number of coins, (2) N/2 =...

Use Excel to compute the table with columns for (1) N=number of coins, (2) N/2 = expected number of heads on average, (3) Sqrt[N]/2 = standard deviation, (4) typical range for number of heads (i.e. average – standard deviation to average + standard deviation), (5) relative width = standard deviation / average. Make rows for N = {10, 100, 1000, 10^4, 10^6, 10^8, … , 10^20, 10^22, 10^24}.

Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
When a fair coin is flipped N times, the average number of heads <n> , is...
When a fair coin is flipped N times, the average number of heads <n> , is N/2 and, in any particular trail, the “fluctuation” about this average, the standard deviation (variance), is expected to be sigma = sqrt(<n^2>-,<n>^2) . Calculate the probability that for N=16 the number of heads in one trail will be outside the expected range N/2+ sigma  to N/2- sigma
Q3. Suppose you toss n “fair” coins (i.e., heads probability = 1/21/2). For every coin that...
Q3. Suppose you toss n “fair” coins (i.e., heads probability = 1/21/2). For every coin that came up tails, suppose you toss it one more time. Let X be the random variable denoting the number of heads in the end. What is the range of the variable X (give exact upper and lower bounds) What is the distribution of X? (Write down the name and give a convincing explanation.)
Total number of subjects = 36 (3 in each cell) Number of columns (factor 1) =...
Total number of subjects = 36 (3 in each cell) Number of columns (factor 1) = 3 Number of rows (factor 2) = 4 Total sum of squares = 40 Sum of squares between cells = 16 Sum of squares for factor 1 = 10 Sum of squares for factor 2 = 4 The interaction sum of squares is equal to: a) 2. b) 36. c) 10. d) 24.
Total number of subjects = 36 (3 in each cell) Number of columns (factor 1) =...
Total number of subjects = 36 (3 in each cell) Number of columns (factor 1) = 3 Number of rows (factor 2) = 4 Total sum of squares = 40 Sum of squares between cells = 16 Sum of squares for factor 1 = 10 Sum of squares for factor 2 = 4 The within-cell sum of squares is equal to: a) 10. b) 2. c) 24. d) 36.
A random experiment was conducted where a Person A tossed five coins and recorded the number...
A random experiment was conducted where a Person A tossed five coins and recorded the number of “heads”. Person B rolled two dice and recorded the smaller number out of the two dice. Simulate this scenario (use 10000 long columns) and answer questions 10 to 13. Hint: check Lectures 26 and 27 in the Book. 10. Which of the two persons (A or B) is more likely to get the number 1? a. Person A b. Person B c. Not...
A random experiment was conducted where a Person A tossed five coins and recorded the number...
A random experiment was conducted where a Person A tossed five coins and recorded the number of “heads”. Person B rolled two dice and recorded the smaller number out of the two dice. Simulate this scenario (use 10000 long columns) and answer questions 10 to 13. Hint: check Lectures 26 and 27 in the Book. 10. Which of the two persons (A or B) is more likely to get the number 1? a. Person A b. Person B c. Not...
For the standard normal distribution, compute Z0.69. Use Excel and round the answer to two decimal...
For the standard normal distribution, compute Z0.69. Use Excel and round the answer to two decimal places. Consider the following test performed with the level of significance 0.01: A random sample of size 28 is obtained from a normally distributed population. The population standard deviation is equal to 3.6. The sample mean happened to be 24. For this hypothesis test, what will be the critical value (the relevant z-alpha)?  Round the answer to three decimal places. A probability distribution of all...
Given are five observations for two variables, and . Use Table 2 of Appendix B. 1...
Given are five observations for two variables, and . Use Table 2 of Appendix B. 1 2 3 4 5 4 7 5 11 14 Round your answers to two decimal places. a. Using the following equation: Sy*=s*SQRT(1/n + (x*-xbar)^2/Sigma(xi-xbar)^2)Estimate the standard deviation of Y when x=4 b. Using the following expression: ^y*+-(t a/2)Sy*Develop a confidence interval for the expected value of y when x=4 c. Using the following equation: S pred=s*sqrt(1+1/n+(x*-xbar)^2/sigma(xi-xbar)2 Estimate the standard deviation of an individual value...
Create a frequency table and a histogram for each of the data sets from Part 2....
Create a frequency table and a histogram for each of the data sets from Part 2. Below are two links explaining how to use Excel to create frequency tables and histrograms. Using Excel for Data and Tables Create a Histogram From a Frequency Table 1) Data Set 1: 23, 26, 50, 39, 55, 64, 50, 10, 42, 35, 51, 42, 43, 56, 64, 48, 48, 57, 27, 37 a. List the data values in order from lowest to highest. b....
Use excel to find the following please thank you! The probability distribution of X, the number...
Use excel to find the following please thank you! The probability distribution of X, the number of defective tires on a randomly selected automobile checked at a certain station is given by the table. X 0 1 2 3 4 p(X) 0.54 0.16 0.06 0.04 0.2 Table 4: Distribution for defective tires Find: a. E(X) b. E(X2) C. σX (8) A sample of 600 Scholastic Aptitude Test (SAT) results has mean of 500 and standard deviation of 100.
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT