# (a) The production manager of ABC Co. Ltd. has found that the relationship between production cost... (a) The production manager of ABC Co. Ltd. has found that the relationship between production cost (y in \$) and lot size (x in units) of a certain product is linear. A random sample of eight lots is taken and the results are summarized as below: Xx=941, Xx? = 325751, y=9570, y =32849700 and X xy = 3271030 (i) Find the least squares linear regression equation for predicting production cost on lot size. (4 marks) (ii) Calculate the coefficient of determination and interpret your result. (4 marks) (b) The ISB Manufacturing Company is developing a regression equation to relate the monthly maintenance costs (y, \$) of their machines to monthly production time (x, machine-hours), number of inspections per month (x,) and age of machine (xz, years). A random sample of eighteen machines is selected and a regression equation is fitted with partial results provided below: Intercept Coefficients 353.5612 5.3650 3.4331 -5.4293 p-value (Sig.) 0.0149 0.1333 0.0546 0.0425 (i) Write down the fitted multiple linear regression equation. (2 marks) (ii) Test whether the overall model is significant at 5% level of significance given that the coefficient of determination is 0.7741. (5 marks) (iii) Test whether the production time is a significant explanatory variable at 10% level of significance. (3 marks) (iv) It is known that the number of inspections and age of machine are highly correlated. Discuss the reliability of the regression coefficients. (2 marks)

6 a)

i)

n = 8

linear regression equation

Y = b0 + b1 * X

Slope b1 = SSxy / SSxx

SSxx = SUM of X^2 - (SUM of x)^2/n = 325751 - 941^2/8 = 215065.9

SSxy = SUM of xy - (SUM of x * SUM of y)/n = 3271030 - (941*9570)/8 = 2145359

Slope b1 = 2145359/215065.9 = 9.9754

Intercept b0 = Mean Y - Mean X * Slope

Mean X = SUM of X / n = 941/8 = 117.625

Mean Y = SUM of Y / n = 9570/8 = 1196.25

Intercept b0 = 1196.25-117.625*9.9754 = 22.8936

Y = 22.8936 + 9.9754 * X

ii)

Coefficient of correlation r = SSxy/SQRT(SSxx*SSyy)

SSyy = SUM of y^2 - (SUM of y)^2/n = 32849700 - (9570^2)/8 = 21401588

r = 2145359/SQRT(215065.9*21401588) = 0.99998 (neraly 1)

Coefficient of determination r^2 = 0.999959 (nearly 1)

100% of variation in Y variable is explained by regression analysis

or

100% of variation in Y variable is explained by variation in X variable  #### Earn Coin

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
• ### Simple Linear regression 1. A researcher uses a simple linear regression to measure the relationship between... Simple Linear regression 1. A researcher uses a simple linear regression to measure the relationship between the monthly salary (Salary measured in dollars) of data scientists and the number of years since being awarded a Master degree (Master Degree). A random sample of 80 observations was collected for the analysis. A researcher used the econometric model which has the following specification Salary,-β0 + β, Master-Degree, + εί, where i = 1, , 80 The (incomplete) Excel output of equation (1)...

• ### A manager at a local bank analyzed the relationship between monthly salary (y, in \$) and length o...

A manager at a local bank analyzed the relationship between monthly salary (y, in \$) and length of service (x, measured in months) for 30 employees. She estimates the model: Salary = β0 + β1 Service + ε. The following ANOVA table summarizes a portion of the regression results. df SS MS F Regression 1 555,420 555,420 7.64 Residual 27 1,962,873 72,699 Total 28 2,518,293 Coefficients Standard Error t-stat p-value Intercept 784.92 322.25 2.44 0.02 Service 9.19 3.20 2.87 0.01...

• ### Mama's Pizza restaurant chain would like to understand which variable most strongly influences the amount of... Mama's Pizza restaurant chain would like to understand which variable most strongly influences the amount of sales of the deep-dish pizza. They have gathered data on the number of monthly sales (in 100's) of deep-dish pizzas and the amounts month on advertising at 20 of their restaurants. Below are the results of the linear regression to predict the number of month 100's) based on monthly advertising (in \$1,000's). SUMMARY OUTPUT - Regression Model to Predict Monthly Sales (in 100's) based...

• ### Thompson Photo Works purchased several new, highly sophisticated processing machines. The production department needed some guidance... Thompson Photo Works purchased several new, highly sophisticated processing machines. The production department needed some guidance with respect to qualifications needed by an operator. Is age a factor? Is the length of service as an operator (in years) important? In order to explore further the factors needed to estimate performance on the new processing machines, four variables were listed: x = Length of time an employee was in the industry x2 = Mechanical aptitude test score x3 = Prior on-the-job...

• ### QUESTION 27 Q27. A manager at a local bank analyzed the relationship between monthly salary (y,... QUESTION 27 Q27. A manager at a local bank analyzed the relationship between monthly salary (y, in \$) and length of service (x, measured in months) for 30 employees. She estimates the model: Salary = Bo + B1 Service + ε. The following ANOVA table below shows a portion of the regression results. df SS M S F Regression 555,420 555,420 7.64 Residual 27 1,962,873 72,699 Total 28 2 ,518,293 Coefficients Standard Error t-stat p-value Intercept 784.92 322.25 2.44 0.02...

• ### 1. Many companies use a incoming shipments of parts, raw materials, and so on. In the... 1. Many companies use a incoming shipments of parts, raw materials, and so on. In the electronics industry, component parts are commonly shipped from suppliers in large lots. Inspection of a sample of n components can be viewed as the n trials of a binomial experimem. The outcome for each component tested (trialD will be that the component is classified as good or defective defective components in the lot do not exceed 1 %. Suppose a random sample of fiver...