Can someone help me solve 1 and 2?
| x | P(x) | xP(x) | x2P(x) |
| 0 | 0.0323 | 0.0000 | 0.0000 |
| 9 | 0.0048 | 0.0435 | 0.3919 |
| 74 | 0.0006 | 0.0477 | 3.5329 |
| 304 | 0.0002 | 0.0490 | 14.9058 |
| 1279 | 0.0001 | 0.0825 | 105.5381 |
| 2699 | 0.0000 | 0.0871 | 234.9871 |
| -1 | 0.9620 | -0.9620 | 0.9620 |
| total | -0.6521 | 360.3179 | |
| E(x) =μ= | ΣxP(x) = | -0.6521 | |
| E(x2) = | Σx2P(x) = | 360.3179 | |
| Var(x)=σ2 = | E(x2)-(E(x))2= | 359.8927 | |
| std deviation= | σ= √σ2 = | 18.9708 |
1)
expected profit = -0.6521
2)
standard deviation =18.9708
3)
here this is binomial distribution with parameter n=11 and p=1/5
| probability = | P(3<=X<=6)= | ∑x=x1x2 (nCx)px(1−p)(n-x) = | 0.3806 | |
Can someone help me solve 1 and 2? SE Homework 3 - Excel Sign in -...
Module Three Homework Template - Excel Data Review View Tell me what you want to do = = Wap Test General . D XI Copy Merge & Center. $ . % , 99 Home Insert Page Layout Formulas A cut 10 A Format Painter BIU.. . Clipboard Font - x x P7-5 A B C D E 7- 5 9 points Conditional Format as Formatting Table Styles Cell Styles Insert Delete for - Alignment Number H I J K L...
FIN 313 Marginal Tax Example - Excel PEDAS - 0 x File Page Layout Formulas Data Review View Help ACROBAT Tell me what you want to do 2 Share suas Home Insert * Calibri B IU -11 A A === » ab Wrap Text General 1 X 0 AutoSum 47 0 Paste - A E S E E Merge & Center - $ % , e Insert Delete Format Conditional Format as Cell Formatting* Table Styles Styles Clear Sort &...
Module Three Homework Template - Excel Data Review View Cut = = Tell me what you want to do Wrap Test General Merge & Center - $ % 48.99 File Home Insert Page Layout Formulas Arial 10 A* C Copy Paste BIU Format Painter . S.A. Clipboard Font K P6-19 D E 1 P6-19 17 points 1 D D Conditional Format as Cell Formatting Table Styles Styles Alignment Number AI F G H I J K L M N No...
Can someone help and explain this??
Workshop 3 Problems Student Q Search Sheet Calibri (Body) , 12 - A- A = = = 0 5p Wrap Text Σ AutoSum' ΑΡ. General $ % Merge & Center ) 0.00 Conditional Format Formatting as Table Cell Styles Insert Delete Format Clear Sort & Filter Home Insert Page Layout Formulas Data Review View Xcut Copy Paste Format BI U DA = = G24 x fx A B C D E F G H...
Module Three Homework Template - Excel * Home Insert Page Layout Formulas * Cut Arial 10 Copy Format Painter BIU.E.O. A Clipboard Font x → P7-5 Data Review View Tell me what you want to do =*=> # Wrap Test General z . Merge & Center - $ % Alignment - & D D Conditional Format as Cell Formatting Table Styles Styles - Number - Cells A C D E G 7- 5 B points H I J K L...
Module Three Homework Template - Excel BS File Home х са Insert Page Layout Formulas Data Review View Tell me what you want to do . Copy Arial - 10 A BIU..A BWrap Text 3 Merge & Center. General $.% = . . Paste • o Conditional Formatan Formatting Table Format Painter Clipboard Cell Styles - Insert - Delete - Format - AL - X P7-24 O P Q 1 PT 24 1 point K L M N No credit...
Hello, Can someone help me figure these problems out. Also, if
you can, help me understand??
Workshop 2 Problems Student Q Search Shoot + View Doo Home Insert Page Layout Formulas X Cut Calitri (ody) 12 . Paste Format B IU. . 013 X V fic Data AA .A Review = - Ep Wrap Text Good Custom B y Autom. AY - Morge & Carter $ % ) A Conditional Format Fermeros To Check Cell Insert Delete Format Clear Fits...
Can anyone help me? Help me
understand
Workshop 2 Problems Student Q Search Shoot + Review View AA. Doo Home Insert Page Layout Formulas Data P . X cut Calibri (Body) 12 . A A Copy Paste format B IU. . .A AG X fx 1 9 Wrap Text General $ . % Morge & Center. ) Conditional Format Check Cell Insert Delete Format Formatting as Table Clear M N L Points: 24 hems1 pt. each - 24 points total...
Can someone help and also help
me understand?
Workshop 2 Problems Student Q Search Shoot + Review View AA. Doo Home Insert Page Layout Formulas Data P . X cut Calibri (Body) 12 . A A Copy Paste format B IU. . .A AG X fx 1 9 Wrap Text General $ . % Morge & Center. ) Conditional Format Check Cell Insert Delete Format Formatting as Table Clear M N L Points: 24 hems1 pt. each - 24 points...
Prepare an income statement from a list of accounts.
Darie Excel Problem 1.xlsx - Excel Tell me what you want to do File Home Insert Page Layout Data Review View Acrobat X Cut Copy Formulas 12 - A A . .A == Add-ins Help Wrap Test Morge & Center - General Normal Calibri B IU. Bad U AutoSum Fill Clear Paste = $ . % * Conditional Neutral Insert Delete Format * Format Painter Formatting Table Clipboard Alignment Styles Cells...