Purchase Solution

A Case study using Multiple Regression Analysis

Not what you're looking for?

Ask Custom Question

The Westar hotel, a 250 room business hotel has 2 lounges on its premises: Pour Nous Lounge (for 50 people)and Gaisete - for 200. We need to forcast beverage sales. Should we take into consideration season promotional food offered during happy hour, and the presence of a piano player in Pour Nous Lounge.Room occupancy is a fact to consider since the number of people staying might well influence beverage sales. the data available is for most recent 30 month..
The promotional food had been discotinued after mo. 12 and the piano player after mo. 13. No data available for mo. 14 & 15 due to change in ownership. What factors really influenced beverage sales? Should the piano player and the seasonal food offered during happo hour should be reinstated? I need to use multiple linear regression to forcast the success in beverage sales. See attached data

Attachments
Purchase this Solution
Solution Summary

In the present solution, a case study to examine the influence of various factors on the beverage sales is carried out using the multiple regression analysis tool and the conclusion is arrived.
The general procedure for implementing multiple regression analysis by using regression analysis tool of M S Excel is provided. Explanations are given, for how to interpret the estimated regression parameters such as the regression coefficients, coefficient of determination etc.

Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

View More Free Quizzes
Related BrainMass Solutions

  • Data Analysis: Multiple Regression

    Basically we want to see which variables are able to predict the dependent variable using the multiple regression. This solution is comprised of a detailed explanation of multiple regression analysis.

  • Importance of Using Regression Analysis

    One can study these factors to see if that is the case.

  • Statistics: Multi Regression analysis

    The statistical analysis of the data involves multiple-regression analysis. This problem is for Graduate/Masters level Questions to answer are: Question 1-4: please use attachment excel case 2008 1.

  • Managerial Reports: Alumni

    Please see the attached files for a full solution. This response provides guidelines on creating a managerial report using multiple linear regression.

  • Linear Regression Analysis

    Given here is Excel output for a simple regression model that was developed for this case. Analyze the computer output. Regression Analysis Can the cost of flying a commercial airliner be predicted using regression analysis?

  • multiple regression and chi-squared

    The data analysis method will be multiple regression. Multiple regression and chi-squared analysis is given in the solution. The solution examines the appropriate type of data collection to evaluate teen prostitution.

  • Multiple Linear Regression - Job Satisfaction

    Multiple linear regression is the most commonly used statistical test for quantitative DBA studies. Run a multiple linear regression using the Week 6 Data File for Multiple Linear Regression.

  • Multiple regression analysis of crime rate in Megastat

    126007 Multiple Regression Analysis My research is based on this topic below. The data is attached in the spreadsheet. This is a multiple regression analysis.

  • Multiple regression analysis for production cost

    F test of a multiple regression model A company that manufactures computer chips wants to use a multiple regression model to study the effect that different variables have on y, the total daily production cost (in thousands of dollars).

View More Related Solutions