Valley of the Grape is a show about wine and winemaking that is available on streaming services throughout the United States.

Kleskin & Relouk (K&R), producers of Valley of the Grape, generate revenue from sales of advertising on the show. Advertising sales by state and region (Northeast, South, Midwest, West) for the previous year are available in the file krsales. K&R management wants to receive reports of state-by-state sales for each region. LO 6

a. Produce a subset of the records in the file krsales that include only states in the Northeast region. Save your results as a file under the name krsales_ne.xlsx.

b. Produce a subset of the records in the file krsales that include only states in the South region. Save your results as a file under the name krsales_s.xlsx.

c. Produce a subset of the records in the file krsales that include only states in the Midwest region. Save your results as a file under the name krsales_mw.xlsx.

d. Produce a subset of the records in the file krsales that include only states in the West region. Save your results as a file under the name krsales_w.xlsx.