Results 1 to 3 of 3

projecting an amount as a normal distribution?

Threaded View

  1. #1
    Registered User
    Join Date
    07-11-2007
    Posts
    22

    projecting an amount as a normal distribution?

    Experts,

    Was wondering if anyone on here can help me with an Excel issue that no one seems to be able to solve.

    in general, I would like to somehow use excel to project a given amount over a set amount of time along a normal distribution.

    as an example, i'd like to project $1M over 12 months with each column representing a month. so, there would be 12 fundings totally $1M. If you were to plot these 12 fundings on a graph, with the months on the x-axis and the fundings on the y-axis, a bell curve would be drawn assuming a best fit line was in place. but, i don't want the graph really, i want the numbers projected.

    any help would be greatly appreciated.

    thanks.
    Last edited by RealEstateFinan; 07-17-2007 at 03:04 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1