# The data presented in ‘ LodgePrices.sav’ file are a random sample of records of re-sale of… 1 answer below »

1. The data presented in ‘LodgePrices.sav’file are a random sample of records of re-sale of individual ‘Wilderness Lodging Units’from Jan – April.

Variables:

Price= Price in thousands of dollars

Sq. Feet= Size of lodge in sq. ft. living space.

Age= Age of lodge in years

Features= Number of features such as appliances (washer, dryer, refrigerator, microwave….etc.)

Using this data, answer the following:

a. What is the mean and std. deviation for:

a. Price __________________

b. SqFt. __________________

c. Age__________________

d. Features__________________

b. What is the value of correlation coefficient between the following variables and how do you interpret it:

a. Price & Sq Ft__________________

b. Price & Age__________________

c. Price & Features__________________

d. Age & Sq. Ft. __________________

e. Features & Sq.Ft. __________________

c. Draw a scatter plot of Price& SqFtand interpret it.

d. Draw a scatter plot of Priceand Ageand interpret it.

e. To analyze if there is an impact of SqFt, Age,and Featureson the Pricesof the wilderness lodges, which statistical technique you will utilize?

Run the analysis:

f. Is this model significant? Report the F & P values.

g. Which variables are significant predictors of the lodge prices? Report Pvalues.

h. What is the value of intercept or constant?

i. What is the regression equation?

j. What is the value of R-squared for this model? Interpret it.

k. Provide interpretation of all the unstandardized ‘B’ coefficients.

a. ______

b. ______

c. ______

d. ______

l. What is the predicted sales price for a 25 yrs. old wilderness lodge, having 6 features and 3000 sq. ft.?

m. Regression Diagnostics: (Show graphs/ figures in output tables and interpret these.)

a. Multicollinearity

b. Homoscedasticity

c. Normality

d. Report Durbin Watson Statistics and state what this indicates.

n. Comment on the validity of the model, in other words, can we generalize this model.

2. The data in file ‘TestScores.sav’were collected on 200 university students and are scores on various tests, including Algebra, Statistics, Readingand General studies (genstd). The variable Genderis a dichotomous variable coded 1 if the student was female and 0 if male.

Using this data, answer the following:

a. If you want to display variability in scores on Statisticstest for different groups (races), which graph you will utilize? Show your output graph below:

b. Are there any outliers in the graph? If yes, list the case number/s and group/s.

c. Which group exhibits the maximum variation in Statisticsscores?

d. Which group exhibits the minimum variation in the Statisticsscores?

e. By visually inspecting the data through this graph, can you identify the group having highest mean on Statisticsscore? If yes, name it.

f. To analyze if there is an impact of Reading scores, Statistics scores, General Studies scores, and Genderon the Algebra scores, which statistical technique you will utilize?

Run the analysis:

g. Is this model significant? Report the F & P values.

h. Which variables are significant predictors of the Algebrascores? Report P values.

i. What is the value of intercept or constant?

j. What is the regression equation?

k. What is the value of R-squared for this model? Interpret it.

l. Provide interpretation of all the unstandardized ‘B’ coefficients.

a. ______

b. ______

c. ______

d. ______

m. What is the predicted Algebra scorefor a female student with a score of 70 on Reading, 80 on Statistics, and 80 on General Studies?

n. Regression Diagnostics: (Show graphs and interpret these.)

a. Multicollinearity

b. Homoscedasticity

c. Normality

d. Report Durbin Watson Statistics and state what this indicates.

o. Comment on the validity of the model, in other words, can we generalize this model?

3. You as a general manager of a large resort hotel are interested in finding which ‘Training Method’is the most effective one for your employees. So far your training manager has utilized 3 different ways to train employees; ‘Face to Face’; ‘Fully Online’; and through ‘Training Manuals’. Manager has recorded the ‘Service Quality Scores’for each of these employees ranging from 0 to 15. The data is provided in file Training1.sav. Analyze the data and answer the following questions:

a. Which statistical analysis is the most appropriate to answer your question.

b. Name the dependent variable____________

c. Name the independent variable ___________

d. State the Null Hypothesis for this research problem. ___________

e. For assumption of ‘Equality of variance’, which test statistics is referred to?

f. What is the sig. value for the above asked test statistic?

g. How do you interpret this test statistic?

h. Report the F statistics and the sig. level for the overall test. Show output and highlight these figures.

i. What is your response to the main question asked above based on the results?

4. The owner of a prominent fine dining European cuisine restaurant wants to decide which chefsare the best for his restaurant, in terms of prepared food dish quality. He believes French chefs are the best in business. To test his belief, he invites Frenchand non-Frenchchefs to prepare some fine dining dishes. The overallqualityof these finisheddisheswas judged on a scale of 1 to 10. He has requested you to test whether he is right or not. You as a researcher believe that ‘Experience’of a chef also influences the overall quality of the prepared dish. The data are provided in file Chefs.sav. Help the owner to figure out whether French chefs are really the best.

a. Which statistical analysis is the most appropriate to answer your question.

b. How many variables you will be including for the analysis?

c. Name the dependent variable____________

d. Name the independent variable ___________

e. Name the third variable, if any. ___________

f. For assumption of ‘Equality of variance’, which test statistics is referred to?

g. What is the one assumption that you will definitely check for in this particular analysis?

h. Test for the assumption, report the sig. and interpret it for the assumption tested?

i. Report the F statistics and the sig. level for the overall test. Show output and highlight these figures.

j. What is your response to the main question asked above based on the results?

5. You, as a general manager of a large resort hotel, are againinterested in finding which ‘TrainingMethod’is the most effective one for your maleand femaleemployees. So far your training manager has utilized 3 different ways to train employees; ‘FacetoFace’; ‘FullyOnline’; and through ‘TrainingManuals’. Manager has recorded the ‘ServiceQualityScores’for each of these employees ranging from 0 to 15. The data is provided in file Training2.sav. Analyze the data and answer the following questions:

a. Which statistical analysis is the most appropriate to answer your question.

b. Name the dependent variable/s____________

c. Name the independent variable/s ___________

d. For assumption of ‘Equality of variance’, which test statistics is referred to?

e. What is the sig. value for this test statistic?

f. How do you interpret this test statistic?

g. Does Method of Training impact Service Quality Scores? Show output, highlight figures and write your answer.

h. Does ‘Gender’ impact the Service Quality Scores? Show output, highlight figures and write your answer.

i. Is there an interaction effect present? Show output, highlight figures and write your answer.

j. Plot the effect of training and gender on Service Quality Scores, show output and interpret it.