Jump to content

Air Quality Regression Forecasting Model


StormChaser02

Recommended Posts

This is a major shot in the dark but I was hoping there could be someone who could assist.  I am an air quality forecaster that uses an in-house air quality forecast model that uses regression statistics.  The model was developed well before I arrived so when it comes to the inner workings of it, I am still figuring things out.  Anyway, there is a formula (which I will post below) that converts the NOAA AQI into a forecast concentration (ppb) and while I recognize the formula, there are a few numbers (in BOLD) I dont recognize.  I dont know if they are widely used constants or are specific to this mode, in which case this is pointless even post. Any assistance would be greatly appreciated. 

=ROUND(IF(B3<51,B3/0.92593,IF(B3<101,55+(B3-51)/3.26667,IF(B3<151,71+(B3-101)/3.5,IF(B3<201,86+(B3-151)/2.5789,106+(B3-201)/1.0532)))),0)

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...