Excel

profilestudent06
ExcelAssignment2copy.xlsx
Home>Mathematics homework help>Statistics homework help>Excel

&UnStack

&DataIndices

&DataCopy

&GraphData

&WorkArea

&Miscel_Area

Ch 3

Customer Type of Customer Items Net Sales Method of Payment Gender Marital Status Age Compute the following for Net Sales
1 Regular 1 39.50 Discover Male Married 32
2 Promotional 1 102.40 Proprietary Card Female Married 36 Mean
3 Regular 1 22.50 Proprietary Card Female Married 32 Median
4 Promotional 5 100.40 Proprietary Card Female Married 28
5 Regular 2 54.00 MasterCard Female Married 34 Variance
6 Regular 1 44.50 MasterCard Female Married 44 SD
7 Promotional 2 78.00 Proprietary Card Female Married 30
8 Regular 1 22.50 Visa Female Married 40 1st Quartile
9 Promotional 2 56.52 Proprietary Card Female Married 46 2nd Quartile
10 Regular 1 44.50 Proprietary Card Female Married 36 3rd Quartile
11 Regular 1 29.50 Proprietary Card Female Married 48 80th Percentile
12 Promotional 1 31.60 Proprietary Card Female Married 40 Skewness
13 Promotional 9 160.40 Visa Female Married 40 IQR
14 Promotional 2 64.50 Visa Female Married 46 z-score for $29.50
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 Covariance (Between net sales and age)
18 Regular 3 54.50 Discover Female Married 40 Correlation coefficient (Between net sales and age)
19 Promotional 2 38.50 MasterCard Female Married 32
20 Promotional 6 44.80 Proprietary Card Female Married 56 Compute the mode for Items:
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

Ch 4

Customer Type of Customer Items Net Sales Method of Payment Gender Marital Status Age
1 Regular 1 39.50 Discover Male Married 32 Frequency Relative Frequency
2 Promotional 1 102.40 Proprietary Card Female Married 36 1 Single
3 Regular 1 22.50 Proprietary Card Female Divorced 32 2 Married
4 Promotional 5 100.40 Proprietary Card Female Married 28 3 Divorced
5 Regular 2 54.00 MasterCard Female Married 34 4 Not Reported
6 Regular 1 44.50 MasterCard Female Not Reported 44 Sum
7 Promotional 2 78.00 Proprietary Card Female Married 30
8 Regular 1 22.50 Visa Female Married 40 What is the probability that someone did not report marital status?
9 Promotional 2 56.52 Proprietary Card Female Divorced 46
10 Regular 1 44.50 Proprietary Card Female Married 36
11 Regular 1 29.50 Proprietary Card Female Not Reported 48 What is the probability that someone is married or divorced?
12 Promotional 1 31.60 Proprietary Card Female Married 40
13 Promotional 9 160.40 Visa Female Not Reported 40
14 Promotional 2 64.50 Visa Female Married 46
15 Regular 1 49.50 Visa Male Divorced 24
16 Promotional 2 71.40 Proprietary Card Male Single 36 For Questions 1 - 3 below, you must decide whether to use a combination or
17 Promotional 3 94.00 Proprietary Card Female Single 22 a permutation.
18 Regular 3 54.50 Discover Female Married 40
19 Promotional 2 38.50 MasterCard Female Not Reported 32 1. Eight friends want to play enough games of checkers to make everyone plays everyone else.
20 Promotional 6 44.80 Proprietary Card Female Married 56 How many games will they have to play?
21 Promotional 1 31.60 Proprietary Card Female Single 28
22 Promotional 4 70.82 Proprietary Card Female Married 38 2. How many ways can the letters in the word HAPPY be rearranged
23 Promotional 7 266.00 American Express Female Divorced 50 without repeating letters?
24 Regular 2 74.00 Proprietary Card Female Married 42
25 Promotional 2 39.50 Visa Male Married 48 3. You must choose the top two people from the 12 that entered the debate competition.
26 Promotional 1 30.02 Proprietary Card Female Married 60 How many ways can they be arranged?
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 A high school has 400 students, 120 are male and 280 are female. Of the males, 60% are enrolled in physics.
30 Promotional 1 18.00 Proprietary Card Female Not Reported 70 Of the females, 80% are enrolled in physics.
31 Promotional 2 63.20 MasterCard Female Not Reported 28
32 Regular 1 75.00 Proprietary Card Female Married 52 What is the probabability that a randomly selected student is a female enrolled in physics?
33 Promotional 3 63.20 Proprietary Card Female Married 44
34 Regular 1 40.00 Proprietary Card Female Divorced 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 After interviewing a group of people (males and females), one was selected that was left-handed. It is estimated
38 Promotional 6 117.50 Proprietary Card Female Married 50 that 12% of males and 9% of females are left-handed. Given the following table for males and females,
39 Promotional 5 13.23 Proprietary Card Female Married 44 complete the joint and posterior probabilities according to Bayes' Theorem.
40 Regular 2 52.50 Proprietary Card Female Married 58
41 Promotional 13 198.80 Proprietary Card Female Divorced 42
42 Promotional 4 19.50 Visa Female Married 46 Events Prior Probabilities Conditional Probabilities Joint Probabilities Posterior Probabilities
43 Regular 2 123.50 Proprietary Card Female Married 48
44 Promotional 1 62.40 Proprietary Card Female Not Reported 54 Male 0.45 0.12
45 Promotional 2 23.80 Proprietary Card Female Not Reported 38 Female 0.55 0.09
46 Promotional 2 39.60 Proprietary Card Female Married 60 Total
47 Regular 1 25.00 MasterCard Female Married 46
48 Promotional 3 63.64 Proprietary Card Female Divorced 30
49 Promotional 1 14.82 Proprietary Card Female Married 32
50 Promotional 9 145.20 MasterCard Female Not Reported 46
51 Promotional 6 176.62 Proprietary Card Female Divorced 38