4. Using the an appropriate statistical method for the variables of age, househo

Question

4. Using the an appropriate statistical method for the variables of age, household income, and years of education, you must determine if there is a statistically significant difference between the segments that you identified above for each variable as they relate to purpose of visit. In other words, you need to determine if the purpose of visit is different for the segments in each of these three variables. You will choose the appropriate level of statistical significance for this test. You will test each variable independently as a univariate test; this is not a multivariate analysis.

a. You will present the statistical findings for each of the three variables using an appropriate table that highlights the statistical results for each test.

b. In 2-3 sentences under each table showing the results for that variable, discuss if the results have statistical significance to the marketing team.

Here is the data:

Age Household Income Years of Education Purpose of Visit 89 155779 14 Place an Order 66 48279 14 Check Status of Order 90 47177 14 Make a Complaint 47 77336 14 Place an Order 28 44551 11 Find Local Store 30 38769 17 Place an Order 80 60614 15 Find Local Store 49 100001 18 Place an Order 38 97266 17 Research Product 23 95921 12 Place an Order 31 10228 13 Research Product 83 110341 20 Find Local Store 39 114261 13 Make a Complaint 75 98855 10 Find Local Store 21 92676 13 Check Status of Order 52 78695 19 Job Opportunities 79 147160 13 Find Local Store 25 66271 16 Check Status of Order 23 10192 19 Find Local Store 49 127071 18 Place an Order 90 170937 14 Find Local Store 33 15511 13 Research Product 28 128602 17 Find Local Store 41 172998 17 Place an Order 87 91158 14 Check Status of Order 43 151635 12 Find Local Store 43 81411 16 Research Product 29 14317 16 Place an Order 38 128218 13 Place an Order 85 172480 15 Research Product 36 66909 10 Check Status of Order 35 144539 21 Check Status of Order 23 57796 15 Research Product 47 136952 19 Place an Order 28 38320 19 Find Local Store 61 103894 12 Research Product 67 159557 17 Research Product 60 99254 14 Place an Order 72 136542 18 Place an Order 48 38207 11 Research Product 30 57733 18 Job Opportunities 86 141964 17 Find Local Store 30 51144 12 Job Opportunities 38 52426 12 Find Local Store 83 139436 20 Check Status of Order 30 47301 18 Research Product 43 98099 18 Check Status of Order 74 154848 19 Research Product 74 91398 19 Research Product 36 44343 21 Find Local Store 87 135727 16 Research Product 38 33043 20 Research Product 65 32926 20 Research Product 54 132910 15 Find Local Store 82 23337 20 Check Status of Order 43 124087 14 Make a Complaint 91 168396 19 Job Opportunities 25 119198 12 Find Local Store 28 124200 20 Check Status of Order 73 125944 19 Place an Order 49 146281 18 Research Product 68 62867 20 Make a Complaint 90 107059 15 Check Status of Order 81 160516 18 Job Opportunities 77 100342 20 Find Local Store 26 88208 20 Place an Order 26 150279 21 Find Local Store 69 78903 15 Research Product 75 23354 18 Research Product 44 130543 20 Research Product 25 12749 14 Research Product 44 3673 13 Find Local Store 70 126312 11 Check Status of Order 28 169916 13 Research Product 52 79070 18 Find Local Store 47 147602 18 Check Status of Order 70 67079 13 Check Status of Order 44 98452 13 Place an Order 51 155313 10 Find Local Store 71 92588 10 Place an Order 46 123589 10 Place an Order 87 166890 21 Place an Order 54 115492 15 Research Product 36 60460 11 Research Product 50 142390 21 Place an Order 33 52636 19 Place an Order 23 10623 20 Research Product 26 127452 14 Check Status of Order 74 171450 12 Check Status of Order 75 49818 16 Find Local Store 51 137775 15 Find Local Store 78 41363 18 Research Product 86 118986 21 Place an Order 87 164902 21 Find Local Store 57 110732 11 Find Local Store 52 87387 21 Check Status of Order 46 149829 18 Find Local Store 45 78653 11 Research Product 89 108253 21 Research Product 83 160997 12 Place an Order 52 100766 11 Check Status of Order 62 90078 20 Check Status of Order 36 150729 21 Make a Complaint 72 79350 12 Research Product 23 23278 17 Place an Order 41 130153 11 Research Product 55 10666 11 Find Local Store 59 74655 11 Find Local Store 50 145844 14 Check Status of Order 59 60772 12 Place an Order 72 80898 19 Place an Order 23 148045 18 Research Product 25 71313 17 Check Status of Order 42 8863 15 Research Product 69 126691 18 Place an Order 71 170426 18 Place an Order 27 136134 20 Make a Complaint 29 37969 17 Research Product 28 81266 12 Find Local Store 22 148489 18 Research Product 71 74423 18 Find Local Store 82 123979 16 Place an Order 24 167390 11 Research Product 75 116996 19 Job Opportunities 37 122326 16 Make a Complaint 73 101601 12 Research Product 91 158130 20 Research Product 86 98491 17 Find Local Store 55 38223 15 Research Product 32 134110 21 Research Product 63 26636 10 Check Status of Order 39 56688 15 Place an Order 54 141116 17 Make a Complaint 39 50154 17 Research Product 54 26529 11 Place an Order 68 131327 18 Find Local Store 49 15552 19 Find Local Store 46 48573 18 Check Status of Order 70 137363 21 Research Product 63 31169 20 Make a Complaint 45 132117 18 Find Local Store 56 20897 21 Research Product 64 71125 15 Research Product 65 144973 10 Research Product 22 57836 10 Place an Order 39 121894 14 Job Opportunities 74 166391 20 Job Opportunities 21 114885 12 Find Local Store 34 116584 19 Place an Order 77 163917 21 Place an Order 85 107331 11 Find Local Store 39 66154 12 Find Local Store 61 144107 19 Check Status of Order 58 56889 13 Research Product 33 74161 11 Make a Complaint 26 145408 11 Check Status of Order 25 125934 21 Check Status of Order 58 169408 17 Research Product 70 120934 14 Check Status of Order 74 124414 15 Find Local Store 67 112538 10 Find Local Store 23 161965 15 Research Product 78 103218 20 Place an Order 23 41217 18 Job Opportunities 80 134916 21 Place an Order 24 31248 15 Place an Order 53 104362 14 Make a Complaint 87 160036 12 Find Local Store 43 62646 15 Research Product 25 143246 10 Place an Order 27 55046 20 Check Status of Order 27 98992 20 Place an Order 21 156246 18 Place an Order 32 94032 14 Research Product 27 12726 21 Place an Order 78 127834 13 Research Product 47 171965 16 Check Status of Order 56 115188 11 Research Product 49 163427 20 Check Status of Order 72 104547 10 Place an Order 49 60612 18 Place an Order 40 142817 17 Research Product 77 54717 18 Find Local Store 90 50963 11 Place an Order 86 139019 18 Research Product 53 44664 14 Research Product 88 154385 12 Research Product 77 91036 17 Find Local Store 23 50027 21 Place an Order 62 138188 19 Research Product 29 44183 20 Research Product 57 31982 20 Check Status of Order 46 132513 16 Place an Order 34 22296 11 Check Status of Order 53 54907 21 Place an Order 50 140274 20 Job Opportunities 54 48767 17 Job Opportunities 46 103213 20 Research Product 52 159080 13 Research Product 39 99106 12 Check Status of Order 64 102946 20 Research Product 87 158604 12 Find Local Store 45 98628 11 Research Product 32 44007 14 Check Status of Order 30 135321 10 Find Local Store 45 32066 11 Check Status of Order 56 99648 15 Check Status of Order 35 156715 10 Place an Order 28 95093 17 Find Local Store 53 125500 13 Find Local Store 44 168901 16 Find Local Store 79 120471 11 Research Product 53 124381 12 Check Status of Order 25 126438 21 Research Product 88 54620 20 Check Status of Order 36 139854 16 Find Local Store 59 48450 17 Check Status of Order 48 90805 10 Job Opportunities 26 151182 18 Check Status of Order 61 81222 15 Job Opportunities 67 50889 13 Job Opportunities 29 138603 15 Place an Order 80 44422 12 Job Opportunities 86 38139 10 Place an Order 56 133709 17 Research Product 40 26478 18 Job Opportunities 51 38667 10 Research Product 53 134513 19 Make a Complaint 40 30727 21 Research Product 32 94852 19 Place an Order 46 153463 19 Research Product 57 88561 14 Check Status of Order 68 84094 11 Check Status of Order 48 148934 19 Check Status of Order 61 74954 18 Find Local Store 43 120166 12 Job Opportunities 72 165397 10 Research Product 86 112988 12 Job Opportunities 86 30672 11 Place an Order 26 131721 12 Job Opportunities 48 16032 16 Job Opportunities 53 118095 19 Check Status of Order 76 164409 16 Place an Order 78 108538 21 Check Status of Order 87 114058 13 Research Product 37 162451 11 Research Product 23 103579 15 Check Status of Order 89 114594 21 Research Product 80 162938 12 Find Local Store 49 104310 18 Job Opportunities 53 56674 14 Make a Complaint 65 140694 10 Research Product 83 49906 15 Research Product 54 37818 21 Research Product 66 133309 15 Place an Order 57 23416 17 Research Product 70 92262 16 Job Opportunities 85 152090 13 Place an Order 37 84307 13 Place an Order 42 20813 20 Place an Order 56 129375 17 Find Local Store 55 8886 13 Place an Order 24 64815 12 Place an Order 35 143676 15 Research Product 38 56823 10 Research Product 73 99942 16 Find Local Store 41 157185 15 Find Local Store 32 85892 13 Research Product 52 149381 16 Place an Order 48 77473 13 Job Opportunities 62 95668 16 Place an Order 68 153923 15 Check Status of Order 50 90239 13 Place an Order 48 93865 15 Place an Order 89 153004 20 Find Local Store 74 87696 15 Research Product 66 22256 21 Find Local Store 58 129763 19 Research Product 26 78454 13 Place an Order 57 146720 20 Find Local Store 90 65075 21 Place an Order 58 100587 11 Check Status of Order 73 157657 17 Research Product 67 97610 12 Research Product 26 15976 19 Place an Order 56 128988 14 Research Product 36 3683 18 Research Product 28 57566 15 Research Product 87 141540 19 Research Product 37 51024 10 Check Status of Order 22 124066 14 Make a Complaint 64 167893 18 Research Product 87 118568 21 Find Local Store 85 124083 12 Place an Order 76 161480 20 Place an Order 70 101859 14 Place an Order 66 120616 16 Place an Order 32 165893 20 Research Product 81 92307 11 Find Local Store 37 152546 10 Research Product 21 86119 18 Research Product 40 26384 19 Place an Order 63 130935 10 Research Product 12 14354 3 Research Product

Explanation / Answer

Answer:

MINITAB used.

4. Using the an appropriate statistical method for the variables of age, household income, and years of education, you must determine if there is a statistically significant difference between the segments that you identified above for each variable as they relate to purpose of visit. In other words, you need to determine if the purpose of visit is different for the segments in each of these three variables. You will choose the appropriate level of statistical significance for this test. You will test each variable independently as a univariate test; this is not a multivariate analysis.

a. You will present the statistical findings for each of the three variables using an appropriate table that highlights the statistical results for each test.

One-way ANOVA: Age versus Purpose of Visit

Method

Null hypothesis

All means are equal

Alternative hypothesis

Not all means are equal

Significance level

= 0.05

Equal variances were assumed for the analysis.

Factor Information

Factor

Levels

Values

Purpose of Visit

6

Check Status of Order, Find Local Store, Job Opportunities, Make a
Complaint, Place an Order, Research Product

Analysis of Variance

Source

DF

Adj SS

Adj MS

F-Value

P-Value

Purpose of Visit

5

2076

415.2

0.96

0.441

Error

298

128645

431.7

Total

303

130721

Model Summary

S

R-sq

R-sq(adj)

R-sq(pred)

20.7773

1.59%

0.00%

0.00%

Means

Purpose of Visit

N

Mean

StDev

95% CI

Check Status of Order

49

51.37

19.49

(45.53, 57.21)

Find Local Store

57

58.23

21.54

(52.81, 63.64)

Job Opportunities

23

55.00

19.87

(46.47, 63.53)

Make a Complaint

14

47.93

18.00

(37.00, 58.86)

Place an Order

70

53.34

22.12

(48.46, 58.23)

Research Product

91

52.49

20.49

(48.21, 56.78)

Pooled StDev = 20.7773

One-way ANOVA: Household Income versus Purpose of Visit

Method

Null hypothesis

All means are equal

Alternative hypothesis

Not all means are equal

Significance level

= 0.05

Equal variances were assumed for the analysis.

Factor Information

Factor

Levels

Values

Purpose of Visit

6

Check Status of Order, Find Local Store, Job Opportunities, Make a
Complaint, Place an Order, Research Product

Analysis of Variance

Source

DF

Adj SS

Adj MS

F-Value

P-Value

Purpose of Visit

5

3828688705

765737741

0.35

0.884

Error

298

6.57550E+11

2206543355

Total

303

6.61379E+11

Model Summary

S

R-sq

R-sq(adj)

R-sq(pred)

46973.9

0.58%

0.00%

0.00%

Means

Purpose of Visit

N

Mean

StDev

95% CI

Check Status of Order

49

98048

42623

(84842, 111254)

Find Local Store

57

104981

46117

(92737, 117225)

Job Opportunities

23

91339

45067

(72063, 110614)

Make a Complaint

14

101689

39275

(76982, 126395)

Place an Order

70

97233

46987

(86184, 108282)

Research Product

91

98028

51009

(88337, 107719)

Pooled StDev = 46973.9

One-way ANOVA: Years of Education versus Purpose of Visit

Method

Null hypothesis

All means are equal

Alternative hypothesis

Not all means are equal

Significance level

= 0.05

Equal variances were assumed for the analysis.

Factor Information

Factor

Levels

Values

Purpose of Visit

6

Check Status of Order, Find Local Store, Job Opportunities, Make a
Complaint, Place an Order, Research Product

Analysis of Variance

Source

DF

Adj SS

Adj MS

F-Value

P-Value

Purpose of Visit

5

15.60

3.120

0.24

0.944

Error

298

3855.14

12.937

Total

303

3870.73

Model Summary

S

R-sq

R-sq(adj)

R-sq(pred)

3.59676

0.40%

0.00%

0.00%

Means

Purpose of Visit

N

Mean

StDev

95% CI

Check Status of Order

49

15.633

3.672

(14.621, 16.644)

Find Local Store

57

15.368

3.539

(14.431, 16.306)

Job Opportunities

23

15.696

3.140

(14.220, 17.172)

Make a Complaint

14

16.214

3.239

(14.323, 18.106)

Place an Order

70

15.929

3.609

(15.083, 16.775)

Research Product

91

15.538

3.734

(14.796, 16.280)

Pooled StDev = 3.59676

b. In 2-3 sentences under each table showing the results for that variable, discuss if the results have statistical significance to the marketing team.

For comparing average age between 6 purpose of visit groups, calculated F=0.96, P=0.441 which is > 0.05 level of significance. Ho is not rejected. We conclude that there is no age mean difference between 6 purpose of visit groups.

For comparing average Household Income between 6 purpose of visit groups, calculated F=0.35, P=0.884 which is > 0.05 level of significance. Ho is not rejected. We conclude that there is no Household Income mean difference between 6 purpose of visit groups.

For comparing average Years of Education between 6 purpose of visit groups, calculated F=0.24, P=0.944 which is > 0.05 level of significance. Ho is not rejected. We conclude that there is no Years of Education mean difference between 6 purpose of visit groups.

Null hypothesis

All means are equal

Alternative hypothesis

Not all means are equal

Significance level

= 0.05

Related Questions

Navigate

• Browse (All)
• Browse 4
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.