#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AP AP is offline
external usenet poster
 
Posts: 11
Default forecasting

Hi,

I want to forecast the potential risk of malaria by using the forecasted
values of temperature and rainfall changes. I'm not sure how to do this since
i have a temperature range of 1-5 degrees and want to see the effect this can
have.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default forecasting

How is your model set up?

"AP" wrote:

Hi,

I want to forecast the potential risk of malaria by using the forecasted
values of temperature and rainfall changes. I'm not sure how to do this since
i have a temperature range of 1-5 degrees and want to see the effect this can
have.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 762
Default forecasting

AP -

First, "look at the data." Use XY (Scatter) charts. Plot "potential risk" on
the Y axis and temperature on the X axis. Also, plot "potential risk" on the
Y axis and rainfall changes on the X axis. If linear fits seem appropriate,
use the Regression tool to see how "potential risk" is related to
temperature and rainfall changes. If linear fits are not appropriate, post
back for more assistance (or buy my book).

- Mike
http://www.mikemiddleton.com

"AP" wrote in message
...
Hi,

I want to forecast the potential risk of malaria by using the forecasted
values of temperature and rainfall changes. I'm not sure how to do this
since
i have a temperature range of 1-5 degrees and want to see the effect this
can
have.



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
Forecasting november678x Charts and Charting in Excel 3 May 10th 06 10:26 PM
Forecasting Gregc. Charts and Charting in Excel 1 February 10th 06 10:15 AM
Forecasting KrunoG Excel Worksheet Functions 0 February 1st 06 08:36 PM
Forecasting BlockNinja Excel Discussion (Misc queries) 2 December 13th 05 06:10 AM
Forecasting tojo107 Excel Discussion (Misc queries) 0 November 16th 05 04:33 PM


All times are GMT +1. The time now is 07:24 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"