Explore BrainMass
Share

# Regression Analysis

### Forecasting with linear trend

The number of new contributors to a public radio station's annual fund drive over the last ten years is 63, 58, 61, 72, 98, 103, 121, 147, 163, 198 Develop a trend equation for this information, and use it to predict next year's number of new contributors. ANS: FORECASTING WITH LINEAR TREND: *******************

### Portfolio risk and return.

1. Suppose a portfolio had been formed with 40% portfolio value in stock DO and 60% in stock GDT. Compute the mean and standard deviation of the individual stock returns, and S&P 500 index returns over the sample period. Is the portfolio's return riskier than the individual stock returns, than the index returns? 2. Calculate th

### A,B,C Inc. produces fresh, a brand of liquid laundry detergent.

A,B,C Inc. produces fresh, a brand of liquid laundry detergent. In order to more effectively manage its inventory and make revenue projections, the company would like to like to better predict demand for Fresh. The company has established the flowing demand equation: Demand = Bo + B1FreshPrice + B2ComPrice +

### Regression, ANOVA, Hypothesis

Need explanation. File attached. Problem 1 A,B,C Inc. produces fresh, a brand of liquid laundry detergent. In order to more effectively manage its inventory and make revenue projections, the company would like to like to better predict demand for Fresh. The company has established the flowing demand equation:

### Multiple Linear Regression Model - Babies R' Us Case Study

Please see two attached files: case study is the word doc; and the data is in excel. ----------------------------- Babies R'Us Case Study You have been hired as a strategic consultant by the hugely successful retailer "Babies R'Us". The company sells many products, although one product in particular, a highly innovativ

### Determining the Least Squares Equation: Example Problem

3. Listed below are the net sales for Schering-Plough Corporation (a pharmaceutical company) and its subsidiaries for the six years from 1997 to 2002. The net sales are in millions of dollars. 1997 \$6714 1998 \$7991 1999 \$9075 2000 \$9775 2001 \$9762 2002 \$10,180 Determi

### Chi square test and regression analysis problems

Hello, Attached are 5 statistics problems that I need help. I would like detailed step-by-step guidance to help me better understand the problems. Thanks in advance. 1. To examine the continuity and discontinuity in the criminal careers of 7,453 females of low socio-economic status, Tracy and Kempf-Leonard (1996) ex

### Analysis of the Number of Touchdowns

Can you predict the number of touchdowns from the following variables: attempts, yards, and yards per game? Develop a correlation matrix for the 3 predictor variables, do you suspect multicolinarity? What is your multiple regression equation, is it significant? Predict the number of touchdowns for a back with 200 at

### Regression & Seasonal Index

Determining a Seasonal Index Listed below is the net sales in \$ million for Home Depot, Inc. and its subsidiaries from 1993 to 2002. Year Net Sales 1993 9,239 1994 12,477 1995 15,470 1996 19,535 1997 24,156 1998 30,219 1999 38,434 2000 45,738 2001 53,553 2002 58,247 Determine the least squares equation. On the

### Completing Correlation Analysis in Excel

I am having trouble really understanding how to complete the correlation analysis. Can someone show me how step by step? I am to figure out how to perform a correlation analysis on the following, with regards to John's fishing trips. John is an avid fisherman and wants to know if there is a correlation between the amount

### A random sample of 85 utility stocks was taken to compare the amount of their annual dividends to the annualized yields of the dividends.

I am attaching a word doc which contains and 2 questions and data. I need step by step answer for the questions in MS_WORD. Step by step answer will help me understand the concept. Thank you. Please see attached file for full problem description. A random sample of 85 utility stocks was taken to compare the amount of t

### Multiple choice questions on hypothesis testing, regression and time series analysis.

A grocery store owner is interested in determining if the average weight of a package of ground beef sold in the store weighs one pound. An appropriate null hypothesis for this study is a. H0: m = 1 lb b. H0: m ¹ 1 lb c. H0: m > 1 lb d. H0: m < 1 lb The rejection region for a two-tail test that uses the standard nor

### Simple Liner Regression, Testing for Signifiance of relationship

Given are five observations collected in a regretion study on two variables: x 2 6 9 13 20 y 7 18 9 26 23 a) what is the value of the standard error of the estimate? b) test for a significant relationship by using the t test Use a=.05

### Step by step method for regression analysis for AIU job satisfaction database is discussed here.

Using Excel as your processing tool, work through three simple regression analyzes. 1. First run a regression analysis using the BENEFITS column of all data points in the attached AIU data set as the independent variable and the INTRINSIC job satisfaction column of all data points in the attached AIU data set as the depend

### Regression analysis The Bradford Electric Illuminating Company is studying the relationship between kilowatt-hours (thousands) used and the number of rooms in a private single-family residence.

EXCEL or manually calculated is acceptable. The Bradford Electric Illuminating Company is studying the relationship between kilowatt-hours (thousands) used and the number of rooms in a private single-family residence. A random sample of 10 homes yielded the following: NUMBER OF KILOWATT ROOMS HOURS

### Regression Analysis Benefits

1. First run a regression analysis using the BENEFITS column of all data points in the AIU data set as the independent variable and the INTRINSIC job satisfaction column of all data points in the AIU data set as the dependent variable. Create a graph with the trendline displayed. What is the least squares regression line equatio

### Decisions Based on Linear Relationships

See the attached file. Molly Prickett has just purchased a relatively small manufacturing company. The Company employs approximately 125 hourly workers, all performing essentially the same assembly-line operation. These non-unionized workers are concerned because they believe their wages for the past 21 years did not keep up wi

### Hypothesis Testing Multiple Choice Problem Set

I am having some trouble with a few problems. Any help is appreciated A grocery store owner is interested in determining if the average weight of a package of ground beef sold in the store weighs one pound. An appropriate null hypothesis for this study is a. H0: m = 1 lb b. H0: m ¹ 1 lb c. H0: m > 1 lb d. H0:

### Limitations on Regression Analysis

Discuss any limitations (inaccurate data; incomplete information; not enough samples for testing)can have an regression analysis. I need some pointers please.

### Which of the following is not used to find a "best" model?

Which of the following is not used to find a "best" model? a. adjusted r2 b. mallow's Cp c. Odds ratio d. all of the above

### The Cp statistic is used

The Cp statistic is used a. to determine if there is a problem of collinearity b. if the variances of the error terms are all the same in a regression model c. to choose the best model d. to determine if there is an irregular component in a time series

### Regression Analysis for he Fresh Detergent Case in Megastat

Hello, I have been asked to do this question in MEGASTAT, which is an add-on to Excel. The problem here is I don't know how to use MEGASTAT that well. I am hoping someone could complete this textbook question using Megastat, and show how they got the answer and graphs. Thank you. The Fresh Detergent Case The follo

### Paper on Regression Analysis

Project Paper Business Statistics Bryant/Smith manual Case 28: We want to find an equation that gives the selling price of a house. Things you'll want to do are: 1. Use regression analysis to derive a model of selling prices of houses in Eastville. Interpret your final model and its coefficients within the context of t

### How is correlation analysis used in a business decision?

(1) How is correlation analysis used in a business decision? (2) What is the standard error of estimate? Describe with an example. (3) What are the coefficients of the linear regression model and what do they mean? What are the various statistics reported in a regression output? (4) How do outlying observations affect reg

### Regression analysis

Need full explanation - Please see attachment. Information is on Tab 1 and data on Tab 2. Please use SPSS. You are a statistical analyst for a computer manufacturing company CompXXX. The COO of CompXXX has requested that you review production and delivery data for two popular CompXXX computer models, UltraModel and Mobil

### Regression Analysis of Test Scores and Stress

See attached. 7. It is recommended that you use the computer EXCEL sheet attached to help you answer the following questions: Write the answers in the provided space. An answer saying "see attached page" is not an option. There are almost no calculations. Most of the answers are on the EXCEL spreadsheet. X Y Stress Te

### Regression Equation, Standard of Error Estimate, and a Typical Seasonal Index

14. Mr. James McWhinney, president of Daniel-James Financial Services, believes there is a relationship between the number of client contacts and the dollar amount of sales. To document this assertion, Mr. McWhinney gathered the following sample information. The X column indicates the number of client contacts last month, and

### David Gallano, a wine merchant, has collected opinions on grape wine quality from a sample of his customers.

1. David Gallano, a wine merchant, has collected opinions on grape wine quality from a sample of his customers. These customers tasted wine made from grapes grown in three regions of the country. They rated the wine quality on a scale of 1 (best) to 4 (worst). The following is the data obtained for customer quality ratin

### Correlation Analysis between Student Success and Family Income

A sociologist claims that the success of students in college (measured by their GPA) is related to their family's income. For a sample of 20 students, the coefficient of correlation is 0.40. Using the 0.01 significance level, can we conclude that there is a positive correlation between the variables?

### In a multiple regression equation two independent variables are considered, and the sample size is 25.

In a multiple regression equation two independent variables are considered, and the sample size is 25. The regression coefficients and the standard errors are as follows. b1= 2.677 sb1= 0.56 b2= -0.880 sb2= 0.71 Conduct a test of hypothesis to determine whether either independent variable has a coeffic