(Q7) [Regression] Let's Conduct a regression analysis to understand what explains the differences in One-year Revenue...

  

Transcribed Image Text:

(Q7) [Regression] Let's Conduct a regression analysis to understand what explains the differences in "One-year Revenue ($) [revenue]" among different members. Potential predictors that we are considering are "Age in Years [age]", "number of visits [visits]", "Gender [gender]", and "Work Status [status]". (7-a) Attach the SPSS output of the regression analysis. (When you run SPSS on a virtual desktop, you might not be able to copy an SPSS output and paste it to an MS Word doc in your local computer. An easy solution is to take a screenshot.) (7-b) What percentage of the total variation of [Revenue] is explained by the estimated regression equation? (7-c) With alpha=0.10, which of the independent variables have a significant impact on the dependent variable(=revenue)? (i.e., list all of the independent variables that have a significant impact on the dependent variable) (7-d) Given the estimated regression equation, what is the predicted revenue from an AFC member with the following profile: - [Age]: 65 years old - [Number of Visits]: 12 times per month - [Gender]: Female (1-Male / 2-Female) - [Work Status]: Retired (1-Employed/2=Retired) (Q7) [Regression] Let's Conduct a regression analysis to understand what explains the differences in "One-year Revenue ($) [revenue]" among different members. Potential predictors that we are considering are "Age in Years [age]", "number of visits [visits]", "Gender [gender]", and "Work Status [status]". (7-a) Attach the SPSS output of the regression analysis. (When you run SPSS on a virtual desktop, you might not be able to copy an SPSS output and paste it to an MS Word doc in your local computer. An easy solution is to take a screenshot.) (7-b) What percentage of the total variation of [Revenue] is explained by the estimated regression equation? (7-c) With alpha=0.10, which of the independent variables have a significant impact on the dependent variable(=revenue)? (i.e., list all of the independent variables that have a significant impact on the dependent variable) (7-d) Given the estimated regression equation, what is the predicted revenue from an AFC member with the following profile: - [Age]: 65 years old - [Number of Visits]: 12 times per month - [Gender]: Female (1-Male / 2-Female) - [Work Status]: Retired (1-Employed/2=Retired)

Answer rating: 100% (QA)

7a Please refer to the attached SPSS output 7b The percentage of the total variation of Revenue expl... View the full answer