# Multiple Regression & Time Series Analysis

See attached files.

The first document is the homework and the second one is the tutor's data and answers.

14.5 A consumer organization wants to develop a regression model to predict mileage (as measured by miles per gallon) based on the horsepower of the car's engine and the weight of the car ( in pounds). Data were collected from a sample of 50 recent car models, and the results are organized and stored in Auto .

a. State the multiple regression equation.

b. Interpret the meaning of the slopes, and in this problem.

c. Explain why the regression coefficient, has no practical meaning in the context of this problem.

d. Predict the miles per gallon for cars that have 60 horsepower and weigh 2,000 pounds.

e. Construct a 95% confidence interval estimate for the mean miles per gallon for cars that have 60 horsepower and weigh 2,000 pounds.

f. Construct a 95% prediction interval for the miles per gallon for an individual car that has 60 horsepower and weighs 2,000 pounds.

14.7 The business problem facing the director of broad-casting operations for a television station was the issue of standby hours ( i. e., hours in which unionized graphic artists at the station are paid but are not actually involved in any activity) and what factors were related to standby hours. The study included the following variables:

Standby hours (Y)? Total number of standby hours in a week Total staff (X1) present ? Weekly total of people- days Remote hours (X2) ? Total number of hours worked by employees at locations away from the central plant Data were collected for 26 weeks; these data are organized and stored in Standby.

a. State the multiple regression equation.

b. Interpret the meaning of the slopes, b1 and b2 in this problem.

c. Explain why the regression coefficient, has no practical meaning in the context of this problem.

d. Predict the standby hours for a week in which the total staff present have 310 people- days and the remote hours are 400.

e. Construct a 95% confidence interval estimate for the mean standby hours for weeks in which the total staff present have 310 people- days and the remote hours are 400.

f. Construct a 95% prediction interval for the standby hours for a single week in which the total staff present have 310 people- days and the remote hours are 400.

14.25 In Problem 14.3 on page 532, you predicted the durability of a brand of running shoe, based on the forefoot shock- absorbing capability (FOREIMP) and the change in impact properties over time (MIDSOLE) for a sample of 15 pairs of shoes. Use the following results:

Standard

Variable Coefficient Error tStatistic pValue

INTERCEPT -0.02686 0.06905 -0.39 0.7034

FOREIMP 0.79116 0.06295 12.57 0.0000

MIDSOLE 0.60484 0.07174 8.43 0.0000

a. Construct a 95% confidence interval estimate of the population slope between durability and forefoot shock-absorbing capability.

b. At the 0.05 level of significance, determine whether each independent variable makes a significant contribution to the regression model. On the basis of these results, indicate the independent variables to include in this model.

14.43 The owner of a moving company typically has his most experienced manager predict the total number of labor hours that will be required to complete an upcoming move. This approach has proved useful in the past, but the owner has the business objective of developing a more accurate method of predicting labor hours. In a preliminary effort to provide a more accurate method, the owner has decided to use the number of cubic feet moved and whether there is an elevator in the apartment building as the independent variables and has collected data for 36 moves in which the origin and destination were within the borough of Manhattan in New York City and the travel time was an insignificant portion of the hours worked. The data are organized and stored in Moving. For ( a) through ( k), do not include an interaction term.

a. State the multiple regression equation for predicting labor hours, using the number of cubic feet moved and whether there is an elevator.

b. Interpret the regression coefficients in ( a).

c. Predict the labor hours for moving 500 cubic feet in an apartment building that has an elevator and construct a 95% confidence interval estimate and a 95% prediction interval.

d. Perform a residual analysis on the results and determine whether the regression assumptions are valid.

e. Is there a significant relationship between labor hours and the two independent variables (cubic feet moved and whether there is an elevator in the apartment building) at the 0.05 level of significance?

f. At the 0.05 level of significance, determine whether each independent variable makes a contribution to the regression model. Indicate the most appropriate regression model for this set of data.

g. Construct a 95% confidence interval estimate of the population slope for the relationship between labor hours and cubic feet moved.

h. Construct a 95% confidence interval estimate for the relationship between labor hours and the presence of an elevator.

i. Compute and interpret the adjusted r2.

j. Compute the coefficients of partial determination and interpret their meaning.

k. What assumption do you need to make about the slope of labor hours with cubic feet moved?

l. Add an interaction term to the model and, at the 0.05 level of significance, determine whether it makes a significant contribution to the model.

m. On the basis of the results of ( f ) and ( l), which model is most appropriate? Explain.

14.49 The director of a training program for a large insurance company has the business objective of determining which training method is best for training underwriters. The three methods to be evaluated are traditional, CD- ROM based, and Web based. The 30 trainees are divided into three randomly assigned groups of 10. Before the start of the training, each trainee is given a proficiency exam that measures mathematics and computer skills. At the end of the training, all students take the same end- of- training exam. The results are organized and stored in . Develop a multiple regression model to predict the score on the end- of- training exam, based on the score on the proficiency exam and the method of training used. For ( a) through ( k), do not include an interaction term.

a. State the multiple regression equation.

b. Interpret the regression coefficients in ( a).

c. Predict the end- of- training exam score for a student with a proficiency exam score of 100 who had Web- based training.

d. Perform a residual analysis on your results and deter-mine whether the regression assumptions are valid.

e. Is there a significant relationship between the end-of- training exam score and the independent variables (proficiency score and training method) at the 0.05 level of significance?

f. At the 0.05 level of significance, determine whether each independent variable makes a contribution to the regression model. Indicate the most appropriate regression model for this set of data.

g. Construct and interpret 95% confidence interval estimate of the population slope for the relationship between end- of- training exam score and proficiency exam.

h. Construct and interpret 95% confidence interval estimates of the population slope for the relationship between end- of- training exam score and type of training method.

i. Compute and interpret the adjusted r2.

j. Compute the coefficients of partial determination and interpret their meaning.

k. What assumption about the slope of proficiency score with end- of- training exam score do you need to make in this problem?

l. Add interaction terms to the model and, at the 0.05 level of significance, determine whether any interaction terms make a significant contribution to the model.

m. On the basis of the results of ( f ) and ( l), which model is most appropriate? Explain.

16.7 The following data ( stored in Treasury) represent the three- month Treasury bill rates in the United States from 1991 to 2008:

Year Rate Year Rate

1991 5.38 2000 5.82

1992 3.43 2001 3.40

1993 3.00 2002 1.61

1994 4.25 2003 1.01

1995 5.49 2004 1.37

1996 5.01 2005 3.15

1997 5.06 2006 4.73

1998 4.78 2007 4.36

1999 4.64 2008 1.37

Source: Board of Governors of the Federal Reserve System, www. federalreserve. Gov

a. Plot the data.

b. Fit a three- year moving average to the data and plot the results.

c. Using a smoothing coefficient of W=0.25, exponentially smooth the series and plot the results.

d. What is your exponentially smoothed forecast for 2009?

e. Repeat ( c) and ( d), using a smoothing coefficient of W=0.25.

f. Compare the results of ( d) and ( e).

16.13 Gross domestic product (GDP) is a major indicator of a nation's overall economic activity. It consists of personal consumption expenditures, gross domestic investment, net exports of goods and services, and government consumption expenditures. The GDP ( in billions of current dollars) for the United States from 1980 to 2008 is stored in GDP.

Source: Data extracted from Bureau of Economic Analysis, U. S. Department of Commerce, www. bea. gov.

a. Plot the data.

b. Compute a linear trend forecasting equation and plot the trend line.

c. What are your forecasts for 2009 and 2010?

d. What conclusions can you reach concerning the trend in GDP?

16.15 The data in Strategic represent the amount of oil, in billions of barrels, held in the U. S. strategic oil reserve, from 1981 through 2008. Source: Data extracted from Energy Information Administration, U. S. Department of Energy, www. eia. doe. gov.

a. Plot the data.

b. Compute a linear trend forecasting equation and plot the trend line.

c. Compute a quadratic trend forecasting equation and plot the results.

d. Compute an exponential trend forecasting equation and plot the results.

e. Which model is the most appropriate?

f. Using the most appropriate model, forecast the number of barrels, in billions, for 2009. Check how accurate your forecast is by locating the true value for 2009 on the Internet or in your library.

16.47 The following data ( stored in Credit) are monthly credit card charges ( in millions of dollars) for a popular credit card issued by a large bank ( the name of which is not disclosed at its request):

Year Month 2007 2008 2009

January 31.9 39.4 45.0

February 27.0 36.2 39.6

March 31.3 40.5

April 31.0 44.6

May 39.4 46.8

June 40.7 44.7

July 42.3 52.2

August 49.5 54.0

September 45.0 48.8

October 50.0 55.8

November 50.9 58.7

December 58.5 63.4

a. Construct the time- series plot.

b. Describe the monthly pattern that is evident in the data.

c. In general, would you say that the overall dollar amounts charged on the bank's credit cards is increasing or decreasing? Explain.

d. Note that December 2008 charges were more than $ 63 million, but those for February 2009 were less than $ 40 million. Was February's total close to what you would have expected?

e. Develop an exponential trend forecasting equation with monthly components.

f. Interpret the monthly compound growth rate.

g. Interpret the January multiplier.

h. What is the predicted value for March 2009?

i. What is the predicted value for April 2009? j. How can this type of time- series forecasting benefit the bank?

https://brainmass.com/statistics/regression-analysis/multiple-regression-time-series-analysis-377936

#### Solution Summary

The solution provides step by step method for the calculation of multiple regression model and time series analysis. Formula for the calculation and Interpretations of the results are also included.