Explore BrainMass
Share

# Regression Analysis

### Estimating and Interpreting a Linear Regression Model: Example

See attached data file. The U.S. Bureau of Labor Statistics provides data on the year-to-year percentage changes in the wages and salaries of workers in private industries, including both 'white-collar' and 'blue-collar' occupations. Here we consider selected annual data in the file P02_56.xlsx. Is there evidence of a strong

### Statistics: Hypothesis Testing and Simple Linear Regression

See attached files. Lab 2: Hypothesis Testing and Simple Linear Regression Purpose: Students will learn (1) use Excel formulas to build contingency tables for the Chi-Square test of independence; (2) use Excel built-in data analysis procedures to perform one-way ANOVA test; (3) use Excel built-in data analysis procedures

### Statistics: 7 problems, Hypothesis Testing and Regression Analysis

Please see attached file. Attached (2): 7 statistic questions (.doc) Formulas and Tables (for reference) --------------------------------------------------------------------------------- HYPOTHESIS TESTING Problem 1 thru 4 (don't forget to state your hypotheses, type of test, alpha level, and your decision statisti

### Linear Trend Model-Regression analysis

Rubax, a U.S. manufacturer of athletic shoes, estimates the following linear trend model for shoe sales : Qt = a + bt + c1D1 + c2D2 + c3D3 Where Qt= sales of athletic shoes in the tth quarter T = 1,2, â?¦.,28 [2004(I), 2004(II), â?¦., 2010(IV)] D1 = 1 if t is quarter I (winter); 0 otherwise D2= 1 if it is t quarter II

### Statistics Analysis for performance of U.S. Navy selected 16 hospitals

Data for the problem is on page 5, 6, and 7 of the attached document The U.S. Navy selected 16 hospitals that it believes to be efficiently run and conducted a regression analysis to evaluate the performance of its hospitals in terms of how many labor hours are used relative to how many labor hours are needed. The variables a

### Statistics Analysis: Sale and Service

Data for the problem appears on page 3 and 4 of the attached document. Accu-Copiers, Inc. sells and services the Accu-500 copying machine. As part of its standard service contract, the company agrees to perform routine service on this copier. To obtain information about the time it takes to perform routine service, Accu-Cop

### Probabilities: Express service, employy exercise, customer checkout line, purchases

See attached template file. 28. Suppose the regional express delivery service wants to estimate the cost of shipping a package (y) as a function of cargo type, where cargo type includes the following possibilities: fragile, semi fragile, and durable. Costs for 15 randomly chose packages od approximately the same weight and s

### Statistics Problems 14.5, 14.7, 14.25, 14.41, 14.43, 14.49, 16.7, 16.13, 16.15, 16.47

See attached files. The first document is the homework and the second one is the tutor's data and answers. 14.5 A consumer organization wants to develop a regression model to predict mileage (as measured by miles per gallon) based on the horsepower of the car's engine and the weight of the car ( in pounds). Data were coll

### 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

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 thousands of dollars) and

### 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

### Multiple Regression and Model Building: Municipalities use of alternative fuel in Illinois

See attached file. 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 are the data and o

### Multiple Regression and Model Building for municipalities use of alternative fuels

See attached file. 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 are the data and o

### Multiple Regression and Model Building for Municipalities energy requirements

See the attached file. 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 is the available

### 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

### When is a regression equation used? What are outliers?

When is a regression equation used? What terms describe the fit of a regression equation to the data? What is the importance of the coefficient of determination (r2)? What are outliers? How do you identify outliers in your data? How do outliers impact your regression equation? Provide a regression equation which would be a

### 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

### Simple Linear Regression Analysis: Zebra Wild Game Prediction interval for advertising

See attached file. The Zebra Wild Game Company sells exotic game to high end restaurants throughout Asia. The sales manager wants to determine what, if any, relationship exists between the pounds/week of game sold by 24 sales persons and the advertising dollars spent (in hundreds of dollars/week). Attached is the MegaSt

### Regression Analysis

The Abalone Fancy Fish Company sells exotic fish to high end restaurants throughout the West Coast. The sales manager wants to determine what, if any, relationship exists between the pounds/week of fish sold by 24 sales persons and the length of time (in years) the sales person has been with the company. Attached is the Me

### Regression Analysis: Fuel Consumption and Temperature

A very broad consensus has emerged around the proposition that global warming is a reality, with likely serious global consequences. Moreover, while there is still not unanimity that global warming is entirely man-made, there is broad agreement that it is desirable to cut emissions from coal and petroleum. Finally, many energy

### Regression and Correlation: Discuss relationships in four situations

Regression and Correlation are the most used and most abused tools in research. People are quick to jump to conclusions that if a relationship exists between two variables, then one must cause the other. There are many reasons why two variables can be related without causality. For example, there is a strong inverse relations

### Simple Linear Regression Analysis, p value, confidence interval: Global Warming

See attached file. A very broad consensus has emerged around the proposition that global warming is a reality, with likely serious global consequences. Moreover, while there is still not unanimity that global warming is entirely man-made, there is broad agreement that it is desirable to cut emissions from coal and petroleum.

### Global Warming: Simple Linear Regression Analysis

See attached file. A very broad consensus has emerged around the proposition that global warming is a reality, with likely serious global consequences. Moreover, while there is still not unanimity that global warming is entirely man-made, there is broad agreement that it is desirable to cut emissions from coal and petroleum.

### 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

### Regression and correlation are the most used and abused tools in research

Regression and correlation are the most used and most abused tools in research. People are often quick to jump to the conclusion that if a relationship exists between two variables, one must cause the other. In reality, there are many reasons why two variables can be related without causality. For example, there is a strong inve

### 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)

### Multiple Regression: Study selling price of house vs size (number of rooms)

See attached file. 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