Activity 1 This activity demonstrates how to create graphics to enhance the presentation of quantitative data...

Activity 1

This activity demonstrates how to create graphics to enhance the presentation of quantitative data

Scenario

The sales manager for a small manufacturer is interested in marketing the company's rain coat line in a new area of the country. As a first step to establishing a marketing plan she has asked you to produce some graphs showing the market share of the products sold over the past several years in the region.

Analysis

After some research, you acquire the approximate sales for each of the competing products presently in the region under consideration (See the data given below). The question now is to show how best to organize the data to take advantage of a graphical analysis. Pie charts give a quick overview of the market share "slices” each competitor presently enjoys. So you decide to use a pie chart to graph the most recent year's sales data for the region. This will give a good indication of just who the market leaders are and how crowded it is at the top.

Next, you decide to graph the sales for the products over the three-year period available. Multiple bar charts can display several sets of data but are hard to read. Stacked bar charts have the advantage of showing clearly how parts of a whole change over time. In this case, the parts are different company rain coat sales and the whole is the total sales for the region. Thus, a stacked bat chart can be used to show how market shares of this total market vary over time.

Finally, the single bar chart excels in showing how single factors, like total market sales, change over equal periods of time. Armed with this information, you set off to create the desired graphs.

TASK A:

Create a spreadsheet with the data shown below.
Produce and print a pie chart showing the percentage of sales each product currently holds. When including a title, it is desirable to use all capitalized letters for the first title and upper and lower case for the second. Use the given titles.

MARKET SHARE ANALYSIS
2005 SALES
COMPANY	PRODUCT	ANNUAL SALES
Good Week	Rain coat with added Hood	40,000
Fire Rock	Rain Poncho	90,000
Big Blue	Rain pants and shirt	28,000
Air Tight	Rain Coat with detachable hood	45,000

TASK B:

From the data below, produce a stacked bar chart showing the market share of sales each product enjoyed for the three years.
Add the appropriate titles, data labels and horizontal and vertical grids for clarity.

PRODUCT	YEAR1	YEAR2	YEAR3
Rain coat with added Hood	20,000	32,000	40,000
Rain Poncho	87,000	93,000	90,000
Rain pants and shirt	54,000	43,000	28,000
Rain Coat with detachable hood	40,000	48,000	45,000

3. Graph the total sales for each year from the data given. Use a line graph to display the results. Format the sales figures in dollars and add appropriate titles.

Solutions

Expert Solution

Task A

Put the data in excel has shown. Inorder get the names of the products in the upper case and lower case, we use the next table. The formulas are shown of how the new name is made.

Highlight the new name and the values and insert the pie chart.

Task B

Put the data in excel, highlight it and insert the stalk graph as shown.

orchestra answered 1 year ago

Next > < Previous

Related Solutions

CREATE A NEW Java PROGRAM that demonstrates : 1.1 numeric and 1 string exception 2. Create...

CREATE A NEW Java PROGRAM that demonstrates : 1.1 numeric and 1 string exception 2. Create your own user defined exception, COMMENT it well, and add code so that it is thrown.

1. This activity investigates the production of glucose on a small scale. The following analysis demonstrates...

1. This activity investigates the production of glucose on a small scale. The following analysis demonstrates what it would take to scale up the operation a. The test stripes measure the concentration of glucose in solution in milligrams per deciliter (mg/dL). There are 100 mL per deciliter. Calculate how many milligrams of glucose are produced in 10 mL of solution if the test strip reads 1000 mg/dL. Hint: Be sure to use conversion factors and keep track of units. b....

Create a simple “how-to” presentation. Describe how you would present the "How-To" to an audience.

1. CREATE a brief critical incident scenario that demonstrates A. Effective issuing of orders and directions,...

1. CREATE a brief critical incident scenario that demonstrates A. Effective issuing of orders and directions, and B.) Effective Command Presence. 2. IDENTIFY at what specific events, during the created critical incident, where two (2) Acute Critical Stress Symptoms and two (2) Delayed Critical Stress Symptoms are found. Please use and list credible APA resource and cite them, at least two. Thank you

1. CREATE a brief critical incident scenario that demonstrates A. Effective issuing of orders and directions,...

Given the following program readline.cpp and the data file e2_input.txt: // Program readline.cpp demonstrates how to...

Given the following program readline.cpp and the data file e2_input.txt: // Program readline.cpp demonstrates how to read a line of text from a file #include <iostream> #include <fstream> #include <string> using namespace std; int main() { string str1, str2, str3, str4; // declares 4 variables ifstream inData; // declares input stream ofstream outData; // declares output stream inData.open("e2_input.txt"); // binds program variable inData to the input file "input.txt" outData.open("e2_output.txt"); // binds program variable outData to the output file "output.txt" //...

How do banks create money and how does that compares to the Federal Reserves Quantitative Easing...

How do banks create money and how does that compares to the Federal Reserves Quantitative Easing experiment that saved the U.S. and European economies from a deeper recession and/or depression at the end of the great recession of 2008 - 2009.

Create a presentation on how technology has affected the field of health care, specifically insurance and...

Create a presentation on how technology has affected the field of health care, specifically insurance and reimbursement. Your presentation should include 10-12 slides, not including a title and summary slide. Cover how computers have affected all of the following: Medical health records HIPAA regulations Insurance claims Accounting done in the medical office (e.g. pegboard system versus current methods of financial management) Ethical considerations related to technology Your presentation should include relevant graphics (images, diagrams, etc.) and bullet points on the...

Develop a presentation sharing how the data collected in the tool is driven by physiological and...

Develop a presentation sharing how the data collected in the tool is driven by physiological and psychological concepts

Activity 2 Record your data from Activity 1 in the boxes below. Place the data (turbidity...

Activity 2 Record your data from Activity 1 in the boxes below. Place the data (turbidity value, appearance) for the samples in the appropriate columns (clean standard, maximum load, standard, sample 1, sample 2, sample 3) The following information will be needed to make your conclusion -- In the region of the United States you are investigating, the allowable standards of turbidity are: Drinking water is 0.3 NTU Water for irrigation and industrial use 5 NTU Water released into...

Subjects