User Account

All Pages

Determine the managerial report

Assignment Help Basic Statistics
Reference no: EM133266077

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:

Customer Type of Customer Items Net Sales Method of Payment Gender Marital Status Age
1 Regular 1 $ 90.00 Discover Male Married 32
2 Promotional 1 $ 102.00 Discover Female Married 36
3 Regular 1 $ 23.00 Discover Female Single 32
4 Promotional 5 $ 200.00 Discover Female Married 28
5 Regular 2 $ 64.00 MasterCard Female Married 34
6 Regular 1 $ 45.00 MasterCard Female Married 44
7 Promotional 2 $ 98.00 MasterCard Male Single 30
8 Regular 1 $ 23.00 Visa Male Married 35
9 Promotional 2 $ 57.00 Visa Male Married 46
10 Regular 1 $ 55.00 MasterCard Female Single 36
11 Regular 1 $ 30.00 MasterCard Female Married 48
12 Promotional 1 $ 32.00 MasterCard Female Married 40
13 Promotional 9 $ 160.00 Visa Male Married 40
14 Promotional 2 $ 65.00 Visa Male Married 46
15 Regular 1 $ 100.00 Visa Male Single 24
16 Promotional 2 $ 71.00 Discover Male Single 36
17 Promotional 3 $ 194.00 Discover Female Single 22
18 Regular 3 $ 55.00 Discover Female Married 40
19 Promotional 2 $ 39.00 MasterCard Female Married 32
20 Promotional 6 $ 45.00 Proprietary Card Male Married 56
21 Promotional 1 $ 32.00 MasterCard Male Single 28
22 Promotional 4 $ 71.00 MasterCard Male Married 38
23 Promotional 7 $ 236.00 MasterCard Male Married 50
24 Regular 2 $ 74.00 Proprietary Card Male Married 42
25 Promotional 2 $ 40.00 Visa Male Married 48
26 Promotional 1 $ 30.00 Visa Female Married 60
27 Regular 1 $ 45.00 Proprietary Card Female Married 54
28 Promotional 5 $ 193.00 Proprietary Card Female Single 42
29 Promotional 3 $ 171.00 Proprietary Card Female Married 32
30 Promotional 1 $ 18.00 MasterCard Female Married 70
31 Promotional 2 $ 63.00 MasterCard Female Married 28
32 Regular 1 $ 75.00 Proprietary Card Female Married 52
33 Promotional 3 $ 63.00 Proprietary Card Female Married 44
34 Regular 1 $ 40.00 MasterCard Male Married 34
35 Promotional 5 $ 106.00 MasterCard Male Married 56
36 Regular 1 $ 30.00 MasterCard Male Single 36
37 Regular 2 $ 103.00 Visa Female Single 42
38 Promotional 6 $ 118.00 Proprietary Card Female Married 50
39 Promotional 5 $ 13.00 Proprietary Card Female Married 44
40 Regular 2 $ 53.00 Proprietary Card Female Married 58
41 Promotional 13 $ 199.00 Proprietary Card Female Married 42
42 Promotional 4 $ 20.00 Visa Female Married 46
43 Regular 2 $ 124.00 Visa Male Married 48
44 Promotional 1 $ 62.00 Visa Female Married 54
45 Promotional 2 $ 24.00 Visa Female Single 38
46 Promotional 2 $ 40.00 Visa Male Single 60
47 Regular 1 $ 25.00 MasterCard Female Married 46
48 Promotional 3 $ 84.00 Proprietary Card Female Married 30
49 Promotional 1 $ 15.00 Proprietary Card Female Married 32
50 Promotional 9 $ 145.00 MasterCard Female Married 46
51 Promotional 6 $ 177.00 Proprietary Card Female Married 38
52 Promotional 5 $ 119.00 Proprietary Card Male Married 68
53 Regular 1 $ 58.00 Discover Male Single 78
54 Regular 2 $ 74.00 Visa Female Single 20
55 Regular 2 $ 50.00 MasterCard Female Married 32
56 Promotional 3 $ 142.00 Proprietary Card Female Married 38
57 Promotional 6 $ 123.00 Proprietary Card Female Married 54
58 Promotional 2 $ 80.00 Proprietary Card Female Married 48
59 Promotional 4 $ 65.00 MasterCard Female Married 46
60 Promotional 4 $ 113.00 Proprietary Card Female Single 50
61 Promotional 1 $ 109.00 Proprietary Card Female Married 46
62 Promotional 3 $ 60.00 Proprietary Card Female Single 30
63 Promotional 5 $ 54.00 Proprietary Card Female Married 54
64 Promotional 1 $ 32.00 Proprietary Card Female Single 42
65 Promotional 2 $ 50.00 Proprietary Card Female Married 48
66 Promotional 1 $ 40.00 Proprietary Card Female Married 62
67 Promotional 2 $ 60.00 Proprietary Card Female Married 34
68 Promotional 5 $ 147.00 Proprietary Card Female Single 28
69 Promotional 2 $ 47.00 Proprietary Card Male Married 46
70 Promotional 8 $ 95.00 Proprietary Card Female Married 54
71 Promotional 5 $ 155.00 Proprietary Card Female Married 30
72 Promotional 4 $ 58.00 MasterCard Male Married 32
73 Regular 1 $ 69.00 Proprietary Card Female Single 22
74 Promotional 2 $ 47.00 Proprietary Card Female Married 32
75 Promotional 2 $ 45.00 Visa Female Married 74
76 Promotional 4 $ 85.00 Visa Male Single 62
77 Regular 2 $ 39.00 Proprietary Card Female Single 42
78 Promotional 4 $ 111.00 Proprietary Card Female Married 28
79 Promotional 3 $ 87.00 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.00 Proprietary Card Female Single 30
83 Promotional 4 $ 59.00 Visa Female Married 36
84 Promotional 3 $ 46.00 Proprietary Card Female Married 44
85 Regular 2 $ 38.00 Visa Female Married 44
86 Promotional 1 $ 21.00 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 $ 52.00 Proprietary Card Female Single 20
90 Promotional 6 $ 58.00 Proprietary Card Female Single 42
91 Promotional 4 $ 95.00 Visa Male Single 54
92 Promotional 1 $ 22.00 Visa Female Married 54
93 Regular 5 $ 160.00 Proprietary Card Male Married 72
94 Promotional 17 $ 250.00 Proprietary Card Female Married 30
95 Regular 3 $ 66.00 American Express Female Married 46
96 Regular 1 $ 40.00 MasterCard Female Married 44
97 Promotional 9 $ 223.00 Proprietary Card Female Married 30
98 Promotional 10 $ 248.00 Discover Male Married 52
99 Promotional 2 $ 48.00 Discover Female Married 30
100 Promotional 1 $ 28.00 Proprietary Card Female Married 44

1. Frequency distribution for each qualitative variable.

2. A bar chart showing the number of customer purchases attributable to the method of payment.

3. A pie chart showing the marital status of customers.

4. A frequency distribution and histogram of net sales. (Begin with the first class starting at 0

and use a class width of 50)

5. A cross tabulation of type of customer (regular or promotional) versus net sales. Comment on any similarities or differences present.

6. A scatter diagram to explore the relationship between net sales and customer age.

Reference no: EM133266077

Questions Cloud

Space station to preserve humanity : Assume that meteors greater than 100m in diameter strike the earth roughly every 5000 years, and that this process can be modeled by a Poisson distribution.
Probability that when 75 eople are surveyed : 4) Assume that ten percent of us are left-handed. The probability of getting at least two left-handed people in a group of 7.
Formulate a system of simultaneous equations : A sales man has the following record of sales during three months for three items A, B and C which have different rates of commission
What is the maximum value in new normal sample : Let Z be a normally distributed random variable with mean 100 and standard deviation 15.
Determine the 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 min
Compare the calculated z score with critical z scores : The following weights were obtained from a randomly selected sample of 20-year-old, 6-foot-1-inch males from Minnesota. This sample of 100 males had a mean weig
Variables for a quantitative test : We have two samples (A and B) of 10 variables for a quantitative test. We want to validate if a treatment works by testing the amount of antibodies.
What would your choice of factor analysis depend on : Identify and describe a business situation in which you would use factor analysis.
Find the p-value for this hypothesis test : A researcher claims that the proportion of people who are right-handed is 70%. To test this claim, a random sample of 600 people is taken and its determined tha

Reviews

Write a Review

Basic Statistics Questions & Answers

  How well the histogram approximates the pdf

Use the R command set.seed(111); hist(rexp(10000), breaks=35, freq=F) to generate a sample of size 10,000 from the exponential(1) distribution and to plot

  What is the expected value and standard deviation

A manufacturing process produces on the average two defective items per hour. What is the probability that after a defective item: One hour will pass before the next defective item and One-half hour will pass?

  Calculate the sample standard deviation s

Determine the proportion of the data values that lies within x¯ ± 1.5s and compare with the lower bound given by Chebyshev's inequality.

  Evaluate strategy for assigning students to the two groups

Suppose we ask the students to volunteer to be in the rereading group. We accept students into this group one at a time until we have the number needed. Evaluate this strategy for assigning students to the two groups.

  Confidence interval for the population mean

You want to be able to state that the population mean is lower than some value with 95% confidence.

  Find probability that exactly two claims will be filed

File a claim is 0.0005. Suppose they wrote 400 policies for the coming weekend, what is the probability that exactly two claims will be filed?

  Paper for a machine learning conference

Jacob is writing a paper for a machine learning conference. He has invented a "new" version of random forests:

  Confidence interval for the mean lifetime of all trees

City planners wish to estimate the mean lifetime of the most commonly planted trees in urban settings. A sample of 16 recently felled trees yielded mean age.

  Find probability mean weight of chosen men would exceed

What is the probability that the mean weight of sixteen randomly chosen men would exceed the individual weight from part (1)?

  Proportion of getting doubles

We found our proportion of getting doubles was 15% to 16%. Using probability theory how often (i.e, what proportion of time) would you theoretically expect to roll doubles from 2 fair dice?

  Determining the sample proportion

Of the 500 students who responded to a survey about recycling on campus, 350 said they recycle on a regular basis. The sample proportion is ??

  Probability that it has a hairline crack

In a shipment of 53 vials, only 13 do not have hairline cracks. If you randomly select one vial from the shipment, what is the probability that it has a hairline crack?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd