Constructing a p chart for given data using excel
Not what you're looking for?
Researchers at Miami University in Oxford, Ohio, investigated the use of charts to monitor the market share of a product and to document the effectiveness of marketing promotions, Market share is defined as the company's proportion of the total number of products sold in a category. If a p chart based on a company's market share indicates an in process, then the company's share in the market is deemed to be stable and consistent over time. In the example given in the article, the RudyBird Disk Company collected daily daily sales data from a nationwide retail audit service. The first 30 days of data in the accompanying table (see the attachment) indicate the total number of cases of computer disks sold and the number of RudyBird disks sold. The final 7 days of data were taken after RudyBird launched a major in-store promotion. A control chart was used to see if the in-store promotion would result in special cause variation in the marketplace.
a. Construct a p chart, using data from the first 30 days (prior to the promotion) to monitor the market share for RudyBird disks.
b. Is the market share for RudyBird in control before the start of the in-store promotion?
c. On your control chart, extend the control limits generated in (b) and plot the proportions for days 31 through 37. What effect, if any, did the in-store promotion have on RudyBird's market share?
Purchase this Solution
Solution Summary
The solution gives detailed steps on constructing p chart for given data using excel and performs a short analysis.
Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.