I have two questions here; should I sort these states by hand into their proper regions? Additionally; what's the best way to plot it after I sort them? To provide evidence related to the first inquiry, we might consider how the number of breweries has changed over time. • To provide evidence related to the second inquiry, we might examine the number of breweries in different areas of the United States. For example, we could focus on regions with similar populations, like the three below: Northeast: New York, Connecticut, Rhode Island, Massachusetts, Vermont, New Hampshire, and Maine. Southeast: Florida and Georgia. West: California. The Excel file contains only three variables: state postal codes (STATE), year (YEAR), and the number of breweries in a state (BREWERIES). The second step in an examination of these queries might involve plotting statistics related to (1) and (2). For example, we might plot the average number of breweries in the Northeast, Southeast, and West over the last 21 years (2000 through 2020). Deliverable To complete this assignment, please plot the average number of breweries in the Northeast, Southeast, and West over the last 21 years (2000 – 2020). Data for all three regions should be presented in a single graph (proc gplot). The graph should be titled “Breweries by Year”, all data points should be connected with lines, and there should be a “legend” showing the variable or region associated with each colored line. Copy and paste your log and the graph (using snip or other options to capture an image are fine) into a Word document and upload through Canvas. Hint: plotting multiple variables in the same graph is referred to as an “overlay”.
... View more