A rocket motor is manufactured by bonding together two types

A rocket motor is manufactured by bonding together two types of propellants. The shear strength of the bond is thought to be related to the age of the propellant when the motor is cast. The Excel file, HW20_ShearStrength.xlsx, contains 20 observations of age and shear strength. We are interested in determining shear strength is linearly related to age of propellant.

a.   Paste a scatter plot below of the data in HW20_ShearStrength. Label x and y axes and give title. Notice whether the relationship appears to be linear and whether it is a positive or negative relationship? (2 points)

b.   Conduct a hypothesis test to determine if there is a significant linear relationship between age (weeks) and shear strength (psi). Use your scatter plot to determine if your alternative should be testing for a positive or negative relationship. Use a 5% level of significance.

c.   What is the estimated least squares regression equation? Please write the equation using the values you found for the y-intercept and slope.

d.   Interpret the slope in the context of this data.

e.   Interpret the y-intercept in the context of this data if it makes sense to do so.

f.    What is the value of the correlation coefficient, r?

g.   What is the value of the coefficient of determination, r²? Interpret the coefficient of determination in the context of this data?

h.   Find the predicted value for shear strength if age is 21 weeks.

i.    Paste a scatter plot of the data with the least squares regression line plotted through the points.

j.    Place a scatter plot of the residuals versus age below.

k.   To be considered a good fit, a plot of the residuals versus the x variable should be ____________________________________________________.   (Complete the statement.)

l.    In general, why is the method for obtaining the estimated regression equation called the Least Squares Method?

Solution