Explore BrainMass

Regression Analysis

Multiple Regression and Model Building: Zebra Wild Game Far East restaurants

See attached file. The Zebra Wild Game Company sells exotic game to high end restaurants throughout the Far East. The sales manager wants to determine what, if any, relationship exists between the pounds of game sold by 24 sales persons and two independent variables, namely, the advertising dollars spent (in hundreds of tho

Multiple Regression and Model Building: Abalone Fancy Fish Company

See attached Excel file. The Abalone Fancy Fish Company sells exotic fish to high end restaurants throughout the East Coast. The sales manager wants to determine what, if any, relationship exists between the pounds of fish sold by 24 sales persons and two independent variables, namely, the length of time ( in years ) the sal

Investment Analysis: Fama and French model for Company A and Cisco Systems

Using the attached Fama and French Excel File: (a) Try to fit the CAPM equation to Company A's returns. What is the percentage of variation in Company A's returns attributable to system risk? (run a regression to answer this question) (b) Try to fit the 3-factor Fama and French model. Discuss the magnitude and economi

Correlation and Multiple Regression Analysis

PROBLEM 1 A consumer data analyst collected the following data on the screen size of popular LCD televisions sold recently at a large retailer: Manufacturer Screen Price ($) Sharp 46 1473.00 Samsung 52 2300.00 Samsung 46 1790.00 Sony 40 1250.00 Sharp 42 1546.50 Samsung 46 1922.50 Samsung 40 1372.00 Sharp 3

Key Data Regarding Multiple Regression Analysis

See attached file for full output. Municipalities and states have been asked by the Department of Energy to assess their energy requirements for each of the alternative fuels. In particular, they have decided to focus initially on natural gas, given the enormity of U.S. reserves and its relative cleanliness. Following ar

Correlation and Regression Analysis

The owner of a retail store randomly selected the following weekly data on profits and advertising cost. Week Advertising Cost ($) Profit ($) 1 0 200 2 50 270 3 250 420 4 150 300 5 125 325 1. Compute the least squares estimated line and predict

Confidence levels, regression analysis, and ANOVA: 3 problems

See attached file. 2. A random sample of 10 examination papers in a course, which was given on a pass or fail basis, showed the following scores. Create a 95% confidence interval for the population with a mean of 75 and Standard Deviation of the population of 10. A. Does this mean fall within that interval, what does t

Home Market Value vs Age: Scatter Chart, Trendline, Regression

See attached data file for data tables 1. Using the data in the Excel in the file Home Market Value, construct a scatter chart for market value versus age and add a linear trendline. Compare the coefficient of determination with the model developed in this chapter. What do you conclude? 2. Using the data in the Excel f

Multiple regression analysis.

The manager of Collins Import Autos believes the number of cars sold in a day (Q) depends on two factors: (1) the number of hours the dealership is open (H) and (2) the number of salespersons working that day (S). After collecting data for two months (53 days), the manager estimates the following log-linear model: Q= aHbSc a)

Multipe Regression Equation for Size and Selling Price

A real estate association in a suburban community would like to study the relationship between the size of a single-family house (as measured by number of rooms) and the selling price of the house (in thousands of dollars). Two different neighborhoods are included in the study, one on the east side of the community (=0) and the

Hypothesis Identification Article Analysis: What can analytics do for a company?

Using the "Competing on Analytics" article by Thomas H. Davenport prepare an analysis of how to compete on analytics. Have at least one industry example from the article. State at least one principle from the article. Based upon the article briefly conclude your review with explaining 'What can analytics such as statistics do

Please help with these statistic problems

Problem 1: (a) How does correlation analysis differ from regression analysis? (b) What does a correlation coefficient reveal? (c) State the quick rule for a significant correlation and explain its limitations. (d) What sums are needed to calculate a correlation coefficient? (e) What are the two ways of testing a correlation

MCQs: Hypothesis Testing & Time series Analysis

See attached file for graphs. 1) if the null hypothesis is not rejected, it can be assumed the proportions are __________ and the differences in them are due to chance. a) equal b) unequal c) small d) large 2) A pharmaceutical company is testing the effectiveness of a new drug for lowering cholesterol. As part of this

Regression Models that Predict Selling Price & SAT Scores

Thirteen students entered the undergraduate business program at Rollins College two years ago. The following table indicates what their grade-point averages (GPAs) were after being in the program for two years and what each student scored on one part of the SAT exam when he or she was in high school. Is there a meaningful relati

A regression equation

You are the marketing manager, in charge of a $1 million advertising budget, for two branches of the Long and Foster Real Estate Company. Because of slumping sales, the company president announces plans for an across-the-board budget cut of 10 percent. However, each department manager will have an opportunity to present his/he

Regression Equation for predicted selling price of $4 million home

The data show the list and selling prices for several expensive homes. Find the regression equation, letting the first variable be independent (x) variable. Find the best predicted selling price of a home having a list price of $4 million. List price (millions of $) 3.2 2.3 4 3.7 1.6 2.9 Selling price (millions of $) 3.4

Statistics: Track and Field

The long jump is a track-and-field event in which a competitor attempts to jump a maximum distance into a sandpit after a running start. At the edge of the pit is a takeoff board. Jumpers usually try to plant their toes at the front edge of this board to maximize their jumping distance. The absolute distance between the front ed

Data tables with excel regression with dependent variable

The data table in the excel file tabulates a pizza parlor's advertising expenditures and sales for 8 consecutive quarters. The marketing manager wants to know how much of an impact current advertising will have on sales two quarters from now. While running a regression with the dependent variable sales and the independent var

Regression Analysis: Predicted value

The regression analysis in the Excel file relates US annual energy consumption in trillions of BTUs to the independent variable US Gross Domestic Product (GDP) in trillions of dollars. Excel Output US Energy Consumption (in trillion BTUs) vs. Gross Domestic Product ($trillions) Regression Statistics

Simple regression or multiple regression

Market researcher Ally Nathan is studying the relationships among price, type (classical or steel string), and consumer demand for acoustic guitars. She wants to find the relationship between demand and price, controlling for type. To determine this relationship, she should A-Run a simple regression of the dependent variable


In a regression analysis with multiple independent variables, multicollinearity can be caused by: A- A strong nonlinear relationship between the dependent variable and one or more independent variables. B-A strong heteroskedastic relationship between the dependent variable and one or more independent variable.