37. Forecast the number of patients expected for a specific month. Hint: Use simple regression unless you have access to a time series analyzer.
SELECT Format([VisitDate],"yyyy-mm") AS YearMonth, Count(Visit.PatientID) AS CountOfPatientID
FROM Visit
GROUP BY Format([VisitDate],"yyyy-mm");
Not enough data to use time series analysis, so go with a simple forecast. Your numbers might be slightly different.
| YearMonth | CountOfPatientID |
|---|---|
| 2010-01 | 1244 |
| 2010-02 | 1161 |
| 2010-03 | 1393 |
| 2010-04 | 1148 |
| 2010-05 | 1339 |
| 2010-06 | 1160 |
| 2010-07 | 1157 |
| 2010-08 | 880 |
| 2010-09 | 1073 |
| 2010-10 | 1180 |
| 2010-11 | 1151 |
| 2010-12 | 660 |
| 2011-01 | 907 |
| 2011-02 | 873 |
| 2011-03 | 839 |