Question

The results of inspection of samples of a product taken over the past 5 days are given below. Sample size for each day has been 100:

Day	1	2	3	4	5
Defectives	2	6	14	3	7

Find the center line (CL).

	a.	6.4
	b.	0.32
	c.	3.2
	d.	0.064

We are interested in studying the linear relationship between someone's age and how much they spend on travel. The following data is provided:

Amount Spent on Travel	Age
850	39
997	43
993	50
649	59
1265	25
680	38

Find MSE (s-squared/ s^2).

	a.	111147.28
	b.	38461.01
	c.	196.11
	d.	667.33

Answer 1

Find the center line (CL).

The correct option is as d. 0.064

CL =

n = sample size = 100

k = number of samples = 5

total no. of defectives =2+6+14+3+7 = 32

Find MSE (s-squared/ s^2). b. 38461.01

Let's use excel:

Multiple regression using Excel.

Step 1) First enter the given data set in excel columns.

Step 2) Then click on Data >>> Data Analysis >>>Regression >>>>OK

Step 3) Input Y Range: Select the data of column "A"

Input X Range: Select the data of column "B"

Click on Labels

then Click on Output Range

Look the following Image

Then Click on OK, we get following result.

From the above output the regression equation is as follows:

Find MSE (s-squared/ s^2).

The MS Residual is the MSE = 38461.01

So correct choice is as b.  38461.01