69% Thu 9: O Grades for Subash Thapa: DSC X Hawkes Learnil (4) ) Your package has ar. C learn.hawkeslearning.com/Portal/Test/TestTa norkw.pro Please
Question Get Answer

<br/><br/><br/><br/><br/><br/><br/>In order to understand this material

sufficiently for your Quiz and the Exam, follow the instructions below and answer all the questions in part 1 and 2.


The data is presented in the spreadsheet entitled Assgt-3.xls.


In order to complete the analysis in this assignment, you need to use Minitab (available at the COB computer lab.) . Once in the COB computer lab, select the COB Menu (Star Icon) &gt; DSCI &gt; Minitab, or COB Menu (Star Icon) &gt; Statistics&gt; Minitab.


Part 1 *********************************************************************
Mc Kinley Inc., a major consulting firm conducts a study for Kneewise, a major jeans and apparel manufacturer to determine the relationship between the age of apparel buyers (basically, their customers) and the primary channel from which they will buy the merchandise. Kneewise has three major channels of retail/distribution; department stores, mail-order catalogs and internet kiosks. 1000 apparel buyers were selected from each age group, and the primary source from which the apparel buyer bought the merchandise was noted. Columns A, B, and C contain the channel used to buy merchandise. These are department stores, mail-order catalogs and internet kiosks respectively. The five rows 1,2,3,4 and 5 correspond to the age groups, viz., less than 25, 25 and less than 35, 35 and less than 45, 45 and less than 55, and 55 and over respectively.
[Data Set Assgt-3.xls (Columns A - C)] 
1.             The data are in columns A - C of an Excel spreadsheet.
2.             Column A 'Stores', column B 'Catalogs', column C 'Internet Kiosks'.
3.             Transfer the contingency table to Minitab and perform a chi-square test for association between Age and Behavior. Use 0.05 as the level of significance.


Assignment Questions:
1.    What are the null hypothesis and alternative hypothesis to test whether the age groups are homogeneous across the channels from which the apparel was purchased?
2.    Are any expected frequencies less than 5?
3.    What is the p-value of the test?
4.    Do the data indicate that the age groups are homogeneous across the channels from which the apparel was purchased at the 5% significance level?
5.    What recommendation regarding marketing effort in the various channels should be made relative to the various age group markets?




Part 2. **********************************************************************


Doctor and Ramble Inc. hands out free samples of their shampoos usually during freshman orientation on college campuses.  It is noteworthy that with more than 2000 college campuses targeted nationwide by Doctor and Ramble, their annual promotion budget runs into the millions. Assume that the data in Columns F - I, which indicate whether the campus population actually availed of the free samples and whether they decided to switch to Doctor and Ramble's brand of shampoos, was obtained from a randomly selected, large university campus. The four rows of Columns F - I were use to indicate four adult age categories: 18 and less than 30, 30 and less than 40, 40 and less than 50, 50 and over years of age respectively.  
[Data Set Assgt#3.xls (Columns F - I)]
1.             The data are in columns F - I of the Excel dataset spreadsheet.
2.             The columns F through I indicate whether a student "Did not sample and did not switch", "Did not sample but switched", " Sampled but did not switch" and "Sampled and switched" respectively.
3.             Conduct the Chi-Square test using Minitab as indicated earlier, but at a significance level of 0.01.
4.             Combine the columns (add the values) in which shoppers did not sample (columns F &amp; G) into column K. Also combine the columns in which shoppers did sample (columns H&amp; I) into column L.
5.              Repeat the Chi-Square test at a significance level of 0.01 for columns K &amp; L.




Assignment Questions:
1.             What are the null and alternative hypotheses for test of independence for the four original groups of students?
2.             What are the expected values and p-value?
3.             What conclusions can be drawn from this test for independence?
4.             What are the null and alternative hypotheses to test the combined groups of students?
5.             What conclusions can be drawn from the test of these combined groups?


Hints for Excel Assignment 3
Part 1 
1. Labels will need to be added following the calculations (for either part).
2. Samples of the print-outs provided below are to help you ensure that you are on the right track.
Before labeling your output should look like the one shown below. (Note some values have been replaced with X/x .)


Start by adding labels to the data in Part 1:




Copy/paste the data from Excel to Minitab:


                          


In Minitab, select Stat &gt; Tables &gt; Chi-square Test for Association. Select Summarized data in a two-way table, and enter the worksheet columns that contain the columns of the contingency table.




Click OK. The results of the chi-square test will appear in the session window.




Test results (the true values are masked using X):




To get the critical chi-square value for alpha = 0.05, use the chi-square table.




Part 2
For the second part, the data is in Columns F through I of the spreadsheet. Start by labeling rows and columns, similar to what is shown below. Continue by transferring the data to Minitab and following steps similar to those described in Part 1.






You will need to modify the data to answer the second question of this part. First, combine the students that tried the samples, and those who didn't, in separate columns. The following is an example of the output of the Chi Square analysis:




To get the critical chi-square value for alpha = 0.01, use the chi-square table.


Experiential Exercise
As you work this assignment think about the following questions. Then form a team of 3 to 5 and discuss each of the following. You can engage in this discussion by meeting or your group can use a Wiki to engage in an online discussion. Instructions for setting up a Wiki are provided on the excel assignment page of our course web site. 
1.    What wording tells you the alternative and null hypothesis?
2.    What wording tells you the type of statistical test to perform? For example, is a z or t statistic appropriate?
3.    What wording tells you that this is a one or two tail hypothesis test?
4.    What were the steps you used to obtain the calculated value of the test statistic?
5.    What were the steps you used to obtain the critical value of the test statistic?
6.    How do you use the calculated and critical value to make a statistical decision about this test?
7.    How do you obtain the p value for the test statistic?
8.    How do you use the p value and the level of significance to make a statistical decision about this test?
9.    How does the result of your test relate to the statistical significance of your findings?
10. What managerial implications can you conclude from the results of your test?


To be ready for the "Excel Quiz 3" HLS Web Test you should prepare the following:

-correct output as required for both part 1 and part 2
- a statement of the null/alternative hypotheses to test independence for Part I and for Part II (Both 4-column and 2-column analyses).
-a decision, giving reason, corresponding to each hypothesis test (highlight, bold, label, or underline any relevant numbers in the output used to make the decision)
- answers to all of the assignment questions for each part typed at the bottom of the spreadsheet containing the analysis for that part.

The Excel assignments are each graded via a short Excel Quiz in HLS Web Test that is open for about 6 days as listed in the syllabus and in your HLS progress report. You are expected to use your output and written answers to complete the quiz. You are not required to turn in the output.


The questions below are much like the quiz you will have in WEBTEST. If you can answer these, you should have no difficulty with those that will be asked. However, these questions are not the exact questions that you will have to answer.


SAMPLE WEBTEST QUIZ
The correct answers to the sample quiz questions are marked with an asterisk.


Part I Questions:
1. What is the critical value of the Chi-square statistic for testing the relationship between purchase channel and age group?
A) 48.82                    B) 810.88                   C) 0.05                       D) 15.507*                 E) 0


2. What is your conclusion for the relationship between purchase channel and age group?
A)       Factors "Age" and "Purchase Channel" are independent.
B)       Age groups are homogeneous across the purchase channels.
C)       Age groups are distributed differently across the purchase channels*




Part II Questions:
3. What is calculated Chi-square value to test the belief that "consumer response (= decisions on whether to sample the product or switch to the product) is independent of age"?
A) 21.666         B) 14.757      C) 0.0331      D) 11.344   E) 18.182*


4. What was the critical (table) value of the Chi-square statistic for the above test?
A) 21.666*       B) 11.344                 C) 14.757      D) 0.002    E) 0.0331


5. What is your conclusion for the relationship between consumer response and age?
A)       There is insufficient evidence to conclude that consumer response and age are related.*
B)       There is sufficient evidence to conclude that consumer response and age are related.

IMG_7549.jpg
69%
Thu 9:
O
Grades for Subash Thapa: DSC X
Hawkes Learnil
(4) ) Your package has ar.
C
learn.hawkeslearning.com/Portal/Test/TestTa
norkw.pro
Please Confirm Your Addre...
Apps
VMware . Paraphrasing
0 Mail Dashboard
Severe Weather In Your A...
norkw.pro
Submit Assignment
DSCI 3710 Excel Quiz 3
Stay Safe and Updated Wit...
Question 1 -
of 5 Step 1 of 1
What is p value to test the belief that &quot;sampling behavior is independent of age&quot;?
Answer
answered
5 Points
Tables
18.18
O 0.002
&lt;
O 0.0331
Prev
O 11.34
O 14.76
2020 Hawkes Learning
tv
W
IMG_7550.jpg
be 18 or older to purchase a ticket, PLAY RESP
elp with a gambling problem (Para ayuda con un
ambling.org
69%
Thu 9:22 PM
Q Q E
Grades for Subash Thapa: DSC X
Hawkes Learning
X
+
C
learn.hawkeslearning.com/Portal/Test/TestTakeTest#
. ..
Apps
VMware . Paraphrasing o Mail Dashboard # GroupMe fi On-campus Interv...
Submit Assignment
DSCI 3710 Excel Quiz 3
SUBASH THAPA
Question 2
of 5 Step 1 of 1
00:00:19
What is your conclusion for the test of homogeneity of purchase channels across different age groups?
Answer
5 Points
Tables
Keypad
There is evidence to conclude homogeneity because the calculated value of the test statistic is more than
the critical value.
There is evidence to conclude non-homogeneity because the calculated value of the test statistic is more
O
than the critical value.
Prev
O
There is evidence to conclude homogeneity because the calculated value of the test statistic is less than
the critical value.
There is evidence to conclude non-homogeneity because the calculated value of the test statistic equals
O
the critical value.
There is evidence to conclude non-homogeneity because the calculated value of the test statistic is less
than the critical value.
2020 Hawkes Learning
tv
4
W
IMG_7551.jpg
e game.
t be 18 or older to purchase a ticket. PLAY RESP.
help with a gambling problem (Para ayuda con t
rambling.org
69% Thu 9:22 PM Q E
Grades for Subash Thapa: DSC X
Hawkes Learning
X
+
C
learn.hawkeslearning.com/Portal/Test/TestTakeTest#
...
ops
VMware
Paraphrasing
10 Mail Dashboard # GroupMe ii On-campus Interv...
Submit Assignment
DSCI 3710 Excel Quiz 3
SUBASH THAPA
Question 3
of 5 Step 1 of 1
00:00:15
What is the p value to test the belief that &quot;sampling and switching behavior is independent of age&quot;?
Answer
5 Points
Tables
Keypad
O 0.0331
O 14.76
O 11.34
Prev
18.18
O 21.67
2020 Hawkes Learning
itv
W
X
IMG_7552.jpg
orial number is for validation purpose
the game.
be 18 or older to purchase a ticket. PLAY RESH
help with a gambling problem (Para ayuda con u
ambling.org
69%
Thu 9:22 PM QE
Grades for Subash Thapa: DSC X Hawkes Learning
X
+
learn.hawkeslearning.com/Portal/Test/TestTakeTest#
. ..
Apps
VMware
Paraphrasing o Mail Dashboard GroupMe
ii On-campus Interv...
Submit Assignment
DSCI 3710 Excel Quiz 3
SUBASH THAPA
Question 4 -
of 5 Step 1 of 1
00:00:11
What is the conclusion of the test if the belief is &quot;sampling behavior is independent of age&quot;?
Answer
5 Points
Tables
Keypad
O
The sampling behavior depends on age because the calculated value of the test statistic equals the
critical value.
The sampling behavior depends on age because the calculated value of the test statistic is less than the
critical value.
Prev
The sampling behavior depends on age because the calculated value of the test statistic is more than the
critical value.
The sampling behavior does not depend on age because the calculated value of the test statistic is more
than the critical value.
D +
The sampling behavior does not depend on age because the calculated value of the test statistic is less
than the critical value.
2020 Hawkes Learning
tv
O
W
IMG_7553.jpg
dures and final decisions of Execut
ve Director.
val number is for validation purposes only a
no game.
be 18 or older to purchase a ticket. PLAY RESt
help with a gambling problem (Para ayuda con u
g.org
69% Thu 9:22 PM
Grades for Subash Thapa: DSC X
Hawkes Learning
X
+
learn.hawkeslearning.com/Portal/Test/TestTakeTest#
. ..
Apps
VMware
Paraphrasing o Mail Dashboard GroupMe ii On-campus Interv...
&gt; &gt;
Submit Assignment
DSCI 3710 Excel Quiz 3
SUBASH THAPA
Question 5 -
of 5 Step 1 of 1
00:00:07
What is the critical (Table) value of the statistic for testing the relationship between retail channel and age
group?
Answer
5 Points
Tables
Keypad
O 48.82
O 15.51
810.88
rev
O 0.05
O 0.00
2020 Hawkes Learning
tv
W

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Let our 24/7 Statistics and Probability tutors help you get unstuck! Ask your first question.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes