A
Ayn00
Hello -- Please be kind! I'm new to these boards and I'm miserably
clueless about Excel. I need some help with my Statistics homework so
if you're kind and/or valiant and/or bored enough to hand-hold a
complete idiot through the process, I'll be so absolutely grateful!
Okay, so in this assignment I have a spreadsheet file: Column A has a
series of various numbers:
A1 has 10;
A2 has 30;
A3 has 5;
...and on and on it goes.
1) In this assignment, I have to somehow make column B bring out the
percentage difference from an arbitrary number (in this case 20) to the
numbers in the A column. For instance, since A1 is 10; B1 will have to
be -50% (since 10 is a 50% decrease of 20). And for B2, since A2 is 30,
B2 should generate a 50% in its cell (since 30 is a 50% increase from
20). So how do I make Excel automatically generate the percentage
differences for rest of the B column?
2) So after the B column gets filled out...is there a way for Excel to
determine the probability that a certain percentage will occur, judging
from what's spat out into the B column? For instance, one of the
questions on my assignment asks for the probability that -45% will
happen, judging from what's generated in column B... So how I do I
input a formula/code for Excel to look through what's in the B column
and determine how likely -45% (or any other percentage) happens?
I know there're many ways Excel can figure out probabilities -- so if
you'd be so kind to just hand-hold me through a basic approach, then
mention any other methods that may yield better answers, I can look
them up accordingly.)
(Please don't be mean! If possible, please try to explain all this as
gently and as "step-by-step" as possible -- you know, as if I'm a
complete dunce, because, well, I am.
)
Thank you so much for any help and insight you can provide!
clueless about Excel. I need some help with my Statistics homework so
if you're kind and/or valiant and/or bored enough to hand-hold a
complete idiot through the process, I'll be so absolutely grateful!
Okay, so in this assignment I have a spreadsheet file: Column A has a
series of various numbers:
A1 has 10;
A2 has 30;
A3 has 5;
...and on and on it goes.
1) In this assignment, I have to somehow make column B bring out the
percentage difference from an arbitrary number (in this case 20) to the
numbers in the A column. For instance, since A1 is 10; B1 will have to
be -50% (since 10 is a 50% decrease of 20). And for B2, since A2 is 30,
B2 should generate a 50% in its cell (since 30 is a 50% increase from
20). So how do I make Excel automatically generate the percentage
differences for rest of the B column?
2) So after the B column gets filled out...is there a way for Excel to
determine the probability that a certain percentage will occur, judging
from what's spat out into the B column? For instance, one of the
questions on my assignment asks for the probability that -45% will
happen, judging from what's generated in column B... So how I do I
input a formula/code for Excel to look through what's in the B column
and determine how likely -45% (or any other percentage) happens?
I know there're many ways Excel can figure out probabilities -- so if
you'd be so kind to just hand-hold me through a basic approach, then
mention any other methods that may yield better answers, I can look
them up accordingly.)
(Please don't be mean! If possible, please try to explain all this as
gently and as "step-by-step" as possible -- you know, as if I'm a
complete dunce, because, well, I am.
)Thank you so much for any help and insight you can provide!