Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default how to calculate histogram from yearly dataset

How do I calcualte histogram of yearly dataset and compute the probability of
distribution of the data. For example:
Year Value
1920 311.9
1921 146.6
1922 339.6
1923 113.3
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default how to calculate histogram from yearly dataset

Refer
http://office.microsoft.com/en-us/ex...109481033.aspx

--
Jacob (MVP - Excel)


"Samson" wrote:

How do I calcualte histogram of yearly dataset and compute the probability of
distribution of the data. For example:
Year Value
1920 311.9
1921 146.6
1922 339.6
1923 113.3

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I was creating a histogram; now i have data but no histogram. ShannonMills3 Excel Worksheet Functions 0 June 14th 06 12:03 AM
How do I calculate the cost of credit figured as a yearly rate? Hottea11 Excel Worksheet Functions 2 April 6th 06 08:34 PM
How to Histogram w/o raw data but histogram Table on Excel 2005 Charts and Charting in Excel 1 February 1st 06 06:48 AM
How to calculate average from large dataset in several sheets? Orf Excel Worksheet Functions 2 December 12th 05 10:59 AM
importing dataset beyond 256 columns Arturo Excel Discussion (Misc queries) 1 December 17th 04 03:55 PM


All times are GMT +1. The time now is 05:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"