Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 16th 05, 05:38 PM
Yenabi
 
Posts: n/a
Default How do I group data using defined ranges?

I would like advice as to how I can group data together using my own defined
ranges. I want to form a graph that will allow me to represent the number of
data points which fall into certain ranges of intensity. I would like to
have the number of objects which fall in the range to be on the x-axis and
the range scale to be on the y-axis. I cannot figure out how to do this
using an excel function rather than doing the calculations manually. I'm
using Microsoft Office 2003 on Windows XP.

  #2   Report Post  
Old May 16th 05, 06:31 PM
William
 
Posts: n/a
Default

Hi Yenabi

1) I am assuming your current net income cells are in the range B8:F8
2) Enter (without inverted commas) "1" in cell H14
3) Enter the formula =B$8 in cell B14
4) Enter the formula =C$8*$H14 in cell C14
5) Copy cell C14 to D14:H14
6) Enter the formula =IRR(B14:F14) in cell A14

Once you have set this up....
1) Select "ToolsGoal Seek"
2) In the "Set Cell" box enter (without inverteed commas) "A14"
3) In the "To value" box enter the IRR you wish to achieve, say, 0.04 (which
is 4%)
4) In the "By Changing cell" box enter (without inverteed commas) "H14"
5) Click OK.

[You could then copy the range A14:H14 to, say, A15:H20, enter a range of
desired IRRs in cells A15:A20 and repeat the above "goal seek" process for
each row thereby constructing a table showing different cash flows for
different IRRs.]

--


XL2003
Regards

William



"Yenabi" wrote in message
...
I would like advice as to how I can group data together using my own
defined
ranges. I want to form a graph that will allow me to represent the number
of
data points which fall into certain ranges of intensity. I would like to
have the number of objects which fall in the range to be on the x-axis and
the range scale to be on the y-axis. I cannot figure out how to do this
using an excel function rather than doing the calculations manually. I'm
using Microsoft Office 2003 on Windows XP.



  #3   Report Post  
Old May 16th 05, 06:33 PM
William
 
Posts: n/a
Default

Meant to answer a different post - sorry

--


XL2003
Regards

William



"William" wrote in message
...
Hi Yenabi

1) I am assuming your current net income cells are in the range B8:F8
2) Enter (without inverted commas) "1" in cell H14
3) Enter the formula =B$8 in cell B14
4) Enter the formula =C$8*$H14 in cell C14
5) Copy cell C14 to D14:H14
6) Enter the formula =IRR(B14:F14) in cell A14

Once you have set this up....
1) Select "ToolsGoal Seek"
2) In the "Set Cell" box enter (without inverteed commas) "A14"
3) In the "To value" box enter the IRR you wish to achieve, say, 0.04
(which is 4%)
4) In the "By Changing cell" box enter (without inverteed commas) "H14"
5) Click OK.

[You could then copy the range A14:H14 to, say, A15:H20, enter a range of
desired IRRs in cells A15:A20 and repeat the above "goal seek" process for
each row thereby constructing a table showing different cash flows for
different IRRs.]

--


XL2003
Regards

William



"Yenabi" wrote in message
...
I would like advice as to how I can group data together using my own
defined
ranges. I want to form a graph that will allow me to represent the
number of
data points which fall into certain ranges of intensity. I would like to
have the number of objects which fall in the range to be on the x-axis
and
the range scale to be on the y-axis. I cannot figure out how to do this
using an excel function rather than doing the calculations manually. I'm
using Microsoft Office 2003 on Windows XP.







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
IRR data in different ranges GaryF Excel Worksheet Functions 6 April 29th 05 10:54 PM
Group data by weeks not months Daniel Excel Discussion (Misc queries) 1 February 18th 05 12:07 PM
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 06:15 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 06:55 PM
Running Data Table using an input that triggers DDE linked data [email protected] Excel Discussion (Misc queries) 1 December 16th 04 12:56 PM


All times are GMT +1. The time now is 07:01 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017