Pelican Stores, a division of National Clo
Hi please find the attached documents and write statistical report using excel. Please see Statisticalpapereport file for examples how to write
Project One:
Pelican Stores, a division of National Clothing, is a chain of women’s apparel stores operating throughout the country. The chain recently ran a promotion in which discount coupons were sent to customers of other National Clothing stores. Data collected for a sample of 100 in-store credit card transactions at Pelican Stores during one day while the promotion was running are contained in the DATAfile named PelicanStores. The Proprietary Card method of payment refers to charges made using a National Clothing charge card. Customers who made a purchase using a discount coupon are referred to as promotional customers, and customers who made a purchase but did not use a discount coupon are referred to as regular customers. Because the promotional coupons were not sent to regular Pelican Stores customers, management considers the sales made to people presenting the promotional coupons as sales it would not otherwise make. Of course, Pelican also hopes that the promotional customers will continue to shop at its stores.
Most of the variables shown in the data file “Pelican Store” are self-explanatory, but two of the variables require some clarification.
Items |
The total number of items purchased |
Net Sales |
The total amount ($) charged to the credit card |
Pelican’s management would like to use this sample data to learn about its customer base and to evaluate the promotion involving discount coupons.
Managerial Report
Use the tabular and graphical methods of descriptive statistics to help management develop a customer profile and to evaluate the promotional campaign. At a minimum, your report should include the following:
1. Percent frequency distribution for key variables.
2. A bar chart or pie chart showing the number of customer purchases attributable to the method of payment.
3. A cross tabulation of type of customer (regular or promotional) versus net sales. Comment on any similarities or differences present.
4. A scatter diagram to explore the relationship between net sales and customer age.
5. Descriptive statistics on net sales and descriptive statistics on net sales by various classifications of customers.
6. Provide a five-number summary and show the box plot for the net sales.
7. Descriptive statistics concerning the relationship between age and net sales.
,
&UnStack
&DataIndices
&DataCopy
&GraphData
&WorkArea
&Miscel_Area
Data
Customer | Type of Customer | Items | Net Sales | Method of Payment | Gender | Marital Status | Age |
1 | Regular | 1 | 39.50 | Discover | Male | Married | 32 |
2 | Promotional | 1 | 102.40 | Proprietary Card | Female | Married | 36 |
3 | Regular | 1 | 22.50 | Proprietary Card | Female | Married | 32 |
4 | Promotional | 5 | 100.40 | Proprietary Card | Female | Married | 28 |
5 | Regular | 2 | 54.00 | MasterCard | Female | Married | 34 |
6 | Regular | 1 | 44.50 | MasterCard | Female | Married | 44 |
7 | Promotional | 2 | 78.00 | Proprietary Card | Female | Married | 30 |
8 | Regular | 1 | 22.50 | Visa | Female | Married | 40 |
9 | Promotional | 2 | 56.52 | Proprietary Card | Female | Married | 46 |
10 | Regular | 1 | 44.50 | Proprietary Card | Female | Married | 36 |
11 | Regular | 1 | 29.50 | Proprietary Card | Female | Married | 48 |
12 | Promotional | 1 | 31.60 | Proprietary Card | Female | Married | 40 |
13 | Promotional | 9 | 160.40 | Visa | Female | Married | 40 |
14 | Promotional | 2 | 64.50 | Visa | Female | Married | 46 |
15 | Regular | 1 | 49.50 | Visa | Male | Single | 24 |
16 | Promotional | 2 | 71.40 | Proprietary Card | Male | Single | 36 |
17 | Promotional | 3 | 94.00 | Proprietary Card | Female | Single | 22 |
18 | Regular | 3 | 54.50 | Discover | Female | Married | 40 |
19 | Promotional | 2 | 38.50 | MasterCard | Female | Married | 32 |
20 | Promotional | 6 | 44.80 | Proprietary Card | Female | Married | 56 |
21 | Promotional | 1 | 31.60 | Proprietary Card | Female | Single | 28 |
22 | Promotional | 4 | 70.82 | Proprietary Card | Female | Married | 38 |
23 | Promotional | 7 | 266.00 | American Express | Female | Married | 50 |
24 | Regular | 2 | 74.00 | Proprietary Card | Female | Married | 42 |
25 | Promotional | 2 | 39.50 | Visa | Male | Married | 48 |
26 | Promotional | 1 | 30.02 | Proprietary Card | Female | Married | 60 |
27 | Regular | 1 | 44.50 | Proprietary Card | Female | Married | 54 |
28 | Promotional | 5 | 192.80 | Proprietary Card | Female | Single | 42 |
29 | Promotional | 3 | 71.20 | Proprietary Card | Female | Married | 32 |
30 | Promotional | 1 | 18.00 | Proprietary Card | Female | Married | 70 |
31 | Promotional | 2 | 63.20 | MasterCard | Female | Married | 28 |
32 | Regular | 1 | 75.00 | Proprietary Card | Female | Married | 52 |
33 | Promotional | 3 | 63.20 | Proprietary Card | Female | Married | 44 |
34 | Regular | 1 | 40.00 | Proprietary Card | Female | Married | 34 |
35 | Promotional | 5 | 105.50 | MasterCard | Female | Married | 56 |
36 | Regular | 1 | 29.50 | MasterCard | Male | Single | 36 |
37 | Regular | 2 | 102.50 | Visa | Female | Single | 42 |
38 | Promotional | 6 | 117.50 | Proprietary Card | Female | Married | 50 |
39 | Promotional | 5 | 13.23 | Proprietary Card | Female | Married | 44 |
40 | Regular | 2 | 52.50 | Proprietary Card | Female | Married | 58 |
41 | Promotional | 13 | 198.80 | Proprietary Card | Female | Married | 42 |
42 | Promotional | 4 | 19.50 | Visa | Female | Married | 46 |
43 | Regular | 2 | 123.50 | Proprietary Card | Female | Married | 48 |
44 | Promotional | 1 | 62.40 | Proprietary Card | Female | Married | 54 |
45 | Promotional | 2 | 23.80 | Proprietary Card | Female | Married | 38 |
46 | Promotional | 2 | 39.60 | Proprietary Card | Female | Married | 60 |
47 | Regular | 1 | 25.00 | MasterCard | Female | Married | 46 |
48 | Promotional | 3 | 63.64 | Proprietary Card | Female | Married | 30 |
49 | Promotional | 1 | 14.82 | Proprietary Card | Female | Married | 32 |
50 | Promotional | 9 | 145.20 | MasterCard | Female | Married | 46 |
51 | Promotional | 6 | 176.62 | Proprietary Card | Female | Married | 38 |
52 | Promotional | 5 | 118.80 | Proprietary Card | Male | Married | 68 |
53 | Regular | 1 | 58.00 | Discover | Female | Single | 78 |
54 | Regular | 2 | 74.00 | Visa | Female | Single | 20 |
55 | Regular | 2 | 49.50 | MasterCard | Female | Married | 32 |
56 | Promotional | 3 | 141.60 | Proprietary Card | Female | Married | 38 |
57 | Promotional | 6 | 123.10 | Proprietary Card | Female | Married | 54 |
58 | Promotional | 2 | 80.40 | Proprietary Card | Female | Married | 48 |
59 | Promotional | 4 | 65.20 | MasterCard | Female | Married | 46 |
60 | Promotional | 4 | 113.00 | Proprietary Card | Female | Single | 50 |
61 | Promotional | 1 | 108.80 | Proprietary Card | Female | Married | 46 |
62 | Promotional | 3 | 59.91 | Proprietary Card | Female | Single | 30 |
63 | Promotional | 5 | 53.60 | Proprietary Card | Female | Married | 54 |
64 | Promotional | 1 | 31.60 | Proprietary Card | Female | Single | 42 |
65 | Promotional | 2 | 49.50 | Proprietary Card | Female | Married | 48 |
66 | Promotional | 1 | 39.60 | Proprietary Card | Female | Married | 62 |
67 | Promotional | 2 | 59.50 | Proprietary Card | Female | Married | 34 |
68 | Promotional | 5 | 146.80 | Proprietary Card | Female | Married | 28 |
69 | Promotional | 2 | 47.20 | Proprietary Card | Male | Married | 46 |
70 | Promotional | 8 | 95.05 | Proprietary Card | Female | Married | 54 |
71 | Promotional | 5 | 155.32 | Proprietary Card | Female | Married | 30 |
72 | Promotional | 4 | 58.00 | MasterCard | Female | Married | 32 |
73 | Regular | 1 | 69.00 | Proprietary Card | Female | Single | 22 |
74 | Promotional | 2 | 46.50 | Proprietary Card | Female | Married | 32 |
75 | Promotional | 2 | 45.22 | Proprietary Card | Female | Married | 74 |
76 | Promotional | 4 | 84.74 | Proprietary Card | Female | Married | 62 |
77 | Regular | 2 | 39.00 | Proprietary Card | Female | Married | 42 |
78 | Promotional | 4 | 111.14 | Proprietary Card | Female | Married | 28 |
79 | Promotional | 3 | 86.80 | Proprietary Card | Female | Married | 38 |
80 | Regular | 2 | 89.00 | Discover | Female | Married | 54 |
81 | Promotional | 2 | 78.00 | MasterCard | Female | Married | 68 |
82 | Promotional | 6 | 53.20 | Proprietary Card | Female | Single | 30 |
83 | Promotional | 4 | 58.50 | Visa | Female | Married | 36 |
84 | Promotional | 3 | 46.00 | Proprietary Card | Female | Married | 44 |
85 | Regular | 2 | 37.50 | Visa | Female | Married | 44 |
86 | Promotional | 1 | 20.80 | Proprietary Card | Female | Married | 62 |
87 | Regular | 6 | 144.00 | MasterCard | Female | Single | 48 |
88 | Regular | 4 | 107.00 | Proprietary Card | Female | Married | 36 |
89 | Promotional | 1 | 31.60 | Proprietary Card | Female | Single | 20 |
90 | Promotional | 6 | 57.60 | Proprietary Card | Female | Married | 42 |
91 | Promotional | 4 | 95.20 | Proprietary Card | Female | Married | 54 |
92 | Promotional | 1 | 22.42 | Proprietary Card | Female | Married | 54 |
93 | Regular | 5 | 159.75 | Proprietary Card | Female | Married | 72 |
94 | Promotional | 17 | 229.50 | Proprietary Card | Female | Married | 30 |
95 | Regular | 3 | 66.00 | American Express | Female | Married | 46 |
96 | Regular | 1 | 39.50 | MasterCard | Female | Married | 44 |
97 | Promotional | 9 | 253.00 | Proprietary Card | Female | Married | 30 |
98 | Promotional | 10 | 287.59 | Proprietary Card | Female | Married | 52 |
99 | Promotional | 2 | 47.60 | Proprietary Card | Female | Married | 30 |
100 | Promotional | 1 | 28.44 | Proprietary Card | Female | Married | 44 |
,
A-1
A Statistical Reporting A-1 IntroductIon
By now, you have learned a wide variety of statistical tools, ranging from simple charts and descriptive measures to more complex tools, such as regression and time series analysis. We suspect that all of you will be required to use some of these tools in your later course- work and in your eventual jobs. This means that you will not only need to understand the statistical tools and apply them correctly, but you will also have to write reports of your analyses for someone else—an instructor, a boss, or a client—to read. Unfortunately, the best statistical analysis is worth little if the report is written poorly. A good report must be accurate from a statistical point of view, but maybe even more important, it must be written in clear, concise English.1
As instructors, we know from experience that statistical report writing is the downfall of many students taking statistics courses. Many students appear to believe that they will be evaluated entirely on whether the numbers are right and that the quality of the write-up is at best secondary. This is simply not true. It is not true in an academic environment, and it is certainly not true in a business environment. Managers and executives in business are very busy people who have little time or patience to wade through poorly written reports. In fact, if a report starts out badly, the remainder will probably not be read at all. Only when it is written clearly, concisely, and accurately will a report have a chance of making any impact. Stated simply, a statistical analysis is often worthless if not reported well.
The goals of this brief appendix are to list several suggestions for writing good reports and to provide examples of good reports based on the analyses presented in this textbook. You have undoubtedly taken several classes in writing throughout your school years, and we cannot hope to make you a good writer if you have not already developed good basic writing skills. However, we can do three things to make you a competent statistical report writer. First, we can motivate you to spend time on your report writing by stressing how important it is in the business world. Indeed, we believe that poor writing often occurs because writers do not believe the quality of their writing makes any difference to anyone. However, we promise you that it does make a difference in the business world—your job might depend on it. Second, we can list several suggestions for improving your statistical report writing. Once you believe that good writing is really important, these tips might be all you need to help you improve your report writing significantly. Finally, we can provide examples of good reports. Some people learn best by example, so these “templates” should come in very handy.
There is no single best way to write a statistical report. Just as there are many different methods for writing a successful novel or a successful biography, there are many different methods for writing a successful statistical report. The examples we provide look good to us, but you might want to change them according to your own tastes—or maybe even
1This appendix discusses report writing. However, we acknowledge that oral presentation of statistical analysis is also very important. Fortunately, virtually all of our suggestions for good report writing carry over to making effective presentations. Also, we focus here on statistical reporting. The same comments apply to other quantitative reports, such as those dealing with optimization or simulation models.
A P P E N D I X
© 2015 Cengage Learning. All Rights Reserved.
88269_appA_online_hr_A-1-A-18.indd 1 01/10/13 1:27 AM
A-2 Appendix A Statistical Reporting
improve on them. Nevertheless, there are some bad habits that practically all readers will object to, and there are some good habits that will make your writing more effective. We list several suggestions here and expand on them in the next section.
Planning
■■ Clarify the objective.
■■ Develop a clear plan.
■■ Give yourself enough time.
Developing a Report
■■ Write a quick first draft.
■■ Edit and proofread.
■■ Give your report a professional look.
Be Clear
■■ Provide sufficient background information.
■■ Tailor statistical explanations to your audience.
■■ Place charts and tables in the body of the report.
Be Concise
■■ Let the charts do the talking.
■■ Be selective in the computer outputs you include.
Be Precise
■■ List assumptions and potential limitations.
■■ Limit the decimal places.
■■ Report the results fairly.
■■ Get advice from an expert.
A-2 SuggeStIonS for good StAtIStIcAl reportIng To some extent, the habits that make someone a good statistical report writer are the same habits that make someone a good writer in general. Good writing is good writing. However, there are some specific aspects of good statistical reporting that do not apply to other forms of writing. In this section, we list several suggestions for becoming a good writer in general and for becoming a good statistical report writer in particular.
A-2a planning Clarify the objective. When you write a statistical report, you are probably writing it for someone—an instructor, a boss, or maybe even a client. Make sure you know exactly what this other person wants, so that you do not write the wrong report (or perform the wrong statistical analysis). If there is any doubt in your mind about the objective of the report, clarify it with the other person before proceeding. Do not just assume that coming close to the target objective is good enough.
© 2015 Cengage Learning. All Rights Reserved.
88269_appA_online_hr_A-1-A-18.indd 2 01/10/13 1:27 AM
A-2 Suggestions for Good Statistical Reporting A-3
Develop a clear plan. Before you start writing the report, make a plan for how you are going to organize it. This can be a mental plan, especially if the report is short and straightforward, or it can be a more formal written outline. Think about the best length for the report. It should be long enough to cover the important points, but it should not be verbose. Think about the overall organization of the report and how you can best divide it into sections (if separate sections are appropriate). Think about the computer outputs you need to include (and those you can exclude) to make your case as strong as possible. Think about the audience for whom you are writing and what level of detail they will demand or will be able to comprehend. If you have a clear plan before you begin writing, the writing itself will flow much more smoothly and easily than if you make up a plan as you go. Most effective statistical reports essentially follow the outline below. We recom- mend that you try it.
■■ Executive summary
■■ Problem description
■■ Data description
■■ Statistical methodology
■■ Results and conclusions
Give yourself enough time. If you plan to follow the suggestions listed here, you need to give yourself time to do the job properly. If the report is due first thing Monday morning and you begin writing it on Sunday evening, your chances of producing anything of high quality are slim. Get started early, and don’t worry if your first effort is not perfect. If you produce something a week ahead of time, you will have plenty of time to polish it in time for the deadline.
A-2b developing a report
Write a quick first draft. We have all seen writers in movies who agonize over the first sentence of a novel, and we suspect that many of you suffer the same problem when writing a report. You want to get it exactly right the first time through, so you agonize over every word, especially at the beginning. We suggest writing the first draft as quickly as possible—just get something down in writing—and then worry about improving it with careful editing later on. The worst thing many of us face as writers is a blank piece of paper (or a blank computer document). Once there is something written, even if it is only in pre- liminary form, the hard part is over and the perfecting can begin.
Edit and proofread. The secret of good writing is rewriting. We believe this sugges- tion (when coupled with the previous suggestion) can have the most immediate impact on the quality of your writing. Fortunately, it is relatively easy to do. With today’s software, there is no excuse for not editing and checking thoroughly, yet we are con- stantly amazed at how many people fail to do so. Spell checkers and grammar checkers are available in all of the popular word processors, and although they do not catch all errors, they should definitely be used. Then the real editing task can begin. A report that contains no spelling or grammatical errors is not necessarily well written. We believe a good practice, given enough time and planning, is to write a report and then reread it with a critical eye a day or two later. Better yet, get a knowledgeable friend to read it. Often the wording you thought was fine the first time around will sound awkward or confusing on a second reading. If this is the case, rewrite it! And don’t just change a word or two. If a sentence sounds really awkward or a paragraph does not get your
© 2015 Cengage Learning. All Rights Reserved.
88269_appA_online_hr_A-1-A-18.indd 3 01/10/13 1:27 AM
A-4 Appendix A Statistical Reporting
point across, don’t be afraid to delete the whole thing and explore better ways of struc- turing it. Finally, proofread the final copy at least once, preferably more than once. Just remember that this report has your name on it, and any careless spelling or grammar mistakes will reflect badly on you. Admittedly, this editing and proofreading process can be time-consuming, but it can also be very rewarding when you realize how much better the final report reads.
Give your report a professional look. We are not necessarily fans of the glitz that today’s software enables (fancy colored fonts, 3-D charts, and so on), and we suspect that many writers spend too much time on glitz as opposed to substance. Nevertheless, it is important to give your reports a professional look. If nothing else, an attractive report makes a good first impression, and a first impression matters. It indicates to the reader that you have spent some time on the report and that there might be something inside worth reading. Of course, the fanciest report in the world cannot overcome a lack of substance, but at least it will gain you some initial respect. A sloppy report, even if it presents a great statistical analysis, might never be read at all. In any case, leave the glitz until last. Spend sufficient time to ensure that your report reads well and makes the points you want to make. Then you can have some fun dressing it up.
A-2c Be clear
How many times have you read a passage from a book, only to find that you need to read it again—maybe several times—because you keep losing your train of thought? It could be that you were daydreaming about something else, but it could also be that the writing itself is not clear. If a report is written clearly, chances are you will pick up its meaning on the first reading. Therefore, strive for clarity in your own writing. Avoid long, convoluted sentence structure. Don’t beat around the bush, but come right out and say what you mean to say. Make sure each paragraph has a single theme that hangs together. Don’t use jargon (unless you define it explicitly) that your intended readers are unlikely to understand. And, of course, read and reread what you have written—that is, edit it—to ensure that your writing is as clear as you initially thought.
Provide sufficient background information. After working on a statistical analysis for weeks or even months, you might lose sight of the fact that others are not as familiar with the project as you are. Make sure you include enough background information to bring the reader up to speed on the context of your report. As instructors, we have read through the fine details of many student reports without knowing exactly what the overall report is all about. Don’t put your readers in this position.
Tailor statistical explanations to your audience. Once you begin writing the Statistical Methodology and Results sections of a statistical report, you will probably start wondering how much explanation you need to include. For example, if you are describing the results of a regression analysis, you certainly want to mention the R2 value, the standard error of estimate, and the regression coefficients, but do you need to explain the meanings of these statistical concepts? This depends entirely on your intended audience. If this report is for a statistics class, your instructor is certainly famil- iar with the statistical concepts, and you do not need to define them in your report. But if your report is for a nontechnical boss who knows very little about statistics beyond means and medians, some explanation is certainly warranted. Even in this case, how- ever, keep in mind that your task is not to write a statistics textbook; it is to analyze a particular problem for your boss. So keep the statistical explanations brief, and get on with the analysis.
© 2015 Cengage Learning. All Rights Reserved.
88269_appA_online_hr_A-1-A-18.indd 4 01/10/13 1:27 AM
A-2 Suggestions for Good Statistical Reporting A-5
Place charts and tables in the body of the report. This is a personal preference and can be disputed, but we favor placing charts and tables in the body of the report, right next to where they are referenced, rather than at the back of the report in an appendix. This way, when readers see a reference to Figure 3 or Table 2 in the body of the report, they do not have to flip through pages to find Figure 3 or Table 2. Given the options in today’s word processors, this can be done in a visually attractive manner with very little extra work. Alternatively, you can use hyperlinks to the charts and tables.
A-2d Be concise
Statistical report writing is not the place for the flowery language often used in novels. Your readers want to get straight to the point, and they typically have no patience for verbose reports. Make sure each paragraph, each sentence, and even each word has a purpose, and eliminate everything that is extraneous. This is the time where you should put critical editing to good use. Just remember that many professionals have a one-page rule—they refuse to read
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
