# GAMMA DISTRIBUTION VALUES

**URL:** <https://community.wolfram.com/t/gamma-distribution-values/2673>\
**Category:** Questions\
**Tags:** chemistry, control-systems, education, engineering\
**Created:** [July 15, 2014, 9:35am UTC](https://community.wolfram.com/t/gamma-distribution-values/2673 "2014-07-15T09:35:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mrnirupa](https://yyz1.discourse-cdn.com/wolfram/user_avatar/community.wolfram.com/mrnirupa/32/3541_2.png) [@mrnirupa](https://community.wolfram.com/u/mrnirupa)\
**Post date:** [July 15, 2014, 9:35am UTC](https://community.wolfram.com/t/gamma-distribution-values/2673/1 "2014-07-15T09:35:54Z")

</div>

p = Plot[Evaluate@  
Table[PDF[GammaDistribution[alpha, beta],  
x], {alpha, {0.001}}, {beta, {14660}}], {x, 0, 100000},  
Filling → Axis]. After this command, when i want to export the data points to excel in the form compatible with the word, i am not getting. I mean when i use the command,  
data = Cases[Normal[p], x\_Line :\> First[x], Infinity];  
data = Flatten[data, 1];  
TableForm[data[[1 ;; 100]]],  
i get the data points but i when i copy paste the values, all the values come as 10^(-6) which is not getting plotted in excel or origin. How do i achieve ths?

---

<div class="post-metadata">

**Author:** ![nma](https://avatars.discourse-cdn.com/v4/letter/n/b5e925/32.png) [@nma](https://community.wolfram.com/u/nma)\
**Post date:** [July 15, 2014, 10:00am UTC](https://community.wolfram.com/t/gamma-distribution-values/2673/2 "2014-07-15T10:00:43Z")

</div>

You should not really by copying and pasting. Use export as in

```
data = Cases[Normal[p], x_Line :> First[x], Infinity]; data = Flatten[data, 1];
SetDirectory[NotebookDirectory[]];
Export["test.xls", data]

```

Now open the file “test.xls” in the same folder as the notebook using excel.

 ![8897Untitled.png](https://global.discourse-cdn.com/wolfram/original/1X/a49b36776cdb503af9521fb7256ef71771c44e8e.png)

---

<div class="post-metadata">

**Author:** ![mrnirupa](https://yyz1.discourse-cdn.com/wolfram/user_avatar/community.wolfram.com/mrnirupa/32/3541_2.png) [@mrnirupa](https://community.wolfram.com/u/mrnirupa)\
**Post date:** [July 15, 2014, 10:54am UTC](https://community.wolfram.com/t/gamma-distribution-values/2673/3 "2014-07-15T10:54:41Z")

</div>

After getting the gamma distribution plot, i am supposed to type the above command and then open the excel file named text.xls? but i am not getting it