But this time,?you need to do the statistical or Hypothesis Testing for: 1. There are five questions Q1?to Q5?i

But this time, you need to do the statistical or Hypothesis Testing for:

1. There are five questions Q1 to Q5 in Part One. You need to conduct the hypothesis test to show AT LEAST THREE that there is no significant difference among the four groups in term of the distribution of each question. (if they, do, you need to write a paragraph to remind the readers the possible issues); 3 out of 5. 

2.  There are three questions in Part Two (Coffee-T-shirt-Shampoo ). You need to conduct the hypothesis test to show that there is no significant difference among the four groups in term of the perception of the prices of the three products. (if they, do, you need to write a paragraph to remind the readers the possible issues);  3 out of 3;

3.  There are TEN questions in Part FOUR (Demographical). You need to conduct the hypothesis test to show AT LEAST THREE variables that there is no significant difference among the four groups. (if they, do, you need to write a paragraph to remind the readers the possible issues); 3 out of 10.

Any other creative analysis is welcomed. 

In conclusion, you are on your own to generate this comprehensive Statistical report (as professional as possible) to proof or disproof your main purpose and make sure you address the possible criticisms.

We can have Q&A in the discussion board.

While the report can be your own way to express what you have learned and what you can find from the survey data to the point of the whole purpose of the survey, I would suggest that you include the followings:

1. Executive Summary;

2. Main findings (the 3 ANOVA results) and explain it to the executives who may not know the Statistics;

3. What can you answer any critics: The key is that the four groups are randomly selected so that there are no significant differences among them in term of Q1 to Q5 and all the Demographic variables.   

***Most importantly – need this assignment completed using Excel