Omaha Steaks Which of the following choices best summarizes the strengths and weaknesses of this visualization? The choropleth map does a good job of depicting the geographic distribution of beef cattle in the state of Nebraska. However, the color shading does not provide a distinct enough contrast to identify the counties with the most beef cattle. The choropleth map does a good job indicating the counties containing the most cows in absolute terms. However, there is a tendency for the largest counties to have the most cattle primarily due to their land area, and this can convey a false differentiation in the density of cows in adjacent counties. The use of color clearly shows which counties contain the most beef cattle. However, the large variance in the size of the counties makes it difficult to extract insight from the visualization for all counties. I, ii, and iii are all accurate comment Omaha Steaks (Revisited). In this problem, we revisit the data from Problem 12. As part of a marketing campaign harkening on its company history based on Nebraskas beef industry, Omaha Steaks wants to create a visualization displaying the states geographic distribution of beef cattle. Data on the number of beef cattle in each county in Nebraska and the size of each county are contained in the file NebraskaBeef. Create a choropleth map that shades each county in Nebraska relative to the density of beef cattle (as measured by head per square mile). Compare this visualization to the choropleth map in Problem 12 and describe the strengths and weaknesses. Umbrella Sales. The file Umbrella contains data on the quarterly sales revenue for a manufacturer of umbrellas and other weather-resistant gear. LO 8 Create a line chart for the sales time series data. Add a four-period moving average to the chart to smooth the data. To investigate the possibility of seasonality on a quarterly basis, plot the data as a collection of five data series (one for each year). From this visualization, do you observe any indication of seasonality? If so, describe it. Smartphone Sales. The file Smartphone contains data on the monthly sales revenue for a smartphone manufacturer. Create a line chart to depict the sales time series at the annual level. Create a line chart to depict the sales time series at the quarterly level. Create a line chart to depict the sales time series at the monthly level. What insight do each of these three views provide? Missing Data in Marketing Survey. The file SurveyResults contains the responses from a marketing survey: 108 individuals responded to the survey of 10 questions. Respondents provided answers of 1, 2, 3, 4, or 5 to each question, corresponding to the overall satisfaction on 10 different dimensions of quality. However, not all respondents answered every question. To highlight the missing data values, shade the empty cells in black. For each question, which respondents did not provide answers? Which question has the highest nonresponse rate? Please create ONE Excel workbook with a tab (sheet) for each of the five questions above. Name the tabs 1,2,3,4,5 to correspond with the questions above. Copy/paste the appropriate data file for each question into your workbook. (Original data files can be found in the Readings and Viewings for session 4). Create the charts/maps associated with each question within the same worksheet off to the right side of the data. Submit your completed workbook for this assignment. There should only be ONE Excel workbook submitted that contains all answers to these questions.