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?
This question has the following supporting file(s):
This answer includes:
- Plain text
- Cited sources when necessary
- Attached file(s)
- Stats Solution.xlsx
Active since 2011