ZuoTi.Pro
Question
Use Microsoft Excel to solve the problem, and either show a screenshot of how you solved it, and or explain each command that you used.

Use Excel function int (rand()/(1-p)) for generating random numbers of value 0 and 1 with probability P(-1) p.
2, Make in Excel three tables size 50 x 100, 250 × 100, 1000 × 100 with Bernoulli distributed random numbers for p(1) 3/13. Use the generated tables for calculating new column of random numbers equal to the number of the position where 1 appears for the first time in the first 100 columns. Random numbers in this column will have Geo- metric distribution. Find population probability distribution functions, means, variances and standard deviations and compare its with sample frequency distribution functions, averages, sample estimation of variances and standard deviations for each table. Draw the graphs. Estimate mean for the random variables in the obtained samples using 90% confidence intervals. Recalculate the tables 10 times and determine how often the population mean u does not belong to the obtained confident intervals.(5 points)
math   Statistics-And-Probability   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Solution for Gamma distau ith paame ler K, the Slehstics ae as follows . variance; k The probabity disbution funcion of a Gammą istibuby table has the Slondard A Sand Vaiab shape parame er gamma tion f given.loy f(t)-1F(リx(k-e- density function if since the gammauis arg ly a sum of u jamma parameter 3lleh mean 6f the dist. ฑ์ bution Should be x4(2 for 4he imulation it 3 table s Loe ge the sam ple mean 121288 t uohich is prettey Close to he i cal mean

0 0
Add a comment
Know the answer?
Add Answer to:
Use Microsoft Excel to solve the problem, and either show a screenshot of how you solved...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • You will be finding probabilities using excel. Use the Excel instructions for Binomial Distribution (=BINOMDIST(x, n,...

    You will be finding probabilities using excel. Use the Excel instructions for Binomial Distribution (=BINOMDIST(x, n, p, true or false)) False is equivalent to binompdf. True is equivalent to binomedf. State which probabilities are unusual. a.) P(x <6), n = 20, p= .8 b.) P(x < 16), n = 20, p=.15 c.) P(x> 14), n = 30, p = .35 3.) Twelve percent of people in the US eligible to donate blood actually do. You randomly section 15 eligible blood...

  • Use Excel to standard normal observations with assumed population parameters with mean 16 and standard deviation...

    Use Excel to standard normal observations with assumed population parameters with mean 16 and standard deviation 5. Go to Data Analysis (you need to have chosen "Analysis Toolpack" first) -> Random Number Generation -> Normal. Generate one random variable with numbers generated for samples of size 5, 16, and 25 from the default standard normal distribution. This will simulate the importance of the "assume normal" assumption. Use the =) provided from the parent population as your "assumed" population standard deviation....

  • I just need the answer for E and F, thank you:) Suppose the lengths of the...

    I just need the answer for E and F, thank you:) Suppose the lengths of the pregnancies of a certain animal are approximately normally distributed with mean p=123 days and standard deviation = 13 days. Complete parts (a) through (1) below. (a) What is the probability that a randomly selected pregnancy lasts less than 118 days? The probability that a randomly selected pregnancy lasts less than 118 days is approximately 0.3503). (Round to four decimal places as needed.) Interpret this...

  • Step 1. Open Excel and complete first two columns with any numbers Make 7-8 rows. Type...

    Step 1. Open Excel and complete first two columns with any numbers Make 7-8 rows. Type below first column "R = " We will use Excel function CORREL(Array-1, Array-2). STEP 2. Click on cell B11 and type: =CORREL( Highlight all numbers in A-column starting with cell A2 (do not include title). That will be Array-1 (input range). Type comma after Array-1 and highlight Array-2 from B-column. Press ENTER. You will see in cell B11 Coefficient of Linear Correlation. STEP 3....

  • For this problem, you must use Excel to perform the necessary calculations. Below are the formulas...

    For this problem, you must use Excel to perform the necessary calculations. Below are the formulas and equations you will need to use. If it is appropriate to use the binomial distribution, use the formula =binom.dist(number_s,trials,probability,cumulative) to calculate the probability. In this formula, number_s is the number of successful trials, trials is the total number of trials, probability is the probability for a single trial expressed as a decimal, and cumulative should be set as false. This will report the...

  • I need help. PLEASE DONT USE THE STANDARD NORMAL DISTRIBUTION TABLE. use normalcdf as part of...

    I need help. PLEASE DONT USE THE STANDARD NORMAL DISTRIBUTION TABLE. use normalcdf as part of your answer. Thank you 8.1.19 Question Help Suppose the lengths of the pregnancies of a certain animal are approximately normally distributed with mean = 212 days and standard deviation o 13 days. Complete parts (a) through (1) below. Click here to view the standard normal distribution table (page 1). Click here to view the standard normal distribution table (Rage 2). (c) What is the...

  • Please answer using EXCEL functions Solve confidence intervals for proportion, proportion with correction factor, and standard...

    Please answer using EXCEL functions Solve confidence intervals for proportion, proportion with correction factor, and standard deviation.         Confidence interval for a population standard deviation A random sample of 15 headache relief pills shows a standard deviation of .8% in the concentration of the active ingredient. Find a 90% confidence interval for the population standard deviation for these pills. Assume that the underlying population distribution of the concentration of the active ingredient is normal.            Note: given these small values, use...

  • I need help. PLEASE DONT USE THE STANDARD NORMAL DISTRIBUTION TABLE. use normalcdf as part of...

    I need help. PLEASE DONT USE THE STANDARD NORMAL DISTRIBUTION TABLE. use normalcdf as part of your answer. Thank you 8.1.19 Suppose the lengths of the pregnancies of a certain animal are approximately normally distributed with mean u 212 days and standard deviation a 13 days. Complete parts (a) through () below. Click here to view the standard normal distribution table (page 1). Click here to view the standard normal distribution table (page 2), (a) What is the probability that...

  • If possible could you show me how to do this in excel? Weights of a population...

    If possible could you show me how to do this in excel? Weights of a population have a mean (µ) of 180 pounds and standard deviation (σ) of 15 pounds. If random samples of size n = 5 are selected from this population, what percentage of the sample means would you expect to be (or “What is the probability that any sample mean (x-bar) is”) 1. (6 points)Between 179 and 181 pounds? 2. (6 points)Less than 177 pounds?

  • info here is given to help solve #3 below this photo: You may use any computer...

    info here is given to help solve #3 below this photo: You may use any computer software of your choice to complete this assignment Random variables from the four probability distributions given may be generated as follows 1. A standard uniform random variable, U in the interval (0,1), i.e., U ~ U (0,1), may be generated using the Matlab function 'rand'. The corresponding uniform random variable, X in the interval (-1,1) may be obtained as X 2U 1 2. A...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT