Excel Statistics 91: TINV & TDIST functions for Critical Value and P-value 6 examples

Hi Everyone - can any of you help me with this question in my assignment?
I'd be very grateful for any assistance!

. Write a function named PValue(cfs, per, r) that returns the present value of a set of cash flows contained in the range cfs (cfs can be either a row or a column.). The range per contains the periods in which each cash flow occurs (e.g. the first cash flow in cfs occurs in period 2, the second cash flow is in period 5). The discount rate is r per period. Do not use any Excel functions within PValue().

can anybody give me examples on Creating functions and how to code them.

thanks in advance

Hello,

1. Is there any document, that Contains Examples of Each Function and Each Formula in Excel.

2. I saw some person using find and replace option in word with "$" and "#" for removing Characters and Numbers. What my Question is, Is there any other Procedure and tips like the above.

Thanking you in advance.
Waiting for your Kind Reply.

Hi All,

I've created a sheet in which I would like to calculate mean and standard
deviation for a user selected range.

I have a number of ranges of data (arranged in columns and of varying
length) which the user may select.

Once the user has selected a range, I'd like them to be able to click a
button to run a macro that will
display the mean and st.dev. (as a string maybe) in the cell immediately
below and to the right of the lowest
cell selected by the user.

Example, the user selects the range (C24:C31), runs the macro and ends up
with the mean and st.dev. in cell D32.

The output I'm after can be achieved using a formula like,
'="The mean is "&ROUND(AVERAGE(C24:C31),1)&" and the standard deviation is
"&ROUND(STDEV(C24:C31),1)'

Any thoughts ?

TIA,

Neil

The idea behind the design of this spreadsheet is that it logs how many darts you throw for each target, and how many are successful hits you get from those throws. I was also hoping it would add your percentage for each target and display them on a graphic representation of a dartboard.

An example of the input columns for one target would be:
Treble 20 - Throws - Hits - 3 - 2 - 1 - 1 - 2 - 3
Treble 19 - Throws - Hits - 3 - 2 - 1 - 1 - 2 - 3
Treble 18 - Throws - Hits - 3 - 2 - 1 - 1 - 2 - 3

the first 3 - 2 - 1 would be red buttons (which count as a miss) that adds to the amount of throws for the target, but does not add anything to the 'hit' column. The 1 - 2 - 3 buttons would be green, and add the relevant amount to the 'hit' column as well as the 'throws' column.

So lets say I aim at Treble 20, miss with 2 darts and hit with 1 dart, I would click the red button labelled '2' and click the green button labelled '1'. Pressing these buttons would update the columns for darts 'thrown' and 'hit' showing that I've thrown three darts and had one dart on target.

I've got the layout for the above, but I am new at this and don't know what code to add for the buttons. So if you guys could supply me with the code then that is the main purpose of this spreadsheet.

Now for the graphic representation of the board... Excel doesn't seem to have a lot of capabilities with combining data with graphics, but I was basically hoping that my above example which would give a percentage of '33.33%' would be added at the Treble 20 on a graphic of a dart board. Are there any ways of doing this?

Hi,

I currently have a pivot table that returns min(date) and max(date) for each by-group 'Name.' So it looks something like this:


Name Min of Date Max of Date
John 1/1/2000 9/1/2000
Mary 4/1/1999 3/1/2000
Chris 2/1/2000 6/1/2006

Now I would like to create a new field that returns the difference between these two dates for each name. However Min of Date and Max of Date do not show up under Field List when I go into Calculated Field. How could I do it and still stay within the pivot table (i.e. not create a formula outside it)?

Thank you in advance for your help.

Hi

Does anyone know how to get the TDIST function to give me a probability outcome much like the NORMDIST Function?

The information I have includes the sample mean, sample standard deviation and the degrees of freedom.

Thanks.

Although the TDist function is listed in the help files as "workbook functions available in visual basic", in fact, when I go to compile my code, it says "function or sub not available". :x

This is for Excel 2003, SP2 running under Windows XP Professional.

I searched the microsoft knowledge base for 'TDist' but did not find any discussion of the issue.

=IF(G8>=2000,S47,G8/2000*S47)+(((N6+R6)/2)*((IF(G26="RCG",0.05,0)+IF(G28="RCG",0.025,0)))+((V42*0.1)*(G8*1000)))

Assuming:

G8 = 4000
S47 = 2453
N6 = 39000
R6 = 85800
G26 = RCG
G28 = RCG
V42 = 0.62%

Answer should be = 9629

PLZ anybody solve it step by step.

Hi all, I work for a not for profit theatre and I'm trying to put together a calendar that shows the following:

- Show (as what the production name is)
- It's season start date
- A series of actions that need to be undertaken to ensure deadlines are met for marketing etc AND these actions need to occur in sequence working back from the show season start date.

For example, the mailout is to occur 4 weeks prior to the show start date, therefore the cell needs to calculate the date 4 weeks back from 'show start date' which is the ultimate / target date of course. There are a series of about 10 actions that need to occur and they all have set timeframes in place that work back from the show date.

The purpose of this spreadsheet is to have a resource that can be used on a weekly basis to show where things need to be for each show. I am using Excel 2003.

I appreciate any assistance on this, I for the life of me cannot work it out alone!!

Tim