Explore BrainMass

Correlation/Regression and Chi Square in Excel

Can you insert formulas into Excel Worksheet where the red answers are and generate a word document on how you arrived at answer mathematically?

See the attached file and solve the following problems:
(A) Use the Excel Analysis ToolPak to find the linear correlation coefficient for the systolic and diastolic measurements.
(B) Use the Excel Analysis ToolPack to determine the linear regression equation that uses the systolic pressure to predict the diastolic pressure.
(C) What is the best predicted value for diastolic pressure given that a women has a systolic level of 10?