Purchase Solution

determining slope and intercept on the regression line

Not what you're looking for?

Ask Custom Question

A company has observed that there is a linear relationship between indirect labor expense (ILE) , in dollars, and direct labor hours (DLH). Data for direct labor hours and indirect labor expense for 18 months are given in the file ILE_and_DLH.xlsx

Treating ILE as the response variable, use regression to fit a straight line to all 18 data points. What values for the intercept (a) and slope (b) do you obtain?

Place your answers, rounded to 3 decimal places, in the blanks provided. Do not use any stray punctuation marks. For example, 34.567 would be a legitimate entry.

intercept (a) =
slope(b) =

Purchase this Solution

Solution Summary

The solution gives detailed steps on determining slope and intercept on the regression line using excel.

Purchase this Solution


Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.