Question

Please use mintab

The strength of a part was monitored as a function of temperature within a process. Generate a Scatter Plot, determine the value of the coefficient of correlation, generate a Fitted Line Plot, generate a Residual Plot, and estimate the percentage of variability in strength as a function of temperature. Note: Data divided into six columns for visual display. Your analysis should have a single Temp column and a single Strength column.

Temp	Strength	Temp	Strength	Temp	Strength
140.6	7.38	140.5	6.95	142.1	3.67
140.9	6.65	139.7	8.58	141.1	6.58
141.0	6.43	140.6	7.17	140.6	7.42
140.8	6.85	140.1	8.55	140.5	7.53
141.6	5.08	141.1	6.23	141.2	6.28
142.0	3.80	140.9	6.27	142.2	3.46
141.6	4.93	140.6	7.54	140.0	8.67
140.6	7.12	140.2	8.27	141.7	4.42
141.6	4.74	139.9	8.85	141.5	4.25
140.2	8.70	140.2	7.43	140.7	7.06

Answer 1

Using Excel, go to Insert Scatter Plot.

Using Excel, go to Data, select Data Analysis, choose Regression. Put Temperature in X input range and Strength in Y input range. Tick Residual Plot and Line Fit Plot.

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.977
R Square	0.955
Adjusted R Square	0.953
Standard Error	0.347
Observations	30
ANOVA
	df	SS	MS	F	Significance F
Regression	1	71.054	71.054	588.593	0.000
Residual	28	3.380	0.121
Total	29	74.434
	Coefficients	Standard Error	t Stat	P-value
Intercept	333.986	13.496	24.747	0.000
Temperature	-2.324	0.096	-24.261	0.000

Correlation coefficient (Multiple R) = 0.977

Percentage of variability in strength as a function of temperature (R-square) = 0.955 = 95.5%