Marketing Research Question:

Please explain for each question how the answer can be found via excel. Due to the excel spread sheet being long I am not able to share the full sheet. Please do explain how to reach each answer of the 5 part question;

(Not full sheet)

P1.What can you say about the type of data collected by the website? (select all that apply)

- contentRating is an interval type non-categorical data

- timeSpentOnline is in ratio scale

- Only medians can be computed for isStudent data and not means

- timeSpentOnline is an interval scale data

P2. What is the mean (average) customer satisfaction levels with website content and website presentation respectively from the sample dataset?

- [5.6, 5.7] and [4.6, 4.7]

- Means cannot be computed for satisfaction ratings

- We cannot quantify means but we can say customers are generally more satisfied with content than presentation.

- None of the above

P3. What is true about the data collected by the website?

- The sample has more employed than unemployed users

- The sample has less students than non-students

- 60% of the website users are employed

- None of the above

P4. What can you say about the correlations between usageTime, contentRating and presentationRating? (select all that apply)

- Because of a strong correlation between contentRating and presentationRating, one can suspect that they are measuring the same thing.

- presentationRating is more heavily correlated with usageTime than contentRating is

- usageTime is positively correlated with both contentRating and presentationRating

- usageTime is positively correlated with presentationRating but not with 'contentRating'

P5. Which of the following is true about the correlation between usageTime and timeSpentOnline?

- There is a strong negative correlation

- The correlation is actually close to zero

- There is a positive correlation of [0.60, 0.63]

- None of the above

A B C D E F G i content Rating 2 7.1 3 5.7 4 5.1 5 6.9 6 7.9 7 4.8 8 5.2 9 4.6 10 8.1 11 4.7 12 6.4 13 4 14 3.2 15 6.4 16 2.4 17 4.3 18 6.9 19 7.4 20 6.5 21 8.1 22 6.9 23 4.6 24 8.3 25 4.5 26 4.8 27 6.5 presentation Rating isStudent 4.1 Yes 5.1 No 7.1 Yes 6.4 No 6.2 No 8.2 Yes 6.3 Yes 8 No 7.7 No 5.3 Yes 5.5 Yes 3.1 Yes 6.6 Yes 4.8 Yes 5.7 Yes 2.8 No 4.4 Yes 7.6 Yes 8.5 Yes 5.7 Yes 3.7 Yes 6.5 No 3.7 No 2.3 Yes 1.6 Yes 6.3 Yes isEmployed No No Yes Yes No Yes Yes No No Yes Yes No Yes Yes Yes No No No No No No No Yes Yes No No timeSpentOnline usageTime isSubscriber 11 95.78 Yes 7.5 70.74 No 12.9 105.45 Yes 11.9 86.32 Yes 8.6 81.41 No 6.7 88.31 Yes 5.6 78.86 No 13.1 99.64 Yes 10 91.87 Yes 9.2 85.14 No 13.7 102.59 Yes 6 71.71 No 11.5 102.72 Yes 14.5 102.26 Yes 5.9 74.33 No 11.2 70.87 No 6.5 80.99 No 6.1 94.94 Yes 6.4 97.47 Yes 6 85.94 No 6.3 78.38 No 6.9 76.85 No 14.2 83.85 No 8.7 71.77 No 12.8 87.17 No 5.5 87.65 No dataset_education website + A B C D E F G i content Rating 2 7.1 3 5.7 4 5.1 5 6.9 6 7.9 7 4.8 8 5.2 9 4.6 10 8.1 11 4.7 12 6.4 13 4 14 3.2 15 6.4 16 2.4 17 4.3 18 6.9 19 7.4 20 6.5 21 8.1 22 6.9 23 4.6 24 8.3 25 4.5 26 4.8 27 6.5 presentation Rating isStudent 4.1 Yes 5.1 No 7.1 Yes 6.4 No 6.2 No 8.2 Yes 6.3 Yes 8 No 7.7 No 5.3 Yes 5.5 Yes 3.1 Yes 6.6 Yes 4.8 Yes 5.7 Yes 2.8 No 4.4 Yes 7.6 Yes 8.5 Yes 5.7 Yes 3.7 Yes 6.5 No 3.7 No 2.3 Yes 1.6 Yes 6.3 Yes isEmployed No No Yes Yes No Yes Yes No No Yes Yes No Yes Yes Yes No No No No No No No Yes Yes No No timeSpentOnline usageTime isSubscriber 11 95.78 Yes 7.5 70.74 No 12.9 105.45 Yes 11.9 86.32 Yes 8.6 81.41 No 6.7 88.31 Yes 5.6 78.86 No 13.1 99.64 Yes 10 91.87 Yes 9.2 85.14 No 13.7 102.59 Yes 6 71.71 No 11.5 102.72 Yes 14.5 102.26 Yes 5.9 74.33 No 11.2 70.87 No 6.5 80.99 No 6.1 94.94 Yes 6.4 97.47 Yes 6 85.94 No 6.3 78.38 No 6.9 76.85 No 14.2 83.85 No 8.7 71.77 No 12.8 87.17 No 5.5 87.65 No dataset_education website +