Question: I'm looking for help with the proper regression test to use. Instructions for Regression Questions Explain which variables you are using and which types of
I'm looking for help with the proper regression test to use.
Instructions for Regression Questions
- Explain which variables you are using and which types of variables they are.
- Explain the context of the data collection and how each variable is measured.
- Explain for each independent variable what type of relationship (e.g., positive, negative, or no relationship) that you are anticipating with the dependent variable and provide a logical reasoning for it.
- If the regression involved more than one iteration in arriving at the final model, use the following table to briefly summarize all iterations and then discuss the points below (a through e) only for the final iteration.
| Model | Independent variables | Model Significance | R2 Adj. | Variable Removed (p value) |
|---|---|---|---|---|
- See the ANOVA table and interpret the results.
- Show the value of R2 and interpret it.
- Show the coefficient table and interpret the results.
- Write the regression equation.
- For each relationship or test result that does not turn out as you anticipated (c), provide the possible reasoning for it.
BST305 Project- Business Analytics II Project Case Questions Questions: 1.Refer to the Table 1 from the case. Items Q2 through Q14 measures different facets of the quality of the campus dining facility. a. For each of these quality factors, test if there are differences in mean scores based on the frequency of visit. b. If there are, find which categories of frequency of visit have a different mean score. Provide a logical explanation about why they differ. c. Why is it important to test differences in mean scores of quality based upon the frequency of visits? 2. The survey measures the overall satisfaction with the dining facility. a. For overall satisfaction, test if there are differences in mean scores based on the frequency of visit and gender. b. Do the female students, for a given level of frequency of visit, have a different level of satisfaction compared to male students? Explain how the test results help you to answer this question. c. Why is it important to test differences in mean scores of satisfaction based upon the frequency of visit and gender? 3. The survey measures retention with the dining facility. a. For retention, test if there are differences in mean scores based on the year in school and gender. b. Do male students, for a given year in school, indicate a different intention of visiting the facility compared to female students, if a new dining option becomes available? Explain how the test results help you to answer this question. c. Why is it important to test the differences in mean scores of satisfaction based upon year in school and gender? 4.Refer to the Table 1 from the case. Items Q2 through Q14 measures different facets of the quality of the campus dining facility. a. What quality factors affect overall satisfaction with the dining facility? b. Include gender along with the factors found significant in part a, and test if gender also affects overall satisfaction with dining facility. 5.Refer to the Table 1 from the case. Items Q2 through Q14 measures different facets of the quality of campus dining facility. a. What quality factors predict retention, measured as is, with the dining facility? b. In addition to the factors found in part a, develop a model that includes gender, and estimate the difference in retention between male and female students
Table 1: Variables and Scale of Measurement Variable Survey Question Scale of Measurement D1 How often do you eat at/purchase meals? 1- Daily 2- 2 or 3 times per week 3- Weekly 4- 2 or 3 times per month 5- Once a month or less D2 Gender 1-Male 2-Female D3 Year in school 1-Freshman 2-Sophomore 3-Junior 4-Senior Q1 Survey ID Number from 1 through 62 Q2 Attractive food presentation Questions Q2 through Q14 were measured on following Scale. 1- Very unsatisfied 2- Somewhat unsatisfied 3- Neither unsatisfied nor satisfied 4- Somewhat satisfied 5- Very satisfied Q3 Variety of food choices Q4 Availability of healthy food options Q5 Taste and flavor of food Q6 Portion size Q7 Hot food is hot and cold food is cold Q8 Quality of ingredients Q9 Cleanliness of the facility Q10 Friendliness of service staff Q11 Speed of service Q12 Hours of service Q13 Prices Q14 Value of the meal Q15 Overall satisfaction with facility Q16 If a new option became available on campus for meals would you stay with this facility or go with the new option? (retention) Questions Q15 measured on following Scale. 1- Very likely stay with this facility 2- somewhat likely stay with this facility 3- Neither likely nor unlikely 4- Somewhat unlikely stay with this facility 5- Very unlikely stay with this facility
| Q1 | D1 | D2 | D3 | Q2 | Q3 | Q4 | Q5 | Q6 | Q7 | Q8 | Q9 | Q10 | Q11 | Q12 | Q13 | Q14 | Q15 | Q16 |
| 1 | 5 | 2 | 1 | 4 | 3 | 5 | 4 | 5 | 4 | 4 | 5 | 5 | 5 | 5 | 3 | 4 | 4 | 1 |
| 2 | 4 | 1 | 1 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 4 | 5 | 4 | 2 |
| 3 | 1 | 2 | 2 | 4 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 5 | 3 | 3 | 3 | 3 | 3 | 1 |
| 4 | 1 | 2 | 1 | 5 | 4 | 3 | 4 | 4 | 5 | 5 | 5 | 5 | 4 | 5 | 5 | 5 | 5 | 1 |
| 5 | 1 | 1 | 1 | 3 | 3 | 5 | 3 | 2 | 4 | 3 | 4 | 5 | 4 | 4 | 3 | 3 | 4 | 3 |
| 6 | 4 | 2 | 4 | 4 | 4 | 3 | 3 | 3 | 3 | 3 | 5 | 3 | 2 | 3 | 3 | 3 | 3 | 4 |
| 7 | 1 | 2 | 1 | 3 | 2 | 3 | 3 | 3 | 4 | 3 | 3 | 4 | 3 | 4 | 2 | 3 | 4 | 3 |
| 8 | 4 | 1 | 1 | 3 | 4 | 4 | 3 | 3 | 3 | 3 | 4 | 4 | 3 | 3 | 2 | 2 | 3 | 3 |
| 9 | 5 | 1 | 1 | 4 | 4 | 4 | 5 | 3 | 4 | 5 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 3 |
| 10 | 3 | 2 | 1 | 5 | 4 | 3 | 4 | 5 | 4 | 4 | 4 | 5 | 5 | 4 | 3 | 4 | 4 | 3 |
| 11 | 5 | 1 | 3 | 2 | 3 | 3 | 2 | 4 | 4 | 2 | 4 | 3 | 3 | 4 | 2 | 2 | 3 | 4 |
| 12 | 3 | 2 | 1 | 3 | 2 | 3 | 4 | 4 | 4 | 3 | 5 | 3 | 2 | 1 | 3 | 3 | 3 | 5 |
| 13 | 5 | 1 | 3 | 4 | 5 | 4 | 5 | 4 | 5 | 4 | 4 | 5 | 4 | 4 | 3 | 3 | 4 | 3 |
| 14 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 3 | 3 | 4 | 2 | 1 | 2 | 2 | 1 | 5 |
| 15 | 5 | 1 | 4 | 3 | 4 | 5 | 3 | 2 | 4 | 4 | 5 | 5 | 5 | 4 | 3 | 2 | 5 | 3 |
| 16 | 1 | 1 | 2 | 2 | 3 | 3 | 2 | 2 | 4 | 2 | 4 | 4 | 3 | 3 | 3 | 2 | 2 | 4 |
| 17 | 4 | 1 | 4 | 2 | 3 | 2 | 2 | 4 | 3 | 2 | 4 | 4 | 4 | 4 | 1 | 2 | 3 | 2 |
| 18 | 5 | 1 | 3 | 4 | 5 | 4 | 3 | 3 | 4 | 5 | 5 | 5 | 5 | 3 | 2 | 1 | 3 | 3 |
| 19 | 3 | 1 | 1 | 4 | 5 | 2 | 4 | 3 | 4 | 4 | 5 | 5 | 4 | 4 | 2 | 3 | 4 | 3 |
| 20 | 1 | 1 | 4 | 3 | 3 | 3 | 3 | 4 | 1 | 2 | 2 | 4 | 4 | 3 | 2 | 1 | 1 | 3 |
| 21 | 1 | 1 | 3 | 4 | 4 | 4 | 4 | 2 | 4 | 4 | 5 | 4 | 3 | 1 | 4 | 3 | 3 | 4 |
| 22 | 1 | 2 | 2 | 2 | 2 | 2 | 1 | 2 | 1 | 2 | 2 | 2 | 1 | 2 | 2 | 2 | 2 | 4 |
| 23 | 1 | 1 | 2 | 3 | 4 | 4 | 4 | 4 | 3 | 2 | 3 | 3 | 4 | 2 | 5 | 3 | 3 | 4 |
| 24 | 5 | 1 | 2 | 2 | 1 | 1 | 2 | 2 | 3 | 2 | 4 | 4 | 4 | 3 | 2 | 2 | 2 | 3 |
| 25 | 2 | 1 | 3 | 4 | 4 | 5 | 3 | 3 | 5 | 4 | 5 | 2 | 2 | 1 | 1 | 2 | 3 | 3 |
| 26 | 5 | 1 | 2 | 4 | 3 | 2 | 3 | 3 | 3 | 2 | 5 | 4 | 3 | 2 | 1 | 3 | 3 | 4 |
| 27 | 2 | 1 | 2 | 4 | 3 | 3 | 4 | 1 | 5 | 3 | 5 | 3 | 1 | 3 | 2 | 2 | 3 | 4 |
| 28 | 1 | 1 | 2 | 1 | 1 | 1 | 3 | 1 | 2 | 2 | 5 | 2 | 1 | 5 | 2 | 3 | 1 | 1 |
| 29 | 1 | 1 | 2 | 3 | 2 | 1 | 2 | 1 | 5 | 3 | 5 | 3 | 3 | 4 | 1 | 2 | 2 | 5 |
| 30 | 3 | 1 | 4 | 4 | 4 | 3 | 4 | 4 | 5 | 3 | 5 | 5 | 4 | 4 | 3 | 4 | 4 | 3 |
| 31 | 5 | 2 | 4 | 3 | 2 | 2 | 3 | 3 | 4 | 3 | 4 | 4 | 4 | 3 | 1 | 3 | 3 | 2 |
| 32 | 3 | 1 | 4 | 3 | 1 | 2 | 4 | 3 | 4 | 4 | 4 | 4 | 3 | 1 | 4 | 2 | 3 | 3 |
| 33 | 2 | 1 | 4 | 3 | 2 | 4 | 4 | 3 | 3 | 3 | 4 | 4 | 4 | 5 | 3 | 5 | 4 | 3 |
| 34 | 3 | 1 | 4 | 4 | 3 | 4 | 5 | 4 | 5 | 5 | 5 | 5 | 4 | 4 | 3 | 4 | 4 | 3 |
| 35 | 1 | 1 | 3 | 4 | 4 | 3 | 4 | 5 | 2 | 4 | 3 | 3 | 1 | 1 | 4 | 4 | 4 | 3 |
| 36 | 1 | 2 | 3 | 3 | 5 | 5 | 5 | 3 | 5 | 5 | 5 | 5 | 3 | 1 | 2 | 3 | 4 | 3 |
| 37 | 1 | 1 | 2 | 5 | 3 | 4 | 4 | 3 | 4 | 4 | 5 | 5 | 3 | 1 | 3 | 3 | 4 | 3 |
| 38 | 2 | 1 | 2 | 3 | 2 | 3 | 2 | 4 | 3 | 3 | 4 | 5 | 4 | 4 | 4 | 3 | 3 | 2 |
| 39 | 1 | 1 | 3 | 3 | 4 | 2 | 2 | 4 | 2 | 3 | 4 | 5 | 3 | 3 | 1 | 2 | 3 | 3 |
| 40 | 3 | 1 | 4 | 3 | 1 | 1 | 5 | 4 | 5 | 4 | 5 | 5 | 4 | 1 | 2 | 2 | 2 | 5 |
| 41 | 1 | 2 | 2 | 3 | 3 | 4 | 4 | 3 | 5 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 |
| 42 | 5 | 1 | 2 | 4 | 3 | 2 | 2 | 3 | 3 | 2 | 4 | 4 | 4 | 3 | 3 | 4 | 3 | 2 |
| 43 | 1 | 1 | 4 | 4 | 3 | 3 | 4 | 4 | 4 | 3 | 3 | 4 | 2 | 4 | 5 | 5 | 4 | 3 |
| 44 | 1 | 1 | 3 | 3 | 3 | 5 | 3 | 5 | 5 | 4 | 5 | 4 | 4 | 2 | 5 | 4 | 4 | 3 |
| 45 | 1 | 1 | 4 | 3 | 1 | 3 | 3 | 2 | 2 | 2 | 5 | 5 | 3 | 3 | 4 | 3 | 3 | 3 |
| 46 | 2 | 1 | 4 | 3 | 4 | 3 | 4 | 2 | 2 | 2 | 4 | 5 | 5 | 5 | 3 | 2 | 2 | 4 |
| 47 | 2 | 1 | 3 | 3 | 2 | 2 | 3 | 2 | 3 | 4 | 3 | 5 | 3 | 4 | 1 | 3 | 3 | 3 |
| 48 | 3 | 2 | 2 | 4 | 3 | 5 | 5 | 4 | 3 | 5 | 4 | 5 | 5 | 5 | 3 | 5 | 4 | 3 |
| 49 | 5 | 1 | 3 | 4 | 4 | 5 | 4 | 3 | 4 | 4 | 5 | 5 | 5 | 2 | 2 | 3 | 5 | 2 |
| 50 | 1 | 2 | 4 | 3 | 4 | 4 | 3 | 5 | 3 | 3 | 4 | 5 | 3 | 3 | 4 | 4 | 4 | 3 |
| 51 | 2 | 1 | 1 | 4 | 4 | 5 | 4 | 3 | 5 | 3 | 5 | 5 | 5 | 4 | 1 | 3 | 4 | 3 |
| 52 | 2 | 2 | 4 | 4 | 5 | 5 | 4 | 4 | 5 | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 2 |
| 53 | 2 | 1 | 2 | 4 | 2 | 2 | 4 | 4 | 5 | 2 | 5 | 3 | 4 | 2 | 1 | 4 | 3 | 1 |
| 54 | 5 | 2 | 1 | 3 | 4 | 2 | 3 | 3 | 3 | 3 | 4 | 4 | 3 | 3 | 2 | 3 | 3 | 3 |
| 55 | 1 | 2 | 1 | 3 | 2 | 2 | 3 | 4 | 5 | 3 | 4 | 5 | 5 | 4 | 3 | 4 | 3 | 3 |
| 56 | 5 | 1 | 1 | 5 | 5 | 3 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 1 | 1 | 2 | 3 | 5 |
| 57 | 5 | 1 | 2 | 4 | 4 | 3 | 3 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 3 | 3 | 4 | 3 |
| 58 | 3 | 2 | 3 | 4 | 4 | 4 | 4 | 1 | 4 | 4 | 4 | 4 | 4 | 4 | 1 | 3 | 3 | 1 |
| 59 | 2 | 1 | 2 | 3 | 2 | 1 | 4 | 2 | 3 | 2 | 3 | 4 | 3 | 3 | 4 | 5 | 4 | 3 |
| 60 | 1 | 1 | 4 | 2 | 1 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 3 |
| 61 | 1 | 2 | 2 | 3 | 3 | 2 | 5 | 4 | 5 | 3 | 5 | 5 | 4 | 2 | 3 | 3 | 3 | 3 |
| 62 | 1 | 1 | 3 | 3 | 1 | 2 | 3 | 4 | 4 | 3 | 5 | 5 | 3 | 2 | 3 | 4 | 2 | 1 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help