ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   forecasting (https://www.excelbanter.com/excel-worksheet-functions/132332-forecasting.html)

AP

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.

bj

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.


Mike Middleton

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.





All times are GMT +1. The time now is 10:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com