Explore BrainMass

Interpolation, Extrapolation, and Regression

Managerial Accounting Mathematics - Mr. Liao

P3-52; Regression Analysis Mr. Liao, CEO of a manufacturer of fine china and stoneware, is troubled by fluctuations in productivity and wants to compute how manufacturing support costs are related to the various sizes of batches of output. The following data show the results of a random sample of 10 batches of one pattern o

Statistics : Regression Analysis

Using Excel as your processing tool, work through three simple regression analysis. 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 g

A problem on Regression is solved in this posting using Excel data Analysis. A complete Interpretation of the Excel output for Regression is given with explanation enabling students to interprete the Regression output of Excel.

*Please show all work, use excel and identify the value and units measured. (Notes for my own Use: Ch8: 6) The National Transportation Safety Board collects data by state (including the District of Columbia) on traffic fatalities. Part of this data is shown in the following table. along with potentially related factors incl

Statistics/Regression problem

A sample of 7 homes sold last week in Tampa, FL is selected. Can we conclude that as the size of the homes (reported below in thousands of square feet) increased, the selling price (reported in $ thousands) also increases? Home Size (thousands of square feet) Selling Price ($ thousands) Thousand Selling price (in

Regression Analysis

Why is it important for you to study regression analysis in a business course? Are there situations in business where you will need to use regression analysis? Understand the limitations of the linear regression method.

Linear Regression

In biology, there is an approximate rule, called the bioclimatic rule for temperate climates,that has been known for a couple of hundred years. This rule states that in spring and early summer, periodic phenomena such as blossoming of flowers, appearance of insects, and ripening of fruit usually come about 4 days later for each

Linear Regression and Bioclimatic Rule

In biology, there is an approximate rule, called the bioclimatic rule for temperate climates,that has been known for a couple of hundred years. This rule states that in spring and early summer, periodic phenomena such as blossoming of flowers, appearance of insects, and ripening of fruit usually come about 4 days later for each

Explained and Unexplained variation and the least-squares regression line

Bivariate data obtained for the paired variables x and y are shown below, in the table labelled "Sample data." These data are plotted in the scatter plot in Figure 1, which also displays the least-squares regression line for the data. The equation for this line is y^ = 4.85+1.01x . In the "Calculations" table are calculation

Seasonal Index and Regression Models

Quarterly billing for water usage is shown below. Year Quarter 1 2 3 4 Winter 64 66 68 73 Spring 103 103 104 120 Summer 152 160 162 176 Fall 73 72 78 88 a. Find the seasonal index for each quarter. b. Deseasonalize the data. c. Find the trend line.

Trends and Forecasting : Linear Regression and Exponential Smoothing

1- The following data summarizes the historical demand for a product Month Actual demand March 20 April 25 May 40 June 35 July 30 August 45 Use exponential smoothing with and the smoothed forecast for July is 32 and determine August and September's smoothed forecasts. 2- 15. Robert has the following accoun

Regression Analysis

What do you know about regression analysis? What is the regression analysis good for?

Forecasting Model: Least Square Regression

Jason believes that sales of coffee at his shop depend on weather. He has taken a sample of 6 days. Results are shown in columns B and C of the table. I have also performed some computations to make you task easier. Please see attachment.

Regression Equation

Health experts recommend that runners drink 4 ounces of water every 15 minutes they run. Although handled bottles work well for many types of runs, all-day cross-country runs require hip-mounted or over-the-shoulder hydration systems. In addition to carrying more water, hip-mounted or over-the-shoulder hydration systems offer mo

Regression : Interpretation of Intercept and Slope of Regression Line

6) The following regression line shows how the monthly return for the mutual fund TWCUX (Twentieth Century Ultra Fund) is mathematically related to the S&P500 monthly return. TWCUX = -2.61 + 1.27 (S&P500) Explain what both the intercept and slope of the regression line tell you in the context of this problem. Calculate

Scatter Diagrams, Slope of Regression Equation and Coefficient of Correlation

Super Markets, Inc. is considering expanding into the Scottsdale, Arizona, area. Ms. Luann Miller, Director of Planning, must present an analysis of the proposed expansion to the operating committee of the board of directors. As a part of her proposal, she needs to include information on the amount people in the region spend per

Regression Equation and Interpretation

A CEO of a large pharmaceutical company would like to determine if he should be placing more money allotted in the budget next year for television advertising of a new drug marketed for controlling asthma. He wonders whether there is a strong relationship between the amount of money spent on television advertising for this new d

Regression and Forecasting : Using Data Regression to Predict Sales

YEAR GNP ln(gnp) 1975 1060 6.966024187 1976 1170 7.064759028 1977 1305 7.17395832 1978 1455 7.28276118 1979 1630 7.396335294 1980 1800 7.495541944 1981 2000 7.60090246 1982 2220 7.705262475 1983 2450 7.803843304 1984 2730 7.912056888 The US BNP during the years 1975-1984 is given in the above table. a. Plot x

Regression:Function, Correlation Coefficient & Maximizing Profit

A. Your function, and specify what the slope and intercept of your function is. B. What this function tells you about the relationship between the price and the number of cups sold? C. How you plan on using this function to help you maximize the profits of your lemonade stand? data: regression equation: y= -100x + 250

Least-Squares Property and Regression Analysis

1. Describe what a line is that satisfies the least-squares property-what is it and what is the function? (Please share your own way of understanding it). 2. This week we looked at regression analysis. What is the difference between a simple regression analysis and multiple regression? Please give examples.

Regression : Forecasting and Confidence Intervals

The data below present the results of a hydrological investigation of the Snake River watershed. The main purpose of the investigation was to forecast the water yield (y inches) from April to July using the weighted water content of snow (x), estimated on April 1. Year X Y Year X Y 1919 23.1 10.5 1928 37.9 22.9 1920 32.8 1

Linear Regression Application Problem : Boston Marathon

Please see the attached files for the fully formatted problems. This program calls for the use of a stats program called "minitab". If you want to use minitab but don't have it, you can get a 30 day download of it at If you want to use minitab, I've included the minitab

Normal Distribution and Linear Regression

Please see the attached file for the fully formatted problems. Question 1 During 2002 the number of beds required per day at St Hallam's hospital was normally distributed with a mean of 1800 and a standard deviation of 190. During the first 50 days of 2003 the average daily requirement for beds was 1830. A senior hospita

Graphs : Regression and Forecasting

Using the following information answer the following questions. Year Population 1860 379, 994 1870 560, 247 1880 864, 694 1890 1,213, 398 1900 1,485, 053 A) What is the linear regression function for this data? Write all decimal points. B) What does the model predict

Using Regression Functions

Demonstrate using regression functions by explaining what a regression function is and the factors which should be considered when interpreting results.