statistic 3303

Case 1 Instruction (Accounting Application)

Use the MS Excel tabular graphical methods of descriptive statistics to summarize the sample data in the data set named PelicanStores in Case 1 folder.

The managerial report should contain summaries such as:

1. A frequency and relative frequency distributions for the methods of
   payment (different cards). (20%)
2. Mean, median, first quartile, third quartile, and sample standard
   deviation for net sales from regular customers. (20%)
3. Mean, median, first quartile, third quartile, and sample standard
   deviation for net sales from married female. (20%)
4. Apply the location method to calculate the 60th percentile manually of net sales for each method (card) of payment. Please indicate which card has the highest 60th percentile and show the process.
   (20%)
5. Apply Chebyshev’s Theorem to calculate the range (i.e. $ to $) of at
   least 75% of the net sales must fall within for the Proprietary Card payment. (20%) (Hint: What is the z-score for at least 75% of data range?)

answer all the question