Question

In: Math

General guidelines: Use EXCEL or PHStat to do the necessary computer work. Do all the necessary...

General guidelines:

Use EXCEL or PHStat to do the necessary computer work.

Do all the necessary analysis and hypothesis test constructions, and explain completely.

Read the textbook Chapter 11. Solve the textbook example on page 403, "Mobile Electronics," in order to compare four different in-store locations with respect to their average sales.

Use One-Way ANOVA to analyze the data set, data, given for this homework.

Use 5% level of significance.

1) Do the Levene test in order to compare the variance of the sales level at four different in-store locations.

2) If there are no significant differences between the variance of sales, then conduct the one-way ANOVA hypothesis test to compare the average sales level at four different in-store locations.

3) If you have seen evidence of difference among the average sales levels at these four different in-store locations, then identify which in-store locations have significantly different average sales than other in-store locations, by using the Tukey procedure

Data Set:

In-aisle Front Kiosk Expert
30.06 32.22 30.78 30.33
29.96 31.47 30.91 30.29
30.19 32.13 30.79 30.25
29.96 31.86 30.95 30.25
27.74 32.29 31.13 30.55
32 31 30
33

30.5

30

Solutions

Expert Solution

MINITAB used for analysis.

Use One-Way ANOVA to analyze the data set, data, given for this homework. Use 5% level of significance.

1) Do the Levene test in order to compare the variance of the sales level at four different in-store locations.

Test for Equal Variances: Inasile, front, kiosk, expert

Method

Null hypothesis

All variances are equal

Alternative hypothesis

At least one variance is different

Significance level

α = 0.05

95% Bonferroni Confidence Intervals for Standard Deviations

Sample

N

StDev

CI

Inasile

5

1.03403

(0.180537, 11.8340)

front

7

0.46824

(0.161813, 2.1066)

kiosk

8

0.35848

(0.094007, 1.9875)

expert

6

0.17646

(0.053434, 0.9983)

Individual confidence level = 98.75%

Tests

Method

Test
Statistic

P-Value

Multiple comparisons

0.133

Levene

0.68

0.575

Calculated Levene test value = 0.68, P=0.575 which is > 0.05 level of significance. Ho is not rejected. We conclude that variance of the sales level at four different in-store locations are equal.

2) If there are no significant differences between the variance of sales, then conduct the one-way ANOVA hypothesis test to compare the average sales level at four different in-store locations.

One-way ANOVA: Inasile, front, kiosk, expert

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

Factor

4

Inasile, front, kiosk, expert

Analysis of Variance

Source

DF

Adj SS

Adj MS

F-Value

P-Value

Factor

3

21.606

7.2020

23.83

0.000

Error

22

6.648

0.3022

Total

25

28.254

Model Summary

S

R-sq

R-sq(adj)

R-sq(pred)

0.549694

76.47%

73.26%

65.06%

Means

Factor

N

Mean

StDev

95% CI

Inasile

5

29.582

1.034

(29.072, 30.092)

front

7

32.139

0.468

(31.708, 32.569)

kiosk

8

30.758

0.358

(30.354, 31.161)

expert

6

30.2783

0.1765

(29.8129, 30.7437)

Pooled StDev = 0.549694

Calculated F test value = 23.83, P=0.000 which is< 0.05 level of significance. Ho is rejected. We conclude that average sales level at four different in-store locations are not same .

3) If you have seen evidence of difference among the average sales levels at these four different in-store locations, then identify which in-store locations have significantly different average sales than other in-store locations, by using the Tukey procedure.​

Tukey Pairwise Comparisons

Grouping Information Using the Tukey Method and 95% Confidence

Factor

N

Mean

Grouping

front

7

32.139

A

kiosk

8

30.758

B

expert

6

30.2783

B

C

Inasile

5

29.582

C

Means that do not share a letter are significantly different.

Tukey Simultaneous Tests for Differences of Means

Difference of Levels

Difference
of Means

SE of
Difference

95% CI

T-Value

Adjusted
P-Value

front - Inasile

2.557

0.322

(1.662, 3.451)

7.94

0.000

kiosk - Inasile

1.175

0.313

(0.305, 2.046)

3.75

0.006

expert - Inasile

0.696

0.333

(-0.229, 1.621)

2.09

0.187

kiosk - front

-1.381

0.284

(-2.172, -0.590)

-4.85

0.000

expert - front

-1.860

0.306

(-2.710, -1.010)

-6.08

0.000

expert - kiosk

-0.479

0.297

(-1.304, 0.346)

-1.61

0.392

Individual confidence level = 98.91%

Tukey procedure shows front and Inasile are significant.

kiosk and Inasile are significant.

kiosk are front are significant.

expert and front are significant.


Related Solutions

Please Use Excel To Show All Work, I will like your asnwer if you do this...
Please Use Excel To Show All Work, I will like your asnwer if you do this :) 15.35 Refer to the Johnson Filtration problem introduced in this section. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow. Repair Time in Hours Months Since Last Service Type of Repair...
General Directions: Show all necessary supporting work and box in each answer. If a blank is...
General Directions: Show all necessary supporting work and box in each answer. If a blank is provided, state the answer in the blank. Use dimensional analysis to convert. If unable to state an exact answer, round to the nearest tenth. 1. 0.35 mi. =                           yd.                                          2. 182 ft =                              in. 3.143 ¾ in (fraction 3 over 4) in. =             cm                                          4. 5,237,833 in = _____ mi Consider the “metric staircase” to convert to the...
CSCE 1030: Lab 7 General Guidelines: (for ALL of your programming assignments and labs)  Use...
CSCE 1030: Lab 7 General Guidelines: (for ALL of your programming assignments and labs)  Use meaningful variable names.  Use appropriate indentation.  Use comments, especially for the header, variables, and blocks of code. Please make sure that your submitted code has comments as points may be deducted for a lack of comments. Example Header: /* Author: Jane Doe ([email protected]) Date: Instructor: Description: A small description in your own words that describe what the program does. Any additional flags...
Make Excel do all of the necessary calculations Report answers on the worksheet Label answers as...
Make Excel do all of the necessary calculations Report answers on the worksheet Label answers as the questions are labelled: a, b, c,… Use the probability notation p(A), p(Aand B),… etc Submit your spreadsheet in Blackboard Assignment. 2. Due to recent global economic trends, Brazilian currency has lost value compared to the US dollar. This devaluation caused an increase in the price of products in Brazil. The following table summarizes results from a consumer survey that asked about the number...
Please complete all work in excel. Use excel to make the calculations (cells can be clicked...
Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. A firm has 82 units of a product on hand. Forecasts of demand are 30 units per week. An MPS quantity of 100 units is planned to arrive in period 3. Customer orders are 32 for period 1, 28 for period 2, and 25 for period 3. What is...
Please complete all work in excel. Use excel to make the calculations (cells can be clicked...
Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. The manager of QuikStop (open 365 days a year) sells 40 cases of water each day. Order costs are $30 per order, and water costs $0.10 per bottle (each case of water contains 24 bottles). Daily holding costs are equal to 3 percent of the cost of the water....
Please complete all work in excel. Use excel to make the calculations (cells can be clicked...
Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. Activity Immediate Predecessor Activity Time (wks) Total Budgeted Cost A - 4 24,000 B - 5 15,000 C A 2 16,000 D B 8 40,000 E C 3 30,000 F D, E 5 55,000 G F 3 21,000 H D 7 21,000 I F 5 10,000 J G, H...
Please complete all work in excel. Use excel to make the calculations (cells can be clicked...
Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. There are four jobs to be done and four employees to do them. Each resource will take a specific time, translated to salaries, to do each job, as shown in the following table: Employee Job A B C D 1 $20 23 21 17 2 18 18 22 19...
Please use excel and show all work and formulas. (I will give your work a like...
Please use excel and show all work and formulas. (I will give your work a like if you do this) Size (1000s sq. ft) Selling Price ($1000s) 1.26 117.5 3.02 299.9 1.99 139.0 0.91 45.6 1.87 129.9 2.63 274.9 2.60 259.9 2.27 177.0 2.30 175.0 2.08 189.9 1.12 95.0 1.38 82.1 1.80 169.0 1.57 96.5 1.45 114.9 What are the p-values of the t test (for the slope estimate) and F test? What is the coefficient of determination? What is...
Use Excel to complete the following question. You must submit/attach all work done in Excel in...
Use Excel to complete the following question. You must submit/attach all work done in Excel in order to receive full credit. 5. A health advocacy group conducted a study to determine if the nicotine content of a particular brand of cigarettes was equal to the advertised amount. The cigarette brand advertised that the average nicotine content per cigarette was 1.4 milligrams. The advocacy group randomly sampled 24 cigarettes. The nicotine level for each of the sampled cigarettes is given below....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT