close

Hello,

I am trying to create a probability graph. On the x-axis, I would like to
have days (365 days). The Y-axis would represent a volume of liquid (from
0.4 to 32.0L). This water is shipped to a location every 6 days. The water
comes either in 0.4 L, 23.5 L or 32.0 L per shipment. How would you
construct a graph that would visually show this knowing also that you can
only have two consecutive shipments of the same quantity (ie. Shipment 1=0.4,
shipment 2=0.4 but shipment 3 could not equal 0.4).

Thanks so much for your help

Have you tried using the data analysis component of Excel? If not, I would
add that in and put inyour data. Once done you can run any type of
probability analysis you want and then select from the graph options within
the analysis.

quot;Luke Williamsquot; wrote:

gt; Hello,
gt;
gt; I am trying to create a probability graph. On the x-axis, I would like to
gt; have days (365 days). The Y-axis would represent a volume of liquid (from
gt; 0.4 to 32.0L). This water is shipped to a location every 6 days. The water
gt; comes either in 0.4 L, 23.5 L or 32.0 L per shipment. How would you
gt; construct a graph that would visually show this knowing also that you can
gt; only have two consecutive shipments of the same quantity (ie. Shipment 1=0.4,
gt; shipment 2=0.4 but shipment 3 could not equal 0.4).
gt;
gt; Thanks so much for your help

Hi Caerus,

Yes, I have tried using the analysis toolpak and I was told that part of the
graph was created with the Random Number Generator. I have tried just about
everything with the toolpak but have not been able to re-create the graph...
Could I email you a JPEG that shows the graph I am trying to recreate?

Thanks so much!

L.

quot;Caerusquot; wrote:

gt; Have you tried using the data analysis component of Excel? If not, I would
gt; add that in and put inyour data. Once done you can run any type of
gt; probability analysis you want and then select from the graph options within
gt; the analysis.
gt;
gt; quot;Luke Williamsquot; wrote:
gt;
gt; gt; Hello,
gt; gt;
gt; gt; I am trying to create a probability graph. On the x-axis, I would like to
gt; gt; have days (365 days). The Y-axis would represent a volume of liquid (from
gt; gt; 0.4 to 32.0L). This water is shipped to a location every 6 days. The water
gt; gt; comes either in 0.4 L, 23.5 L or 32.0 L per shipment. How would you
gt; gt; construct a graph that would visually show this knowing also that you can
gt; gt; only have two consecutive shipments of the same quantity (ie. Shipment 1=0.4,
gt; gt; shipment 2=0.4 but shipment 3 could not equal 0.4).
gt; gt;
gt; gt; Thanks so much for your help

shot it to me. will try to help.

quot;Luke Williamsquot; wrote:

gt; Hi Caerus,
gt;
gt; Yes, I have tried using the analysis toolpak and I was told that part of the
gt; graph was created with the Random Number Generator. I have tried just about
gt; everything with the toolpak but have not been able to re-create the graph...
gt; Could I email you a JPEG that shows the graph I am trying to recreate?
gt;
gt; Thanks so much!
gt;
gt; L.
gt;
gt; quot;Caerusquot; wrote:
gt;
gt; gt; Have you tried using the data analysis component of Excel? If not, I would
gt; gt; add that in and put inyour data. Once done you can run any type of
gt; gt; probability analysis you want and then select from the graph options within
gt; gt; the analysis.
gt; gt;
gt; gt; quot;Luke Williamsquot; wrote:
gt; gt;
gt; gt; gt; Hello,
gt; gt; gt;
gt; gt; gt; I am trying to create a probability graph. On the x-axis, I would like to
gt; gt; gt; have days (365 days). The Y-axis would represent a volume of liquid (from
gt; gt; gt; 0.4 to 32.0L). This water is shipped to a location every 6 days. The water
gt; gt; gt; comes either in 0.4 L, 23.5 L or 32.0 L per shipment. How would you
gt; gt; gt; construct a graph that would visually show this knowing also that you can
gt; gt; gt; only have two consecutive shipments of the same quantity (ie. Shipment 1=0.4,
gt; gt; gt; shipment 2=0.4 but shipment 3 could not equal 0.4).
gt; gt; gt;
gt; gt; gt; Thanks so much for your help

Would like to but I cannot attach a JPEG with this forum - what is your email
address?

quot;Caerusquot; wrote:

gt; shot it to me. will try to help.
gt;
gt; quot;Luke Williamsquot; wrote:
gt;
gt; gt; Hi Caerus,
gt; gt;
gt; gt; Yes, I have tried using the analysis toolpak and I was told that part of the
gt; gt; graph was created with the Random Number Generator. I have tried just about
gt; gt; everything with the toolpak but have not been able to re-create the graph...
gt; gt; Could I email you a JPEG that shows the graph I am trying to recreate?
gt; gt;
gt; gt; Thanks so much!
gt; gt;
gt; gt; L.
gt; gt;
gt; gt; quot;Caerusquot; wrote:
gt; gt;
gt; gt; gt; Have you tried using the data analysis component of Excel? If not, I would
gt; gt; gt; add that in and put inyour data. Once done you can run any type of
gt; gt; gt; probability analysis you want and then select from the graph options within
gt; gt; gt; the analysis.
gt; gt; gt;
gt; gt; gt; quot;Luke Williamsquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Hello,
gt; gt; gt; gt;
gt; gt; gt; gt; I am trying to create a probability graph. On the x-axis, I would like to
gt; gt; gt; gt; have days (365 days). The Y-axis would represent a volume of liquid (from
gt; gt; gt; gt; 0.4 to 32.0L). This water is shipped to a location every 6 days. The water
gt; gt; gt; gt; comes either in 0.4 L, 23.5 L or 32.0 L per shipment. How would you
gt; gt; gt; gt; construct a graph that would visually show this knowing also that you can
gt; gt; gt; gt; only have two consecutive shipments of the same quantity (ie. Shipment 1=0.4,
gt; gt; gt; gt; shipment 2=0.4 but shipment 3 could not equal 0.4).
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks so much for your help



quot;Luke Williamsquot; wrote:

gt; Would like to but I cannot attach a JPEG with this forum - what is your email
gt; address?
gt;
gt; quot;Caerusquot; wrote:
gt;
gt; gt; shot it to me. will try to help.
gt; gt;
gt; gt; quot;Luke Williamsquot; wrote:
gt; gt;
gt; gt; gt; Hi Caerus,
gt; gt; gt;
gt; gt; gt; Yes, I have tried using the analysis toolpak and I was told that part of the
gt; gt; gt; graph was created with the Random Number Generator. I have tried just about
gt; gt; gt; everything with the toolpak but have not been able to re-create the graph...
gt; gt; gt; Could I email you a JPEG that shows the graph I am trying to recreate?
gt; gt; gt;
gt; gt; gt; Thanks so much!
gt; gt; gt;
gt; gt; gt; L.
gt; gt; gt;
gt; gt; gt; quot;Caerusquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Have you tried using the data analysis component of Excel? If not, I would
gt; gt; gt; gt; add that in and put inyour data. Once done you can run any type of
gt; gt; gt; gt; probability analysis you want and then select from the graph options within
gt; gt; gt; gt; the analysis.
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Luke Williamsquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Hello,
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; I am trying to create a probability graph. On the x-axis, I would like to
gt; gt; gt; gt; gt; have days (365 days). The Y-axis would represent a volume of liquid (from
gt; gt; gt; gt; gt; 0.4 to 32.0L). This water is shipped to a location every 6 days. The water
gt; gt; gt; gt; gt; comes either in 0.4 L, 23.5 L or 32.0 L per shipment. How would you
gt; gt; gt; gt; gt; construct a graph that would visually show this knowing also that you can
gt; gt; gt; gt; gt; only have two consecutive shipments of the same quantity (ie. Shipment 1=0.4,
gt; gt; gt; gt; gt; shipment 2=0.4 but shipment 3 could not equal 0.4).
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Thanks so much for your help

Send me your e-mail again.

quot;Luke Williamsquot; wrote:

gt; Would like to but I cannot attach a JPEG with this forum - what is your email
gt; address?
gt;
gt; quot;Caerusquot; wrote:
gt;
gt; gt; shot it to me. will try to help.
gt; gt;
gt; gt; quot;Luke Williamsquot; wrote:
gt; gt;
gt; gt; gt; Hi Caerus,
gt; gt; gt;
gt; gt; gt; Yes, I have tried using the analysis toolpak and I was told that part of the
gt; gt; gt; graph was created with the Random Number Generator. I have tried just about
gt; gt; gt; everything with the toolpak but have not been able to re-create the graph...
gt; gt; gt; Could I email you a JPEG that shows the graph I am trying to recreate?
gt; gt; gt;
gt; gt; gt; Thanks so much!
gt; gt; gt;
gt; gt; gt; L.
gt; gt; gt;
gt; gt; gt; quot;Caerusquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Have you tried using the data analysis component of Excel? If not, I would
gt; gt; gt; gt; add that in and put inyour data. Once done you can run any type of
gt; gt; gt; gt; probability analysis you want and then select from the graph options within
gt; gt; gt; gt; the analysis.
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Luke Williamsquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Hello,
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; I am trying to create a probability graph. On the x-axis, I would like to
gt; gt; gt; gt; gt; have days (365 days). The Y-axis would represent a volume of liquid (from
gt; gt; gt; gt; gt; 0.4 to 32.0L). This water is shipped to a location every 6 days. The water
gt; gt; gt; gt; gt; comes either in 0.4 L, 23.5 L or 32.0 L per shipment. How would you
gt; gt; gt; gt; gt; construct a graph that would visually show this knowing also that you can
gt; gt; gt; gt; gt; only have two consecutive shipments of the same quantity (ie. Shipment 1=0.4,
gt; gt; gt; gt; gt; shipment 2=0.4 but shipment 3 could not equal 0.4).
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Thanks so much for your help

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()