Explore BrainMass

Regression Analysis

Bio-Statistics: Multiple Regression Analysis

1. Consider the data shown in this table measured in a sample of n=25 undergraduates in an on-campus survey of health behaviors. Enter the data into an excel worksheet for analysis. 2. Estimate the multiple linear regression equation relating number of cups of coffee per week, female gender, and number of hours of exercise pe

Regression: Data Point Table

The data table below 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. When running a regression with the dependent variable "Sales" and the independent variable "A

Develop a regression model for movie demand

I have also attached a sample xls file that contains the 5 steps referred to in the word doc. The data is located in the movie.xls file. Develop a regression model for movie demand. Follow the five steps outlined in the sample XLS file. ? Accomplish a correlation table and scatter plots with trend lines of all of the varia

Forecasting (moving average/ exponential smoothing) problems

Q17.26 (pp661). The dean of a law school has developed a regression equation for estimating the starting salary (thousands of dollars) of a new graduate on the basis of two independent variables: x1 = the score on the Law School Admission Test (LSAT) at the time of the application, and x2

Regression Analysis for Alzheimer's Disease Data

Problem 15 in Chapter 16 described a study examining the effectiveness of a 7-Minute Screen test for Alzheimer's disease. The study evaluated the relationship between scores from the 7-Minute Screen and scores for the same patients form a set of cognitive exams that are typically used to test for Alzheimer's disease. For a sampl

5 Problems: Chi-Square, Regression, Regression Equation & Relation, etc...

In preparation for my final in two weeks, I have this set of study problems. In order to ensure I am working these correctly, I have created problems based of study problems and wish to compare work. Please complete the problems, show solutions in excel if applicable and explain. I really need to understand the concept as the

This part of the quote, "The formulation of a problem is far more often essential than its solution, which may be merely a matter of mathematical or experimental skill" illustrates the following which I want you to expand on: 1) Planning and Designing is often the most important step of s research process. The way you design and collect your data is more important than the analysis of the data and subsequent interpretation of the result of the analyses.

This part of the quote, "The formulation of a problem is far more often essential than its solution, which may be merely a matter of mathematical or experimental skill" illustrates the following which I want you to expand on: 1) Planning and Designing is often the most important step of s research process. The way you design

Statistics: Define autocorrelation, and multicollinearity

Define autocorrelation in the following terms: a. In which type of regression is it likely to occur? b. What is the negative impact of autocorrelation in a regression? c. Which method is used to determine if it exists? d. If found in a regression, how is autocorrelation eliminated? Define multicollinearity in the followin

Forecast Techniques, Forecast Accuracy Measures and Regression Analysis

Please show all work. 5. The chairperson of the department of management at State University wants to forecast the number of students who will enroll in production and operations management (POM) next semester, in order to determine how many sections to schedule. The chair has accumulated the following enrollment data for th

Moving Average Forecast, Exponential Smoothing Forecast, Adjusted Exponential Smoothing Forecast, MAD, MAPD, Cumulative Error, Comparison among different Forecast Techniques and Regression Analysis

1. The saki motorcycle dealer in Minneapolis wants to make an accurate forecast of demand for the Saki Super TXII motorcycle during the next month. Because the manufacturer is in Japan, it is difficult to send motorycles back or reorder if the proper number is not ordered a month ahead. From sales records, the d

Job Satisfaction Survey -Regression Analysis

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

Biostatistics: Multivariable Regression Analysis

A study is conducted in patients with HIV. The primary outcome is CD4 cell count, which is a measure of the stage of the disease. Lower CD4 counts are associated with more advanced disease. The investigators are interested in the assocition between vitamin and mineral suppliments and CD4 count. A multiple regression analysis is

Multiple Regression Model

We are given a multiple regression model : InQt=1.2789-0.1647 In Pt+ 0.5115 In It + 0.1483 In P't - 0.0089T - 0.961D1t - 0.1570D2t-0.0097D3t Its purpose is to describe the relationship between the terms on the right (the independent variable) to Qt (the dependent variable. We find values of each variable be taking a random

AIU Benefits Data: Regression, Lease Squares, Y-intercepts

See attached data file to complete this task. Prepare a report using Excel as your processing tool to process 3 simple regression analyses. Create a graph with the trend line displayed for each of the 3 different regressions. First run a regression analysis using the BENEFITS column of all data points in the AIU data set

Statistics: Multiple Regression Equation

See the attached file. PG 2 -6 The US Navy selected 16 hospitals that were believed to be efficiently run. They conducted a regression analysis to evaluate the performance of the hospitals in terms of how many labor hours used relative to how many labor hours needed. Y= monthly labor hours required X1= monthly X-ray e


See attached file. Accu-copiers Inc sells Accu 500 copy machines. As part of standard contract, they perform routine servicing of the copier. To obtain the time it takes to perform the routine service they collected 11 service calls. The service call information revealed the the following. Refer to Table 10C attached.

Use of ANOVA, One-Way, Two-Way, R-Square in Regression

Short Answer - One paragraph per response; your own words! Reference links may be included. Question 1: The F test is used in Analysis of Variance (ANOVA). When would a researcher use an ANOVA? Explain. Questions 2: A research assistant is contemplating whether to use a One Way ANOVA or a Two Way ANOVA. The research as

Realtor using regression analysis for house prices

You are a realtor with a small business. You use a simple 2 variable linear regression analysis for quick first glance house price estimates using square footage of the house. You are asked by a customer what the price for his house would be given that his house has 1,500 square feet. The number you are trying to explain is the

Regression Hypothesis Test on Real Estate Data

Test the Hypothesis that homes located closer to the centre of the city, are higher in price than those homes located further away from the centre of the city. -Perform a regression hypothesis test on the data -Include a graph showing the results -Include the results of your computations, using graphical and/or tabular met

Regression Model for predicting risk for stroke.

A 10 year study by the American Heart Association provided data on how age, blood pressure and smoking relate to the risk of strokes. Data from a portion of this study are shown below. Risk is interpreted as the probability (times 100) that a person will have a stroke over the next 10 year period. For the smoker variable, 1 indi

General Statistics

5 Answer questions 5-8 using the following information: Test the hypothesis that the treatment means for samples given below are equal. Use the .01 significance level. Treatment 1 Treatment 2 Treatment 3 22 34 13 20 31 10 21 25 14 18 25 11 19 32 30 The decision rule is: Choose one answer. a. Reject the nul

Statistics: Multi Regression analysis

We want to determine the primary factors that affect Motor Vehicle Theft crime rates in the United States. The statistical analysis of the data involves multiple-regression analysis. This problem is for Graduate/Masters level 1.What are the primary determinants of Motor Vehicle Theft crimes in the United States? 2. What

Artsy Company: Difference in pay rates by job grade, time in grade and by sex

Artsy Case The Artsy Corporation has been sued in the United States Federal Court on charges of employment discrimination under Title VII of the Civil Rights Act of 1964. (Artsy is an actual corporation and the data given in the case is real, but the name has been changed to protect the firm's true identity.) The litigation at

SPSS Input

A Survey of 50 Companies In January '08, fifty customers of a lumber manufacturer were surveyed regarding their satisfaction with products and service. These customers buy from the supplier and sell to retail chains like Home Depot and Lowes. Shortly after, the manufacturing company was sold. In June '08, the customers were

Multiple Regression & Seasonal Forecasting

This solution describes how to do multiple regression using Excel and the Megastat plugin. Students are given step-by-step instructions on how to use the MegaStat plugin for Excel and told why Excel's Data Analysis Toolpak isn't reliable for rigorous statistical analysis. Attachments include example spreadsheets, a video tutoria