Home

What If Analysis data table

%3CLINGO-SUB%20id%3D%22lingo-sub-1054696%22%20slang%3D%22en-US%22%3EWhat%20If%20Analysis%20data%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1054696%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20working%20on%20a%20homework%20problem%20and%20I%20am%20trying%20to%20use%20the%20What-If%20Analysis.%20I%20don't%20know%20if%20I%20do%20not%20have%20enough%20values%20or%20if%20I%20am%20not%20inputting%20them%20correctly.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20is%20as%20follows%3A%3C%2FP%3E%3CP%3EYou%20have%20two%20investment%20options%3A%3C%2FP%3E%3CUL%3E%3CLI%3EStock%20A%20with%20a%20price%20of%20%2410%3C%2FLI%3E%3CLI%3EStock%20B%20with%20%3CSPAN%3Ea%20price%20of%20%24100%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%3CSPAN%3EYou%20plan%20on%20investing%20%241%2C000%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EStock%20A%20is%20pretty%20stable%20and%20the%20lowest%20it%20is%20expected%20to%20down%20to%20%248%20but%20some%20analysts%26nbsp%3Bbelieve%20it%20could%20go%20up%20to%20%2413%3C%2FP%3E%3CP%3EStock%20B%20is%20more%20volatile.%20%26nbsp%3BThe%20lowest%20it%20is%20expected%20to%20go%20is%20as%20low%20as%20%2465%2C%20but%20it%20could%20get%20as%20high%20as%20%24150.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20anyone%20able%20to%20help%20me%20with%20the%20set%20up%20for%20this%20problem%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1054696%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1054759%22%20slang%3D%22en-US%22%3ERe%3A%20What%20If%20Analysis%20data%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1054759%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F481804%22%20target%3D%22_blank%22%3E%40Alyshia%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESince%20you%20start%20with%20saying%20%3CEM%3EI%20am%20working%20on%20a%20homework%20problem%20and%20I%20am%20trying%20to%20use%20the%20What-If%20Analysis.%20I%20don't%20know%20if%20I%20do%20not%20have%20enough%20values%20or%20if%20I%20am%20not%20inputting%20them%20correctly%3C%2FEM%3E%2C%20it%20seems%20reasonable%20to%20assume%20that%20you've%20made%20some%20tries%20already.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhy%20don't%20you%20upload%20what%20you've%20done%20so%20far%20so%20I%20or%20somebody%20else%20can%20comment%20on%20what%20you've%20done%20and%20not%20have%20to%20start%20from%20scratch.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20since%20you%20acknowledge%20it's%20a%20homework%20problem%2C%20I'm%20sure%20you'll%20agree%20that%20it%20makes%20more%20sense%20that%20you%20do%20most%20of%20the%20work....so%20if%20I%20end%20up%20being%20the%20one%20commenting%2C%20I%20might%20just%20offer%20one%20or%20two%20suggestions%20like...(1)%20write%20your%20formulas%20so%20they%20use%20a%20separate%20field%20called%20%22assumed%20growth%20rate%20for%20S%26amp%3BP%20500%20overall%22%20or%20something%20like%20that.%20(2)%20You%20clearly%20need%20a%20variable%20(better%20as%20a%20separate%20cell%20referenced%20in%20your%20%22What-if%22%20formulas)%20that%20would%20reflect%20that%20vague%20thing%20called%20%22volatility%22....%20and%20so%20forth.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Alyshia
Occasional Visitor

I am working on a homework problem and I am trying to use the What-If Analysis. I don't know if I do not have enough values or if I am not inputting them correctly. 

 

The problem is as follows:

You have two investment options:

  • Stock A with a price of $10
  • Stock B with a price of $100

You plan on investing $1,000

Stock A is pretty stable and the lowest it is expected to down to $8 but some analysts believe it could go up to $13

Stock B is more volatile.  The lowest it is expected to go is as low as $65, but it could get as high as $150.

 

Is anyone able to help me with the set up for this problem?

1 Reply

@Alyshia 

 

Since you start with saying I am working on a homework problem and I am trying to use the What-If Analysis. I don't know if I do not have enough values or if I am not inputting them correctly, it seems reasonable to assume that you've made some tries already.

 

Why don't you upload what you've done so far so I or somebody else can comment on what you've done and not have to start from scratch.

 

Also, since you acknowledge it's a homework problem, I'm sure you'll agree that it makes more sense that you do most of the work....so if I end up being the one commenting, I might just offer one or two suggestions like...(1) write your formulas so they use a separate field called "assumed growth rate for S&P 500 overall" or something like that. (2) You clearly need a variable (better as a separate cell referenced in your "What-if" formulas) that would reflect that vague thing called "volatility".... and so forth.

Related Conversations
PivotTable : Unexpected behavior with 2 tables
CastyChichi in Excel on
2 Replies
Help with an IF AND formula
aanaya6 in Excel on
3 Replies
IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
thomasea in Excel on
6 Replies
Pulling data from one tab to another
krysphares in Excel on
6 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies