Problem:

PH Stat Review View PHStat O Simple Linear Regression Multiple-Sample Tests Control Charts Data ummarized Data) Y Variable Cell Range: Correlation! $B$1:$B$21 Regression Decision-Making X Variable Cell Range: Correlation! $A$1:$A$21 marized Data) First cells in both ranges contain label Simple Linear Regression... Confidence level for regression coefficients 95 % Multiple Regression... D Regression Tool Output Options Best Subsets... Regression Statistics Table V ANOVA and Coefficients Table Stepwise Regression... Residuals Table Residual Plot Logistic Regression... Output Options Title: Clerical Works V Scatter Plot Durbin-Watson Statistic Confidence Int. Est. & Prediction Int. for X = Confidence le for intervals: Help OK Cancel CORRELATIONPH Stat Clerical Works Calculations b1, bo Coefficients -0.0045 86.7442 Regression Statistics b1, bo Standard Error 0.1475 11.3958 Multiple R 0.0072 R Square, Standard Error 0.0001 5.0265 R Square 0.0001 F, Residual df 0.0009 18.0000 Adjusted R Square -0.0555 Regression SS, Residual SS 0.0233 454.7767 Standard Error 5.0265 Observations 20 Confidence level 95% t Critical Value 2.1009 ANOVA Half Width bo 23.9418 df SS MS F Significance F Half Width b1 0.3098 Regression 1 0.0233 0.0233 0.0009 0.9761 Residual 18 454.7767 25.2654 Total 19 454.8000 Coefficients Standard Error tStat P-value Lower 95% Upper 95% Lower 95% Upper 95% Intercept 86.7442 11.3958 7.6119 0.0000 62.8024 110.6860 62.8024 110.68595 Work Environment -0.0045 0.1475 -0.0304 0.9761 -0.3143 0.3053 -0.3143 0.30534PH Stat Scatter Plot 94 92 90 88 V= -0.0045x + 86.744 86 R2 = 5E-05 84 82 80 78 10 20 30 40 50 60 70 80 90 100 XClassroom Exercise: Shown on the table beside are the average daily Fat Consumption Cholesterol Level consumption of saturated fat 65 190 (in grams) and the cholesterol 78 225 level (in milligrams per 60 205 hundred millimeters) of 10 44 175 53 180 randomly chosen sample of 68 214 patients at the Cebu City 87 245 Medical Center. Is there a 46 160 significant correlation between 55 210 73 fat consumption and 215 cholesterol level? Test at 0.05 level of significance. CORRELATION