BELOW I HAVE UPLOADED 2 EXCEL DOCUMENTS AND I NEED TO COMPLETE THE CORRELATION REGRESSION ANALYSIS FOR BLOOD PRESSURE EXCEL WORK
I HAVE ALSO ADDED AN EXAMPLE(BP SCATTER PLOT) WITH THAT
THE ONE ON THE (BELOW UPLOADS) IS MY HOMEWORK AND ON THE RIGHT I HAVE AN EXAMPLE.
CORRELATION, REGRESSION PREDICTION FOR AGE 72, Your Analysis.
Sheet1
| REGRSSION ANALYSIS FOR AGE AND BLOOD PRESSURE |
| SUBJECT |
|
AGE X |
|
BP Y |
| A |
|
44 |
|
124 |
| B |
|
50 |
|
128 |
| C |
|
55 |
|
135 |
| D |
|
61 |
|
143 |
| E |
|
63 |
|
141 |
| F |
|
65 |
|
146 |
| G |
|
69 |
|
152 |
| H |
|
70 |
|
150 |
| |
CORRELATION |
| |
REGRESSION PREDICTION |
| |
FOR AGE 72 |
| |
Your Analysis |
Sheet1
| AN EXAMINATION OF AGE AND BLOOD PRESSURE USING EXCEL STATISTICS |
| SUBJECT |
|
AGE x |
|
BLOOD PRESSURE y |
| A |
|
43 |
|
128 |
| B |
|
43 |
|
120 |
| C |
|
56 |
|
135 |
| D |
|
66 |
|
143 |
| E |
|
67 |
|
141 |
| F |
|
70 |
|
152 |
| MODE |
|
43 |
|
ERROR:#N/A |
| MEDIAN |
|
61 |
|
138 |
| MEAN |
|
57.5 |
|
136.5 |
| GEO MEAN |
|
56.36 |
|
136.10 |
| |
|
|
|
SCATTER PLOT |
| |
CORRELATION |
|
0.945996599 |
AGE 43 43 56 66 67 70 BLOOD PRESSURE 43 43 56 66 67 70 128 120 135 143 141 152

- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How It Works
- Click on the “Place Your Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.