Hello, I am needing help determining which are the appropriate predictive statistical tests to run to prepare my dataset for predicting future sales for each location. The dataset consists of 24 observations, a month column (independent variable), and 4 different City columns (dependent variables). The values recorded for each city during the observation is the total sales (in dollars). The dataset essentially looks like: Month Dallas Boston NYC Chicago 1 34245 58745 62145 12345 ....... 24 87451 58472 21451 64125 I think a correlation test will be needed to see if there is a relationship between any of the cities and then finally a linear regression model to predict future values of sales at each location. thank you in advance for your assistance!
... View more