Results 1 to 4 of 4

Thread: simulating actual values from average values

  1. #1

    Thread Starter
    New Member
    Join Date
    Mar 2007
    Posts
    5

    simulating actual values from average values

    i am having the average min temperature, max temperature, average temperature values for each month i.e from jan to dec. now i want to findout the min tempearature, max temperature, average temperature for each day and temperature for each hour. is there any mathematical approch? can any one help me

    thanking you

  2. #2
    Frenzied Member zaza's Avatar
    Join Date
    Apr 2001
    Location
    Borneo Rainforest Habits: Scratching
    Posts
    1,486

    Re: simulating actual values from average values

    Welcome to the Forums




    In a word, No. You can't take max, min and average data for a month and extract from that data for a day or an hour. There are any number of ways in which the data points could be arranged, so you couldn't say "On the 1st, the average was this and the max/min was that".

    The average for the month is the average for all the days in that month, and that's as much data as you have I'm afraid.



    zaza
    I use VB 6, VB.Net 2003 and Office 2010



    Code:
    Excel Graphing | Excel Timer | Excel Tips and Tricks | Add controls in Office | Data tables in Excel | Gaussian random number distribution (VB6/VBA,VB.Net) | Coordinates, Vectors and 3D volumes

  3. #3

    Thread Starter
    New Member
    Join Date
    Mar 2007
    Posts
    5

    Re: simulating actual values from average values

    i agree with you, but atleast is there any way to find the diffrenet combinations which satiesfys the average values.

  4. #4
    I'm about to be a PowerPoster!
    Join Date
    Jan 2005
    Location
    Everywhere
    Posts
    13,647

    Re: simulating actual values from average values

    If you can feed the values you have into a formula that fits the temperature fluctuation within a month reasonably accurately, then yes. Otherwise, no.

Posting Permissions

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



Click Here to Expand Forum to Full Width