1.Bay Side Manufacturing produces small leather goods such as wallets, travel organizers, toiletry kits, briefcases, and folios. The company has a 16% share in the U.S. travel organizers market, but management is concerned that its market share in the southeastern United States lags behind its national share. Bay Side’s monthly share of the travel organizers market for the past year in 15 major cities in the southeastern United States is provided in the file bayside_stacked. A portion of the data is shown in the following table.
| Market Share | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Jan | Feb | Mar | Apr | Nov | Dec | |||||
| Atlanta | 0.142 | 0.145 | 0.137 | 0.152 | … | 0.132 | 0.152 | |||
| Baltimore | 0.172 | 0.199 | 0.177 | 0.189 | … | 0.181 | 0.185 | |||
| Baton Rouge | 0.133 | 0.084 | 0.137 | 0.123 | … | 0.144 | 0.097 | |||
| Birmingham | 0.087 | 0.105 | 0.105 | 0.096 | … | 0.118 | 0.121 | |||
| Charlotte | 0.088 | 0.112 | 0.094 | 0.100 | … | 0.069 | 0.077 | |||
| Jacksonville | 0.188 | 0.188 | 0.190 | 0.173 | … | 0.197 | 0.185 | |||
| Louisville | 0.217 | 0.214 | 0.164 | 0.190 | … | 0.189 | 0.192 | |||
| Memphis | 0.107 | 0.115 | 0.132 | 0.111 | … | 0.125 | 0.115 | |||
| Miami | 0.162 | 0.158 | 0.158 | 0.157 | … | 0.180 | 0.169 | |||
| Nashville | 0.053 | 0.054 | 0.074 | 0.081 | … | 0.083 | 0.099 | |||
| New Orleans | 0.129 | 0.161 | 0.159 | 0.189 | … | 0.194 | 0.155 | |||
| Raleigh | 0.156 | 0.188 | 0.162 | 0.150 | … | 0.190 | 0.191 | |||
| Richmond | 0.178 | 0.156 | 0.183 | 0.157 | … | 0.158 | 0.145 | |||
| Tampa | 0.119 | 0.115 | 0.108 | 0.145 | … | 0.144 | 0.110 | |||
| Virginia Beach | 0.172 | 0.174 | 0.129 | 0.166 | … | 0.164 | 0.191 | |||
| Washington, DC | 0.232 | 0.241 | 0.204 | 0.191 | … | 0.207 | 0.243 | |||
Use these data to create a heat map of Bay Side’s monthly share of the travel organizers market for these 15 southeastern U.S. cities. (Hint: Format the Month column as a date.)
Use a three color scale from red to white to blue, so that red corresponds to market shares less than 16%, blue corresponds to market shares greater than 16%, and the color grows darker as the deviation of the market share from 16% increases in either direction.
Hint: From the Background color dialog box in the Cell elements menu item, use the following settings.
Set the Minimum color to red and the Maximum color to blue.
Check the Add a middle color check box.
Select Custom from the Center drop-down menu.
Select the color white to the right of the Center drop-down menu.
- Set the Minimum color to red and the Maximum color to blue.
- Check the Add a middle color check box.
- Select Custom from the Center drop-down menu.
- Select the color white to the right of the Center drop-down menu.
- Enter 0.16 in the box below the Center drop-down menu.
What message will this map communicate to an audience?
The map communicates that the southeastern U.S. Bay Side’s share of the travel organizers market is generally Below the national 16% level. There also Does not appear to be a seasonal pattern to these market shares.
Will this chart be difficult for colorblind audience members to visually process? Explain.
1. This heat map uses shades of red and blue, which is not a type of colorblindness, but the colors chosen are similar enough in hue that it may be difficult to distinguish between the two.
2. This heat map uses shades of red and blue, which is not a type of colorblindness, so the audience members will be able to visually process this chart.
3. This heat map uses shades of red and blue, which is a type of colorblindness; even though the percentage of market share is also shown an audience member who is red-blue colorblind may have difficulty visually processing this chart.
A. ( ii )
2. The 18–49 age group is an extremely lucrative demographic for television networks. Advertisers pay a premium to reach consumers in this age group with their advertising. The following bar chart shows the number of viewers in millions that the top 10 scripted series averaged during the 2019–2020 television season.
It is also important for this graph to show which television network broadcasts each show. The networks that broadcast these shows are:
1. ABC: The Good Doctor,Modern Family,Grey’s Anatomy
2. CBS: Young Sheldon,NCIS
3. NBC: New Amsterdam,Chicago Med,Chicago Fire,Chicago PD,This Is Us
Use color to add this information to the original bar chart, which is provided in the file top10TV2020visual. (Use blue (Hue = 148, Sat = 255, Lum = 152 or Red = 49, Green = 157, Blue = 255) for ABC shows, green (Hue = 104, Sat = 255, Lum = 180 or Red = 105, Green = 255, Blue = 173) for CBS shows, and red (Hue = 0, Sat = 255, Lum = 100 or Red = 200, Green = 0, Blue = 0) for NBC shows.) Will your chart be difficult for colorblind audience members to visually process? Explain.
By differentiating between the networks by using different Hues and levels of luminance, we create a chart that Should not be difficult for colorblind audience members to visually process.
3. Pet Fare, Inc. produces high-end refrigerated pet food and ships it anywhere in the United States. Total Pet Fare sales of cat food and dog food by state for the previous year are given in the file catsanddogs.
(a)Create a geographic information system (GIS) map that uses a sequential color scheme to represent total Pet Fare cat food sales by state. Use orange for the color for this choropleth map.
Hint: To apply the sequential orange color scheme, use the following steps.
1. Click anywhere on the chart.
2. In the Visualizations pane, click the Format visual button.
3. Expand Fill colors.
4. In the Colors dialog box, set the Minimum color to a light orange and the Maximum color to a dark orange.
5. Set the Minimum numeric value to 5,238 and the Maximum numeric value to 74,108.
What information does this chart convey to the audience?
(b) Create a geographic information system (GIS) map that uses a sequential color scheme to represent total Pet Fare dog food sales by state. Use a light blue for the Minimum color and a dark blue for the Maximum color, and set the Minimum and Maximum values to 5,371 and 198,703, respectively, for this choropleth map. What information does this chart convey to the audience?
(C ) Create a scatter chart that enables the audience to better understand the relationship between total cat food sales and total dog food sales for the states. What does this chart tell you about the relationship between total cat food sales and total dog food sales?
The relationship between total cat food sales and total dog food sales is Positive . Higher sales in one category generally coincide with Higher sales in the other category.
(d) Use color to highlight Wyoming in the scatter chart from part (c).
Hint: To apply a different color to the point for Wyoming, use the following steps.
1. Click anywhere on the chart.
2. In the Visualizations pane, click the Format visual button.
3. Expand Markers and then Color.
4. Toggle Show all to On.
5. Set the point ($5,238, $9,893) to orange.
6. To add a label to this point, click the Insert tab on the Ribbon. Click the Text box button on the Elements group. Enter “WY” into the text box and position the text box near the orange point.
What does this chart tell you about total cat food sales and total dog food sales in Wyoming relative to the other states?
Wyoming is near the bottom of cat food sales and near the bottom of dog food sales.
(e) What inherent weaknesses do you see in the analysis performed in parts (a)–(c)? (Hint: Consider the disparities in the sizes of the statewide markets.)
Both cat food sales and dog food sales are generally highest in highly populated states.
How could you address these issues?
1. Data on the cat and dog populations of each state could be used to calculate dollars per capita for the cat and dog populations for each state.
2. States could be grouped by region and each region could have a different color to draw attention to any geographic patterns in the data.
3. A bubble chart could be created with the same axes as the chart in part (c), and the size of the bubbles could be used to show relative populations of the corresponding states.
A: ( i, ii, or iii )