Share
Explore BrainMass

Regression Analysis

Advantages of Linear Regression in Complex Situations

How does a linear regression allow us to better estimate trends, costs, and other factors in complex situations?

High-Low Method; Regression Analysis

Tessmer Manufacturing Company produces inventory in a highly automated assembly plant in Olathe, Kansas. The automated system is in its first year of operation and management is still unsure of the best way to estimate the overhead costs of operations for budgetary purposes. For the first six months of operations, the following

Engineering Salaries Analysis for an MS

See attached data files. Engineering Salaries Analysis for an MS A project requires us to develop a regression model to assist us in our salary/bonus prediction based on variables represented by analyzing various factors about each engineering school. For example: (1) if a student wants to go to a specific engineeri

Regression Analysis for large bank to develop model to predict time to process invoices

See data file attached. The manager of the purchasing department of a large banking organization would like to develop a model to predict the amount of time it takes to process invoices. Data are collected from a sample of 30 days, and the number of invoices processed and completion time, in hours, is stored in the file invoi

Regression Analysis: Interval Level of Measurement; dependent, independent variable

See the attached file. (1) What can you now infer about the relationship between Corporate Taxes and Capital Formation (Investment)? Is it a positive or negative relationship? (based on the attached Case study) (2) Based on the attached lecture, look at the original table....it is a snapshot of the world economy from the

Regression Modeling for Time to Process Invoices

See data file attached. The manager of the purchasing department of a large banking organization would like to develop a model to predict the amount of time it takes to process invoices. Data are collected from a sample of 30 days, and the number of invoices processed and completion time, in hours, is stored in the file invoi

Auto manufacturer tests to investigate price and age depreciation of car models

1. An auto manufacturing company wanted to investigate how the price of one of its car models depreciates with age. The research department at the company took a sample of eight cars of this model and collected the following information on the ages (in years) and prices (in hundreds of dollars) of these cars. Age (x) 8 3 6 9

Time Series Analysis: Seasonal Index and Seasonal Forecast

Caseload per worker for each of the past 48 months is shown in the attached Excel file, as well as the number of workers budgeted and the numbers of workers who actually reported to work during each month. The caseload changes periodically, mainly down in the summer, up in the fall, down in winter, up in the spring. I need

Regression Analysis for AIU data: benefits; job satisfaction, intrinsic and extrinsic

See attached files. Prepare a report using Excel as your processing tool to process three simple regression analyses. 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

Find auto-regressive parameters and their significance with multiple choice answers. When fitting a third-order autoregressive model to the DJIA, what is A3? When testing for the significance of the third-order autoregressive parameter with &#61537; = 0.05, can A3 be deleted? When applied an exponential trend model to this data, provide the annual forecast of the DJIA for 2006?

See attached data as an excel spread sheet. INFORMATION 14 The data in DJIA.XLS (CD-> browse->Excel_Data_Files) represent the closing value of the Dow Jones Industrial Average (DJIA) over the 27-year period 1979 through 2005. See Problem 16.29 (p.675). Using EXCEL or PHStat2, answer the following: 1. When fitting a thir

Real Estate Data: Statistical Analysis

Does the price of homes depend on the distance from the city centre? Perform a five-step hypothesis test on the given research question.

Regression Analysis: SSR, F-Value for Partial F-Test Criterion, Variance Inflationary Factor (VIF), Confidence Interval

A large consumer product company wants to measure the effectiveness of different types of advertising media in the promotion of its products. Specifically, two types of advertising media are to be considered: radio/TV advertising and newspaper advertising (including the cost of discount coupons). The sales of product (in thousan

ANOVA: Job Standardization and Increasing Citizenship Behaviour

See attached files. Attached is the article I chose for the report (PDF File). If the article does not have the information required to complete the ANOVA process, there is an excel file ("Data Set and Data Key") that has data to complete this process (this is referenced in the "project" portion of the message below as the AI

Logistic regression to assess the association between CVD and obesity

A logistic regression model was used to assess the association between CVD and obesity. P is defined to be the probability that the people have CVD. log(P/(1-P)) = -2 + 0.7(obesity) What is the odds ratio for CVD in persons who are obese as compared to not obese?

Variation in regression line and coefficient of determination

Problems 1, 3 1. Use the graph below to describe the total variation about a regression line in words and in symbols. This is the answer from the book, but how? S(yi - y)2; the sum of the squares of the differences between the y-values of each ordered pair and the mean of the y-values of the ordered pairs. 3 Use the

Philip Morris vs the market: Inference for Regression - Involving Minitab

Philip Morris Versus the Market. The table (see Minitab attachment) shows the monthly returns on the common stock of Philip Morris (MO), as the company was then named, and the returns on the Standard & Poor's 500 stock index for the same months. Return is measured in percent. The data are for 83 consecutive months running from

A brokerage house wants to predict the number of trade executions per day

See data file attached. A brokerage house wants to predict the number of trade executions per day, using the number of incoming phone calls as a predictor variable. Data were collected over a period of 35 days and are stored in the file trades.xls. a. Use the least-squares method to compute the regression coefficients b0

Finding and Using the Regression Equation for Predicting Values

For the following data: a) find the regression equation for the predicting y from x. b) use the regression equation to find a predicted y for each x c) find the difference between the actual y value and the predicted y value for each individual, square the differences and add the squared values to obtain ss residual. d) calc

Calculate the Pearson Correlation and Find the Regression Equation

A set of n=20 pairs of score (x and y values) has ssx=25, ssy=16, and sp=12.5. If the mean for the x values is m=6 and the mean for the y values is m=4. a) Calculate the Pearson Correlation for the scores. b) Find the regression equation for predicting y from the x values.

Multiple regression: quality of life

A psychologist studying perceived 'quality of life' in a large number of cities (N=150) came up with the following equation using mean temperature (Temp), median income in \$1000 (Income), per capita expenditure on social services (SocSer), and population density (Popul) as predictors. Y= 5.37-0.01Temp+ 0.05Income + 0.003SocSe

Bio-Statistics: Select the Appropriate Statistical Test for Analysis of Hospital Costs

Select the appropriate statistical test that allows you to conduct an analysis of the factors affecting hospital costs. You will have to select the correct statistical test and conduct that test in Excel. 1. Analyze your data and produce a summary describing the major findings of your analysis. 2. The variables that most

Regression Analysis for Accu-Copiers, Inc.

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-Copiers has collected data for 11 service calls. The service calls information

Explain the concept of dependent and independent variables

In business, investors are always interested in the tradeoff between returns and risk. Regression analysis is a statistical technique that can be used to quantify this risk. Explain the concept of dependent and independent variables in terms of a business performance indicator e.g. stock price, profits, etc., clearly stating th

Statistics Analysis and Efficiency Tests

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 assigned for this analysis are: y = monthly labor hours required x1

Correlation, Regression Analysis and F-Test for Difference Between Two Standard Deviations (Variances)

1. The owner of Maumee Motors wants to study the relationship between the age of a car ad its selling price. Listed below is a random sample of 12 used cars sold at Maumee Motors during the last year. Car Age (years) Selling Price (\$000) Car Age (years) Selling Price (\$000) 1 9 8.1 7 8 7.6 2 7 6.0 8 11 8.0 3 11 3.6

What is the fitted trend value for a time series on real net sales for the tenth year?

The linear trend forecasting equation for an annual time series containing 40 observations (from 1963 to 2002) on real net sales (in billions of constant 1995 dollars) is Y = 1.2 + 0.5X What is the fitted trend value for this time series on real net sales for the tenth year?

Indirect Relationships

Now that warm weather is finally upon us (or at least in some parts of the country), is there a possible relationship between crime rates and ice cream sales? In the world of regression analysis, this is called an indirect relationship. As there is no direct correlation between the 2 variables. However, what if you identifi

Convert Summer Historical Inventory Data To An Index: Time Series Forecast

I. Convert the Summer Historical Inventory Data into an index II. Use the time series data from the converted index to forecast the inventory data for the next year III. Graph of choice Time Series. A Time series is a sequence of measurements, typically taken at successive points in time. Time series analysis includes

Research and Evaluation: Problems 12.48, 12.50, 13.30, 13.32, 14.16

See attachment for problems 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?

Use linear regression to forecast sales for month 5. Use quadratic to forecast.

Month Sales 1 6 2 13 3 24 4 36 Use linear regression to forecast sales for month 5. Prob 1b Use quadratic (y=ax2 + bx + c) to forecast sales for month 5.