Purchase Solution

Using regression and EDA to relate ratings to price

Not what you're looking for?

Ask Custom Question

Zagat's publishes restaurant ratings for various locations in the United States. The file RESTRATE.xls contains the Zagat rating for food, décor, service, and the price per person for a sample of 53 restaurants located in New York City and 53 restaurants located in Long Island. Suppose you wanted to develop a regression model to predict the price per person based on a variable that represents the sum of the ratings for food, décor, and service. Using EXCEL or PHStat2, answer the following: The following is a minimum guideline about what you should analyze. For example, you may have to use such tools as confidence interval estimates, one or two-sample tests on the data to improve the quality of your report.
a) State your statistical objective for this data set.
b) Perform exploratory data analysis using numerical measures or the box-and-whisker plot for this data set.
c) Construct a scatter diagram of price against summated rating. Describe the relationship that you think there may be. Does this appear to have some association (linear or non-linear)?
d) Construct a scatter diagram of price against each of food, décor, and service separately. Describe the relationship that you see from each diagram. Does any of these appear to have some association?

Guidelines for developing the essay is provided.

Please see the attachment for more information.

Attachments
Purchase this Solution
Solution Summary

The analysis involve using regression and EDA (Exploratory Data Analysis) to model the effect of restaurant ratings on price in two cities: New York and Long Island. We explore each variable using charts and numerical statistics. Then we apply Anova and ancova to model the effect.

Purchase this Solution
Free BrainMass Quizzes
Probability Quiz

Some questions on probability

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

View More Free Quizzes
Related BrainMass Solutions

  • Forming a Regression Model with Interaction Term

    Suppose you wanted to develop a regression model to predict the price per person based on a variable that represents the sum of the ratings for food, decor, and service.

  • Regression Analysis of Restaurant ratings

    Suppose you wanted to develop a regression model to predict the price per person based on a variable that represents the sum of the ratings for food, decor, and service.

  • Regression results for a bivariate model

    Below are MINITAB results from a regression using Y = mean student evaluation of the professor and X = class size for 364 business school classes taught during the 2002-2003 academic year. Ratings are on a scale of 1 (lowest) to 5 (highest).

  • Regression Analysis Calculations

    You want to develop a regression model to predict the price per person based on a variable that represents the sum of the ratings for food, décor, and service and to write a report on your findings.

  • Statistical Analysis in SAS

    Use this merged dataset to analyze the relationship between "gross_sell_amt" and other variables by using PROC MEANS, PROC FREQ, PROC UNIVARIATE, and PROC CORR, and PROC SGPLOT. 5.

  • Regression analysis and confidence interval

    Step by step method for regression analysis is discussed here. Regression coefficients, coefficient of determination, scatter diagram and significance of regression model are explained in the solution.

  • Calculation of regression line and Chi square

    Linear regression analysis is done for GPA and Salary data.

  • Regression Analysis: Plasma televisions by brand

    418524 Linear Regression for 42 inch plasma televisions by brand See attached data file. Consumer Reports provided extensive testing and ratings for more than 100 HDTVs.

  • ANOVA questions

    Using the example in #9 and the F distribution table in your book, what F score would you need to exceed in order to find significance at the .05 level?

View More Related Solutions