Question
Please use Excel to show the EXCEL FORMULA used to answer these questions. Thank you in advance!

1 0.2 0.3 0.2 0.1 0.1 0.1 1 2 3 4 5 X Probability E(X) Var(x) SD(X) 0.2011 0.276 0.125 0,087 0.075 0.087 0.063 0.04 0.046 12
0 0
Add a comment Improve this question Transcribed image text
Answer #1

A B F G H M N I A) 1 sum 3 0.4 0.3 1.9 prob Xi*pi Xi^2 xi^2 * pi 0.3 1 0.3 16 1.6 o 0.8 0.9 6.1 E[x]= var[x]= sd expect value

Add a comment
Know the answer?
Add Answer to:
Please use Excel to show the EXCEL FORMULA used to answer these questions. Thank you in...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

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
  • PLEASE USE EXCEL AND SHOW EXCEL FORMULAS USED W/THE FORMULA ARGUMENTS PLEASE USE EXCEL AND SHOW...

    PLEASE USE EXCEL AND SHOW EXCEL FORMULAS USED W/THE FORMULA ARGUMENTS PLEASE USE EXCEL AND SHOW EXCEL FORMULAS USED W/THE FORMULA ARGUMENTS THANK YOU! Plan A Plan B Payout P Payout $30,000 0.55 $45,000 $70,000 Payout PPayout -$50,000 0.26 $30,0000.49 $35,000 0.1 0.25 0.35

  • Please use only Minitab or Excel. Thank you Please use only Minitab or Excel. Thank you...

    Please use only Minitab or Excel. Thank you Please use only Minitab or Excel. Thank you Please use only Minitab or Excel. Please use only Minitab or Excel. Thank you Two different tire compound formulas are tested for tire wear in thousandths of inches. Everything else that might vary is held at a pre-determined constant value to the best of the experimenter's ability. The following are the samples randomly selected from the tires made by the different compound formulas (assume...

  • please show all the work. if you use excel please show the screenshots. Thank you !...

    please show all the work. if you use excel please show the screenshots. Thank you ! Question 5 (25pts) Suppose the athletic director at a university would like to develop a regression model to predict the point differential for games played by the men's basketball team. A point differential is the difference between the final points scored by two competing teams. A positive differential is a win, and a negative differential is a loss. For a random sample of games,...

  • Please answer the following statistics problem and show all your steps thoroughly! Thank you! ​​​​​​​ Question...

    Please answer the following statistics problem and show all your steps thoroughly! Thank you! ​​​​​​​ Question 5 (10 marks) Suppose that (X, Y) have joint probability function f(x,y) specified by the following table: f(x,y) 0 0.2 0.15 1 Х 2 0.3 0 1 0.1 0.1 3 0.05 0.1 у 2 a) (2 marks) Find the marginal distribution of X and Y (display in a table) b) (2 marks) Find the conditional distribution of Y given X=3. (display in a table)...

  • using excel answer the problem below Let X be a discrete random variable having following probability...

    using excel answer the problem below Let X be a discrete random variable having following probability distribution. x 2 4 6 8 P(x) 0.2 0.35 0.3 0.15 Complete the following table and compute mean and variance for X x P(x) x· P(x) x2. P(x) 2 0.2 4 0.35 6 0.3 8 0.15 Total 1 Expected value E(X) = u = Variance Var = o2 =

  • Please, step by step solving on paper. Thank you. 2. Probability model of X and Y...

    Please, step by step solving on paper. Thank you. 2. Probability model of X and Y discrete random variables is given below in the table. Find the marginal probability mass function, mean and variance of X and Y. correlation (Txy), covariance (Oxy) and correlation coefficient (Pxy). y = 0 y = 1 0 Pxy(x,y) x = 1 x = 2 x = 3 y= -1 0.3 0.1 0.1 0.2 0 0.1 0.2

  • Please answer using an Excel Formula Answers must be written using an Excel Formula Thank you...

    Please answer using an Excel Formula Answers must be written using an Excel Formula Thank you G H 7 A B C D E F 176 Below is Required Homework 177 178 Formulas 179 Subtract cell G180 from cell F180 180 35 181 182 Divide cell F184 by G184 183 Format the result as a percent with one decimal place 184 7 185 186 187 Calculate the product of the two light grey cells divided by the sum of the...

  • Please use excel and state the formula used and what was inputted to solve it, thank...

    Please use excel and state the formula used and what was inputted to solve it, thank you 1. A budgeting Web site reported that 20 % of U.S. households have withdrawn money from a 401(k) or other retirement account for needs other than retirement in 2013. A random sample of 11 U.S. households was selected. What is the probability that exactly three households withdrew funds from a retirement account for needs other than retirement? Find the mean, variance, and standard...

  • Please show work. Thanks in advance. Question 5 (20 pts) You must decide which of two...

    Please show work. Thanks in advance. Question 5 (20 pts) You must decide which of two discrete distri- butions a random variable X has. We will call the distributions po and p. Here are the probabilities they assign to the values r of X. 2 Po P 0 1 2 0.1 0.1 0.2 0.1 0.3 0.2 3 4 5 0.3 0.1 0.1 0.1 0.1 0.1 6 0.1 0.1 You have a single observation on X and wish to test Ho:...

  • Please show using the formula in excel X Usinq the DuPont identity - Excel Sign In...

    Please show using the formula in excel X Usinq the DuPont identity - Excel Sign In DATA FILE HOME INSERT PAGE LAYOUT FORMULAS REVIEW VIEW 1 Arial 12 A A Conditional Format as Cell Paste Cells Alignment Number Editing B IU T FormattingTable Styles Clipboard Font Styles X D14 A C D Е F G K 1. 2 Y3K, Inc., has sales of $5,783, total assets of $2,604, and a debt-equity ratio of .75. If its return on equity is...

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