Share
Explore BrainMass

Regression Analysis

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

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

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

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