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; (by process taken to reach the answer therefor, I can do it myself to reach the answer)

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 + Question 6 3 pts If you model 'usageTime' as a linear function of contentRating presentationRating and 'time SpentOnline' using a simple linear regression, which of the following statements is true? The marginal Impact of contentRating the change in website usage time for 1-unit increase in customer satisfaction with website content) is positive but not significant The marginal Impact of content Rating the change in website usage time for 1-unit increase in customer satisfaction with website content) is positive and significant. Customer satisfaction ratings with the content of the website has a greater impact on usage time than their satisfaction with website presentation None of the above U Question 7 3 pts If you model 'usageTime' as a linear function of contentRating: presentationRating and 'time SpentOnline' using a simple linear regression, what can you say about the coefficients of the model? select all that apply! The coefficients of the model capture the marginal Impact of the Independent/predictor variables on the dependent/predicted variable One-unit increase in time spent online measured in hours increases website usage time by (2.8, 2.9 minutes. Some of the estimated coeficients of the model are statistically Insignificant The coefficients are causal effects U Question 8 3 pts If you model 'usageTime' as a linear function of contentRating presentationRating and 'time SpentOnline' using a simple linear regression, which of the following statements is true? The overall model is unfortunately not significant statistically speaking The overall model is statistically significant time SpentOnline' has the greatest Impact on usageTime None of the above D Question 9 3 pts If you model'usageTime' as a linear function of contentRating presentationRating: 'timeSpentOnline' and student' using a simple linear regression, which of the following is an accurate statement about the results please convert categorical variables into numeric indicator variables before running a regression? This model with 'Is Student data does not particularly add any additional value to the model without It O presentation Rating' no longer has a greater impact on usageTime than 'contentRating: Whether or not a customer is also a student has a strong positive impact on website usage time None of the above U Question 10 3 pts If you model'usageTime' as a linear function of contentRating: presentationRating: 'time SpentOnline' and is Student' using a simple linear regression, what can you say about the results? (select all that apply) The model explains 1953, 96% of the variation in 'usageTime! The model explains 99%,99.5%) of the variation in 'usageTime: Whether or not a customer is also a student has the greatest impact on website usage time. The results are meaningless because the overal model is not statistically significant D Question 11 3 pts If you model 'usageTime' as a linear function of contentRating presentationRating: 'timeSpentOnline, isStudent' and 'isEmployed' using a simple linear regression, which of the following statements is true? This model is a better model compared to the ones exclude dent' or 'IsEmployed O Whether or not a customer is employed has a positive and significant impact on usageTime Whether or not a customer is employed has a greater Impact than whether or not they are a student O None of the above Question 12 3 pts If you model 'usageTime' as a linear function of contentRating: presentationRating'timeSpentOnline, isStudent' and 'isEmployed' using a simple linear regression, what is the marginal impact of isEmployed' on 'usageTime'? O 15.0, 6.0 O 1-4.0-4.01 O [-6.0 5.0 None of the above Question 13 3 pts What will be predicted value of usageTime' for a new student customer that is unemployed and is also known to spend 10 hours a week assuming their satisfaction ratings on both content and presentation are 5.0 on a scale of 1-10 (use a simple linear regression model where 'usageTime' is predicted as a function of contentRating: 'presentationRating: 'time SpentOnline'isStudent' and is Employed') O 191, 93 minutes O 191, 93] hours O 194,95] minutes None of the above D Question 14 3 pts What will be the predicted value of 'usageTime for a new student customer who is currently employed and is also known to spend 5 hours a week online assuming their satisfaction ratings on both content and presentation are same as the average in the sample dataset (use a simple linear regression model where 'usageTime'is predicted as a function of content Rating presentation Rating timeSpentOnline "isStudent' and Employed? O 170,71 minutes 170,71] seconds O 171,72 minutes None of the above Question 15 3 pts There are two customers exactly similar in every aspect except that one is employed and other is unemployed? Who is likely to spend more time on the website and by how much? (use a simple linear regression model where 'usageTime' is predicted as a function of contentRating presentationRating timeSpentOnline Student' and 'isEmployed)? Employed customer: 15. 6 minutes Unemployed customer. 15, 6 minutes Unemployed customer. [4, 5] minutes 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 + Question 6 3 pts If you model 'usageTime' as a linear function of contentRating presentationRating and 'time SpentOnline' using a simple linear regression, which of the following statements is true? The marginal Impact of contentRating the change in website usage time for 1-unit increase in customer satisfaction with website content) is positive but not significant The marginal Impact of content Rating the change in website usage time for 1-unit increase in customer satisfaction with website content) is positive and significant. Customer satisfaction ratings with the content of the website has a greater impact on usage time than their satisfaction with website presentation None of the above U Question 7 3 pts If you model 'usageTime' as a linear function of contentRating: presentationRating and 'time SpentOnline' using a simple linear regression, what can you say about the coefficients of the model? select all that apply! The coefficients of the model capture the marginal Impact of the Independent/predictor variables on the dependent/predicted variable One-unit increase in time spent online measured in hours increases website usage time by (2.8, 2.9 minutes. Some of the estimated coeficients of the model are statistically Insignificant The coefficients are causal effects U Question 8 3 pts If you model 'usageTime' as a linear function of contentRating presentationRating and 'time SpentOnline' using a simple linear regression, which of the following statements is true? The overall model is unfortunately not significant statistically speaking The overall model is statistically significant time SpentOnline' has the greatest Impact on usageTime None of the above D Question 9 3 pts If you model'usageTime' as a linear function of contentRating presentationRating: 'timeSpentOnline' and student' using a simple linear regression, which of the following is an accurate statement about the results please convert categorical variables into numeric indicator variables before running a regression? This model with 'Is Student data does not particularly add any additional value to the model without It O presentation Rating' no longer has a greater impact on usageTime than 'contentRating: Whether or not a customer is also a student has a strong positive impact on website usage time None of the above U Question 10 3 pts If you model'usageTime' as a linear function of contentRating: presentationRating: 'time SpentOnline' and is Student' using a simple linear regression, what can you say about the results? (select all that apply) The model explains 1953, 96% of the variation in 'usageTime! The model explains 99%,99.5%) of the variation in 'usageTime: Whether or not a customer is also a student has the greatest impact on website usage time. The results are meaningless because the overal model is not statistically significant D Question 11 3 pts If you model 'usageTime' as a linear function of contentRating presentationRating: 'timeSpentOnline, isStudent' and 'isEmployed' using a simple linear regression, which of the following statements is true? This model is a better model compared to the ones exclude dent' or 'IsEmployed O Whether or not a customer is employed has a positive and significant impact on usageTime Whether or not a customer is employed has a greater Impact than whether or not they are a student O None of the above Question 12 3 pts If you model 'usageTime' as a linear function of contentRating: presentationRating'timeSpentOnline, isStudent' and 'isEmployed' using a simple linear regression, what is the marginal impact of isEmployed' on 'usageTime'? O 15.0, 6.0 O 1-4.0-4.01 O [-6.0 5.0 None of the above Question 13 3 pts What will be predicted value of usageTime' for a new student customer that is unemployed and is also known to spend 10 hours a week assuming their satisfaction ratings on both content and presentation are 5.0 on a scale of 1-10 (use a simple linear regression model where 'usageTime' is predicted as a function of contentRating: 'presentationRating: 'time SpentOnline'isStudent' and is Employed') O 191, 93 minutes O 191, 93] hours O 194,95] minutes None of the above D Question 14 3 pts What will be the predicted value of 'usageTime for a new student customer who is currently employed and is also known to spend 5 hours a week online assuming their satisfaction ratings on both content and presentation are same as the average in the sample dataset (use a simple linear regression model where 'usageTime'is predicted as a function of content Rating presentation Rating timeSpentOnline "isStudent' and Employed? O 170,71 minutes 170,71] seconds O 171,72 minutes None of the above Question 15 3 pts There are two customers exactly similar in every aspect except that one is employed and other is unemployed? Who is likely to spend more time on the website and by how much? (use a simple linear regression model where 'usageTime' is predicted as a function of contentRating presentationRating timeSpentOnline Student' and 'isEmployed)? Employed customer: 15. 6 minutes Unemployed customer. 15, 6 minutes Unemployed customer. [4, 5] minutes None of the above